The CDBD_BILLPLAN table in SAP ERP or S/4HANA stores BT – Billing plan data. There are total 27 fields in CDBD_BILLPLAN table. The BT – Billing plan 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_BILLPLAN 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_BILLPLAN Table Fields
Following is the list of fields that are available in SAP CDBD_BILLPLAN table. The primary key fields of BT – Billing plan table in SAP are CLIENT (Client), BILLPLAN_GUID (BILLPLAN GUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| BILLPLAN_GUID | BILLPLAN GUID | CDBT_BILLPLAN_GUID | RAW (16) | |
| BILLPLAN_S_GUID | Billing plan Set guid | CDBT_BILLPLAN_S_GUID | RAW (16) | |
| BILLPLAN_TYPE | Billing Plan Type | CRMT_BILLPLAN_TYPE | * | CHAR (2) |
| REFERENCE_NO | Reference Billing Plan Number | CRMT_REFERENCE_NO | CHAR (10) | |
| RULE_HORIZON | Rule for Determining Horizon in Billing Plan | CRMT_RULE_HORIZON | * | RAW (16) |
| START_DATE | Start Date of Billing Plan | CRMT_START_DATE | DEC (15) | |
| RULE_START_DATE | Rule for Determining Billing Plan Start Date | CRMT_RULE_START_DATE | * | RAW (16) |
| END_DATE | End Date of Billing Plan | CRMT_END_DATE | DEC (15) | |
| RULE_END_DATE | Rule for Determining Billing Plan End Date | CRMT_RULE_END_DATE | * | RAW (16) |
| DATE_FROM | Dates From | CRMT_DATE_FROM | DEC (15) | |
| RULE_DATE_FROM | Rule for Determining Dates from | CRMT_RULE_DATE_FROM | * | RAW (16) |
| DATE_TO | Dates To | CRMT_DATE_TO | DEC (15) | |
| RULE_DATE_TO | Rule for Determining Dates To | CRMT_RULE_DATE_TO | * | RAW (16) |
| BILLING_TIMEZONE | Time Zone of Billing Plan Set | CRMT_BILLING_TIMEZONE | * | CHAR (6) |
| SET_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| KIND_HORIZON | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_START_DATE | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_END_DATE | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_DATE_FROM | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_DATE_TO | Date type | TIMENAEVEN | CHAR (12) | |
| 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) |
