SAP ABAP Table CRMS_BW_IU_DSM_I_EXTRACTION (CRM DSM Item Generic Extraction Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-DSM (Application Component) Demand Side Management
     ⤷ CRM_IU_DSM_BW (Package) Utilities DSM (Demand Side management) BW package

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_BW_IU_DSM_I_EXTRACTION	Table Relationship Diagram
Short Description	CRM DSM Item Generic Extraction Structure

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	HEADER_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
3	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
4	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
5	.INCLUDE	☐				0	0	ORDERADM_I Data for BW DataSources
6	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
7	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
8	ITEM_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
9	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
10	ITEM_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
11	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
12	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
13	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
14	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
15	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
16	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
17	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
18	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
19	ALTERNATIVE	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
20	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
21	ITM_BP	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
22	ITEM_CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
23	ITEM_CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
24	ORDER_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
25	.INCLUDE	☐				0	0	PARTNER (Sales) Data for BW DataSources
26	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
27	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
28	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
29	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
30	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
31	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
32	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
33	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
34	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
35	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
36	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
37	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
38	.INCLUDE	☐				0	0	DSM Partner Set
39	PAYMENT_RECIPT	☐	CRMT_RP_PAYMENT_RECIPIENT	BU_PARTNER	CHAR	10	0	Payment Recipient	*
40	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
41	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
42	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
43	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
44	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
45	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
46	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
47	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
48	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
49	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
50	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
51	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
52	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
53	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
54	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
55	.INCLUDE	☐				0	0	General Product Data for BW DataSources
56	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
57	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
58	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
59	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
60	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
61	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
62	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
63	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
64	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
65	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
66	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
67	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
68	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
69	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
70	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
71	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
72	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
73	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
74	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
75	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
76	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
77	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
78	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
79	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
80	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
81	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
82	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
83	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
84	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
85	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
86	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
87	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
88	.INCLUDE	☐				0	0	DSM Application, Agreement Status
89	BWSTONESYSD	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
90	.INCLUDE	☐				0	0	CRM BW DSM Dates
91	SRV_RREADY	☐	DATS	DATS	DATS	8	0	Field of type DATS
92	SRV_RFIRST	☐	DATS	DATS	DATS	8	0	Field of type DATS
93	SRV_START	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
94	SRV_CUST_END	☐	SC_DATETO	DATUM	DATS	8	0	End Date
95	SRV_CUST_BEG	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
96	SETTL_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
97	SETTL_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
98	PERIOD_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
99	BILL_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
100	INVCR_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
101	DSM_VAL_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
102	DSM_VAL_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
103	DSM_REL	☐	DATS	DATS	DATS	8	0	Field of type DATS
104	START_DATE	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
105	END_DATE	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
106	DATE_FROM	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
107	DATE_TO	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
108	.INCLUDE	☐				0	0	CRM DSM Billplan D
109	ADD_BP_USAGE	☐	CRMT_BP_USAGE	CRMT_BP_USAGE	CHAR	1	0	Billing Plan Usage
110	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
111	RULE_PER_DATE_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
112	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
113	BILLPLAN_TYPE	☐	CRMT_BILLPLAN_TYPE	CRM_BILLPLAN_TYPE	CHAR	2	0	Billing Plan Type	*
114	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
115	.INCLUDE	☐				0	0	DOC_FLOW Data for BW - DSM
116	DSM_PM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
117	DSM_PM_ID	☐	CRMT_EXTERNAL_ACTIVITY_ID	CRM_EXTERNAL_ACTIVITY_ID	CHAR	20	0	External Business Transaction Number
118	DSM_APL_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
119	DSM_APL_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
120	DSM_POD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
121	DSM_PREMISE_ID	☐	CRM_ISU_PREMISE	CRM_ISU_PREMISE	CHAR	10	0	Premise
122	DSM_ITM_REF_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
123	DSM_ITM_REF_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
124	DSM_ADDR_LINE1	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
125	DSM_ADDR_LINE2	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
126	DSM_PREMISE_DESC	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
127	.INCLUDE	☐				0	0	DSM Key Figures
128	QUANTITY	☐	CRMT_QUANTITY	CRM_MENGV15	QUAN	15	3	Quantity in Doc.Flow
129	UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
130	AMOUNT	☐	CRM_IU_DSM_PRG_INCT_AMOUNT		CURR	15	2	Amount
131	TOTAL_INCT	☐	CRM_IU_DSM_PRG_INCT_AMOUNT		CURR	15	2	Amount
132	TOTAL_BILL	☐	CRM_IU_DSM_PRG_INCT_AMOUNT		CURR	15	2	Amount
133	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
134	.INCLUDE	☐				0	0	DSM Application Equipment Attribute
135	MANUFACTURER	☐	MANUFACTURER_ID_UI	MANUFACTURER_ID_UI	CHAR	40	0	Manufacturer
136	MODEL_NUMBER	☐	MANUFACT_MODEL_UI	MANUFACT_MODEL_UI	CHAR	40	0	Model Number
137	SERIAL_NO	☐	MANUFACT_SERIALNO_UI	MANUFACT_SERIALNO_UI	CHAR	40	0	Manufacturer Serial Number
138	.INCLUDE	☐				0	0	CRM BW DSM Business Agreement
139	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
140	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
141	BUAG_CLASS	☐	CRMT_BUAG_CLASS	CRMT_BUAG_CLASS	CHAR	10	0	Business Agreement Class	*
142	.INCLUDE	☐				0	0	DSM Program Equipment Category
143	EQUIP_CAT_GUID	☐	COMT_CATEGORY_GUID_CHAR32	CHAR32	CHAR	32	0	Category GUID as CHAR32
144	EQUIP_CAT_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID

History

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