The CDBD_ORDERADM_H table in SAP ERP or S/4HANA stores Business Transaction data. There are total 44 fields in CDBD_ORDERADM_H table. The Business Transaction 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_ORDERADM_H 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_ORDERADM_H Table Fields
Following is the list of fields that are available in SAP CDBD_ORDERADM_H table. The primary key fields of Business Transaction table in SAP are CLIENT (Client), ORDERADM_H_GUID (Character field, length 32).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| ORDERADM_H_GUID | Character field, length 32 | CHAR32 | CHAR (32) | |
| OBJECT_ID | Transaction ID | CRMT_OBJECT_ID | CHAR (10) | |
| PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE | CHAR (4) | |
| DESCRIPTION | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR (40) | |
| DESCR_LANGUAGE | Component of the Version Number | CHAR2 | CHAR (2) | |
| COMPLETION | Completion Rate in Percent | CRMT_COMPLETION | NUMC (3) | |
| TEMPLATE_TYPE | Service Transaction: Template Type | CRMT_TEMPLATE_TYPE | CHAR (1) | |
| LOGICAL_SYSTEM | Logical System | CRMT_LOGSYS | CHAR (10) | |
| OBJECT_TYPE | Business Transaction Category | CRMT_SUBOBJECT_CATEGORY | CRMC_SUBOB_CAT | CHAR (10) |
| CREATED_AT_DATE | Field of type DATS | DATS | DATS (8) | |
| CREATED_BY | User that Created the Transaction | CRMT_CREATED_BY | CHAR (12) | |
| CHANGED_AT_DATE | Field of type DATS | DATS | DATS (8) | |
| CHANGED_BY | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR (12) | |
| ARCHIVING_FLAG | Indicator Whether the Business Transaction Can Be Archived | CRMT_ARCHIVING_FLAG | CHAR (1) | |
| OBJECT_ID_OK | Indicator That Transaction ID Is Correct | CRMT_OBJECT_ID_OK | CHAR (1) | |
| OBJECTIVE | Goal of an Activity | CRMT_OBJECTIVE | CHAR (3) | |
| PRIORITY | Activity Priority | CRMT_PRIORITY | NUMC (1) | |
| CATEGORY | Activity Category (Communication Type) | CRMT_ACTIVITY_CATEGORY | CHAR (3) | |
| DESIREDSTARTDATE | Field of type DATS | DATS | DATS (8) | |
| DESIREDSTARTTIME | Field of type TIMS | TIMS | TIMS (6) | |
| DESIREDENDDATE | Field of type DATS | DATS | DATS (8) | |
| DESIREDENDTIME | Field of type TIMS | TIMS | TIMS (6) | |
| ORD_STATUS | System status | J_ISTAT | CHAR (5) | |
| USER_STATUS | User Status | J_ESTAT | CHAR (5) | |
| ERROR_FLAG | Error Flag denoting error with the status | ERR_FLAG | CHAR (1) | |
| TIME_ZONE | Time Zone | TZNZONE | CHAR (6) | |
| PARENT_ORDER | Character field, length 32 | CHAR32 | CHAR (32) | |
| 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) | |
| KALSM | Pricing Procedure | PRCT_PRIC_PROC_CDB | CHAR (6) | |
| NET_VALUE | Total Net Value of Document in Document Currency | CRMT_NET_VALUE_CUM | CURR (15) | |
| COND | Character field of length 6 | CHAR6 | CHAR (6) | |
| SERVICE_ID | Template Search Term | CRMT_TSRV_SERVICE_ID | CHAR (54) | |
| CHANGED_AT_TIME | Field of type TIMS | TIMS | TIMS (6) | |
| CREATED_AT_TIME | Field of type TIMS | TIMS | TIMS (6) | |
| CRM_RELEASE | SAP Release | SAPRELEASE | CHAR (10) | |
| CRM_CHANGED_AT | Time of Last Change in CRM Online | CRMT_ONLINE_CHANGED_AT | DEC (15) | |
| CURRENCY | Currency | CRMT_CURRENCY | CUKY (5) | |
| PARENT_OBJTYPE | Business Transaction Category | CRMT_SUBOBJECT_CATEGORY | CHAR (10) |
