SAP ABAP Table CDBD_BILLPLAN_D (BT - Billing plan - Date)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CDB_ORDER (Package) CRM Order: CDB Objects for General Sales Order Processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_BILLPLAN_D	Table Relationship Diagram
Short Description	BT - Billing plan - Date

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BILLPLAN_D_GUID	☑	CDBT_BILLPLAN_D_GUID	SYSUUID	RAW	16	0	Billplan Dates Guid
3	.INCLUDE	☐				0	0	Billing Plan Deadline: External Fields
4	BILLPLAN_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	.INCLUDE	☐				0	0	Date Fields at Deadline Level: External Part
6	PERIOD_DATE	☐	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
7	RULE_PERIOD_DATE	☐	CRMT_RULE_PERIOD_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Period Date	*
8	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
9	RULE_SETTL_FROM	☐	CRMT_RULE_SETTL_FROM	TIMERULEID	RAW	16	0	Rule for Determining Start of Settlement Period	*
10	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
11	RULE_SETTL_TO	☐	CRMT_RULE_SETTL_TO	TIMERULEID	RAW	16	0	Rule for Determining End of Settlement Period	*
12	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
13	RULE_BILL_DATE	☐	CRMT_RULE_BILL_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Next Billing Date	*
14	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
15	RULE_INVCR_DATE	☐	CRMT_RULE_INVCR_DATE	TIMERULEID	RAW	16	0	Rule for Determining Next Billing Document Creation Date	*
16	VALUE_DATE	☐	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
17	RULE_VALUE_DATE	☐	CRMT_RULE_VALUE_DATE	TIMERULEID	RAW	16	0	Rule for Origin of Next Fixed Value Date	*
18	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
19	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
20	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
21	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
22	NO_OF_PERIODS	☐	CRMT_NO_OF_PERIODS		NUMC	5	0	Number of Periods in Billing Plan
23	NUMBER_INT	☐	CRMT_BILL_NUMBER_INT		NUMC	10	0	Billing Plan: Internal Sort Order
24	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
25	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
26	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
27	NO_BILLITEMS	☐	CRMT_NO_BILLITEMS	XFELD	CHAR	1	0	Generate Flag for No Billing Request Items
28	BP_USAGE	☐	CRMT_BP_USAGE	CRMT_BP_USAGE	CHAR	1	0	Billing Plan Usage
29	BILLPLAN_LINE_ID	☐	CRMT_BILLPLAN_LINE_ID	CRMT_BILLPLAN_LINE_ID	CHAR	2	0	ID of Billing Plan Line
30	START_DATE	☐	CRMT_START_DATE	BCOS_TSTMP	DEC	15	0	Start Date of Billing Plan
31	RULE_START_DATE	☐	CRMT_RULE_START_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan Start Date	*
32	END_DATE	☐	CRMT_END_DATE	BCOS_TSTMP	DEC	15	0	End Date of Billing Plan
33	RULE_END_DATE	☐	CRMT_RULE_END_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan End Date	*
34	DATE_FROM	☐	CRMT_DATE_FROM	BCOS_TSTMP	DEC	15	0	Dates From
35	RULE_DATE_FROM	☐	CRMT_RULE_DATE_FROM	TIMERULEID	RAW	16	0	Rule for Determining Dates from	*
36	DATE_TO	☐	CRMT_DATE_TO	BCOS_TSTMP	DEC	15	0	Dates To
37	RULE_DATE_TO	☐	CRMT_RULE_DATE_TO	TIMERULEID	RAW	16	0	Rule for Determining Dates To	*
38	RULE_STA_DATE_T	☐	CRMT_RULE_START_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan Start Date
39	RULE_END_DATE_T	☐	CRMT_RULE_END_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan End Date
40	RULE_DATE_FROM_T	☐	CRMT_RULE_DATE_FROM_T	TIMENAME	CHAR	12	0	Rule for determining dates from
41	RULE_DATE_TO_T	☐	CRMT_RULE_DATE_TO_T	TIMENAME	CHAR	12	0	Rule for Determining Dates to
42	BP_SUBTYPE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
43	.INCLUDE	☐				0	0	External UBB Fields for a Billing Plan Date
44	BPLAN_DATE_TYPE	☐	CRMT_BILLPLAN_DATE_TYPE	CRM_BILLPLAN_DATE_TYPE	NUMC	2	0	UBB Billing Plan Date Type
45	NO_OF_BLOCK	☐	CRMT_NO_OF_BLOCK		NUMC	3	0	UBB Pool Assignment
46	PROC_EVENT_TYPE	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type	CRMC_PE_TYPE
47	PROC_EVENT_TYPE2	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type	CRMC_PE_TYPE
48	RULE_PER_ORIG_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
49	PERIOD_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
50	PERIOD_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
51	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
52	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
53	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
54	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
55	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
56	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
57	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CDBD_BILLPLAN_D	CURRENCY	TCURC	WAERS
2	CDBD_BILLPLAN_D	PROC_EVENT_TYPE	CRMC_PE_TYPE	PROC_EVENT_TYPE	KEY	1	CN
3	CDBD_BILLPLAN_D	PROC_EVENT_TYPE2	CRMC_PE_TYPE	PROC_EVENT_TYPE	KEY	1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	20C