SAP ABAP Table CRMS_BW_IU_DSM_H_EXTRACTION (CRM DSM Header 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_H_EXTRACTION	Table Relationship Diagram
Short Description	CRM DSM Header 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	External Fields for External References
27	REFERENCE_TYPE	☐	CRMT_EXT_REF_TYPE	CRM_EXT_REF_TYPE	CHAR	4	0	Type of External Reference	*
28	REFERENCE_NUMBER	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
29	.INCLUDE	☐				0	0	CRM BW DSM Business Agreement
30	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
31	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
32	BUAG_CLASS	☐	CRMT_BUAG_CLASS	CRMT_BUAG_CLASS	CHAR	10	0	Business Agreement Class	*
33	.INCLUDE	☐				0	0	PARTNER (Sales) Data for BW DataSources
34	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
35	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
36	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
37	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
38	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
39	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
40	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
41	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
42	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
43	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
44	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
45	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
46	.INCLUDE	☐				0	0	DSM Partner Set
47	PAYMENT_RECIPT	☐	CRMT_RP_PAYMENT_RECIPIENT	BU_PARTNER	CHAR	10	0	Payment Recipient	*
48	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
49	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
50	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
51	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
52	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
53	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
54	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
55	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
56	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
57	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
58	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
59	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
60	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
61	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
62	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
63	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
64	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
65	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
66	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
67	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
68	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
69	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
70	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
71	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
72	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
73	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
74	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
75	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
76	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
77	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
78	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
79	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
80	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
81	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
82	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
83	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
84	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
85	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
86	.INCLUDE	☐				0	0	DSM Application, Agreement Status
87	BWSTONESYSD	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
88	.INCLUDE	☐				0	0	CRM BW DSM Dates
89	SRV_RREADY	☐	DATS	DATS	DATS	8	0	Field of type DATS
90	SRV_RFIRST	☐	DATS	DATS	DATS	8	0	Field of type DATS
91	SRV_START	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
92	SRV_CUST_END	☐	SC_DATETO	DATUM	DATS	8	0	End Date
93	SRV_CUST_BEG	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
94	SETTL_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
95	SETTL_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
96	PERIOD_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
97	BILL_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
98	INVCR_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
99	DSM_VAL_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
100	DSM_VAL_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
101	DSM_REL	☐	DATS	DATS	DATS	8	0	Field of type DATS
102	START_DATE	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
103	END_DATE	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
104	DATE_FROM	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
105	DATE_TO	☐	CRMT_DATE	DATUM	DATS	8	0	Date for Different Goals (Posting Date etc.)
106	.INCLUDE	☐				0	0	DOC_FLOW Data for BW - DSM
107	DSM_PM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
108	DSM_PM_ID	☐	CRMT_EXTERNAL_ACTIVITY_ID	CRM_EXTERNAL_ACTIVITY_ID	CHAR	20	0	External Business Transaction Number
109	DSM_APL_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
110	DSM_APL_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
111	DSM_POD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
112	DSM_PREMISE_ID	☐	CRM_ISU_PREMISE	CRM_ISU_PREMISE	CHAR	10	0	Premise
113	DSM_ITM_REF_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
114	DSM_ITM_REF_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
115	DSM_ADDR_LINE1	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
116	DSM_ADDR_LINE2	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
117	DSM_PREMISE_DESC	☐	CRM_IU_DSM_ADDR_LINE	LINES	CHAR	80	0	Address Line
118	.INCLUDE	☐				0	0	DSM Key Figures
119	QUANTITY	☐	CRMT_QUANTITY	CRM_MENGV15	QUAN	15	3	Quantity in Doc.Flow
120	UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
121	AMOUNT	☐	CRM_IU_DSM_PRG_INCT_AMOUNT		CURR	15	2	Amount
122	TOTAL_INCT	☐	CRM_IU_DSM_PRG_INCT_AMOUNT		CURR	15	2	Amount
123	TOTAL_BILL	☐	CRM_IU_DSM_PRG_INCT_AMOUNT		CURR	15	2	Amount
124	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*

Foreign Keys

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

History

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