The CDBD_BILLPLAN_D table in SAP ERP or S/4HANA stores BT – Billing plan – Date data. There are total 52 fields in CDBD_BILLPLAN_D table. The BT – Billing plan – Date 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_D 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_D Table Fields
Following is the list of fields that are available in SAP CDBD_BILLPLAN_D table. The primary key fields of BT – Billing plan – Date table in SAP are CLIENT (Client), BILLPLAN_D_GUID (Billplan Dates Guid).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| BILLPLAN_D_GUID | Billplan Dates Guid | CDBT_BILLPLAN_D_GUID | RAW (16) | |
| BILLPLAN_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| PERIOD_DATE | Period Date | CRMT_PERIOD_DATE | DEC (15) | |
| RULE_PERIOD_DATE | Rule for Determining the Period Date | CRMT_RULE_PERIOD_DATE | * | RAW (16) |
| SETTL_FROM | Start of Settlement for Period | CRMT_SETTL_FROM | DEC (15) | |
| RULE_SETTL_FROM | Rule for Determining Start of Settlement Period | CRMT_RULE_SETTL_FROM | * | RAW (16) |
| SETTL_TO | End of Settlement for Period | CRMT_SETTL_TO | DEC (15) | |
| RULE_SETTL_TO | Rule for Determining End of Settlement Period | CRMT_RULE_SETTL_TO | * | RAW (16) |
| BILL_DATE | Billing Date for Billing Index and Printout | CRMT_BILL_DATE | DEC (15) | |
| RULE_BILL_DATE | Rule for Determining the Next Billing Date | CRMT_RULE_BILL_DATE | * | RAW (16) |
| INVCR_DATE | Billing Document Creation Date | CRMT_INVCR_DATE | DEC (15) | |
| RULE_INVCR_DATE | Rule for Determining Next Billing Document Creation Date | CRMT_RULE_INVCR_DATE | * | RAW (16) |
| PRICE_DATE | Pricing Date | CRMT_PRICE_DATE | DATS (8) | |
| RULE_PRICE_DATE | Rule for Determining the Pricing Date | CRMS4_RULE_PRICE_DATE | CHAR (1) | |
| VALUE_DATE | Fixed Value Date | CRMT_VALUE_DATE | DEC (15) | |
| RULE_VALUE_DATE | Rule for Origin of Next Fixed Value Date | CRMT_RULE_VALUE_DATE | * | RAW (16) |
| BILLING_TIMEZONE | Time Zone of Billing Plan Set | CRMT_BILLING_TIMEZONE | TTZZ | CHAR (6) |
| PERCENTAGE | Percentage of Value to be Billed | CRMT_BILL_PERCENTAGE | DEC (5) | |
| BILL_VALUE | Value to be Billed on Date Specified in Billing Plan | CRMT_BILL_VALUE | CURR (19) | |
| CURRENCY | Currency | CRMT_CURRENCY | TCURC | CUKY (5) |
| CASHFLOW_TYPE | Flow Category | CRMT_CASHFLOW_TYPE | CHAR (4) | |
| QUANTITY | CRM Schedule Line Quantity | CRMT_SCHEDLIN_QUAN | QUAN (13) | |
| QTY_UNIT | Unit of Measure in Which the Product Is Sold | CRMT_PROCESS_QTY_UNIT | * | UNIT (3) |
| NO_BILLITEMS | Generate Flag for No Billing Request Items | CRMT_NO_BILLITEMS | CHAR (1) | |
| BP_USAGE | Billing Plan Usage | CRMT_BP_USAGE | CHAR (1) | |
| BILLPLAN_LINE_ID | ID of Billing Plan Line | CRMT_BILLPLAN_LINE_ID | * | CHAR (2) |
| 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) |
| RULE_STA_DATE_T | Rule for Determining Billing Plan Start Date | CRMT_RULE_START_DATE_T | CHAR (12) | |
| RULE_END_DATE_T | Rule for Determining Billing Plan End Date | CRMT_RULE_END_DATE_T | CHAR (12) | |
| RULE_DATE_FROM_T | Rule for determining dates from | CRMT_RULE_DATE_FROM_T | CHAR (12) | |
| RULE_DATE_TO_T | Rule for Determining Dates to | CRMT_RULE_DATE_TO_T | CHAR (12) | |
| BP_SUBTYPE | Billing Plan Subtype | CRMT_BP_SUBTYPE | * | CHAR (1) |
| BPLAN_DATE_TYPE | UBB Billing Plan Date Type | CRMT_BILLPLAN_DATE_TYPE | NUMC (2) | |
| PROC_EVENT_TYPE | UBB Process Event Type | CRMT_PROCESS_EVENT_TYPE | CRMC_PE_TYPE | CHAR (4) |
| PROC_EVENT_TYPE2 | UBB Process Event Type | CRMT_PROCESS_EVENT_TYPE | CRMC_PE_TYPE | CHAR (4) |
| RULE_PER_ORIG_T | Rule for Determining the Period Date | CRMT_RULE_PERIOD_DATE_T | CHAR (12) | |
| PERIOD_DURA | Numerical Value of Duration | TIMEDURA | DEC (13) | |
| PERIOD_UNIT | Default Value for Time Unit | TIMEUNITDU | * | 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) |
