DB2_SNODETEXT SAP (DB2 Deadlocks Output Structure for Display of Details) Structure details

Dictionary Type: Structure
Description: DB2 Deadlocks Output Structure for Display of Details




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




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

DB2_SNODETEXT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DB2 Deadlocks Output Structure for Display of Details" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB2_SNODETEXT TYPE DB2_SNODETEXT.

The DB2_SNODETEXT table consists of various fields, each holding specific information or linking keys about DB2 Deadlocks Output Structure for Display of Details data available in SAP. These include ID (Internal: Node ID), TYPE (Node type), NAME (Object name), TLEVEL (Node level).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DB2_SNODETEXT structure 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
IDInternal: Node ID SEU_IDNUMC6SEU_ID
TYPENode type SEU_TYPECHAR4SEU_TYPE
NAMEObject name SEU_NAMECHAR30SEU_NAME
TLEVELNode level SEU_LEVELNUMC2SEU_LEVEL
LINKLink ID SEU_LINKCHAR1CHAR1
COMPRESSInternal: Compression ID SEU_COMPRCHAR1CHAR1
LEAFInternal: Page ID SEU_LEAFCHAR1CHAR1
TLOCKInternal: Selection ID SEU_LOCKCHAR1CHAR1
PARENTInternal: Node ID SEU_IDNUMC6SEU_ID
CHILDInternal: Node ID SEU_IDNUMC6SEU_ID
NEXTInternal: Node ID SEU_IDNUMC6SEU_ID
NLENGTHOutput length of a hierarchy node SEU_NODELNNUMC2NUM2
COLORColor display of a hierarchy node SEU_COLORNUMC1NUM1
INTENSIVIntensity of display SEU_INTENSCHAR1CHAR1
TEXTText/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTHOutput length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLORColor display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIVIntensity of display SEU_INTENSCHAR1CHAR1
TPOSHierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KINDText type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT1Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH1Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR1Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV1Intensity of display SEU_INTENSCHAR1CHAR1
TPOS1Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND1Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT2Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH2Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR2Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV2Intensity of display SEU_INTENSCHAR1CHAR1
TPOS2Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND2Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT3Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH3Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR3Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV3Intensity of display SEU_INTENSCHAR1CHAR1
TPOS3Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND3Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT4Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH4Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR4Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV4Intensity of display SEU_INTENSCHAR1CHAR1
TPOS4Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND4Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT5Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH5Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR5Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV5Intensity of display SEU_INTENSCHAR1CHAR1
TPOS5Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND5Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT6Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH6Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR6Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV6Intensity of display SEU_INTENSCHAR1CHAR1
TPOS6Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND6Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT7Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH7Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR7Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV7Intensity of display SEU_INTENSCHAR1CHAR1
TPOS7Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND7Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT8Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH8Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR8Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV8Intensity of display SEU_INTENSCHAR1CHAR1
TPOS8Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND8Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
TEXT9Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TLENGTH9Output length of a hierarchy node SEU_NODELNNUMC2NUM2
TCOLOR9Color display of a hierarchy node SEU_COLORNUMC1NUM1
TINTENSIV9Intensity of display SEU_INTENSCHAR1CHAR1
TPOS9Hierarchy display: Column position of a text SEU_POSCHAR3CHAR3
KIND9Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol) SEU_KINDCHAR1CHAR1
HIDEHide area of a hierarchy node SEU_HIDECHAR75SEU_TEXT
FORCE_PLUSSingle-Character Indicator CHAR1CHAR1CHAR1
HOTSPOTSingle-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT1Single-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT2Single-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT3Single-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT4Single-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT5Single-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT6Single-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT7Single-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT8Single-Character Indicator CHAR1CHAR1CHAR1
HOTSPOT9Single-Character Indicator CHAR1CHAR1CHAR1
INPUTSingle-Character Indicator CHAR1CHAR1CHAR1
INPUT1Single-Character Indicator CHAR1CHAR1CHAR1
INPUT2Single-Character Indicator CHAR1CHAR1CHAR1
INPUT3Single-Character Indicator CHAR1CHAR1CHAR1
INPUT4Single-Character Indicator CHAR1CHAR1CHAR1
INPUT5Single-Character Indicator CHAR1CHAR1CHAR1
INPUT6Single-Character Indicator CHAR1CHAR1CHAR1
INPUT7Single-Character Indicator CHAR1CHAR1CHAR1
INPUT8Single-Character Indicator CHAR1CHAR1CHAR1
INPUT9Single-Character Indicator CHAR1CHAR1CHAR1
NODISPLAYFlag: Nodes not displayed NODISPLAYCHAR1CHAR1_X
MOREINFOFlage: Additional information about nodes exists MOREINFOCHAR1CHAR1_X
PROPFAW0Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAWFlag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW1Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW2Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW3Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW4Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW5Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW6Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW7Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW8Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
PROPFAW9Flag: Proportional font and automatic item width PROPFAWCHAR1CHAR1_X
STYLE0Tree control style CTLSTYLENUMC2NUMC2
STYLETree control style CTLSTYLENUMC2NUMC2
STYLE1Tree control style CTLSTYLENUMC2NUMC2
STYLE2Tree control style CTLSTYLENUMC2NUMC2
STYLE3Tree control style CTLSTYLENUMC2NUMC2
STYLE4Tree control style CTLSTYLENUMC2NUMC2
STYLE5Tree control style CTLSTYLENUMC2NUMC2
STYLE6Tree control style CTLSTYLENUMC2NUMC2
STYLE7Tree control style CTLSTYLENUMC2NUMC2
STYLE8Tree control style CTLSTYLENUMC2NUMC2
STYLE9Tree control style CTLSTYLENUMC2NUMC2
NODEICONTree Control: Icon / Image TV_IMAGECHAR46TV_IMAGE
LASTHTEXT Text Field from STREEATTR0
TEXT_5Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT
TEXT_6Text/Icon/Symbol SEU_TEXTCHAR75SEU_TEXT

Key field Non-key field



How do I retrieve data from SAP structure DB2_SNODETEXT using ABAP code?

As DB2_SNODETEXT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2_SNODETEXT as there is no data to select.

How to access SAP table DB2_SNODETEXT

Within an ECC or HANA version of SAP you can also view further information about DB2_SNODETEXT 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!