The CRMD_BILLPLAN_DA table in SAP ERP or S/4HANA stores Value Split for Billing Plan data. There are total 19 fields in CRMD_BILLPLAN_DA table. The Value Split for 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 CRMD_BILLPLAN_DA table. It is in CRM Billing Plan (CRM_BILLPLAN) ABAP package and is part of the Billing Plan (CRM-BTX-BF-BPL) module.
SAP CRMD_BILLPLAN_DA Table Fields
Following is the list of fields that are available in SAP CRMD_BILLPLAN_DA table. The primary key fields of the table are CLIENT (Client), GUID (GUID of a CRM Order Object).
| 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) | |
| PARTNER1 | Partner Number | CRMT_PARTNER_NO | CHAR (32) | |
| PARTNER1_FCT | Partner func. | CRMT_PARTNER_FCT | CHAR (8) | |
| PARTNER2 | Partner Number | CRMT_PARTNER_NO | CHAR (32) | |
| PARTNER2_FCT | Partner func. | CRMT_PARTNER_FCT | CHAR (8) | |
| AC_INDICATOR | Accounting Indicator | CRMT_AC_INDICATOR | CHAR (2) | |
| AC_OBJECT_TYPE | Object Type for Settlement Account Assignment | CRMT_AC_OBJECT_TYPE | * | CHAR (2) |
| AC_ASSIGNMENT | Settlement Account Assignment | CRMT_AC_ASSIGN | CHAR (50) | |
| AC_PERCENTAGE | Percentage of Costs to Be Distributed | CRMT_AC_COST_PERCENTAGE | DEC (5) | |
| SPLIT_ORIGIN | Origin Split | CRMT_SPLIT_ORIGIN | CHAR (2) | |
| KSCHL | Pricing – Condition Type | PRCT_COND_TYPE | * | CHAR (4) |
| GROUP1 | Group 1 | CRMT_GROUP1 | CHAR (32) | |
| GROUP2 | Group 2 | CRMT_GROUP2 | CHAR (32) | |
| GROUP3 | Group 3 | CRMT_GROUP3 | CHAR (32) | |
| GROUP4 | Group 4 | CRMT_GROUP4 | CHAR (32) | |
| GROUP5 | Group 5 | CRMT_GROUP5 | CHAR (32) | |
| GROUP6 | Group 6 | CRMT_GROUP6 | CHAR (32) | |
| GROUP7 | Group 7 | CRMT_GROUP7 | CHAR (32) |
