SAP ABAP Table CRMT_0502_ALV_BILLPLAN_D_UI (UBB Billing Plan Dates in ALV)

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_0502_ALV_BILLPLAN_D_UI	Table Relationship Diagram
Short Description	UBB Billing Plan Dates in ALV

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	SELECTION_MARK	☐	CRMT_SELECTION_MARK	CRM_SELECTION_MARK	CHAR	1	0	Selection Indicator for Table Controls
2	.INCLUDE	☐				0	0	UBB Billing Plan Date in the User Interface
3	.INCLUDE	☐				0	0	UBB Billing Plan Date in User Interface
4	.INCLUDE	☐				0	0	Billing Plan Date on the User Interface
5	.INCLUDE	☐				0	0	Management of Interface Structures
6	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
7	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
8	BILLPLAN_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
9	SETTL_FROM_TZTF	☐	CRMT_SETTL_FROM_TZTF	TZTF_IO_FIELD	CHAR	26	0	Start of Settlement for Period (Interface)
10	SETTL_TO_TZTF	☐	CRMT_SETTL_TO_TZTF	TZTF_IO_FIELD	CHAR	26	0	End of Settlement for Period (Interface)
11	BILL_DATE_TZTF	☐	CRMT_BILL_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Date for Billing Index and Printout
12	INVCR_DATE_TZTF	☐	CRMT_INVCR_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Document Creation Date
13	PERIOD_DATE	☐	CRMT_PERIOD_DATE	BCOS_TSTMP	DEC	15	0	Period Date
14	RULE_PER_DATE_TEXT	☐	CRMT_RULE_PERIOD_DATE_TEXT	TIMERUTEXT	CHAR	50	0	Rule for Determining the Period Date
15	RULE_PER_DATE_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date	TIMERUNA
16	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
17	RULE_SET_FROM_T	☐	CRMT_RULE_SETTL_FROM_T	TIMENAME	CHAR	12	0	Rule for Determining Start of Settlement Period	TIMERUNA
18	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
19	RULE_SETTL_TO_T	☐	CRMT_RULE_SETTL_TO_T	TIMENAME	CHAR	12	0	Rule for Determining End of Settlement Period	TIMERUNA
20	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
21	RULE_BILL_DATE_TEXT	☐	CRMT_RULE_BILL_DATE_TEXT	TIMERUTEXT	CHAR	50	0	Rule for Determining the Next Billing Date
22	RULE_BILL_DATE_T	☐	CRMT_RULE_BILL_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Next Billing Date	TIMERUNA
23	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
24	RULE_INV_DATE_TEXT	☐	CRMT_RULE_INVCR_DATE_TEXT	TIMERUTEXT	CHAR	50	0	Rule for Determining Next Billing Document Creation Date
25	RULE_INV_DATE_T	☐	CRMT_RULE_INVCR_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Next Billing Document Creation Date	TIMERUNA
26	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
27	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
28	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
29	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
30	NO_OF_PERIODS	☐	CRMT_NO_OF_PERIODS		NUMC	5	0	Number of Periods in Billing Plan
31	NUMBER_INT	☐	CRMT_BILL_NUMBER_INT		NUMC	10	0	Billing Plan: Internal Sort Order
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	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
35	START_DATE	☐	CRMT_START_DATE	BCOS_TSTMP	DEC	15	0	Start Date of Billing Plan
36	RULE_START_DATE	☐	CRMT_RULE_START_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan Start Date	*
37	END_DATE	☐	CRMT_END_DATE	BCOS_TSTMP	DEC	15	0	End Date of Billing Plan
38	RULE_END_DATE	☐	CRMT_RULE_END_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan End Date	*
39	DATE_FROM	☐	CRMT_DATE_FROM	BCOS_TSTMP	DEC	15	0	Dates From
40	RULE_DATE_FROM	☐	CRMT_RULE_DATE_FROM	TIMERULEID	RAW	16	0	Rule for Determining Dates from	*
41	DATE_TO	☐	CRMT_DATE_TO	BCOS_TSTMP	DEC	15	0	Dates To
42	RULE_DATE_TO	☐	CRMT_RULE_DATE_TO	TIMERULEID	RAW	16	0	Rule for Determining Dates To	*
43	RULE_STA_DATE_T	☐	CRMT_RULE_START_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan Start Date
44	RULE_END_DATE_T	☐	CRMT_RULE_END_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan End Date
45	RULE_DATE_FROM_T	☐	CRMT_RULE_DATE_FROM_T	TIMENAME	CHAR	12	0	Rule for determining dates from
46	RULE_DATE_TO_T	☐	CRMT_RULE_DATE_TO_T	TIMENAME	CHAR	12	0	Rule for Determining Dates to
47	.INCLUDE	☐				0	0	External UBB Fields for a Billing Plan Date
48	BPLAN_DATE_TYPE	☐	CRMT_BILLPLAN_DATE_TYPE	CRM_BILLPLAN_DATE_TYPE	NUMC	2	0	UBB Billing Plan Date Type
49	NO_OF_BLOCK	☐	CRMT_NO_OF_BLOCK		NUMC	3	0	UBB Pool Assignment
50	PROC_EVENT_TYPE	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type	CRMC_PE_TYPE
51	PROC_EVENT_TYPE2	☐	CRMT_PROCESS_EVENT_TYPE	CRM_PROCESS_EVENT_TYPE	CHAR	4	0	UBB Process Event Type	CRMC_PE_TYPE
52	RULE_PER_ORIG_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
53	BP_SUBTYPE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
54	CELL	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_0502_ALV_BILLPLAN_D_UI	PROC_EVENT_TYPE	CRMC_PE_TYPE	PROC_EVENT_TYPE	KEY	1	CN
2	CRMT_0502_ALV_BILLPLAN_D_UI	PROC_EVENT_TYPE2	CRMC_PE_TYPE	PROC_EVENT_TYPE	KEY	1	CN
3	CRMT_0502_ALV_BILLPLAN_D_UI	RULE_BILL_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
4	CRMT_0502_ALV_BILLPLAN_D_UI	RULE_INV_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
5	CRMT_0502_ALV_BILLPLAN_D_UI	RULE_PER_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
6	CRMT_0502_ALV_BILLPLAN_D_UI	RULE_SETTL_TO_T	TIMERUNA	RULE_NAME	REF	1	CN
7	CRMT_0502_ALV_BILLPLAN_D_UI	RULE_SET_FROM_T	TIMERUNA	RULE_NAME	REF	1	CN

History

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