SAP ABAP Table CRMT_BILLPLAN_EVENT_WRK (Billing Plan: Structure for Events)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-BPL (Application Component) Billing Plan
     ⤷ CRM_BILLPLAN (Package) CRM Billing Plan

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BILLPLAN_EVENT_WRK	Table Relationship Diagram
Short Description	Billing Plan: Structure for Events

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Billing Plan
2	.INCLUDE	☐				0	0	One Order: Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	.INCLUDE	☐				0	0	External Fields for Billing Plan
6	BILLPLAN_TYPE	☐	CRMT_BILLPLAN_TYPE	CRM_BILLPLAN_TYPE	CHAR	2	0	Billing Plan Type	*
7	REFERENCE_NO	☐	CRMT_REFERENCE_NO	CRM_REFERENCE_BILLPLAN	CHAR	10	0	Reference Billing Plan Number
8	RULE_HORIZON	☐	CRMT_RULE_HORIZON	TIMERULEID	RAW	16	0	Rule for Determining Horizon in Billing Plan	*
9	START_DATE	☐	CRMT_START_DATE	BCOS_TSTMP	DEC	15	0	Start Date of Billing Plan
10	RULE_START_DATE	☐	CRMT_RULE_START_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan Start Date	*
11	END_DATE	☐	CRMT_END_DATE	BCOS_TSTMP	DEC	15	0	End Date of Billing Plan
12	RULE_END_DATE	☐	CRMT_RULE_END_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan End Date	*
13	DATE_FROM	☐	CRMT_DATE_FROM	BCOS_TSTMP	DEC	15	0	Dates From
14	RULE_DATE_FROM	☐	CRMT_RULE_DATE_FROM	TIMERULEID	RAW	16	0	Rule for Determining Dates from	*
15	DATE_TO	☐	CRMT_DATE_TO	BCOS_TSTMP	DEC	15	0	Dates To
16	RULE_DATE_TO	☐	CRMT_RULE_DATE_TO	TIMERULEID	RAW	16	0	Rule for Determining Dates To	*
17	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
18	.INCLUDE	☐				0	0	Billing Plan: Internal Fields
19	SET_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
20	KIND_HORIZON	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
21	KIND_START_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
22	KIND_END_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
23	KIND_DATE_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
24	KIND_DATE_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
25	REF_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
26	REF_KIND	☐	CRMT_OBJECT_KIND	CRM_OBJECTKIND	CHAR	1	0	Object Type
27	.INCLUDE	☐				0	0	Billing Plan: Internal Dynamic Fields
28	LINE_CHANGED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
29	.INCLUDE	☐				0	0	Billing Plan: External Dynamic Fields
30	BILLPLAN_TYPE_T	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
31	RULE_STA_DATE_T	☐	CRMT_RULE_START_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan Start Date
32	RULE_END_DATE_T	☐	CRMT_RULE_END_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan End Date
33	RULE_DATE_FROM_T	☐	CRMT_RULE_DATE_FROM_T	TIMENAME	CHAR	12	0	Rule for determining dates from
34	RULE_DATE_TO_T	☐	CRMT_RULE_DATE_TO_T	TIMENAME	CHAR	12	0	Rule for Determining Dates to
35	RULE_HORIZON_T	☐	CRMT_RULE_HORIZON_T	TIMENAME	CHAR	12	0	Rule for Determining Horizon in Billing Plan
36	DATE_HORIZON	☐	CRMT_DATE_HORIZON	BCOS_TSTMP	DEC	15	0	Horizon in Billing Plan
37	REF_TO_HEADER	☐	CRMT_BILLPLAN_REF_TO_HEADER	CHAR1	CHAR	1	0	Indicator: Billing Plan hangs on Header
38	COPY	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
39	BILLPLAN_D	☐	CRMD_BILLPLAN_D		STRU	0	0
40	.INCLUDE	☐				0	0	One Order: Key Fields
41	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
42	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
43	.INCLUDE	☐				0	0	Billing Plan Deadline: External Fields
44	BILLPLAN_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
45	.INCLUDE	☐				0	0	Date Fields at Deadline Level: External Part
46	PERIOD_DATE	☐	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
47	RULE_PERIOD_DATE	☐	CRMT_RULE_PERIOD_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Period Date
48	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
49	RULE_SETTL_FROM	☐	CRMT_RULE_SETTL_FROM	TIMERULEID	RAW	16	0	Rule for Determining Start of Settlement Period
50	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
51	RULE_SETTL_TO	☐	CRMT_RULE_SETTL_TO	TIMERULEID	RAW	16	0	Rule for Determining End of Settlement Period
52	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
53	RULE_BILL_DATE	☐	CRMT_RULE_BILL_DATE	TIMERULEID	RAW	16	0	Rule for Determining the Next Billing Date
54	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
55	RULE_INVCR_DATE	☐	CRMT_RULE_INVCR_DATE	TIMERULEID	RAW	16	0	Rule for Determining Next Billing Document Creation Date
56	VALUE_DATE	☐	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
57	RULE_VALUE_DATE	☐	CRMT_RULE_VALUE_DATE	TIMERULEID	RAW	16	0	Rule for Origin of Next Fixed Value Date
58	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set
59	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
60	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
61	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency
62	NO_OF_PERIODS	☐	CRMT_NO_OF_PERIODS		NUMC	5	0	Number of Periods in Billing Plan
63	NUMBER_INT	☐	CRMT_BILL_NUMBER_INT		NUMC	10	0	Billing Plan: Internal Sort Order
64	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
65	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
66	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold
67	NO_BILLITEMS	☐	CRMT_NO_BILLITEMS	XFELD	CHAR	1	0	Generate Flag for No Billing Request Items
68	BP_USAGE	☐	CRMT_BP_USAGE	CRMT_BP_USAGE	CHAR	1	0	Billing Plan Usage
69	BILLPLAN_LINE_ID	☐	CRMT_BILLPLAN_LINE_ID	CRMT_BILLPLAN_LINE_ID	CHAR	2	0	ID of Billing Plan Line
70	START_DATE	☐	CRMT_START_DATE	BCOS_TSTMP	DEC	15	0	Start Date of Billing Plan
71	RULE_START_DATE	☐	CRMT_RULE_START_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan Start Date
72	END_DATE	☐	CRMT_END_DATE	BCOS_TSTMP	DEC	15	0	End Date of Billing Plan
73	RULE_END_DATE	☐	CRMT_RULE_END_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan End Date
74	DATE_FROM	☐	CRMT_DATE_FROM	BCOS_TSTMP	DEC	15	0	Dates From
75	RULE_DATE_FROM	☐	CRMT_RULE_DATE_FROM	TIMERULEID	RAW	16	0	Rule for Determining Dates from
76	DATE_TO	☐	CRMT_DATE_TO	BCOS_TSTMP	DEC	15	0	Dates To
77	RULE_DATE_TO	☐	CRMT_RULE_DATE_TO	TIMERULEID	RAW	16	0	Rule for Determining Dates To
78	RULE_STA_DATE_T	☐	CRMT_RULE_START_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan Start Date
79	RULE_END_DATE_T	☐	CRMT_RULE_END_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan End Date
80	RULE_DATE_FROM_T	☐	CRMT_RULE_DATE_FROM_T	TIMENAME	CHAR	12	0	Rule for determining dates from
81	RULE_DATE_TO_T	☐	CRMT_RULE_DATE_TO_T	TIMENAME	CHAR	12	0	Rule for Determining Dates to
82	BP_SUBTYPE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype
83	.INCLUDE	☐				0	0	External UBB Fields for a Billing Plan Date
84	BPLAN_DATE_TYPE	☐	CRMT_BILLPLAN_DATE_TYPE	CRM_BILLPLAN_DATE_TYPE	NUMC	2	0	UBB Billing Plan Date Type
85	NO_OF_BLOCK	☐	CRMT_NO_OF_BLOCK		NUMC	3	0	UBB Pool Assignment
86	PROC_EVENT_TYPE	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type
87	PROC_EVENT_TYPE2	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type
88	RULE_PER_ORIG_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
89	PERIOD_DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
90	PERIOD_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit
91	.INCLUDE	☐				0	0	Billing Plan Deadline: Internal Fields
92	.INCLUDE	☐				0	0	Date Fields at Deadline Level: Internal Part
93	KIND_PERIOD_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
94	KIND_SETTL_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
95	KIND_SETTL_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
96	KIND_BILL_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
97	KIND_INVCR_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
98	KIND_VALUE_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
99	KIND_START_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
100	KIND_END_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
101	KIND_DATE_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
102	KIND_DATE_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type
103	.INCLUDE	☐				0	0	Milestone Billing Plan: Internal Fields
104	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number

History

Last changed by/on	SAP	20110908
SAP Release Created in	12A