The DD05B table in SAP ERP or S/4HANA stores DD: Associations for Structured Objects: Fields data. There are total 18 fields in DD05B table. The DD: Associations for Structured Objects: Fields table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DD05B table. It is in RDL Artifacts (SDCBO) ABAP package and is part of the ABAP Dictionary (BC-DWB-DIC) module.
SAP DD05B Table Fields
Following is the list of fields that are available in SAP DD05B table. The primary key fields of DD: Associations for Structured Objects: Fields table in SAP are STRUCOBJN (DD: Name of a structured object (e.g. entity, context)), NODENAME (Node Name of BO in ABAP Dictionary), ASSOCIATIONNAME (DD: Name of an Association), FIELDNAME_T (DD: Concatenated Field Name), AS4LOCAL (Activation State of Repository Object), FDPOSITION (DD: Marked Position in a Repeat Group).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| STRUCOBJN | DD: Name of a structured object (e.g. entity, context) | DDSTRUCOBJNAME | CHAR (30) | |
| NODENAME | Node Name of BO in ABAP Dictionary | DDNODENAME | CHAR (30) | |
| ASSOCIATIONNAME | DD: Name of an Association | DDASSOCIATIONNAME | CHAR (30) | |
| FIELDNAME_T | DD: Concatenated Field Name | DDFIELDNAME_L | CHAR (256) | |
| AS4LOCAL | Activation State of Repository Object | AS4LOCAL | CHAR (1) | |
| FDPOSITION | DD: Marked Position in a Repeat Group | DDFDPOS | INT4 (10) | |
| NODENAME_S | DD: Node name if source field comes from a different node | DDNODENAME_S | CHAR (30) | |
| FIELDNAME | DD: Concatenated Field Name | DDFIELDNAME_L | CHAR (256) | |
| IF_NAME | ABAP Program Name | PROGNAME | CHAR (40) | |
| IF_ATTRIBUT | DD: Interface Attribute (for Association Constants) | DDIFATTRIBUT | CHAR (250) | |
| OPERATOR | Operator in a Join Condition | VSOPERATOR | CHAR (2) | |
| UP_NODENAME_S | DD: Node name if source field comes from a different node | DDNODENAME_S | CHAR (30) | |
| UP_FIELDNAME | DD: Concatenated Field Name | DDFIELDNAME_L | CHAR (256) | |
| UP_IF_NAME | ABAP Program Name | PROGNAME | CHAR (40) | |
| UP_IF_ATTRIBUT | DD: Interface Attribute (for Association Constants) | DDIFATTRIBUT | CHAR (250) | |
| ABAP_SYSTEM_VAR | DD: ABAP system variable as field in an association | DDABAPSYSTVAR | CHAR (61) | |
| UP_OPERATOR | Operator in a Join Condition | VSOPERATOR | CHAR (2) | |
| AND_OR | AND/OR link in a selection or join condition | VSCONJ | CHAR (3) |
