SAP Table X031L stores Nametab Structure, Database Structure DDNTFdata

  

In this post, I will try and describe everything you need to know about the SAP x031l table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for X031L what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from X031L....Right lets get started!


SAP X031L dictionary attributes

Object Name: X031L
Dictionary Type: Structure
Description: Nametab Structure, Database Structure DDNTF


X031L field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
TABNAMETABNAMECHAR30(0) *Table NameAS4TABDTBSDIC
POSITIONFLPOSRAW2(0) Position number of table field in databaseNTABLONGSDIC
FLAG1FDFLAG1RAW1(0) Flag 1 length 1 byte for field attributesNTABSHORTSDIC
FLAG2FDFLAG2RAW1(0) Flag 2 length 1 byte for field attributesNTABSHORTSDIC
FLAG3FDFLAG1RAW1(0) Flag 1 length 1 byte for field attributesNTABSHORTSDIC
FLAG4FDFLAG2RAW1(0) Flag 2 length 1 byte for field attributesNTABSHORTSDIC
DBTABPOSFLPOSRAW2(0) Position number of table field in databaseNTABLONGSDIC
FIELDTYPEFLDTYPERAW1(0) ABAP data type (coded)NTABSHORTSDIC
OFFSETROFFSETRAW4(0) Table field offsetDDRAW4SDIC
DBLENGTHDBLENGTHRAW2(0) Length of field in ABAPNTABLONGSDIC
DBLENGTH2DBLENGTH2RAW4(0) ABAP Dictionary: Length on DatabaseDDRAW4
EXLENGTHOUTLENGTHRAW2(0) Field output lengthNTABLONGSDIC
DECIMALSINTDECIMRAW1(0) Number of decimal places in the fieldNTABSHORTSDIC
DEPTHDDDEPTHRAW1(0) Depth in nested structuresNTABSHORT
FLDALIGNFLDALIGNRAW1(0) Alignment of types with different pointer lengthsNTABSHORT
FIELDNAMEFIELDNAMECHAR30(0) *Field NameFDNAMEDFDSDIC
ROLLNAMEROLLNAMECHAR30(0) *Data element (semantic domain)ROLLNAMEROLSDICDD_DTELROLLNAME
ABTYPEABTYPERAW1(0) ABAP data type (nametab interface coded)NTABSHORTSDIC
DTYPDATATYPE_DCHAR4(0) Data Type in ABAP DictionaryDATATYPESDIC
EXIDINTTYPECHAR1(0) ABAP data type (C,D,N,...)INTTYPESDIC
REFTABLEREFTABLECHAR30(0) *Table for reference fieldAS4TABSDIC
REFFIELDREFFIELDCHAR30(0) *Reference field for currency and qty fieldsFDNAMESDIC
PRECFIELDPRECINTERNRAW2(0) Internal precisionNTABLONGSDIC
CONVEXITCONVEXITCHAR5(0) Conversion RoutineCONVEXITSDIC
MEMORYIDMEMORYIDCHAR20(0) *Set/Get parameter IDMEMORYIDSDIC
CHECKTABLECHECKTABLECHAR30(0) *Check table name of the foreign keyAS4TABSDIC
DIGITSDDINTLENGRAW2(0) Dictionary length for DEC, CURR, QUAN typesNTABLONGSDIC