SAP ABAP Table CRMT_BILLPLAN_UI (Billing Plan Dates)

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_UI	Table Relationship Diagram
Short Description	Billing Plan Dates

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	Management of Interface Structures
2	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
4	.INCLUDE	☐				0	0	External Fields for Billing Plan
5	BILLPLAN_TYPE	☐	CRMT_BILLPLAN_TYPE	CRM_BILLPLAN_TYPE	CHAR	2	0	Billing Plan Type	*
6	REFERENCE_NO	☐	CRMT_REFERENCE_NO	CRM_REFERENCE_BILLPLAN	CHAR	10	0	Reference Billing Plan Number
7	RULE_HORIZON	☐	CRMT_RULE_HORIZON	TIMERULEID	RAW	16	0	Rule for Determining Horizon in Billing Plan	*
8	START_DATE	☐	CRMT_START_DATE	BCOS_TSTMP	DEC	15	0	Start Date of Billing Plan
9	RULE_START_DATE	☐	CRMT_RULE_START_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan Start Date	*
10	END_DATE	☐	CRMT_END_DATE	BCOS_TSTMP	DEC	15	0	End Date of Billing Plan
11	RULE_END_DATE	☐	CRMT_RULE_END_DATE	TIMERULEID	RAW	16	0	Rule for Determining Billing Plan End Date	*
12	DATE_FROM	☐	CRMT_DATE_FROM	BCOS_TSTMP	DEC	15	0	Dates From
13	RULE_DATE_FROM	☐	CRMT_RULE_DATE_FROM	TIMERULEID	RAW	16	0	Rule for Determining Dates from	*
14	DATE_TO	☐	CRMT_DATE_TO	BCOS_TSTMP	DEC	15	0	Dates To
15	RULE_DATE_TO	☐	CRMT_RULE_DATE_TO	TIMERULEID	RAW	16	0	Rule for Determining Dates To	*
16	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
17	BILLPLAN_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
18	DATE_HORIZON	☐	CRMT_DATE_HORIZON	BCOS_TSTMP	DEC	15	0	Horizon in Billing Plan
19	DATE_HORIZ_TZTF	☐	CRMT_DATE_HORIZ_TZTF	TZTF_IO_FIELD	CHAR	26	0	Horizon in Billing Plan
20	RULE_HORIZON_T	☐	CRMT_RULE_HORIZON_T	TIMENAME	CHAR	12	0	Rule for Determining Horizon in Billing Plan	TIMERUNA
21	BILLPLAN_TYPE_T	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
22	START_DATE_TZTF	☐	CRMT_START_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Start Date of Billing Plan
23	END_DATE_TZTF	☐	CRMT_END_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	End Date of Billing Plan
24	DATE_FROM_TZTF	☐	CRMT_DATE_FROM_TZTF	TZTF_IO_FIELD	CHAR	26	0	Dates From
25	DATE_TO_TZTF	☐	CRMT_DATE_TO_TZTF	TZTF_IO_FIELD	CHAR	26	0	Dates To
26	RULE_STA_DATE_T	☐	CRMT_RULE_START_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan Start Date	TIMERUNA
27	RULE_END_DATE_T	☐	CRMT_RULE_END_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Billing Plan End Date	TIMERUNA
28	RULE_DATE_FROM_T	☐	CRMT_RULE_DATE_FROM_T	TIMENAME	CHAR	12	0	Rule for determining dates from	TIMERUNA
29	RULE_DATE_TO_T	☐	CRMT_RULE_DATE_TO_T	TIMENAME	CHAR	12	0	Rule for Determining Dates to	TIMERUNA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BILLPLAN_UI	RULE_DATE_FROM_T	TIMERUNA	RULE_NAME	REF	1	CN
2	CRMT_BILLPLAN_UI	RULE_DATE_TO_T	TIMERUNA	RULE_NAME	REF	1	CN
3	CRMT_BILLPLAN_UI	RULE_END_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
4	CRMT_BILLPLAN_UI	RULE_HORIZON_T	TIMERUNA	RULE_NAME	REF	1	CN
5	CRMT_BILLPLAN_UI	RULE_STA_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN

History

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