In this post, I will try and describe everything you need to know about the SAP crmd_billplan 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 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....Right lets get started!
Object Name: CRMD_BILLPLAN
Dictionary Type: Transparent table
Description: Billing Plan
| 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_TYPE | CRMT_BILLPLAN_TYPE | CHAR | 2(0) | CRMC_BILP_TYPE | Billing Plan Type | CRM_BILLPLAN_TYPE | CRM | |||||
| REFERENCE_NO | CRMT_REFERENCE_NO | CHAR | 10(0) | Reference Billing Plan Number | CRM_REFERENCE_BILLPLAN | CRM | ||||||
| RULE_HORIZON | CRMT_RULE_HORIZON | RAW | 16(0) | * | Rule for Determining Horizon in Billing Plan | TIMERULEID | 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 | |||||
| BILLING_TIMEZONE | CRMT_BILLING_TIMEZONE | CHAR | 6(0) | * | Time Zone of Billing Plan Set | TZNZONE | CRM | |||||
| SET_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| KIND_HORIZON | 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 |