The CDBD_STRUCT_I table in SAP ERP or S/4HANA stores Business transaction item – configuration data. There are total 22 fields in CDBD_STRUCT_I table. The Business transaction item – configuration table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CDBD_STRUCT_I table. It is in CRM Order: CDB Objects for General Sales Order Processing (CDB_ORDER) ABAP package and is part of the Business Transactions (CRM-BTX) module.
SAP CDBD_STRUCT_I Table Fields
Following is the list of fields that are available in SAP CDBD_STRUCT_I table. The primary key fields of Business transaction item – configuration table in SAP are CLIENT (Client), GUID (GUID of a CRM Order Object), STRUCT_I_GUID (Own guid for STRUCT_I table).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| STRUCT_I_GUID | Own guid for STRUCT_I table | CDBT_STRUCT_I_GUID | RAW (16) | |
| ORDERADM_I_GUID | Order Item Guid | CDBT_ORDERADM_I_GUID | RAW (16) | |
| INT_OBJ_NO | Configuration (Internal Object Number) | CRMT_INT_OBJ_NO | NUMC (18) | |
| EXIST_VCKEY | Indicator Variant Key Available for Item | CRMT_EXIST_VCKEY | CHAR (1) | |
| ROOT_CONFIG | Root Configuration Indicator | CRMT_ROOT_CONFIG | CHAR (1) | |
| COMP_QTY | Component quantity | CRMT_COMP_QTY | QUAN (13) | |
| COMP_QTY_UNIT | Component unit of measure | CRMT_COMP_QTY_UNIT | * | UNIT (3) |
| BASE_QTY | Base quantity | CRMT_BASE_QTY | QUAN (13) | |
| OBJ_IDENT | Object Identifier | CRMT_OBJ_IDENT | CHAR (50) | |
| OBJ_TYPE | Type of Object Identifier | CRMT_OBJ_TYPE | CHAR (2) | |
| DATE_KB_DETERM | Date for KB Determination in IPC(Master Data Version Config) | CRMT_DATE_KB_DETERMINATION | DATS (8) | |
| CONFIG_FILTER | Configuration Filter | CRMT_CONFIG_FILTER | NUMC (18) | |
| FILTER_REF | Filter Flag is Referenced | CRMT_FILTER_REF | CHAR (1) | |
| FIXQTY | Single-Character Flag | CHAR1 | CHAR (1) | |
| TR_USER | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_ID | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_STATUS | Undefined range (can be used for patch levels) | CHAR4 | CHAR (4) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| DELETED | Single-Character Flag | CHAR1 | CHAR (1) | |
| TR_ROOTID | Character field, length 32 | CHAR32 | CHAR (32) |
