CRMD_BILLPLAN_D - Billing Plan Date

Billing Plan Date information is stored in SAP table CRMD_BILLPLAN_D.
It is part of development package CRM_BILLPLAN in software component CRM-BTX-BF-BPL. This development package consists of objects that can be grouped under "CRM Billing Plan".

Fields for table CRMD_BILLPLAN_D

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMT_OBJECT_KEY	0
CLIENT	Client	X	MANDT	CLNT	6	*
GUID	GUID of a CRM Order Object	X	CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMT_BILLPLAN_D_EXT	0
BILLPLAN_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMT_BILLING_DATES_EXT	0
PERIOD_DATE	Period Date		CRMT_PERIOD_DATE	DEC	8
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	8
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	8
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	8
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	8
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	16
RULE_PRICE_DATE	Rule for Determining the Pricing Date		CRMS4_RULE_PRICE_DATE	CHAR	2
VALUE_DATE	Fixed Value Date		CRMT_VALUE_DATE	DEC	8
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	CHAR	12	TTZZ
PERCENTAGE	Percentage of Value to be Billed		CRMT_BILL_PERCENTAGE	DEC	3
BILL_VALUE	Value to be Billed on Date Specified in Billing Plan		CRMT_BILL_VALUE	CURR	10
CURRENCY	Currency		CRMT_CURRENCY	CUKY	10	TCURC
NO_OF_PERIODS	Number of Periods in Billing Plan		CRMT_NO_OF_PERIODS	NUMC	10
NUMBER_INT	Billing Plan: Internal Sort Order		CRMT_BILL_NUMBER_INT	NUMC	20
CASHFLOW_TYPE	Flow Category		CRMT_CASHFLOW_TYPE	CHAR	8
QUANTITY	CRM Schedule Line Quantity		CRMT_SCHEDLIN_QUAN	QUAN	7
QTY_UNIT	Unit of Measure in Which the Product Is Sold		CRMT_PROCESS_QTY_UNIT	UNIT	6	*
NO_BILLITEMS	Generate Flag for No Billing Request Items		CRMT_NO_BILLITEMS	CHAR	2
BP_USAGE	Billing Plan Usage		CRMT_BP_USAGE	CHAR	2
BILLPLAN_LINE_ID	ID of Billing Plan Line		CRMT_BILLPLAN_LINE_ID	CHAR	4	*
START_DATE	Start Date of Billing Plan		CRMT_START_DATE	DEC	8
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	8
RULE_END_DATE	Rule for Determining Billing Plan End Date		CRMT_RULE_END_DATE	RAW	16	*
DATE_FROM	Dates From		CRMT_DATE_FROM	DEC	8
RULE_DATE_FROM	Rule for Determining Dates from		CRMT_RULE_DATE_FROM	RAW	16	*
DATE_TO	Dates To		CRMT_DATE_TO	DEC	8
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	24
RULE_END_DATE_T	Rule for Determining Billing Plan End Date		CRMT_RULE_END_DATE_T	CHAR	24
RULE_DATE_FROM_T	Rule for determining dates from		CRMT_RULE_DATE_FROM_T	CHAR	24
RULE_DATE_TO_T	Rule for Determining Dates to		CRMT_RULE_DATE_TO_T	CHAR	24
BP_SUBTYPE	Billing Plan Subtype		CRMT_BP_SUBTYPE	CHAR	2	*
.INCLUDE				CRMT_BILLPLAN_D_UBB_EXT	0
BPLAN_DATE_TYPE	UBB Billing Plan Date Type		CRMT_BILLPLAN_DATE_TYPE	NUMC	4
NO_OF_BLOCK	UBB Pool Assignment		CRMT_NO_OF_BLOCK	NUMC	6
PROC_EVENT_TYPE	UBB Process Event Type		CRMT_PROCESS_EVENT_TYPE	CHAR	8	CRMC_PE_TYPE
PROC_EVENT_TYPE2	UBB Process Event Type		CRMT_PROCESS_EVENT_TYPE	CHAR	8	CRMC_PE_TYPE
RULE_PER_ORIG_T	Rule for Determining the Period Date		CRMT_RULE_PERIOD_DATE_T	CHAR	24
PERIOD_DURA	Numerical Value of Duration		TIMEDURA	DEC	7
PERIOD_UNIT	Default Value for Time Unit		TIMEUNITDU	CHAR	24	*
BILL_SETTL_STAT	Settlement Status of Billing Request Line		CRM_BILLING_SETTLEMENT_STATUS	CHAR	2
DESCRIPTION	Description		CRMT_DESC	CHAR	80
BILLING_BLOCK	Business Partner: Billing Block Reason		CRMT_BUS_BILL_BLOCK_REASON	CHAR	4	*
SERVICESRENDEREDDATETIME	Services Rendered Date as Timestamp		CRMS4_SRV_RENDER_TSTMP	DEC	8
.INCLUDE				CRMT_BILLPLAN_D_INT	0
.INCLUDE				CRMT_BILLING_DATES_INT	0
KIND_PERIOD_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_SETTL_FROM	Date type		TIMENAEVEN	CHAR	24
KIND_SETTL_TO	Date type		TIMENAEVEN	CHAR	24
KIND_BILL_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_INVCR_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_VALUE_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_START_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_END_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_DATE_FROM	Date type		TIMENAEVEN	CHAR	24
KIND_DATE_TO	Date type		TIMENAEVEN	CHAR	24
.INCLUDE				CRMT_BILLPLAN_MSTONE_INT	0
NUMBER_EXT	External Item Number		CRMT_ITEM_NO_EXT	NUMC	20