SAP ABAP Table CRMT_BW_PREPAYMENT (CRM Claim Prepayment 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_PREPAYMENT	Table Relationship Diagram
Short Description	CRM Claim Prepayment 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	ORGMAN Data for BW DataSources
47	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
48	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
49	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
50	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
51	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
52	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
53	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
54	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
55	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
56	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
57	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
58	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
59	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
60	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
61	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
62	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
63	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
64	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
65	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
66	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
67	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
68	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
69	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
70	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
71	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
72	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
73	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
74	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
75	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
76	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
77	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
78	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
79	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
80	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
81	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
82	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
83	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
84	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
85	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
86	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
87	.INCLUDE	☐				0	0	PARTNER (Claims) Data for BW DataSources
88	PAYEE	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
89	.INCLUDE	☐				0	0	PRICING_H Data for BW DataSources
90	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
91	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
92	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
93	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
94	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
95	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
96	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
97	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
98	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
99	.INCLUDE	☐				0	0	PRICING_I Data for BW DataSources
100	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
101	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
102	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
103	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
104	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
105	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
106	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
107	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
108	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
109	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
110	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
111	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
112	CREDIT_INDICATOR	☐	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
113	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
114	.INCLUDE	☐				0	0	BI Extraction: Referenced objects in Claims Management
115	CLAIM_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
116	CLAIM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
117	REF_C_CLAIM_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
118	REF_C_CLAIM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
119	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
120	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
121	FUNDPLAN_GUID	☐	CRM_FM_FND_FUNDPLAN_GUID	SYSUUID	RAW	16	0	Funds Plan GUID
122	FUNDPLAN_ID	☐	CRM_FM_FND_FUNDPLAN_ID	CRM_OBJECT_ID	CHAR	10	0	Funds Plan ID
123	FUNDUSAGE_GUID	☐	CRM_FM_FU_HEADER_GUID	SYSUUID	RAW	16	0	Trade Promotion: Fund Usage Header GUID
124	FUNDUSAGE_ID	☐	CRM_FM_FU_HEADER_ID	CHAR24	CHAR	24	0	Trade Promotion: Fund Usage ID
125	PREPAYMENT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
126	PREPAYMENT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
127	CCB_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
128	CCB_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
129	CSD_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
130	CSD_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
131	INITIATIVE_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
132	INITIATIVE_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
133	INIT_ELT_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
134	INIT_ELT_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
135	RESERV_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
136	RESERV_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
137	SPEC_PROG_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
138	SPEC_PROG_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
139	PROGRAM_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
140	PROGRAM_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
141	DISPUTECASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
142	DISPUTECASE_ID	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
143	PREDECESSOR_TYPE	☐	CRMT_PREDECESSOR_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type for Preceding Object	*
144	PREDECESSOR_KEY	☐	CRMT_PREDECESSOR_PROCESS	SWO_TYPEID	CHAR	70	0	Persistent Identification of a Preceding Object
145	PRIORITY	☐	CRMT_CLA_PRIORITY	CRM_CLA_PRIORITY	CHAR	4	0	Claim Priority	*
146	IS_CORRECTION	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
147	MKTPROJ_GUID	☐	CRM_MKTPL_GUID	CRM_MKTPL_GUID	RAW	16	0	CRM Marketing Planning - Marketing Element GUID
148	MKTPROJ_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
149	MKTPROJ_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
150	CLAIM_SCHED_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
151	CLAIM_SCHED_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
152	CLAIM_RECV_FROM	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
153	CLAIM_RECV_TO	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
154	RETURN_TO_ERP	☐	CRMT_CLA_CSD_IS_SA4R3_DIS_CASE	FLAG	CHAR	1	0	Indicator: Sales Organization for ERP Company Code
155	PREF_PAYOUT_DATE	☐	CRM_CLA_CSD_PAYDATE	BCOS_TSTMP	DEC	15	0	Payment Date
156	VALSHEET_GUID	☐	CRM_CLA_VS_GUID	SYSUUID	RAW	16	0	GUID of a Validation Sheet
157	DUPL_IGN_REASON	☐	CRM_CLA_IGNORE_DUPLICAT_REASON	CHAR3	CHAR	3	0	Claims Duplicates: Ignore Duplicate Reason
158	VS_SNAPSHOT_GUID	☐	CRM_CLA_VS_GUID	SYSUUID	RAW	16	0	GUID of a Validation Sheet
159	.INCLUDE	☐				0	0	BI Extraction: Status_h objects in Claims Management
160	CF_APPROVED	☐	CRMT_STATUS_H_APPROVED	CRM_STATUS_H_APPROVED	CHAR	1	0	StatusH: Approved
161	CF_REJECTED	☐	CRMT_STATUS_H_REJECTED	CRM_STATUS_H_REJECTED	CHAR	1	0	StatusH: Rejected
162	CF_TO_BE_APPR	☐	CRMT_STATUS_H_TO_BE_APPROVED	CRM_STATUS_H_TO_BE_APPROVED	CHAR	1	0	StatusH: To Be Approved
163	CF_SETTLED	☐	CRMT_STATUS_H_SETTLED	CRM_STATUS_H_SETTLED	CHAR	1	0	StatusH: Settled
164	CF_CANCELED	☐	CRMT_STATUS_H_CANCELED	CRM_STATUS_H_CANCELED	CHAR	1	0	StatusH: Canceled
165	CF_OPEN	☐	CRMT_STATUS_H_OPEN	CRM_STATUS_H_OPEN	CHAR	1	0	StatusH: Open
166	CF_RETURNED	☐	CRMT_STATUS_H_RETURNED	CRM_STATUS_H_RETURNED	CHAR	1	0	StatusH: Returned
167	CF_WRITTEN_OFF	☐	CRMT_STATUS_H_WRITTEN_OFF	CRM_STATUS_H_WRITTEN_OFF	CHAR	1	0	StatusH: Written-Off
168	CF_IN_PROCESS	☐	CRMT_STATUS_H_IN_PROCESS	CRM_STATUS_H_IN_PROCESS	CHAR	1	0	StatusH: In Process
169	.INCLUDE	☐				0	0	CRM MDF/TPM Partner for Claim - BI extraction structure
170	CLAIMING_ACCOUNT	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
171	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
172	CORP_CH_PARTNER	☐	CMST_CORPORATE_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Corporate Channel Partner	*
173	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
174	INVOICE_RECIP	☐	CRMT_INVOICE_RECIPIENT	BU_PARTNER	CHAR	10	0	Invoice Recipient	*
175	TERRITORY_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
176	TERRITORY_GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
177	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
178	TERR_PATH_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
179	ERP_DC_PROCESS	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
180	ERP_DC_COORD	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
181	ERP_DC_RESPONS	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
182	.INCLUDE	☐				0	0	External reference numbers used in claims extract structures
183	EXT_REF1	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
184	EXT_REF2	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
185	EXT_REF3	☐	CRMT_EXT_REF_NUM	TEXT35	CHAR	35	0	External Reference Number
186	.INCLUDE	☐				0	0	Tax related fields for carried over prepayments
187	NET_AMOUNT	☐	CRM_CLA_CPP_NET_AMOUNT	CRM_COND_VALUE	CURR	19	2	Carried-Over Prepayment Net Amount
188	REJECTION_CODE	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
189	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
190	.INCLUDE	☐				0	0	Prepayment: Remaining (Balance) and Original (Prepaid)Amount
191	REMAINING_AMOUNT	☐	CRMT_CLA_REMAINING_BAL_AMOUNT	CRM_COND_VALUE	CURR	19	2	Remaining Amount (Prepaid Balance Amount)
192	ORIGINAL_AMOUNT	☐	CRMT_CLA_ORIGINAL_PREP_AMOUNT	CRM_COND_VALUE	CURR	19	2	Original Amount (Prepaid Amount)

Foreign Keys

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

History

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