SAP ABAP Table CRMT_BW_RESERV (CRM Reservation 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_RESERV	Table Relationship Diagram
Short Description	CRM Reservation 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	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	BI Extraction: Referenced objects in Claims Management
47	CLAIM_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
48	CLAIM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
49	REF_C_CLAIM_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
50	REF_C_CLAIM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
51	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
52	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
53	FUNDPLAN_GUID	☐	CRM_FM_FND_FUNDPLAN_GUID	SYSUUID	RAW	16	0	Funds Plan GUID
54	FUNDPLAN_ID	☐	CRM_FM_FND_FUNDPLAN_ID	CRM_OBJECT_ID	CHAR	10	0	Funds Plan ID
55	FUNDUSAGE_GUID	☐	CRM_FM_FU_HEADER_GUID	SYSUUID	RAW	16	0	Trade Promotion: Fund Usage Header GUID
56	FUNDUSAGE_ID	☐	CRM_FM_FU_HEADER_ID	CHAR24	CHAR	24	0	Trade Promotion: Fund Usage ID
57	PREPAYMENT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
58	PREPAYMENT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
59	CCB_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
60	CCB_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
61	CSD_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
62	CSD_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
63	INITIATIVE_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
64	INITIATIVE_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
65	INIT_ELT_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
66	INIT_ELT_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
67	RESERV_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
68	RESERV_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
69	SPEC_PROG_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
70	SPEC_PROG_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
71	PROGRAM_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
72	PROGRAM_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
73	DISPUTECASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
74	DISPUTECASE_ID	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
75	PREDECESSOR_TYPE	☐	CRMT_PREDECESSOR_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type for Preceding Object	*
76	PREDECESSOR_KEY	☐	CRMT_PREDECESSOR_PROCESS	SWO_TYPEID	CHAR	70	0	Persistent Identification of a Preceding Object
77	PRIORITY	☐	CRMT_CLA_PRIORITY	CRM_CLA_PRIORITY	CHAR	4	0	Claim Priority	*
78	IS_CORRECTION	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
79	MKTPROJ_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
80	MKTPROJ_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
81	MKTPROJ_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
82	CLAIM_SCHED_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
83	CLAIM_SCHED_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
84	CLAIM_RECV_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
85	CLAIM_RECV_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
86	RETURN_TO_ERP	☐	CRMT_CLA_CSD_IS_SA4R3_DIS_CASE	FLAG	CHAR	1	0	Indicator: Sales Organization for ERP Company Code
87	PREF_PAYOUT_DATE	☐	CRM_CLA_CSD_PAYDATE	BCOS_TSTMP	DEC	15	0	Payment Date
88	VALSHEET_GUID	☐	CRM_CLA_VS_GUID	SYSUUID	RAW	16	0	GUID of a Validation Sheet
89	DUPL_IGN_REASON	☐	CRM_CLA_IGNORE_DUPLICAT_REASON	CHAR3	CHAR	3	0	Claims Duplicates: Ignore Duplicate Reason
90	VS_SNAPSHOT_GUID	☐	CRM_CLA_VS_GUID	SYSUUID	RAW	16	0	GUID of a Validation Sheet
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	DATES Data for BW DataSources
141	REQUESTED_DATE	☐	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
142	CONFIRMED_DATE	☐	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
143	BEGIN_DATE	☐	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
144	ENDING_DATE	☐	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
145	START_OF_BILLING	☐	CRMT_START_OF_BILLING	CRM_RPRTNG_DATE	DATS	8	0	Start Date of Billing Plan
146	VALID_FROM_DATE	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
147	VALID_TO_DATE	☐	CRMT_VALID_TO_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation: Valid to Date
148	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
149	PLANNED_TS_FROM	☐	CRMT_PLANNED_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time from
150	PLANNED_TS_TO	☐	CRMT_PLANNED_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time to
151	ACTUAL_TS_FROM	☐	CRMT_ACTUAL_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time from
152	ACTUAL_TS_TO	☐	CRMT_ACTUAL_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time to
153	PLANNED_FROM	☐	CRMT_PLANNED_FROM	CRM_RPRTNG_DATE	DATS	8	0	Planned Date from
154	PLANNED_TO	☐	CRMT_PLANNED_TO	CRM_RPRTNG_DATE	DATS	8	0	Planned Date to
155	ACTUAL_FROM	☐	CRMT_ACTUAL_FROM	CRM_RPRTNG_DATE	DATS	8	0	Actual Date from
156	ACTUAL_TO	☐	CRMT_ACTUAL_TO	CRM_RPRTNG_DATE	DATS	8	0	Actual Date to
157	EARLIEST_CONFIRM	☐	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
158	DURA	☐	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
159	DURA_FULLFILL	☐	CRMT_BW_DURA_FULLFILL	TIMEDURA	DEC	13	0	Duration Until Fulfillment of Contract
160	DURA_UNIT	☐	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
161	BEGIN_TO_COMPLET	☐	CRMT_BW_BEGIN_TO_COMPLETE	TIMEDURA	DEC	13	0	Duration Start to Conversion or Cancellation of a Quotation
162	COMPLETE_TO_END	☐	CRMT_BW_COMPLETE_TO_END	TIMEDURA	DEC	13	0	Duration Conversion or Cancellation Before End of Quotation
163	REL_TO_BEGIN	☐	CRMT_BW_REL_TO_BEGIN		DEC	7	2	Time Relation: Time to Completion / Validity Interval
164	REL_BEFORE_END	☐	CRMT_BW_REL_BEFORE_END		DEC	5	2	Time Relation: Time Completed Before End / Validity Interval
165	REQ_DLV_DATE	☐	CRMT_REQ_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Required Delivery Date
166	LAST_DLV_DATE	☐	CRMT_LAST_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Delivery Date
167	LAST_QI_ACT_DATE	☐	CRMT_LAST_QI_ACTUAL_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Actual Goods Issue Data
168	LAST_REQ_AVA_DAT	☐	CRMT_LAST_REQ_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Requested)
169	LAST_CONF_AV_DAT	☐	CRMT_LAST_CONF_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Confirmed)
170	LAST_REQ_QI_PLDA	☐	CRMT_LAST_REQ_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Requested)
171	LAST_CONF_QI_PLD	☐	CRMT_LAST_CONF_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Confirmed)
172	CONFIRMED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
173	ACTUAL_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
174	EARLIEST_CON_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
175	REQUESTED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
176	VALID_FROM_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
177	VALID_TO_TS	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
178	.INCLUDE	☐				0	0	General Product Data for BW DataSources
179	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
180	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
181	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
182	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
183	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
184	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
185	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
186	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
187	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
188	PARENT_PRODUCT	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
189	COMPETITOR_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
190	REPLACED_PROD	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
191	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
192	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
193	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
194	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
195	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
196	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
197	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
198	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
199	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
200	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
201	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
202	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
203	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
204	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
205	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
206	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
207	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
208	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
209	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
210	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
211	.INCLUDE	☐				0	0	CRM MDF / TPM Claim Costs extraction structure
212	ESTIMATED_COST	☐	CRMT_CLA_EXPECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Expected Amount
213	A_ESTIMATED_COST	☐	CRMT_CLA_A_EXPECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Adjusted Expected Amount
214	REIMBURS_AMT	☐	CRMT_CLA_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Reimbursement Amount
215	A_REIMBURS_AMT	☐	CRMT_CLA_A_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Adjusted Reimbursement Amount
216	REIMBURS_RATE	☐	CRMT_CLA_REIMB_RATE	WERTV8	CURR	15	2	Reimbursement Rate
217	A_REIMBURS_RATE	☐	CRMT_CLA_A_REIMB_RATE	WERTV8	CURR	15	2	Adjusted Reimbursement Rate
218	REIMBURS_RATE_BO	☐	CRMT_CLA_REIMB_RATE	WERTV8	CURR	15	2	Reimbursement Rate
219	REIMBURS_AMT_BO	☐	CRMT_CLA_REIMB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Reimbursement Amount
220	REQ_COST_CP	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
221	REQ_COST_BO	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
222	CALC_APPR_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
223	RESERVED_COST	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
224	CLAIMED_COST	☐	CRMT_CLA_CLAIMED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Claimed Amount
225	APPROVED_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
226	REJECTED_COST	☐	CRMT_CLA_REJECTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Rejected Amount
227	SETTLED_COST	☐	CRMT_CLA_SETTLED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Settled Amount
228	CHARGEBACK_COST	☐	CRMT_CLA_CHARGEBACK_AMOUNT	CRM_COND_VALUE	CURR	19	2	Chargeback Amount
229	WRITEOFF_COST	☐	CRMT_CLA_WRITEOFF_AMOUNT	CRM_COND_VALUE	CURR	19	2	Write-Off Amount
230	RECOVERED_COST	☐	CRMT_CLA_RECOVERED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Recovered Amount
231	COP_COST	☐	CRMT_CLA_CARRIED_OVER_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Amount
232	COLL_COST	☐	CRMT_CLA_COLLECTIBLE_AMOUNT	CRM_COND_VALUE	CURR	19	2	Collectible Amount
233	UNCOLL_COST	☐	CRMT_CLA_UNCOLLECTIBLE_AMOUNT	CRM_COND_VALUE	CURR	19	2	Uncollectible Amount
234	VALIDATED_COST	☐	CRMT_CLA_VALIDATED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Validated Amount
235	CCB_FND_COST	☐	CRMT_CLA_CCB_FNDBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Fund-Based Chargeback Amount
236	CCB_PRJ_COST	☐	CRMT_CLA_CCB_PRJBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Project-Based Chargeback Amount
237	CCB_SUM_COST	☐	CRMT_CLA_CCB_SUMBASED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Chargeback Sum Amount
238	COP_CCB_COST	☐	CRMT_CLA_CARR_OVER_CCB_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Chargeback Amount
239	COP_CSD_COST	☐	CRMT_CLA_CARR_OVER_CSD_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Claim Submission Amount
240	COP_SUM_COST	☐	CRMT_CLA_CARR_OVER_SUM_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Sum Amount
241	ORI_DISPUTE_COST	☐	CRMT_CLA_ORIG_DISPUTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Original Dispute Case Amount
242	DISPUTED_COST	☐	CRMT_CLA_DISPUTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Dispute Case Amount
243	PAID_COST	☐	CRMT_CLA_PAID_AMOUNT	CRM_COND_VALUE	CURR	19	2	Paid Amount
244	CREDITED_COST	☐	CRMT_CLA_CREDITED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Credited Amount
245	MANU_CLEAR_COST	☐	CRMT_CLA_MANU_CLEARED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Manually Cleared Amount
246	AUT_WRITEOF_COST	☐	CRMT_CLA_AUTO_WRITE_OFF_AMOUNT	CRM_COND_VALUE	CURR	19	2	Automatically Written-Off Amount
247	WRITEOF_SUM_COST	☐	CRMT_CLA_WRITE_OFF_SUM_AMOUNT	CRM_COND_VALUE	CURR	19	2	Written-Off Sum Amount
248	REQUESTED_COST	☐	CRMT_CLA_REQUESTED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Requested Amount
249	UNASSIGNED_COST	☐	CRMT_CLA_UNASSIGNED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unassigned Amount
250	UNRESOLVED_COST	☐	CRMT_CLA_UNRESOLVED_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unresolved Amount
251	UNCLEAR_REJ_COST	☐	CRMT_CLA_UNCLEAR_REJECT_AMOUNT	CRM_COND_VALUE	CURR	19	2	Unclear Rejected Amount
252	REL_EXP_AMOUNT	☐	CRMT_CLA_REL_EXP_AMOUNT	CRM_COND_VALUE	CURR	19	2	Amount released after expiration of claim
253	ALLOC_AMT_PAYEE	☐	CRMT_CLA_ALLOC_AMT_PAYEE	CRM_COND_VALUE	CURR	19	2	Allocated Amount Payee
254	ALLOC_AMT_FUND	☐	CRMT_CLA_ALLOC_AMT_FUND	CRM_COND_VALUE	CURR	19	2	Allocated Amount Fund
255	.INCLUDE	☐				0	0	BI Extraction: Status_h objects in Claims Management
256	CF_APPROVED	☐	CRMT_STATUS_H_APPROVED	CRM_STATUS_H_APPROVED	CHAR	1	0	StatusH: Approved
257	CF_REJECTED	☐	CRMT_STATUS_H_REJECTED	CRM_STATUS_H_REJECTED	CHAR	1	0	StatusH: Rejected
258	CF_TO_BE_APPR	☐	CRMT_STATUS_H_TO_BE_APPROVED	CRM_STATUS_H_TO_BE_APPROVED	CHAR	1	0	StatusH: To Be Approved
259	CF_SETTLED	☐	CRMT_STATUS_H_SETTLED	CRM_STATUS_H_SETTLED	CHAR	1	0	StatusH: Settled
260	CF_CANCELED	☐	CRMT_STATUS_H_CANCELED	CRM_STATUS_H_CANCELED	CHAR	1	0	StatusH: Canceled
261	CF_OPEN	☐	CRMT_STATUS_H_OPEN	CRM_STATUS_H_OPEN	CHAR	1	0	StatusH: Open
262	CF_RETURNED	☐	CRMT_STATUS_H_RETURNED	CRM_STATUS_H_RETURNED	CHAR	1	0	StatusH: Returned
263	CF_WRITTEN_OFF	☐	CRMT_STATUS_H_WRITTEN_OFF	CRM_STATUS_H_WRITTEN_OFF	CHAR	1	0	StatusH: Written-Off
264	CF_IN_PROCESS	☐	CRMT_STATUS_H_IN_PROCESS	CRM_STATUS_H_IN_PROCESS	CHAR	1	0	StatusH: In Process
265	.INCLUDE	☐				0	0	CRM MDF/TPM Partner for Claim - BI extraction structure
266	CLAIMING_ACCOUNT	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
267	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
268	CORP_CH_PARTNER	☐	CMST_CORPORATE_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Corporate Channel Partner	*
269	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
270	INVOICE_RECIP	☐	CRMT_INVOICE_RECIPIENT	BU_PARTNER	CHAR	10	0	Invoice Recipient	*
271	TERRITORY_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
272	TERRITORY_GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
273	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
274	TERR_PATH_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
275	ERP_DC_PROCESS	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
276	ERP_DC_COORD	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
277	ERP_DC_RESPONS	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
278	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
279	REASON_CODE	☐	CRMT_CLA_REASON	CRMT_CLA_REASON	CHAR	4	0	Claim Reason	*

Foreign Keys

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

History

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