In this post, I will try and describe everything you need to know about the SAP crmd_billplan_d table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_BILLPLAN_D what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_BILLPLAN_D....Right lets get started!
Object Name: CRMD_BILLPLAN_D
Dictionary Type: Transparent table
Description: Billing Plan Date
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| BILLPLAN_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| PERIOD_DATE | CRMT_PERIOD_DATE | DEC | 15(0) | Period Date | BCOS_TSTMP | CRM | ||||||
| RULE_PERIOD_DATE | CRMT_RULE_PERIOD_DATE | RAW | 16(0) | * | Rule for Determining the Period Date | TIMERULEID | CRM | |||||
| SETTL_FROM | CRMT_SETTL_FROM | DEC | 15(0) | Start of Settlement for Period | BCOS_TSTMP | CRM | ||||||
| RULE_SETTL_FROM | CRMT_RULE_SETTL_FROM | RAW | 16(0) | * | Rule for Determining Start of Settlement Period | TIMERULEID | CRM | |||||
| SETTL_TO | CRMT_SETTL_TO | DEC | 15(0) | End of Settlement for Period | BCOS_TSTMP | CRM | ||||||
| RULE_SETTL_TO | CRMT_RULE_SETTL_TO | RAW | 16(0) | * | Rule for Determining End of Settlement Period | TIMERULEID | CRM | |||||
| BILL_DATE | CRMT_BILL_DATE | DEC | 15(0) | Billing Date for Billing Index and Printout | BCOS_TSTMP | CRM | ||||||
| RULE_BILL_DATE | CRMT_RULE_BILL_DATE | RAW | 16(0) | * | Rule for Determining the Next Billing Date | TIMERULEID | CRM | |||||
| INVCR_DATE | CRMT_INVCR_DATE | DEC | 15(0) | Billing Document Creation Date | BCOS_TSTMP | CRM | ||||||
| RULE_INVCR_DATE | CRMT_RULE_INVCR_DATE | RAW | 16(0) | * | Rule for Determining Next Billing Document Creation Date | TIMERULEID | CRM | |||||
| VALUE_DATE | CRMT_VALUE_DATE | DEC | 15(0) | Fixed Value Date | BCOS_TSTMP | CRM | ||||||
| RULE_VALUE_DATE | CRMT_RULE_VALUE_DATE | RAW | 16(0) | * | Rule for Origin of Next Fixed Value Date | TIMERULEID | CRM | |||||
| BILLING_TIMEZONE | CRMT_BILLING_TIMEZONE | CHAR | 6(0) | TTZZ | Time Zone of Billing Plan Set | TZNZONE | CRM | |||||
| PERCENTAGE | CRMT_BILL_PERCENTAGE | DEC | 5(2) | Percentage of Value to be Billed | DEC3_2 | CRM | ||||||
| BILL_VALUE | CRMT_BILL_VALUE | CURR | 19(2) | Value to be Billed on Date Specified in Billing Plan | PRC_COND_VALUE | CRM | ||||||
| CURRENCY | CRMT_CURRENCY | CUKY | 5(0) | * | Currency | WAERS | FWS | CRM | ||||
| NO_OF_PERIODS | CRMT_NO_OF_PERIODS | NUMC | 5(0) | Number of Periods in Billing Plan | CRM | |||||||
| NUMBER_INT | CRMT_BILL_NUMBER_INT | NUMC | 10(0) | Billing Plan: Internal Sort Order | CRM | |||||||
| CASHFLOW_TYPE | CRMT_CASHFLOW_TYPE | CHAR | 4(0) | Flow Category | CRMT_CASHFLOW_TYPE | CRM | ||||||
| QUANTITY | CRMT_SCHEDLIN_QUAN | QUAN | 13(3) | CRM Schedule Line Quantity | MENG13 | CRM | ||||||
| QTY_UNIT | CRMT_PROCESS_QTY_UNIT | UNIT | 3(0) | * | Unit of Measure in Which the Product Is Sold | MEINS | CRM | |||||
| NO_BILLITEMS | CRMT_NO_BILLITEMS | CHAR | 1(0) | Generate Flag for No Billing Request Items | XFELD | CRM | ||||||
| BP_USAGE | CRMT_BP_USAGE | CHAR | 1(0) | Billing Plan Usage | CRMT_BP_USAGE | CRM | ||||||
| BILLPLAN_LINE_ID | CRMT_BILLPLAN_LINE_ID | CHAR | 2(0) | ID of Billing Plan Line | CRMT_BILLPLAN_LINE_ID | CRM | ||||||
| START_DATE | CRMT_START_DATE | DEC | 15(0) | Start Date of Billing Plan | BCOS_TSTMP | CRM | ||||||
| RULE_START_DATE | CRMT_RULE_START_DATE | RAW | 16(0) | * | Rule for Determining Billing Plan Start Date | TIMERULEID | CRM | |||||
| END_DATE | CRMT_END_DATE | DEC | 15(0) | End Date of Billing Plan | BCOS_TSTMP | CRM | ||||||
| RULE_END_DATE | CRMT_RULE_END_DATE | RAW | 16(0) | * | Rule for Determining Billing Plan End Date | TIMERULEID | CRM | |||||
| DATE_FROM | CRMT_DATE_FROM | DEC | 15(0) | Dates From | BCOS_TSTMP | CRM | ||||||
| RULE_DATE_FROM | CRMT_RULE_DATE_FROM | RAW | 16(0) | * | Rule for Determining Dates from | TIMERULEID | CRM | |||||
| DATE_TO | CRMT_DATE_TO | DEC | 15(0) | Dates To | BCOS_TSTMP | CRM | ||||||
| RULE_DATE_TO | CRMT_RULE_DATE_TO | RAW | 16(0) | * | Rule for Determining Dates To | TIMERULEID | CRM | |||||
| RULE_STA_DATE_T | CRMT_RULE_START_DATE_T | CHAR | 12(0) | Rule for Determining Billing Plan Start Date | TIMENAME | CRM | ||||||
| RULE_END_DATE_T | CRMT_RULE_END_DATE_T | CHAR | 12(0) | Rule for Determining Billing Plan End Date | TIMENAME | CRM | ||||||
| RULE_DATE_FROM_T | CRMT_RULE_DATE_FROM_T | CHAR | 12(0) | Rule for determining dates from | TIMENAME | CRM | ||||||
| RULE_DATE_TO_T | CRMT_RULE_DATE_TO_T | CHAR | 12(0) | Rule for Determining Dates to | TIMENAME | CRM | ||||||
| BP_SUBTYPE | CRMT_BP_SUBTYPE | CHAR | 1(0) | * | Billing Plan Subtype | CRMT_BP_SUBTYPE | CRM | |||||
| BPLAN_DATE_TYPE | CRMT_BILLPLAN_DATE_TYPE | NUMC | 2(0) | UBB Billing Plan Date Type | CRM_BILLPLAN_DATE_TYPE | CRM | ||||||
| NO_OF_BLOCK | CRMT_NO_OF_BLOCK | NUMC | 3(0) | UBB Pool Assignment | CRM | |||||||
| PROC_EVENT_TYPE | CRMT_PROCESS_EVENT_TYPE | CHAR | 4(0) | CRMC_PE_TYPE | UBB Process Event Type | CRM_PROCESS_EVENT_TYPE | CRM | |||||
| PROC_EVENT_TYPE2 | CRMT_PROCESS_EVENT_TYPE | CHAR | 4(0) | CRMC_PE_TYPE | UBB Process Event Type | CRM_PROCESS_EVENT_TYPE | CRM | |||||
| RULE_PER_ORIG_T | CRMT_RULE_PERIOD_DATE_T | CHAR | 12(0) | Rule for Determining the Period Date | TIMENAME | CRM | ||||||
| PERIOD_DURA | TIMEDURA | DEC | 13(0) | Numerical Value of Duration | TIMEDURA | CRM | ||||||
| PERIOD_UNIT | TIMEUNITDU | CHAR | 12(0) | * | Default Value for Time Unit | TIMEUNITNA | CRM | |||||
| KIND_PERIOD_DATE | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_SETTL_FROM | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_SETTL_TO | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_BILL_DATE | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_INVCR_DATE | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_VALUE_DATE | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_START_DATE | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_END_DATE | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_DATE_FROM | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| KIND_DATE_TO | TIMENAEVEN | CHAR | 12(0) | * | Date type | SC_APPTTYP | TIMENAEV | NAME_EVENT | CRM | |||
| NUMBER_EXT | CRMT_ITEM_NO_EXT | NUMC | 10(0) | External Item Number | CRM |