TN02S SAP (IS-H: Systems and System Attributes) Table details

Dictionary Type: Table
Description: IS-H: Systems and System Attributes




ABAP Code to SELECT data from TN02S
Related tables to TN02S
Access table TN02S




Table field list including key, data, relationships and ABAP select examples

TN02S is a standard SAP Table which is used to store IS-H: Systems and System Attributes data and is available within R/3 SAP systems depending on the version and release level.

The TN02S table consists of various fields, each holding specific information or linking keys about IS-H: Systems and System Attributes data available in SAP. These include SYSTYP (IS-H: System Type Specification), ISHREL (IS-H: Release), DBREM (IS-H: Identification of External System), XCOMNAME (IS-HCM: Name of the Communication Partner in Table TXCOM).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: G - Customising table which is protected against SAP Update
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP TN02S table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
SYSTEMIS-H: Unique system identification (logical name) ISH_SYSTEMCHAR8ALPHAISH_SYSTEM
SYSTYPIS-H: System Type Specification SYSTYPCHAR2ALPHASYSTYP
ISHRELIS-H: Release ISHRELCHAR4ALPHAISHREL
DBREMIS-H: Identification of External System DBREMCHAR1XFELD
XCOMNAMEIS-HCM: Name of the Communication Partner in Table TXCOM XCOMNAMECHAR8XUHDEST
STANDIS-HCM: Communications Standard CMSTDCHAR8TNCSTNTSTD
STVERIS-HCM: Version of Communication Standard STDVERCHAR3TNCSTNTVER
SPECHARSIS-HCM: Special Characters Agreed (Standard-Dependent) SPECHARSCHAR6CHAR6
CODEPAGESAP Character Set ID CPCODEPAGENUMC4TCP00CPCODEPAGE
ALLINONEIS-HCM: Write all messages to file NTISH.dat NALLINONECHAR1XFELD
SPERRKZBlocking Indicator RI_SPERRCHAR1XFELD
RFCDESTIS-HCM: Logical Destination for Remote Function Call ISHRFCDESTCHAR32RFCDESRFCDESTRFC
KZDELIVERIS-HCM: Indicator for Express Dispatch KZDELIVERCHAR1XFELD
KZRECEIVEIS-HCM: Indicator for Synchronous Receipt KZRECEIVECHAR1XFELD
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPTIMIS-H: Time Data Record was Last Changed ISH_UPTIMTIMS6UHRZT
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERTIMIS-H: Time when Data Record Created ISH_ERTIMTIMS6UHRZT
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
PATEVTKZIS-HCM: Turn Additional Patient Events into Messages PATEVTKZCHAR1XFELD
PSEUDO_MODEPseudonymization Mode for Communication ISH_CM_PSEUDO_MODECHAR1ISH_CM_PSEUDO_MODE

Key field Non-key field



How do I retrieve data from SAP table TN02S using ABAP code

The following ABAP code Example will allow you to do a basic selection on TN02S to SELECT all data from the table
DATA: WA_TN02S TYPE TN02S.

SELECT SINGLE *
FROM TN02S
INTO CORRESPONDING FIELDS OF WA_TN02S
WHERE...

How to access SAP table TN02S

Within an ECC or HANA version of SAP you can also view further information about TN02S and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!