The BAD_BILLPLAN_D table in SAP ERP or S/4HANA stores BAD – Billing plan date data. There are total 98 fields in BAD_BILLPLAN_D table. The BAD – 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 BAD_BILLPLAN_D table. It is in CRM Order: BAD Objects – General Order Processing (BAD_ORDER) ABAP package and is part of the Basic Functions for Business Transactions (CRM-BTX-BF) module.
SAP BAD_BILLPLAN_D Table Fields
Following is the list of fields that are available in SAP BAD_BILLPLAN_D 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) | |
| 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) |
| KIND_PERIOD_DATE | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_SETTL_FROM | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_SETTL_TO | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_BILL_DATE | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_INVCR_DATE | Date type | TIMENAEVEN | CHAR (12) | |
| KIND_VALUE_DATE | 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) | |
| RULE_PER_DATE_T | Rule for Determining the Period Date | CRMT_RULE_PERIOD_DATE_T | CHAR (12) | |
| RULE_BILL_DATE_T | Rule for Determining the Next Billing Date | CRMT_RULE_BILL_DATE_T | CHAR (12) | |
| RULE_INV_DATE_T | Rule for Determining Next Billing Document Creation Date | CRMT_RULE_INVCR_DATE_T | CHAR (12) | |
| RULE_VAL_DATE_T | Rule for Origin of Next Fixed Value Date | CRMT_RULE_VALUE_DATE_T | CHAR (12) | |
| RULE_SET_FROM_T | Rule for Determining Start of Settlement Period | CRMT_RULE_SETTL_FROM_T | CHAR (12) | |
| RULE_SETTL_TO_T | Rule for Determining End of Settlement Period | CRMT_RULE_SETTL_TO_T | CHAR (12) | |
| SUPPRESS_EVENT | Logical Variable | CRMT_BOOLEAN | CHAR (1) | |
| UNIT_PERIODS | Time Unit for Periods | CRMT_UNIT_PERIODS | NUMC (2) | |
| MAN_FIRSTDUEDATE | Individual Due Date | CRMT_MAN_FIRSTDUEDATE | DEC (15) | |
| NOMINAL_INT_RATE | Nominal Interest Rate | CRMT_NOMINAL_INT_RATE | DEC (10) | |
| NOMINAL_IRAT_INT | Nominal Interest Rate (Internal Plan) | CRMT_NOMINAL_INT_RATE_INT | DEC (10) | |
| DEFAULT_PERCENT | Default Percentage | CRMT_DEFAULT_PERCENTAGE | DEC (10) | |
| DEF_RATEPERX | Default Rate per x | CRMT_DEFAULT_RATEPERK | DEC (17) | |
| FREQ_CONVERSION | Payment Frequency Factor | CRMT_FREQ_CONVERSION | DEC (6) | |
| CALCULATION_DATE | Calculation date | CRMT_CALCULATION_DATE | DEC (15) | |
| FLAG_ULTIMO | Do Not Draw Standard Values from Conditions | CRMT_FLAG_ULTIMO | CHAR (1) | |
| FLAG_BLOCKED | Calculation Locked | CRMT_FLAG_BLOCKED | CHAR (1) | |
| STEP_KIND | Payment Structure/Change to Principal Indicator | CRMT_STEP_KIND | NUMC (2) | |
| FIXING | Field Control Billplan_d Rows (Fixed/Changeable) | CRMT_STEP_FIXING | NUMC (2) | |
| SETTL_FROM_VIRTU | Virtual Start of Settlement of Period | CRMT_SETTL_FROM_FIMA | DEC (15) | |
| DATEUPD_SUPPRESS | No Date Update (FIMA) | CRMT_DATEUPD_SUPPRESS | CHAR (1) | |
| OFFSET_VAL | dec5 | CRMT_DEC5 | DEC (5) | |
| OFFSET_UNIT | Name of Time Unit | TIMEUNITNA | * | CHAR (12) |
| RESULT_RATEPERK | Rate per x | CRMT_RESULT_RATEPERK | DEC (17) | |
| RESULT_RATE_K_G | Gross Rate per X | CRMT_RESULT_RATEPERK_G | DEC (17) | |
| 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) |
