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!
Object Name: X031L
Dictionary Type: Structure
Description: Nametab Structure, Database Structure DDNTF
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| TABNAME | TABNAME | CHAR | 30(0) | * | Table Name | AS4TAB | DTB | SDIC | ||||
| POSITION | FLPOS | RAW | 2(0) | Position number of table field in database | NTABLONG | SDIC | ||||||
| FLAG1 | FDFLAG1 | RAW | 1(0) | Flag 1 length 1 byte for field attributes | NTABSHORT | SDIC | ||||||
| FLAG2 | FDFLAG2 | RAW | 1(0) | Flag 2 length 1 byte for field attributes | NTABSHORT | SDIC | ||||||
| FLAG3 | FDFLAG1 | RAW | 1(0) | Flag 1 length 1 byte for field attributes | NTABSHORT | SDIC | ||||||
| FLAG4 | FDFLAG2 | RAW | 1(0) | Flag 2 length 1 byte for field attributes | NTABSHORT | SDIC | ||||||
| DBTABPOS | FLPOS | RAW | 2(0) | Position number of table field in database | NTABLONG | SDIC | ||||||
| FIELDTYPE | FLDTYPE | RAW | 1(0) | ABAP data type (coded) | NTABSHORT | SDIC | ||||||
| OFFSET | ROFFSET | RAW | 4(0) | Table field offset | DDRAW4 | SDIC | ||||||
| DBLENGTH | DBLENGTH | RAW | 2(0) | Length of field in ABAP | NTABLONG | SDIC | ||||||
| DBLENGTH2 | DBLENGTH2 | RAW | 4(0) | ABAP Dictionary: Length on Database | DDRAW4 | |||||||
| EXLENGTH | OUTLENGTH | RAW | 2(0) | Field output length | NTABLONG | SDIC | ||||||
| DECIMALS | INTDECIM | RAW | 1(0) | Number of decimal places in the field | NTABSHORT | SDIC | ||||||
| DEPTH | DDDEPTH | RAW | 1(0) | Depth in nested structures | NTABSHORT | |||||||
| FLDALIGN | FLDALIGN | RAW | 1(0) | Alignment of types with different pointer lengths | NTABSHORT | |||||||
| FIELDNAME | FIELDNAME | CHAR | 30(0) | * | Field Name | FDNAME | DFD | SDIC | ||||
| ROLLNAME | ROLLNAME | CHAR | 30(0) | * | Data element (semantic domain) | ROLLNAME | ROL | SDIC | DD_DTEL | ROLLNAME | ||
| ABTYPE | ABTYPE | RAW | 1(0) | ABAP data type (nametab interface coded) | NTABSHORT | SDIC | ||||||
| DTYP | DATATYPE_D | CHAR | 4(0) | Data Type in ABAP Dictionary | DATATYPE | SDIC | ||||||
| EXID | INTTYPE | CHAR | 1(0) | ABAP data type (C,D,N,...) | INTTYPE | SDIC | ||||||
| REFTABLE | REFTABLE | CHAR | 30(0) | * | Table for reference field | AS4TAB | SDIC | |||||
| REFFIELD | REFFIELD | CHAR | 30(0) | * | Reference field for currency and qty fields | FDNAME | SDIC | |||||
| PRECFIELD | PRECINTERN | RAW | 2(0) | Internal precision | NTABLONG | SDIC | ||||||
| CONVEXIT | CONVEXIT | CHAR | 5(0) | Conversion Routine | CONVEXIT | SDIC | ||||||
| MEMORYID | MEMORYID | CHAR | 20(0) | * | Set/Get parameter ID | MEMORYID | SDIC | |||||
| CHECKTABLE | CHECKTABLE | CHAR | 30(0) | * | Check table name of the foreign key | AS4TAB | SDIC | |||||
| DIGITS | DDINTLENG | RAW | 2(0) | Dictionary length for DEC, CURR, QUAN types | NTABLONG | SDIC |