SAP ABAP Table CRMS_BW_IU_DSM_EXTRACTION (CRM DSM 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_EXTRACTION	Table Relationship Diagram
Short Description	CRM DSM 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	.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	PARTNER (Sales) Data for BW DataSources
47	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
48	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
49	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
50	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
51	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
52	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
53	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
54	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
55	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
56	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
57	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
58	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
59	.INCLUDE	☐				0	0	Service Partner for BW Extraction
60	SERVICE_TEAM	☐	CRMT_SERVICE_TEAM	BU_PARTNER	CHAR	10	0	Service Team	*
61	SERVICE_EMPLOYEE	☐	CRMT_SERVICE_EMPLOYEE	BU_PARTNER	CHAR	10	0	Executing Service Employee	*
62	.INCLUDE	☐				0	0	General Product Data for BW DataSources
63	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
64	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
65	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
66	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
67	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
68	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
69	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
70	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
71	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
72	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
73	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
74	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
75	.INCLUDE	☐				0	0	PRODUCT_I Data for BW DataSources
76	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT	MENG15	QUAN	15	3	Gross Weight
77	NET_WEIGHT	☐	CRMT_NET_WEIGHT	MENG15	QUAN	15	3	Net Weight
78	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
79	VOLUME	☐	CRMT_VOLUME	MENG15	QUAN	15	3	Volume Occupied by the Product per Volume Unit
80	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
81	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
82	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
83	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
84	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
85	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
86	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
87	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
88	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
89	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
90	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
91	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
92	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
93	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
94	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
95	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
96	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
97	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
98	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
99	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
100	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
101	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
102	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
103	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
104	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
105	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
106	.INCLUDE	☐				0	0	SALES Data for BW DataSources
107	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
108	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
109	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
110	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
111	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
112	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
113	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
114	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
115	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
116	PCAT_VRT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
117	PCAT_CTY_ID	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
118	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
119	DLV_RELEVANCE	☐	CRMT_DELIVERY_RELEVANT	CRM_DELIVERY_RELEVANT	CHAR	1	0	Delivery-Relevant
120	DATE_QTY_FIXED	☐	CRMT_DATE_QTY_FIXED	CRM_BOOLEAN	CHAR	1	0	Fixed Date and Quantity
121	.INCLUDE	☐				0	0	PRICING_H Data for BW DataSources
122	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
123	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
124	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
125	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
126	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
127	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
128	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
129	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
130	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
131	.INCLUDE	☐				0	0	PRICING_I Data for BW DataSources
132	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
133	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
134	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
135	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
136	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
137	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
138	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
139	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
140	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
141	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
142	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
143	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
144	CREDIT_INDICATOR	☐	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
145	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
146	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
147	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
148	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
149	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
150	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
151	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
152	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
153	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
154	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
155	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
156	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
157	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
158	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
159	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
160	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
161	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
162	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
163	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
164	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
165	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
166	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
167	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
168	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
169	.INCLUDE	☐				0	0	CRM BW DSM Dates
170	SRV_RREADY	☐	DATS	DATS	DATS	8	0	Field of type DATS
171	SRV_RFIRST	☐	DATS	DATS	DATS	8	0	Field of type DATS
172	SRV_START	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
173	SRV_CUST_END	☐	SC_DATETO	DATUM	DATS	8	0	End Date
174	SRV_CUST_BEG	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
175	SETTL_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
176	SETTL_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
177	PERIOD_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
178	BILL_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
179	INVCR_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
180	DSM_VAL_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
181	DSM_VAL_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
182	DSM_REL	☐	DATS	DATS	DATS	8	0	Field of type DATS
183	START_DATE	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
184	END_DATE	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
185	DATE_FROM	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
186	DATE_TO	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
187	.INCLUDE	☐				0	0	DOC_FLOW Data for BW - DSM
188	DSM_PM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
189	DSM_PM_ID	☐	CRMT_EXTERNAL_ACTIVITY_ID	CRM_EXTERNAL_ACTIVITY_ID	CHAR	20	0	External Business Transaction Number
190	DSM_APL_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
191	DSM_APL_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
192	DSM_POD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
193	DSM_PREMISE_ID	☐	CRM_ISU_PREMISE	CRM_ISU_PREMISE	CHAR	10	0	Premise
194	DSM_ITM_REF_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
195	DSM_ITM_REF_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
196	DSM_ADDR_LINE1	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
197	DSM_ADDR_LINE2	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
198	DSM_PREMISE_DESC	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
199	.INCLUDE	☐				0	0	DSM Partner Set
200	PAYMENT_RECIPT	☐	CRMT_RP_PAYMENT_RECIPIENT	BU_PARTNER	CHAR	10	0	Payment Recipient	*
201	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
202	.INCLUDE	☐				0	0	CRM BW DSM Business Agreement
203	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
204	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
205	BUAG_CLASS	☐	CRMT_BUAG_CLASS	CRMT_BUAG_CLASS	CHAR	10	0	Business Agreement Class	*
206	.INCLUDE	☐				0	0	BILLING Data for BW DataSources
207	BILLING_DATE	☐	CRMT_BW_BILL_DATE	CRM_RPRTNG_DATE	DATS	8	0	Billing Date
208	BILLING_BLOCK	☐	CRMT_BUS_BILL_BLOCK_REASON	CRM_BILLING_BLOCK	CHAR	2	0	Business Partner (CRM): Billing Block Reason	*
209	LOC_GUID	☐	CRMT_LOC_GUID	SYSUUID_C	CHAR	32	0	Letter of Credit GUID from SAP Global Trade Services
210	LOC_EXT_NUMBER	☐	CRMT_LOC_EXTERNAL_NUMBER		CHAR	40	0	External Number Letter of Credit
211	BILLING_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
212	.INCLUDE	☐				0	0	CRM DSM Billplan D
213	ADD_BP_USAGE	☐	CRMT_BP_USAGE	CRMT_BP_USAGE	CHAR	1	0	Billing Plan Usage
214	CASHFLOW_TYPE	☐	CRMT_CASHFLOW_TYPE	CRMT_CASHFLOW_TYPE	CHAR	4	0	Flow Category
215	RULE_PER_DATE_T	☐	CRMT_RULE_PERIOD_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Period Date
216	PERCENTAGE	☐	CRMT_BILL_PERCENTAGE	DEC3_2	DEC	5	2	Percentage of Value to be Billed
217	BILLPLAN_TYPE	☐	CRMT_BILLPLAN_TYPE	CRM_BILLPLAN_TYPE	CHAR	2	0	Billing Plan Type	*
218	BILL_VALUE	☐	CRMT_BILL_VALUE	CRM_COND_VALUE	CURR	19	2	Value to be Billed on Date Specified in Billing Plan
219	.INCLUDE	☐				0	0	External Fields for External References
220	REFERENCE_TYPE	☐	CRMT_EXT_REF_TYPE	CRM_EXT_REF_TYPE	CHAR	4	0	Type of External Reference	*
221	REFERENCE_NUMBER	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number

Foreign Keys

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

History

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