SAP ABAP Table CRMT_BW_CHARGEBACK (CRM Chargeback BI extraction structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CLA-BI (Application Component) BI Integration
     ⤷ CRM_CLA_BI_APPLICATION (Package) CRM Claims Management: BI Integration Application Logic

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BW_CHARGEBACK	Table Relationship Diagram
Short Description	CRM Chargeback BI 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	BI Extraction: Referenced objects in Claims Management
2	CLAIM_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
3	CLAIM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	REF_C_CLAIM_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	REF_C_CLAIM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
7	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
8	FUNDPLAN_GUID	☐	CRM_FM_FND_FUNDPLAN_GUID	SYSUUID	RAW	16	0	Funds Plan GUID
9	FUNDPLAN_ID	☐	CRM_FM_FND_FUNDPLAN_ID	CRM_OBJECT_ID	CHAR	10	0	Funds Plan ID
10	FUNDUSAGE_GUID	☐	CRM_FM_FU_HEADER_GUID	SYSUUID	RAW	16	0	Trade Promotion: Fund Usage Header GUID
11	FUNDUSAGE_ID	☐	CRM_FM_FU_HEADER_ID	CHAR24	CHAR	24	0	Trade Promotion: Fund Usage ID
12	PREPAYMENT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
13	PREPAYMENT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
14	CCB_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
15	CCB_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
16	CSD_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
17	CSD_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
18	INITIATIVE_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
19	INITIATIVE_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
20	INIT_ELT_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
21	INIT_ELT_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
22	RESERV_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
23	RESERV_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
24	SPEC_PROG_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
25	SPEC_PROG_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
26	PROGRAM_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
27	PROGRAM_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
28	DISPUTECASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
29	DISPUTECASE_ID	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
30	PREDECESSOR_TYPE	☐	CRMT_PREDECESSOR_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type for Preceding Object	*
31	PREDECESSOR_KEY	☐	CRMT_PREDECESSOR_PROCESS	SWO_TYPEID	CHAR	70	0	Persistent Identification of a Preceding Object
32	PRIORITY	☐	CRMT_CLA_PRIORITY	CRM_CLA_PRIORITY	CHAR	4	0	Claim Priority	*
33	IS_CORRECTION	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
34	MKTPROJ_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
35	MKTPROJ_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
36	MKTPROJ_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
37	CLAIM_SCHED_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
38	CLAIM_SCHED_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
39	CLAIM_RECV_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
40	CLAIM_RECV_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
41	RETURN_TO_ERP	☐	CRMT_CLA_CSD_IS_SA4R3_DIS_CASE	FLAG	CHAR	1	0	Indicator: Sales Organization for ERP Company Code
42	PREF_PAYOUT_DATE	☐	CRM_CLA_CSD_PAYDATE	BCOS_TSTMP	DEC	15	0	Payment Date
43	VALSHEET_GUID	☐	CRM_CLA_VS_GUID	SYSUUID	RAW	16	0	GUID of a Validation Sheet
44	DUPL_IGN_REASON	☐	CRM_CLA_IGNORE_DUPLICAT_REASON	CHAR3	CHAR	3	0	Claims Duplicates: Ignore Duplicate Reason
45	VS_SNAPSHOT_GUID	☐	CRM_CLA_VS_GUID	SYSUUID	RAW	16	0	GUID of a Validation Sheet
46	.INCLUDE	☐				0	0	ORDERADM_H Data for BW DataSources
47	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
48	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
49	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
50	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
51	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
52	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
53	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
54	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
55	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
56	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
57	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
58	CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
59	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
60	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
61	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
62	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
63	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
64	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
65	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
66	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
67	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
68	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
69	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
70	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
71	.INCLUDE	☐				0	0	ORDERADM_I Data for BW DataSources
72	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
73	ITEM_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
74	ITEM_CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
75	ITEM_CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
76	ITEM_CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
77	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
78	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
79	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
80	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
81	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
82	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
83	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
84	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
85	ALTERNATIVE	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
86	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
87	ITM_BP	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
88	ITEM_CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
89	ITEM_CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
90	ORDER_DATE_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
91	.INCLUDE	☐				0	0	CRM MDF/TPM Partner for Claim - BI extraction structure
92	CLAIMING_ACCOUNT	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
93	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
94	CORP_CH_PARTNER	☐	CMST_CORPORATE_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Corporate Channel Partner	*
95	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
96	INVOICE_RECIP	☐	CRMT_INVOICE_RECIPIENT	BU_PARTNER	CHAR	10	0	Invoice Recipient	*
97	TERRITORY_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
98	TERRITORY_GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
99	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
100	TERR_PATH_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
101	ERP_DC_PROCESS	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
102	ERP_DC_COORD	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
103	ERP_DC_RESPONS	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
104	.INCLUDE	☐				0	0	PARTNER (Sales) Data for BW DataSources
105	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
106	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
107	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
108	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
109	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
110	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
111	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
112	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
113	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
114	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
115	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
116	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
117	.INCLUDE	☐				0	0	BW Extract Structure for Chargeback Recovery Item
118	RECOVERY_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
119	PAYMENT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
120	RECOVERED_ON	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
121	RECOV_RECALL	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
122	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
123	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
124	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
125	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
126	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
127	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
128	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
129	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
130	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
131	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
132	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
133	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
134	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
135	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
136	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
137	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
138	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
139	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
140	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
141	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
142	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
143	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
144	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
145	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
146	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
147	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
148	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
149	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
150	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
151	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
152	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
153	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
154	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
155	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
156	.INCLUDE	☐				0	0	CRM MDF / TPM Claim Costs extraction structure
157	ESTIMATED_COST	☐	CRMT_CLA_EXPECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Expected Amount
158	A_ESTIMATED_COST	☐	CRMT_CLA_A_EXPECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Adjusted Expected Amount
159	REIMBURS_AMT	☐	CRMT_CLA_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Reimbursement Amount
160	A_REIMBURS_AMT	☐	CRMT_CLA_A_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Adjusted Reimbursement Amount
161	REIMBURS_RATE	☐	CRMT_CLA_REIMB_RATE	WERTV8	CURR	15	2	Reimbursement Rate
162	A_REIMBURS_RATE	☐	CRMT_CLA_A_REIMB_RATE	WERTV8	CURR	15	2	Adjusted Reimbursement Rate
163	REIMBURS_RATE_BO	☐	CRMT_CLA_REIMB_RATE	WERTV8	CURR	15	2	Reimbursement Rate
164	REIMBURS_AMT_BO	☐	CRMT_CLA_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Reimbursement Amount
165	REQ_COST_CP	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
166	REQ_COST_BO	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
167	CALC_APPR_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
168	RESERVED_COST	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
169	CLAIMED_COST	☐	CRMT_CLA_CLAIMED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Claimed Amount
170	APPROVED_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
171	REJECTED_COST	☐	CRMT_CLA_REJECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Rejected Amount
172	SETTLED_COST	☐	CRMT_CLA_SETTLED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Settled Amount
173	CHARGEBACK_COST	☐	CRMT_CLA_CHARGEBACK_AMOUNT	CRM_COND_VALUE	CURR	19	2	Chargeback Amount
174	WRITEOFF_COST	☐	CRMT_CLA_WRITEOFF_AMOUNT	CRM_COND_VALUE	CURR	19	2	Write-Off Amount
175	RECOVERED_COST	☐	CRMT_CLA_RECOVERED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Recovered Amount
176	COP_COST	☐	CRMT_CLA_CARRIED_OVER_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Amount
177	COLL_COST	☐	CRMT_CLA_COLLECTIBLE_AMOUNT	CRM_COND_VALUE	CURR	19	2	Collectible Amount
178	UNCOLL_COST	☐	CRMT_CLA_UNCOLLECTIBLE_AMOUNT	CRM_COND_VALUE	CURR	19	2	Uncollectible Amount
179	VALIDATED_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
180	CCB_FND_COST	☐	CRMT_CLA_CCB_FNDBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Fund-Based Chargeback Amount
181	CCB_PRJ_COST	☐	CRMT_CLA_CCB_PRJBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Project-Based Chargeback Amount
182	CCB_SUM_COST	☐	CRMT_CLA_CCB_SUMBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Chargeback Sum Amount
183	COP_CCB_COST	☐	CRMT_CLA_CARR_OVER_CCB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Chargeback Amount
184	COP_CSD_COST	☐	CRMT_CLA_CARR_OVER_CSD_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Claim Submission Amount
185	COP_SUM_COST	☐	CRMT_CLA_CARR_OVER_SUM_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Sum Amount
186	ORI_DISPUTE_COST	☐	CRMT_CLA_ORIG_DISPUTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Original Dispute Case Amount
187	DISPUTED_COST	☐	CRMT_CLA_DISPUTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Dispute Case Amount
188	PAID_COST	☐	CRMT_CLA_PAID_AMOUNT	CRM_COND_VALUE	CURR	19	2	Paid Amount
189	CREDITED_COST	☐	CRMT_CLA_CREDITED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Credited Amount
190	MANU_CLEAR_COST	☐	CRMT_CLA_MANU_CLEARED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Manually Cleared Amount
191	AUT_WRITEOF_COST	☐	CRMT_CLA_AUTO_WRITE_OFF_AMOUNT	CRM_COND_VALUE	CURR	19	2	Automatically Written-Off Amount
192	WRITEOF_SUM_COST	☐	CRMT_CLA_WRITE_OFF_SUM_AMOUNT	CRM_COND_VALUE	CURR	19	2	Written-Off Sum Amount
193	REQUESTED_COST	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
194	UNASSIGNED_COST	☐	CRMT_CLA_UNASSIGNED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unassigned Amount
195	UNRESOLVED_COST	☐	CRMT_CLA_UNRESOLVED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unresolved Amount
196	UNCLEAR_REJ_COST	☐	CRMT_CLA_UNCLEAR_REJECT_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unclear Rejected Amount
197	REL_EXP_AMOUNT	☐	CRMT_CLA_REL_EXP_AMOUNT	CRM_COND_VALUE	CURR	19	2	Amount released after expiration of claim
198	ALLOC_AMT_PAYEE	☐	CRMT_CLA_ALLOC_AMT_PAYEE	CRM_COND_VALUE	CURR	19	2	Allocated Amount Payee
199	ALLOC_AMT_FUND	☐	CRMT_CLA_ALLOC_AMT_FUND	CRM_COND_VALUE	CURR	19	2	Allocated Amount Fund
200	.INCLUDE	☐				0	0	PRICING_H Data for BW DataSources
201	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
202	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
203	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
204	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
205	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
206	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
207	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
208	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
209	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
210	.INCLUDE	☐				0	0	General Product Data for BW DataSources
211	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
212	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
213	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
214	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
215	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
216	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
217	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
218	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
219	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
220	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
221	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
222	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
223	.INCLUDE	☐				0	0	BI Extraction: Referenced item objects in Claims Management
224	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
225	REASON_CODE	☐	CRMT_CLA_REASON	CRMT_CLA_REASON	CHAR	4	0	Claim Reason	*
226	PRODUCT_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
227	PRODUCT_SEGMENT	☐	CRMT_MKTTG_PRSEG_GUID	SYSUUID	RAW	16	0	GUID of a Product Segment
228	TARGETGRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
229	TARGETGRP_ID	☐	CRMT_MKTTG_TG_ID	CRMT_MKTTG_TG_ID	CHAR	10	0	Unique Identifiers for Target Groups and Product Segments
230	.INCLUDE	☐				0	0	BI Extraction: Status_h objects in Claims Management
231	CF_APPROVED	☐	CRMT_STATUS_H_APPROVED	CRM_STATUS_H_APPROVED	CHAR	1	0	StatusH: Approved
232	CF_REJECTED	☐	CRMT_STATUS_H_REJECTED	CRM_STATUS_H_REJECTED	CHAR	1	0	StatusH: Rejected
233	CF_TO_BE_APPR	☐	CRMT_STATUS_H_TO_BE_APPROVED	CRM_STATUS_H_TO_BE_APPROVED	CHAR	1	0	StatusH: To Be Approved
234	CF_SETTLED	☐	CRMT_STATUS_H_SETTLED	CRM_STATUS_H_SETTLED	CHAR	1	0	StatusH: Settled
235	CF_CANCELED	☐	CRMT_STATUS_H_CANCELED	CRM_STATUS_H_CANCELED	CHAR	1	0	StatusH: Canceled
236	CF_OPEN	☐	CRMT_STATUS_H_OPEN	CRM_STATUS_H_OPEN	CHAR	1	0	StatusH: Open
237	CF_RETURNED	☐	CRMT_STATUS_H_RETURNED	CRM_STATUS_H_RETURNED	CHAR	1	0	StatusH: Returned
238	CF_WRITTEN_OFF	☐	CRMT_STATUS_H_WRITTEN_OFF	CRM_STATUS_H_WRITTEN_OFF	CHAR	1	0	StatusH: Written-Off
239	CF_IN_PROCESS	☐	CRMT_STATUS_H_IN_PROCESS	CRM_STATUS_H_IN_PROCESS	CHAR	1	0	StatusH: In Process
240	.INCLUDE	☐				0	0	External reference numbers used in claims extract structures
241	EXT_REF1	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
242	EXT_REF2	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
243	EXT_REF3	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
244	.INCLUDE	☐				0	0	Tax related fields for chargebacks
245	NET_AMOUNT	☐	CRM_CLA_CCB_NET_AMOUNT	CRM_COND_VALUE	CURR	19	2	Chargeback Net Amount
246	TAX_AMOUNT	☐	CRM_CLA_CCB_TAX_AMOUNT	CRM_COND_VALUE	CURR	19	2	Chargeback Tax Amount
247	.INCLUDE	☐				0	0	Claim: Product Groups
248	PRC_GROUP1	☐	CRMT_PROD_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
249	PRC_GROUP2	☐	CRMT_PROD_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
250	PRC_GROUP3	☐	CRMT_PROD_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
251	PRC_GROUP4	☐	CRMT_PROD_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
252	PRC_GROUP5	☐	CRMT_PROD_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*

Foreign Keys

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

History

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