SAP ABAP Table CRMT_BW_GCR (CRM BW Grantor Change Request)

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_GCR	Table Relationship Diagram
Short Description	CRM BW Grantor Change Request

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	PARTNER (Sales) Data for BW DataSources
27	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
28	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
29	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
30	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
31	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
32	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
33	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
34	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
35	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
36	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
37	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
38	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
39	.INCLUDE	☐				0	0	Service Partner for BW Extraction
40	SERVICE_TEAM	☐	CRMT_SERVICE_TEAM	BU_PARTNER	CHAR	10	0	Service Team	*
41	SERVICE_EMPLOYEE	☐	CRMT_SERVICE_EMPLOYEE	BU_PARTNER	CHAR	10	0	Executing Service Employee	*
42	.INCLUDE	☐				0	0	BW Partner/Grantor
43	PAYMENT_RECIPT	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
44	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
45	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
46	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
47	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
48	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
49	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
50	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
51	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
52	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
53	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
54	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
55	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
56	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
57	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
58	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
59	.INCLUDE	☐				0	0	SALES Data for BW DataSources
60	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
61	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
62	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
63	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
64	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
65	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
66	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
67	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
68	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
69	PCAT_VRT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
70	PCAT_CTY_ID	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
71	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
72	DLV_RELEVANCE	☐	CRMT_DELIVERY_RELEVANT	CRM_DELIVERY_RELEVANT	CHAR	1	0	Delivery-Relevant
73	DATE_QTY_FIXED	☐	CRMT_DATE_QTY_FIXED	CRM_BOOLEAN	CHAR	1	0	Fixed Date and Quantity
74	.INCLUDE	☐				0	0	PRICING_H Data for BW DataSources
75	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
76	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
77	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
78	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
79	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
80	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
81	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
82	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
83	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
84	.INCLUDE	☐				0	0	CRM BW Dates Grantor
85	VALID_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
86	VALID_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
87	ITEM_VALFR	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
88	ITEM_VALTO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
89	DURA	☐	TIMEDURA	TIMEDURA	DEC	13	0	Numerical Value of Duration
90	DUE_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
91	DURA_UNIT	☐	TIMEUNITDU	TIMEUNITNA	CHAR	12	0	Default Value for Time Unit	*
92	EXPENSE_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
93	.INCLUDE	☐				0	0	CUMULATED_H Data for BW Data Sources
94	GROSS_VALUE_H	☐	CRMT_GROSS_VALUE_CUM	WERTV8	CURR	15	2	Total Gross Value of Document in Document Currency
95	NET_VALUE_H	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
96	NET_VALUE_MAN_H	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
97	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
98	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
99	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
100	.INCLUDE	☐				0	0	DOC_FLOW Data for BW - Grantor
101	GPM_NODE_GUID	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
102	GAP_H_GUID	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
103	GAP_H_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
104	GAP_I_GUID	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
105	GAP_I_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
106	GAG_H_GUID	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
107	GAG_H_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
108	GAG_I_GUID	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
109	GAG_I_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
110	GCL_H_GUID	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
111	GCL_H_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
112	GCL_I_GUID	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
113	GCL_I_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
114	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
115	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
116	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
117	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
118	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
119	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
120	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
121	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
122	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
123	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
124	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
125	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
126	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
127	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
128	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
129	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
130	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
131	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
132	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
133	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status

Foreign Keys

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

History

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