SAP ABAP Table CRMT_IST_BW_CONTR_I (Extract Structure for BW DataSource Telco Contract)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-IT (Application Component) Telecommunications
⤷

CRM_IST1_BW (Package) Telco: BW Content Developments

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IST_BW_CONTR_I	Table Relationship Diagram
Short Description	Extract Structure for BW DataSource Telco Contract

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	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	IS-T: Document Item Data for BW
27	.INCLUDE				0	0	ORDERADM_I Data for BW DataSources
28	ITEM_GUID	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
29	ITEM_CREATED_AT	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
30	ITEM_CREATED_BY	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
31	ITEM_CHANGED_AT	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
32	ITEM_CHANGED_BY	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
33	ORDER_DATE	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
34	NUMBER_INT	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
35	ITEM_OBJECT_TYPE	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
36	ITM_TYPE	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
37	NUMBER_OF_I	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
38	BW_ASSIGN	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
39	ITM_USAGE	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
40	ITM_TYPE_USAGE	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
41	ALTERNATIVE	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
42	PARENT	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
43	ITM_BP	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
44	ITEM_CREATED_TS	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
45	ITEM_CHANGED_TS	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
46	ORDER_DATE_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
47	DESCRIPTION	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
48	PRODUCT	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
49	NUM_OF_MAIN_I	CRM_IST_NUM_OF_MAIN_I	INT4	INT4	10	0	IS-T: Number of Main Items
50	.INCLUDE				0	0	IS-T: Document Flow for BW
51	PRED_ITEM_GUID	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
52	MKT_ELEMENT	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
53	.INCLUDE				0	0	IS-T: Installation Component in the Order for BW
54	IB_IOBJ_GUID	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
55	IB_GUID	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
56	.INCLUDE				0	0	IS-T: Dates for BW
57	BEGIN_DATE	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
58	ENDING_DATE	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
59	PLANNED_BEG_DATE	CRM_IST_PLANNED_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	IS-T: Contract Validity Start
60	PLANNED_END_DATE	CRM_IST_PLANNED_END_DATE	CRM_RPRTNG_DATE	DATS	8	0	IS-T: Contract Validity End
61	BEGIN_TIMESLICE	CRM_IST_BEGIN_TIMESLICE	CRM_RPRTNG_DATE	DATS	8	0	IS-T: Start of Contract Time Slice
62	END_TIMESLICE	CRM_IST_END_TIMESLICE	CRM_RPRTNG_DATE	DATS	8	0	IS-T: End of Contract Time Slice
63	CANC_DATE	CRM_IST_CANC_DATE	CRM_RPRTNG_DATE	DATS	8	0	IS-T: Cancellation Date
64	.INCLUDE				0	0	IS-T: Billing Data for BW
65	BUAG_GUID	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
66	.INCLUDE				0	0	IS-T: Partner Functions for BW
67	.INCLUDE				0	0	PARTNER (General) Data for BW DataSoures
68	SALES_EMPLOYEE	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
69	PERSON_RESP	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
70	CONTACT_PERSON	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
71	SALESPARTNER	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
72	RESP_GROUP_RFW	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
73	PLANNING_ACCOUNT	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
74	.INCLUDE				0	0	PARTNER (Sales) Data for BW DataSources
75	SOLD_TO_PARTY	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
76	SHIP_TO_PARTY	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
77	BILL_TO_PARTY	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
78	PAYER	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
79	SOLD_FROM	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
80	RESP_AT_PART	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
81	.INCLUDE				0	0	ORGMAN Data for BW DataSources
82	SALES_ORG_RESP	OBJEKTID	NUM08	NUMC	8	0	Object ID
83	SALES_ORG	OBJEKTID	NUM08	NUMC	8	0	Object ID
84	SALES_OFFICE	OBJEKTID	NUM08	NUMC	8	0	Object ID
85	SALES_GROUP	OBJEKTID	NUM08	NUMC	8	0	Object ID
86	DIS_CHANNEL	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
87	DIVISION	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
88	SERVICE_ORG_RESP	OBJEKTID	NUM08	NUMC	8	0	Object ID
89	SERVICE_ORG	OBJEKTID	NUM08	NUMC	8	0	Object ID
90	PURCH_ORG_RESP	OBJEKTID	NUM08	NUMC	8	0	Object ID
91	PURCH_ORG	OBJEKTID	NUM08	NUMC	8	0	Object ID
92	PURCH_GROUP	OBJEKTID	NUM08	NUMC	8	0	Object ID
93	IC_BD_CCODE	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
94	IC_BD_LOGSYS	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
95	.INCLUDE				0	0	Territory Data for BW Data Sources (Partner Attribute)
96	PATH_GUID	CRMT_PATH_GUID_32	SYSUUID_C	CHAR	32	0	Path GUID of Territory 32
97	TERR_GUID	CRMT_TERR_GUID_32	SYSUUID_C	CHAR	32	0	Territory GUID 32
98	.INCLUDE				0	0	IS-T: Status for BW
99	BWSTTELSYS0	CRMBWST	J_STONR	NUMC	2	0	BW Status
100	BWSTTELSYS1	CRMBWST	J_STONR	NUMC	2	0	BW Status
101	BWSTTELSYS2	CRMBWST	J_STONR	NUMC	2	0	BW Status
102	BWSTTELSYS3	CRMBWST	J_STONR	NUMC	2	0	BW Status
103	BWSTTELSYS4	CRMBWST	J_STONR	NUMC	2	0	BW Status
104	BWSTTELSYS5	CRMBWST	J_STONR	NUMC	2	0	BW Status
105	BWSTTECSYS2	CRMBWST	J_STONR	NUMC	2	0	BW Status
106	BWSTLOCSYS0	CRMBWST	J_STONR	NUMC	2	0	BW Status
107	.INCLUDE				0	0	IS-T: Enhancement to the Order Item for BW
108	EXT_REF_NUMBER	IST_EXT_REF	IST_EXT_REF	CHAR	20	0	IS-T Contract Number
109	ILGUID	COMT_IL_ILGUID	SYSUUID	RAW	16	0	Internal, Unique ID of a Relationship
110	PROCESS	IST_ITEM_PROCESS	IST_ITEM_PROCESS	CHAR	4	0	Process Type
111	SCORE	IST_PROCESS_SCORE	IST_PROCESS_SCORE	NUMC	10	0	Process Score
112	SELTYPE	IST_SELECTION_TYPE	IST_SELECTION_TYPE	CHAR	1	0	Product Selection Type
113	PRCPROC	CRMT_IST_PROCESS	CRMD_IST_PROCESS	CHAR	4	0	IS-T: Pricing Process
114	.INCLUDE				0	0	CANCEL Data for BW DataSources
115	CANCPARTY	CRMT_CANC_PARTY	CRM_CANC_PARTY	CHAR	4	0	Cancelling Party
116	CANC_REASON	CRMT_SRV_CANCEL_REASON	QCODE	CHAR	4	0	CRM Service : Reason for Cancellation	*
117	.INCLUDE				0	0	IS-T: Pricing Data for BW
118	CURRENCY	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
119	.INCLUDE				0	0	IS-T: Prices for BW
120	NET_VALUE	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
121	NET_VALUE_MAN	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
122	GROSS_VALUE	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
123	NET_PRICE	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
124	TAX_AMOUNT	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
125	.INCLUDE				0	0	Structure for Composite Transaction Object
126	COMP_TX_GUID	CRMT_COMP_TX_HEADER_GUID	SYSUUID	RAW	16	0	GUID of Composite Transaction Header
127	COMP_TX_ID	CRMT_COMP_TX_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Solution Contract ID