SAP ABAP Table CRMT_1030_SPLIT_UI (Billing Plan Dates for Amount Allocation)

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_1030_SPLIT_UI	Table Relationship Diagram
Short Description	Billing Plan Dates for Amount Allocation

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 Date on the User Interface
2	.INCLUDE	☐				0	0	Management of Interface Structures
3	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
5	BILLPLAN_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
6	SETTL_FROM_TZTF	☐	CRMT_SETTL_FROM_TZTF	TZTF_IO_FIELD	CHAR	26	0	Start of Settlement for Period (Interface)
7	SETTL_TO_TZTF	☐	CRMT_SETTL_TO_TZTF	TZTF_IO_FIELD	CHAR	26	0	End of Settlement for Period (Interface)
8	BILL_DATE_TZTF	☐	CRMT_BILL_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Date for Billing Index and Printout
9	INVCR_DATE_TZTF	☐	CRMT_INVCR_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Document Creation Date
10	PERIOD_DATE	☐	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
11	RULE_PER_DATE_TEXT	☐	CRMT_RULE_PERIOD_DATE_TEXT	TIMERUTEXT	CHAR	50	0	Rule for Determining the Period Date
12	RULE_PER_DATE_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date	TIMERUNA
13	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
14	RULE_SET_FROM_T	☐	CRMT_RULE_SETTL_FROM_T	TIMENAME	CHAR	12	0	Rule for Determining Start of Settlement Period	TIMERUNA
15	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
16	RULE_SETTL_TO_T	☐	CRMT_RULE_SETTL_TO_T	TIMENAME	CHAR	12	0	Rule for Determining End of Settlement Period	TIMERUNA
17	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
18	RULE_BILL_DATE_TEXT	☐	CRMT_RULE_BILL_DATE_TEXT	TIMERUTEXT	CHAR	50	0	Rule for Determining the Next Billing Date
19	RULE_BILL_DATE_T	☐	CRMT_RULE_BILL_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Next Billing Date	TIMERUNA
20	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
21	RULE_INV_DATE_TEXT	☐	CRMT_RULE_INVCR_DATE_TEXT	TIMERUTEXT	CHAR	50	0	Rule for Determining Next Billing Document Creation Date
22	RULE_INV_DATE_T	☐	CRMT_RULE_INVCR_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Next Billing Document Creation Date	TIMERUNA
23	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	TTZZ
24	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
25	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
26	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
27	NO_OF_PERIODS	☐	CRMT_NO_OF_PERIODS		NUMC	5	0	Number of Periods in Billing Plan
28	NUMBER_INT	☐	CRMT_BILL_NUMBER_INT		NUMC	10	0	Billing Plan: Internal Sort Order
29	BP_USAGE	☐	CRMT_BP_USAGE	CRMT_BP_USAGE	CHAR	1	0	Billing Plan Usage
30	BILLPLAN_LINE_ID	☐	CRMT_BILLPLAN_LINE_ID	CRMT_BILLPLAN_LINE_ID	CHAR	2	0	ID of Billing Plan Line
31	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
32	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
33	QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
34	.INCLUDE	☐				0	0	Amount Allocation UI
35	PARTNER1_NO	☐	COMT_PARTNER_NUMBER	COM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
36	PARTNER1	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
37	PARTNER1_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
38	PARTNER1_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
39	PARTNER2_NO	☐	COMT_PARTNER_NUMBER	COM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
40	PARTNER2	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
41	PARTNER2_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
42	PARTNER2_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
43	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	*
44	ACIND_DESCR	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
45	AC_OBJECT_TYPE	☐	CRMT_AC_OBJECT_TYPE_UI	CRMT_OBJECT_TYPE_UI	CHAR	5	0	Object Type for Settlement Account Assignment
46	AC_ASSIGNMENT	☐	CRMT_AC_ASSIGN	CRMT_AC_ASSIGN	CHAR	50	0	Settlement Account Assignment
47	AC_PERCENTAGE	☐	CRMT_AC_COST_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Costs to Be Distributed
48	SPLIT_ORIGIN	☐	CRMT_SPLIT_ORIGIN	CRMT_SPLIT_ORIGIN	CHAR	2	0	Origin Split
49	KSCHL	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	*
50	.INCLUDE	☐				0	0	External Grouping Fields for Amount Allocation
51	GROUP1	☐	CRMT_GROUP1	CRMT_GROUP	CHAR	32	0	Group 1
52	GROUP1_DESCR	☐	CRMT_GROUP1_DESCR	DDTEXT	CHAR	60	0	Group 1
53	GROUP2	☐	CRMT_GROUP2	CRMT_GROUP	CHAR	32	0	Group 2
54	GROUP2_DESCR	☐	CRMT_GROUP2_DESCR	DDTEXT	CHAR	60	0	Group 2
55	GROUP3	☐	CRMT_GROUP3	CRMT_GROUP	CHAR	32	0	Group 3
56	GROUP3_DESCR	☐	CRMT_GROUP3_DESCR	DDTEXT	CHAR	60	0	Group 3
57	GROUP4	☐	CRMT_GROUP4	CRMT_GROUP	CHAR	32	0	Group 4
58	GROUP4_DESCR	☐	CRMT_GROUP4_DESCR	DDTEXT	CHAR	60	0	Group 4
59	GROUP5	☐	CRMT_GROUP5	CRMT_GROUP	CHAR	32	0	Group 5
60	GROUP5_DESCR	☐	CRMT_GROUP5_DESCR	DDTEXT	CHAR	60	0	Group 5
61	GROUP6	☐	CRMT_GROUP6	CRMT_GROUP	CHAR	32	0	Group 6
62	GROUP6_DESCR	☐	CRMT_GROUP6_DESCR	DDTEXT	CHAR	60	0	Group 6
63	GROUP7	☐	CRMT_GROUP7	CRMT_GROUP	CHAR	32	0	Group 7
64	GROUP7_DESCR	☐	CRMT_GROUP7_DESCR	DDTEXT	CHAR	60	0	Group 7

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_1030_SPLIT_UI	BILLING_TIMEZONE	TTZZ	TZONE	KEY	1	CN
2	CRMT_1030_SPLIT_UI	RULE_BILL_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
3	CRMT_1030_SPLIT_UI	RULE_INV_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
4	CRMT_1030_SPLIT_UI	RULE_PER_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
5	CRMT_1030_SPLIT_UI	RULE_SETTL_TO_T	TIMERUNA	RULE_NAME	REF	1	CN
6	CRMT_1030_SPLIT_UI	RULE_SET_FROM_T	TIMERUNA	RULE_NAME	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	400