SAP ABAP Table CDBD_BILLPLAN_D1 (Billing Plan Date and value Split -- CDB)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ CDB (Package) new CDB tables for new BDocs for CRM 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_BILLPLAN_D1	Table Relationship Diagram
Short Description	Billing Plan Date and value Split -- CDB

Delivery and Maintenance

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

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	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	BILLPLAN_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
4	PERIOD_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
5	PERIOD_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
6	RULE_PERIOD_DATE	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
7	SETTL_FROM_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
8	SETTL_FROM_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
9	RULE_SETTL_FROM	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
10	SETTL_TO_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
11	SETTL_TO_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
12	RULE_SETTL_TO	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
13	BILL_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
14	BILL_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
15	RULE_BILL_DATE	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
16	INVCR_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
17	INVCR_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
18	RULE_INVCR_DATE	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
19	BILLING_TIMEZONE	☐	CDB_TIME_ZONE	TZNZONE	CHAR	6	0	Time Zone	*
20	VALUE_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
21	VALUE_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
22	RULE_VALUE_DATE	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
23	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
24	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
25	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
26	NO_OF_PERIODS	☐	CRMT_NO_OF_PERIODS		NUMC	5	0	Number of Periods in Billing Plan
27	NUMBER_INT	☐	CRMT_BILL_NUMBER_INT		NUMC	10	0	Billing Plan: Internal Sort Order
28	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
29	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
30	QTY_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
31	NO_BILLITEMS	☐	CRMT_NO_BILLITEMS	XFELD	CHAR	1	0	Generate Flag for No Billing Request Items
32	BP_USAGE	☐	CRMT_BP_USAGE	CRMT_BP_USAGE	CHAR	1	0	Billing Plan Usage
33	BILLPLAN_LINE_ID	☐	CRMT_BILLPLAN_LINE_ID	CRMT_BILLPLAN_LINE_ID	CHAR	2	0	ID of Billing Plan Line
34	START_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
35	START_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
36	RULE_START_DATE	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
37	END_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
38	END_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
39	RULE_END_DATE	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
40	DATE_FROM	☐	DATS	DATS	DATS	8	0	Field of type DATS
41	TIME_FROM	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
42	RULE_DATE_FROM	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
43	DATE_TO	☐	DATS	DATS	DATS	8	0	Field of type DATS
44	TIME_TO	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
45	RULE_DATE_TO	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
46	RULE_STA_DATE_T	☐	CRMT_RULE_START_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan Start Date
47	RULE_END_DATE_T	☐	CRMT_RULE_END_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan End Date
48	RULE_DATE_FROM_T	☐	CRMT_RULE_DATE_FROM_T	TIMENAME	CHAR	12	0	Rule for determining dates from
49	RULE_DATE_TO_T	☐	CRMT_RULE_DATE_TO_T	TIMENAME	CHAR	12	0	Rule for Determining Dates to
50	BP_SUBTYPE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
51	BPLAN_DATE_TYPE	☐	CRMT_BILLPLAN_DATE_TYPE	CRM_BILLPLAN_DATE_TYPE	NUMC	2	0	UBB Billing Plan Date Type
52	NO_OF_BLOCK	☐	CRMT_NO_OF_BLOCK		NUMC	3	0	UBB Pool Assignment
53	PROC_EVENT_TYPE	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type	*
54	PROC_EVENT_TYPE2	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type	*
55	RULE_PER_ORIG_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
56	PERIOD_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
57	PERIOD_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
58	PARTNER1	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
59	PARTNER1_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
60	PARTNER2	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
61	PARTNER2_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
62	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	*
63	AC_OBJECT_TYPE	☐	CRMT_AC_OBJECT_TYPE	CRMT_OBJECT_TYPE	CHAR	2	0	Object Type for Settlement Account Assignment	*
64	AC_ASSIGNMENT	☐	CRMT_AC_ASSIGN	CRMT_AC_ASSIGN	CHAR	50	0	Settlement Account Assignment
65	AC_PERCENTAGE	☐	CRMT_AC_COST_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Costs to Be Distributed
66	SPLIT_ORIGIN	☐	CRMT_SPLIT_ORIGIN	CRMT_SPLIT_ORIGIN	CHAR	2	0	Origin Split
67	KSCHL	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
68	GROUP1	☐	CRMT_GROUP1	CRMT_GROUP	CHAR	32	0	Group 1
69	GROUP2	☐	CRMT_GROUP2	CRMT_GROUP	CHAR	32	0	Group 2
70	GROUP3	☐	CRMT_GROUP3	CRMT_GROUP	CHAR	32	0	Group 3
71	GROUP4	☐	CRMT_GROUP4	CRMT_GROUP	CHAR	32	0	Group 4
72	GROUP5	☐	CRMT_GROUP5	CRMT_GROUP	CHAR	32	0	Group 5
73	GROUP6	☐	CRMT_GROUP6	CRMT_GROUP	CHAR	32	0	Group 6
74	GROUP7	☐	CRMT_GROUP7	CRMT_GROUP	CHAR	32	0	Group 7

History

Last changed by/on	SAP	20110908
SAP Release Created in	500