SAP ABAP Table CRMT_BW_UBB_CONTRACT_ITEM (BW: DataSource for UBB)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BW_UBB_CONTRACT_ITEM	Table Relationship Diagram
Short Description	BW: DataSource for UBB

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	ORDERADM_H Data for BW DataSources
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
9	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
10	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
11	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
12	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
13	CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
14	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
16	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
17	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
18	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
19	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
20	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
21	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
22	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
23	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
24	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
25	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
26	.INCLUDE	☐				0	0	ORDERADM_I Data for BW DataSources
27	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
28	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
29	ITEM_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
30	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
31	ITEM_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
32	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
33	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
34	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
35	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
36	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
37	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
38	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
39	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
40	ALTERNATIVE	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
41	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
42	ITM_BP	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
43	ITEM_CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
44	ITEM_CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
45	ORDER_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
46	.INCLUDE	☐				0	0	BW UBB Extension of Contract Item Structure EXT
47	USAGEFCTGRP	☐	CRMT_UBB_USAGEFCT_GRP	CRM_UBB_USAGEFCT_GRP	CHAR	3	0	Usage Function Group	*
48	SEQUENCE	☐	CRMT_UBB_SEQUENCE	CRM_UBB_SEQUENCE	CHAR	4	0	Message Sequence for Reading Reminder	*
49	READING_DTM_PROC	☐	CRMT_UBB_VOL_I_VALID_RULE	CRM_UBB_VOL_I_VALID_RULE	CHAR	2	0	Validation Rule for Volume Documents	*
50	ESTIMAT_SEQUENCE	☐	CRMT_UBB_ESTIMATION_SEQUENCE	CRM_UBB_ESTIMATION_SEQUENCE	CHAR	4	0	Estimation Sequence
51	CONTRACT_CLASS	☐	CRMT_CONTRACT_CLASS	CRMT_CONTRACT_CLASS	NUMC	2	0	Contract Class
52	PRED_HEADER_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
53	PRED_ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
54	INVOICE_SPLIT	☐	CRMT_UBB_INVOICE_SPLIT	CRMT_UBB_INVOICE_SPLIT	CHAR	1	0	Invoice Split	*
55	.INCLUDE	☐				0	0	BW Substructure for CTR_I
56	UBB_STG_I_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
57	.INCLUDE	☐				0	0	Service Type GUIDs for LAE
58	BP_SUBTYPE	☐	CRMT_BP_SUBTYPE	CRMT_BP_SUBTYPE	CHAR	1	0	Billing Plan Subtype	*
59	XLEADING	☐	CRMT_XLEADING_SERVICE_TYPE	XFELD	CHAR	1	0	Dominant Service Type
60	.INCLUDE	☐				0	0	BW Substructure for CTR_I
61	UBB_HDPER_I_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
62	HDPER_CREATED_AT	☐	CRMT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
63	HDPER_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
64	HDPER_CHANGED_AT	☐	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
65	HDPER_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
66	HOLI_PERIOD_FROM	☐	CRMT_UBB_HOLIPER_FROM	BCOS_TSTMP	DEC	15	0	Start of Billing Holiday Period (Database Field)
67	HOLI_PERIOD_TO	☐	CRMT_UBB_HOLIPER_TO	BCOS_TSTMP	DEC	15	0	End of Billing Holiday Period (Database Field)
68	HOLI_PERIOD_TEXT	☐	CRMT_UBB_HOLIPER_TEXT	TEXT40	CHAR	40	0	Description
69	.INCLUDE	☐				0	0	UBB-Specific BILLPLAN Data
70	BILLPLAN_D_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
71	BILLPLAN_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
72	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
73	START_DATE	☐	CRMT_START_DATE	BCOS_TSTMP	DEC	15	0	Start Date of Billing Plan
74	END_DATE	☐	CRMT_END_DATE	BCOS_TSTMP	DEC	15	0	End Date of Billing Plan
75	DATE_FROM	☐	CRMT_DATE_FROM	BCOS_TSTMP	DEC	15	0	Dates From
76	DATE_TO	☐	CRMT_DATE_TO	BCOS_TSTMP	DEC	15	0	Dates To
77	ADD_BP_USAGE	☐	CRMT_BP_USAGE	CRMT_BP_USAGE	CHAR	1	0	Billing Plan Usage
78	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
79	RULE_PER_DATE_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
80	.INCLUDE	☐				0	0	Billing Plan Date: Internal Fields UBB
81	KIND_HORIZON	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
82	KIND_START_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
83	KIND_END_DATE	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
84	KIND_DATE_FROM	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
85	KIND_DATE_TO	☐	TIMENAEVEN	SC_APPTTYP	CHAR	12	0	Date type	*
86	.INCLUDE	☐				0	0	UBB BW Credit Overview
87	CR_I_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
88	VALID_FROM	☐	CRMT_UBB_VALID_FROM	CRM_TSTMP	DEC	15	0	Valid from
89	VALID_TO	☐	CRMT_UBB_VALID_TO	CRM_TSTMP	DEC	15	0	Valid To
90	QUANTITY	☐	CRMT_UBB_CRED_QUANTITY	CRM_MENGV15	QUAN	15	3	Credit Quantity
91	CURRENT_QUANTITY	☐	CRMT_UBB_CRED_CURR_QUANTITY	CRM_MENGV15	QUAN	15	3	Current Credit Quantity
92	UNIT	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	*
93	USAGEFCTCAT	☐	CRMT_UBB_USAGEFCT_CAT	CRM_UBB_USAGEFCT_CAT	CHAR	4	0	Usage Function Category
94	USAGEFCT	☐	CRMT_UBB_USAGEFCT	CRM_UBB_USAGEFCT	CHAR	4	0	Usage Function	*
95	COMMENTS	☐	CRMT_UBB_COMMENT_60	CRM_UBB_COMMENT_60	CHAR	60	0	Comment
96	SOURCE	☐	CRMT_UBB_CRED_SOURCE	CRM_UBB_CRED_SOURCE	CHAR	1	0	Credit Source
97	PRODUCT	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
98	IBASE_NO	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
99	CREDIT_STATUS	☐	CRMT_UBB_CREDIT_STATUS	CRM_UBB_CREDIT_STATUS	CHAR	1	0	Credit Status
100	CREDIT_ITEM_NO	☐	CRMT_UBB_CREDIT_ITEM_NO	NUMC5	NUMC	5	0	Credit Item Number
101	CR_TYPE	☐	CRMT_UBB_CR_TYPE	CRM_UBB_CR_TYPE	CHAR	1	0	Type of Credit	*
102	READING_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
103	READING_ID	☐	CRMT_MPK_OBJECT_ID_READING	CRM_MPK_OBJECT_ID_READING	CHAR	20	0	Reading Number
104	VALUE	☐	CRMT_UBB_CRED_VALUE	CRM_UBB_COND_VALUE	CURR	19	2	Credit Value
105	CURRENT_VALUE	☐	CRMT_UBB_CRED_VALUE_CURRENT	CRM_UBB_COND_VALUE	CURR	19	2	Current Credit Value
106	CURRENCY	☐	CRMT_UBB_CRED_CURR	WAERS	CUKY	5	0	Credit Currency	*
107	SRC_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
108	REF_CREDIT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
109	.INCLUDE	☐				0	0	UBB BW Usage Overview
110	CR_I_C_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
111	CHANGE_QUANTITY	☐	CRMT_UBB_CRED_CHANGE_QUANTITY	CRM_MENGV15	QUAN	15	3	Change Credit Quantity
112	CHANGE_VALUE	☐	CRMT_UBB_CRED_CHANGED_VALUE	CRM_UBB_COND_VALUE	CURR	19	2	Changed Credit Value
113	CR_I_C_UNIT	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	*
114	CR_I_C_CURRENCY	☐	CRMT_UBB_CRED_CURR	WAERS	CUKY	5	0	Credit Currency	*
115	REF_BRI	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
116	CONSUMP_STATUS	☐	CRMT_UBB_CONSUMPTION_STATUS	CRMT_UBB_CONSUMPTION_STATUS	CHAR	1	0	Usage Status
117	.INCLUDE	☐				0	0	Messaging Structure UBB_VOL_I
118	VOL_I_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
119	SETTL_FROM	☐	CRMT_SETTL_FROM	BCOS_TSTMP	DEC	15	0	Start of Settlement for Period
120	SETTL_TO	☐	CRMT_SETTL_TO	BCOS_TSTMP	DEC	15	0	End of Settlement for Period
121	VOL_BILLING_TMZN	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
122	VOL_USAGEFCT	☐	CRMT_UBB_USAGEFCT	CRM_UBB_USAGEFCT	CHAR	4	0	Usage Function	*
123	MEAS_POINT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
124	MEAS_POINT_ID	☐	CRMT_MPK_OBJECT_ID_MPOINT	CRM_MPK_OBJECT_ID_MPOINT	CHAR	20	0	Counter Identifier
125	VOL_READING_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
126	READING_DATE	☐	CRMT_UBB_VOL_I_END_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Date for Ending Value
127	READING_TMZN	☐	CRMT_UBB_VOL_I_END_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Ending Value	*
128	READING_VAL	☐	CRMT_UBB_VOL_I_END_VALUE	CRM_MPK_FLTP_UI	CHAR	22	0	Value at End of Interval
129	READING_ORIG	☐	CRMT_UBB_VOL_I_END_ORIGIN	CRM_UBB_READING_ORIGIN	CHAR	1	0	Origin of Ending Value
130	PRI_READING_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
131	PRI_READING_ID	☐	CRMT_UBB_VOL_ID_READING_PRI	CRM_MPK_OBJECT_ID_READING	CHAR	20	0	Number of Previous Reading
132	PRI_READING_DATE	☐	CRMT_UBB_VOL_I_START_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Date for Initial Value
133	PRI_READING_TMZN	☐	CRMT_UBB_VOL_I_START_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Starting Value	*
134	PRI_READING_VAL	☐	CRMT_UBB_VOL_I_START_VALUE	CRM_MPK_FLTP_UI	CHAR	22	0	Value at Start of Interval
135	PRI_READING_ORIG	☐	CRMT_UBB_VOL_I_START_ORIGIN	CRM_UBB_READING_ORIGIN	CHAR	1	0	Origin of Starting Value
136	VOL_UNIT	☐	CRMT_UBB_VOL_I_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Volumes	*
137	VOL_QUANTITY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
138	STATUS_PROCESS	☐	CRMT_UBB_VOL_I_STATUS_PROCESS	CRMT_UBB_VOL_I_STATUS_PROCESS	CHAR	1	0	Status of Usage Volume Document
139	STATUS_POOL	☐	CRMT_UBB_VOL_I_STATUS_POOL	CRM_BOOLEAN	CHAR	1	0	Prebilling Status of Pool Contracts
140	RELEASE_FUT_READ	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
141	DUMMY_INTERNAL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BW_UBB_CONTRACT_ITEM	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY

History

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