SAP table CRMC_BILP_TYPL (Billing Plan Lines)
SAP table CRMC_BILP_TYPL has 3 primary key fields being CLIENT,BILLPLAN_TYPE,BILLPLAN_LINE_ID.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| BILLPLAN_TYPE | Billing Plan Type | CHAR | 2 | 0 | CRMC_BILP_TYPE | CRMT_BILLPLAN_TYPE | |||||||||
| BILLPLAN_LINE_ID | ID of Billing Plan Line | CHAR | 2 | 0 | CRMT_BILLPLAN_LINE_ID | ||||||||||
| RULE_PER_DATE_T | Rule for Determining the Period Date | CHAR | 12 | 0 | TIMERUNA | CRMT_RULE_PERIOD_DATE_T | |||||||||
| RULE_BILL_DATE_T | Rule for Determining the Next Billing Date | CHAR | 12 | 0 | TIMERUNA | CRMT_RULE_BILL_DATE_T | |||||||||
| RULE_PRICE_DATE | Rule for Determining the Pricing Date | CHAR | 1 | 0 | CRMS4_RULE_PRICE_DATE |
|
|||||||||
| RULE_INV_DATE_T | Rule for Determining Next Billing Document Creation Date | CHAR | 12 | 0 | TIMERUNA | CRMT_RULE_INVCR_DATE_T | |||||||||
| CASHFLOW_TYPE | Flow Category | CHAR | 4 | 0 | CRMC_CFTYPE | CRMT_CASHFLOW_TYPE | |||||||||
| NO_BILLITEMS | Generate Flag for No Billing Request Items | CHAR | 1 | 0 | CRMT_NO_BILLITEMS | ||||||||||
| PERCENTAGE | Percentage of Value to be Billed | DEC | 5 | 2 | CRMT_BILL_PERCENTAGE | ||||||||||
| BP_USAGE | Billing Plan Usage | CHAR | 1 | 0 | CRMT_BP_USAGE |
|
|||||||||
| DEFAULT_LINE | Milestone Billing - Plan Line Default Value | CHAR | 1 | 0 | CRMT_BILLPLAN_LINE_DEFAULT | ||||||||||
| BP_SUBTYPE | Billing Plan Subtype | CHAR | 1 | 0 | CRMC_BP_SUBTYPE | CRMT_BP_SUBTYPE |
CRMC_BILP_TYPL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 CRMC_BILP_TYPL | BILLPLAN_TYPE | CRMC_BILP_TYPE | Billing Plan Type | CLIENT |
| 0 CRMC_BILP_TYPL | BILLPLAN_TYPE | CRMC_BILP_TYPE | Billing Plan Type | BILLPLAN_TYPE |
| 1 CRMC_BILP_TYPL | CASHFLOW_TYPE | CRMC_CFTYPE | Flow Categories - Customer Definitions | CLIENT |
| 0 CRMC_BILP_TYPL | CLIENT | T000 | Clients | MANDT |
| 1 CRMC_BILP_TYPL | RULE_BILL_DATE_T | TIMERUNA | Date Rule of External Descriptor | CLIENT |
| 1 CRMC_BILP_TYPL | RULE_BILL_DATE_T | TIMERUNA | Date Rule of External Descriptor | RULE_NAME |
| 0 CRMC_BILP_TYPL | RULE_INV_DATE_T | TIMERUNA | Date Rule of External Descriptor | CLIENT |
| 0 CRMC_BILP_TYPL | RULE_INV_DATE_T | TIMERUNA | Date Rule of External Descriptor | RULE_NAME |
| 1 CRMC_BILP_TYPL | RULE_PER_DATE_T | TIMERUNA | Date Rule of External Descriptor | CLIENT |
| 1 CRMC_BILP_TYPL | RULE_PER_DATE_T | TIMERUNA | Date Rule of External Descriptor | RULE_NAME |