SAP ABAP Table CRMT_BW_CLAIM (CRM Claim 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_CLAIM	Table Relationship Diagram
Short Description	CRM Claim 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	PARTNER (Sales) Data for BW DataSources
92	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
93	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
94	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
95	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
96	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
97	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
98	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
99	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
100	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
101	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
102	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
103	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
104	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
105	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
106	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
107	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
108	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
109	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
110	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
111	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
112	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
113	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
114	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
115	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
116	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
117	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
118	.INCLUDE	☐				0	0	PRICING_H Data for BW DataSources
119	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
120	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
121	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
122	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
123	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
124	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
125	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
126	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
127	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
128	.INCLUDE	☐				0	0	STATUS Data for BW DataSources
129	STATUS_INQUIRY	☐	CRMT_STATUS_INQUIRY	BOOLEAN	CHAR	1	0	Status of Inquiry
130	STATUS_QUOTATION	☐	CRMT_STATUS_QUOTATION	CRM_BOOLEAN	CHAR	1	0	Quotation Status
131	STATUS_ERROR	☐	CRMT_STATUS_ERROR	CRM_BOOLEAN	CHAR	1	0	Indicates Whether Document is Incorrect
132	STATUS_INVOICED	☐	CRMT_STATUS_INVOICED	CRM_BOOLEAN	CHAR	1	0	Billing Status
133	STATUS_ACCEPTED	☐	CRMT_STATUS_ACCEPTED	BOOLEAN	CHAR	1	0	Status Accepted
134	STATUS_COMPLETED	☐	CRMT_STATUS_COMPLETED	BOOLEAN	CHAR	1	0	Status: Completed
135	STATUS_CANCELLED	☐	CRMT_STATUS_CANCELLED	BOOLEAN	CHAR	1	0	Rejection Status
136	STATUS_DOC_SYS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
137	STATUS_DELIVERED	☐	CRMT_DELIVERY_STAT	CRMT_BW_DELIVERY_STAT_DOM	CHAR	1	0	Delivery Status (Use for BW Only)
138	STATUS_EXPIRED	☐	CRMT_STATUS_EXPIRED	BOOLEAN	CHAR	1	0	Status End of Validity Period (Quotation)
139	STATUS_INCOMPL	☐	CRMT_STATUS_INCOMPLETE	BOOLEAN	CHAR	1	0	Status: Incompleted
140	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
141	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
142	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
143	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
144	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
145	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
146	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
147	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
148	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
149	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
150	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
151	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
152	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
153	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
154	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
155	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
156	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
157	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
158	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
159	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
160	.INCLUDE	☐				0	0	CRM MDF / TPM Claim Costs extraction structure
161	ESTIMATED_COST	☐	CRMT_CLA_EXPECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Expected Amount
162	A_ESTIMATED_COST	☐	CRMT_CLA_A_EXPECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Adjusted Expected Amount
163	REIMBURS_AMT	☐	CRMT_CLA_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Reimbursement Amount
164	A_REIMBURS_AMT	☐	CRMT_CLA_A_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Adjusted Reimbursement Amount
165	REIMBURS_RATE	☐	CRMT_CLA_REIMB_RATE	WERTV8	CURR	15	2	Reimbursement Rate
166	A_REIMBURS_RATE	☐	CRMT_CLA_A_REIMB_RATE	WERTV8	CURR	15	2	Adjusted Reimbursement Rate
167	REIMBURS_RATE_BO	☐	CRMT_CLA_REIMB_RATE	WERTV8	CURR	15	2	Reimbursement Rate
168	REIMBURS_AMT_BO	☐	CRMT_CLA_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Reimbursement Amount
169	REQ_COST_CP	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
170	REQ_COST_BO	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
171	CALC_APPR_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
172	RESERVED_COST	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
173	CLAIMED_COST	☐	CRMT_CLA_CLAIMED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Claimed Amount
174	APPROVED_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
175	REJECTED_COST	☐	CRMT_CLA_REJECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Rejected Amount
176	SETTLED_COST	☐	CRMT_CLA_SETTLED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Settled Amount
177	CHARGEBACK_COST	☐	CRMT_CLA_CHARGEBACK_AMOUNT	CRM_COND_VALUE	CURR	19	2	Chargeback Amount
178	WRITEOFF_COST	☐	CRMT_CLA_WRITEOFF_AMOUNT	CRM_COND_VALUE	CURR	19	2	Write-Off Amount
179	RECOVERED_COST	☐	CRMT_CLA_RECOVERED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Recovered Amount
180	COP_COST	☐	CRMT_CLA_CARRIED_OVER_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Amount
181	COLL_COST	☐	CRMT_CLA_COLLECTIBLE_AMOUNT	CRM_COND_VALUE	CURR	19	2	Collectible Amount
182	UNCOLL_COST	☐	CRMT_CLA_UNCOLLECTIBLE_AMOUNT	CRM_COND_VALUE	CURR	19	2	Uncollectible Amount
183	VALIDATED_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
184	CCB_FND_COST	☐	CRMT_CLA_CCB_FNDBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Fund-Based Chargeback Amount
185	CCB_PRJ_COST	☐	CRMT_CLA_CCB_PRJBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Project-Based Chargeback Amount
186	CCB_SUM_COST	☐	CRMT_CLA_CCB_SUMBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Chargeback Sum Amount
187	COP_CCB_COST	☐	CRMT_CLA_CARR_OVER_CCB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Chargeback Amount
188	COP_CSD_COST	☐	CRMT_CLA_CARR_OVER_CSD_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Claim Submission Amount
189	COP_SUM_COST	☐	CRMT_CLA_CARR_OVER_SUM_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Sum Amount
190	ORI_DISPUTE_COST	☐	CRMT_CLA_ORIG_DISPUTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Original Dispute Case Amount
191	DISPUTED_COST	☐	CRMT_CLA_DISPUTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Dispute Case Amount
192	PAID_COST	☐	CRMT_CLA_PAID_AMOUNT	CRM_COND_VALUE	CURR	19	2	Paid Amount
193	CREDITED_COST	☐	CRMT_CLA_CREDITED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Credited Amount
194	MANU_CLEAR_COST	☐	CRMT_CLA_MANU_CLEARED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Manually Cleared Amount
195	AUT_WRITEOF_COST	☐	CRMT_CLA_AUTO_WRITE_OFF_AMOUNT	CRM_COND_VALUE	CURR	19	2	Automatically Written-Off Amount
196	WRITEOF_SUM_COST	☐	CRMT_CLA_WRITE_OFF_SUM_AMOUNT	CRM_COND_VALUE	CURR	19	2	Written-Off Sum Amount
197	REQUESTED_COST	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
198	UNASSIGNED_COST	☐	CRMT_CLA_UNASSIGNED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unassigned Amount
199	UNRESOLVED_COST	☐	CRMT_CLA_UNRESOLVED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unresolved Amount
200	UNCLEAR_REJ_COST	☐	CRMT_CLA_UNCLEAR_REJECT_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unclear Rejected Amount
201	REL_EXP_AMOUNT	☐	CRMT_CLA_REL_EXP_AMOUNT	CRM_COND_VALUE	CURR	19	2	Amount released after expiration of claim
202	ALLOC_AMT_PAYEE	☐	CRMT_CLA_ALLOC_AMT_PAYEE	CRM_COND_VALUE	CURR	19	2	Allocated Amount Payee
203	ALLOC_AMT_FUND	☐	CRMT_CLA_ALLOC_AMT_FUND	CRM_COND_VALUE	CURR	19	2	Allocated Amount Fund
204	.INCLUDE	☐				0	0	General Product Data for BW DataSources
205	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
206	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
207	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
208	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
209	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
210	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
211	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
212	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
213	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
214	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
215	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
216	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
217	.INCLUDE	☐				0	0	BI Extraction: Referenced item objects in Claims Management
218	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
219	REASON_CODE	☐	CRMT_CLA_REASON	CRMT_CLA_REASON	CHAR	4	0	Claim Reason	*
220	PRODUCT_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
221	PRODUCT_SEGMENT	☐	CRMT_MKTTG_PRSEG_GUID	SYSUUID	RAW	16	0	GUID of a Product Segment
222	TARGETGRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
223	TARGETGRP_ID	☐	CRMT_MKTTG_TG_ID	CRMT_MKTTG_TG_ID	CHAR	10	0	Unique Identifiers for Target Groups and Product Segments
224	.INCLUDE	☐				0	0	BI Extraction: Status_h objects in Claims Management
225	CF_APPROVED	☐	CRMT_STATUS_H_APPROVED	CRM_STATUS_H_APPROVED	CHAR	1	0	StatusH: Approved
226	CF_REJECTED	☐	CRMT_STATUS_H_REJECTED	CRM_STATUS_H_REJECTED	CHAR	1	0	StatusH: Rejected
227	CF_TO_BE_APPR	☐	CRMT_STATUS_H_TO_BE_APPROVED	CRM_STATUS_H_TO_BE_APPROVED	CHAR	1	0	StatusH: To Be Approved
228	CF_SETTLED	☐	CRMT_STATUS_H_SETTLED	CRM_STATUS_H_SETTLED	CHAR	1	0	StatusH: Settled
229	CF_CANCELED	☐	CRMT_STATUS_H_CANCELED	CRM_STATUS_H_CANCELED	CHAR	1	0	StatusH: Canceled
230	CF_OPEN	☐	CRMT_STATUS_H_OPEN	CRM_STATUS_H_OPEN	CHAR	1	0	StatusH: Open
231	CF_RETURNED	☐	CRMT_STATUS_H_RETURNED	CRM_STATUS_H_RETURNED	CHAR	1	0	StatusH: Returned
232	CF_WRITTEN_OFF	☐	CRMT_STATUS_H_WRITTEN_OFF	CRM_STATUS_H_WRITTEN_OFF	CHAR	1	0	StatusH: Written-Off
233	CF_IN_PROCESS	☐	CRMT_STATUS_H_IN_PROCESS	CRM_STATUS_H_IN_PROCESS	CHAR	1	0	StatusH: In Process
234	.INCLUDE	☐				0	0	DATES Data for BW DataSources
235	REQUESTED_DATE	☐	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
236	CONFIRMED_DATE	☐	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
237	BEGIN_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
238	ENDING_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
239	START_OF_BILLING	☐	CRMT_START_OF_BILLING	CRM_RPRTNG_DATE	DATS	8	0	Start Date of Billing Plan
240	VALID_FROM_DATE	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
241	VALID_TO_DATE	☐	CRMT_VALID_TO_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation: Valid to Date
242	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
243	PLANNED_TS_FROM	☐	CRMT_PLANNED_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time from
244	PLANNED_TS_TO	☐	CRMT_PLANNED_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time to
245	ACTUAL_TS_FROM	☐	CRMT_ACTUAL_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time from
246	ACTUAL_TS_TO	☐	CRMT_ACTUAL_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time to
247	PLANNED_FROM	☐	CRMT_PLANNED_FROM	CRM_RPRTNG_DATE	DATS	8	0	Planned Date from
248	PLANNED_TO	☐	CRMT_PLANNED_TO	CRM_RPRTNG_DATE	DATS	8	0	Planned Date to
249	ACTUAL_FROM	☐	CRMT_ACTUAL_FROM	CRM_RPRTNG_DATE	DATS	8	0	Actual Date from
250	ACTUAL_TO	☐	CRMT_ACTUAL_TO	CRM_RPRTNG_DATE	DATS	8	0	Actual Date to
251	EARLIEST_CONFIRM	☐	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
252	DURA	☐	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
253	DURA_FULLFILL	☐	CRMT_BW_DURA_FULLFILL	TIMEDURA	DEC	13	0	Duration Until Fulfillment of Contract
254	DURA_UNIT	☐	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
255	BEGIN_TO_COMPLET	☐	CRMT_BW_BEGIN_TO_COMPLETE	TIMEDURA	DEC	13	0	Duration Start to Conversion or Cancellation of a Quotation
256	COMPLETE_TO_END	☐	CRMT_BW_COMPLETE_TO_END	TIMEDURA	DEC	13	0	Duration Conversion or Cancellation Before End of Quotation
257	REL_TO_BEGIN	☐	CRMT_BW_REL_TO_BEGIN		DEC	7	2	Time Relation: Time to Completion / Validity Interval
258	REL_BEFORE_END	☐	CRMT_BW_REL_BEFORE_END		DEC	5	2	Time Relation: Time Completed Before End / Validity Interval
259	REQ_DLV_DATE	☐	CRMT_REQ_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Required Delivery Date
260	LAST_DLV_DATE	☐	CRMT_LAST_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Delivery Date
261	LAST_QI_ACT_DATE	☐	CRMT_LAST_QI_ACTUAL_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Actual Goods Issue Data
262	LAST_REQ_AVA_DAT	☐	CRMT_LAST_REQ_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Requested)
263	LAST_CONF_AV_DAT	☐	CRMT_LAST_CONF_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Confirmed)
264	LAST_REQ_QI_PLDA	☐	CRMT_LAST_REQ_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Requested)
265	LAST_CONF_QI_PLD	☐	CRMT_LAST_CONF_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Confirmed)
266	CONFIRMED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
267	ACTUAL_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
268	EARLIEST_CON_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
269	REQUESTED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
270	VALID_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
271	VALID_TO_TS	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
272	.INCLUDE	☐				0	0	CRM MDF/TPM Partner for Claim - BI extraction structure
273	CLAIMING_ACCOUNT	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
274	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
275	CORP_CH_PARTNER	☐	CMST_CORPORATE_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Corporate Channel Partner	*
276	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
277	INVOICE_RECIP	☐	CRMT_INVOICE_RECIPIENT	BU_PARTNER	CHAR	10	0	Invoice Recipient	*
278	TERRITORY_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
279	TERRITORY_GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
280	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
281	TERR_PATH_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
282	ERP_DC_PROCESS	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
283	ERP_DC_COORD	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
284	ERP_DC_RESPONS	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
285	PAYMENT_METHOD	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	*
286	.INCLUDE	☐				0	0	External reference numbers used in claims extract structures
287	EXT_REF1	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
288	EXT_REF2	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
289	EXT_REF3	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
290	.INCLUDE	☐				0	0	Planning Account: Target Group and Hierarchy Node
291	TARGET_GROUP	☐	CRMT_CLA_PLANNING_ACC_TGGRP	SYSUUID	RAW	16	0	Planning Account: Target Group
292	BP_HIER_NODE	☐	CRMT_CLA_PLANNING_ACC_BPHNODE	SYSUUID	RAW	16	0	Planning Account: BP Hierarchy Node
293	.INCLUDE	☐				0	0	Claim: Product Groups
294	PRC_GROUP1	☐	CRMT_PROD_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
295	PRC_GROUP2	☐	CRMT_PROD_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
296	PRC_GROUP3	☐	CRMT_PROD_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
297	PRC_GROUP4	☐	CRMT_PROD_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
298	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_CLAIM	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY

History

Last changed by/on	SAP	20131122
SAP Release Created in	700