SAP ABAP Table CRMT_BW_CHARGEBACK_RECOVERY (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_RECOVERY   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 CCR_GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
2 CCR_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
3 PRIORITY CRMT_CLA_PRIORITY CRM_CLA_PRIORITY CHAR 4   0   Claim Priority *
4 .INCLUDE       0   0   ORDERADM_H Data for BW DataSources  
5 CLIENT MANDT MANDT CLNT 3   0   Client *
6 GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
7 OBJECT_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
8 PROCESS_TYPE CRMT_PROCESS_TYPE CRM_PROCESS_TYPE CHAR 4   0   Business Transaction Type *
9 POSTING_DATE CRMT_POSTING_DATE   DATS 8   0   Posting Date for a Business Transaction  
10 DESCRIPTION_UC CRMT_PROCESS_DESCRIPTION_UC CRM_PROCESS_DESCRIPTION_UC CHAR 40   0   Transaction Description (Upper Case)  
11 DESCR_LANGUAGE CRMT_PROCESS_DESCRIPTION_LANGU SPRAS LANG 1   0   Language Key of Description *
12 LOGICAL_SYSTEM CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
13 OBJECT_TYPE CRMT_SUBOBJECT_CATEGORY CRM_OJ_NAME_PROCESS CHAR 10   0   Business Transaction Category CRMC_SUBOB_CAT
14 CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
15 CREATED_BY CRMT_CREATED_BY UNAME CHAR 12   0   User that Created the Transaction  
16 CHANGED_AT CRMT_OPPT_CHANGED_AT DATUM DATS 8   0   Time of Last Change to the Transaction  
17 CHANGED_BY CRMT_CHANGED_BY UNAME CHAR 12   0   Transaction Last Changed By  
18 RECORDMODE RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
19 NUM_OF_HEAD CRMT_NUMBER_OF_H INT4 INT4 10   0   Order Header Number  
20 OCCURRENCE CRMT_OCC_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
21 SCENARIO CRMT_SCENARIO CRM_SCENARIO CHAR 10   0   Scenario Identity  
22 TEMPLATE_TYPE CRMT_TEMPLATE_TYPE_DB CRM_TEMPLATE_TYPE CHAR 1   0   Template Type of CRM Transaction  
23 OCCURR_QUOT CRMT_QUO_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
24 OCCURR_CONT CRMT_CON_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
25 REF_UPDATE CRMT_FLG_REF_UPDATE_BW XFELD CHAR 1   0   Flag: Ref. Update (Extract Structure Only Partially Filled)  
26 INPUT_CHANNEL CRMT_INPUT_CHANNEL CRM_INPUT_CHANNEL CHAR 3   0   Input channel  
27 CREATED_TS COMT_CREATED_AT_USR COM_TSTMP DEC 15   0   Created At (Output in User Time Zone)  
28 CHANGED_TS COMT_CHANGED_AT_USR COM_TSTMP DEC 15   0   Changed At (Output in User Time Zone)  
29 .INCLUDE       0   0   CRM MDF/TPM Partner for Claim - BI extraction structure  
30 CLAIMING_ACCOUNT CRMT_SOLD_TO_PART BU_PARTNER CHAR 10   0   Sold-To Party *
31 RESP_AT_PARTNER CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
32 CORP_CH_PARTNER CMST_CORPORATE_CHANNEL_PARTNER BU_PARTNER CHAR 10   0   Corporate Channel Partner *
33 CHANNEL_PARTNER CMST_CHANNEL_PARTNER BU_PARTNER CHAR 10   0   Channel Partner *
34 INVOICE_RECIP CRMT_INVOICE_RECIPIENT BU_PARTNER CHAR 10   0   Invoice Recipient *
35 TERRITORY_ID CRMT_TERRITORY_ID CRM_TERRITORY_ID CHAR 30   0   Territory ID  
36 TERRITORY_GUID CRMT_TERRITORY_GUID SYSUUID RAW 16   0   Territory GUID  
37 TERR_PATH_ID CRMT_TERRITORY_PATH_ID CRM_TERRITORY_PATH_ID CHAR 30   0   Territory Hierarchy ID  
38 TERR_PATH_GUID GUID_16 SYSUUID RAW 16   0   GUID in 'RAW' format  
39 ERP_DC_PROCESS CRMT_PARTNER_GUID SYSUUID RAW 16   0   GUID for an Individual Partner  
40 ERP_DC_COORD CRMT_PARTNER_GUID SYSUUID RAW 16   0   GUID for an Individual Partner  
41 ERP_DC_RESPONS CRMT_PARTNER_GUID SYSUUID RAW 16   0   GUID for an Individual Partner  
42 .INCLUDE       0   0   PARTNER (Sales) Data for BW DataSources  
43 SOLD_TO_PARTY CRMT_SOLD_TO_PART BU_PARTNER CHAR 10   0   Sold-To Party *
44 SHIP_TO_PARTY CRMT_SHIP_TO_PART BU_PARTNER CHAR 10   0   Ship-To Party *
45 BILL_TO_PARTY CRMT_BILL_TO_PART BU_PARTNER CHAR 10   0   Bill-To Party *
46 PAYER CRMT_RP_PAYER BU_PARTNER CHAR 10   0   Payer *
47 SOLD_FROM CRMT_SOLD_FROM_PARTY_ID BU_PARTNER CHAR 10   0   Salesperson ID *
48 .INCLUDE       0   0   PARTNER (General) Data for BW DataSoures  
49 SALES_EMPLOYEE CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
50 PERSON_RESP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
51 CONTACT_PERSON CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
52 SALESPARTNER CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
53 RESP_GROUP_RFW CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
54 PLANNING_ACCOUNT CRMT_PLANNING_ACCOUNT BU_PARTNER CHAR 10   0   Planning Account *
55 .INCLUDE       0   0   ORGMAN Data for BW DataSources  
56 SALES_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
57 SALES_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
58 SALES_OFFICE OBJEKTID NUM08 NUMC 8   0   Object ID  
59 SALES_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
60 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
61 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
62 SERVICE_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
63 SERVICE_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
64 PURCH_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
65 PURCH_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
66 PURCH_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
67 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
68 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
69 .INCLUDE       0   0   CRM MDF / TPM Claim Costs extraction structure  
70 ESTIMATED_COST CRMT_CLA_EXPECTED_AMOUNT CRM_COND_VALUE CURR 19   2   Expected Amount  
71 A_ESTIMATED_COST CRMT_CLA_A_EXPECTED_AMOUNT CRM_COND_VALUE CURR 19   2   Adjusted Expected Amount  
72 REIMBURS_AMT CRMT_CLA_REIMB_AMOUNT CRM_COND_VALUE CURR 19   2   Reimbursement Amount  
73 A_REIMBURS_AMT CRMT_CLA_A_REIMB_AMOUNT CRM_COND_VALUE CURR 19   2   Adjusted Reimbursement Amount  
74 REIMBURS_RATE CRMT_CLA_REIMB_RATE WERTV8 CURR 15   2   Reimbursement Rate  
75 A_REIMBURS_RATE CRMT_CLA_A_REIMB_RATE WERTV8 CURR 15   2   Adjusted Reimbursement Rate  
76 REIMBURS_RATE_BO CRMT_CLA_REIMB_RATE WERTV8 CURR 15   2   Reimbursement Rate  
77 REIMBURS_AMT_BO CRMT_CLA_REIMB_AMOUNT CRM_COND_VALUE CURR 19   2   Reimbursement Amount  
78 REQ_COST_CP CRMT_CLA_REQUESTED_AMOUNT CRM_COND_VALUE CURR 19   2   Requested Amount  
79 REQ_COST_BO CRMT_CLA_REQUESTED_AMOUNT CRM_COND_VALUE CURR 19   2   Requested Amount  
80 CALC_APPR_COST CRMT_CLA_VALIDATED_AMOUNT CRM_COND_VALUE CURR 19   2   Validated Amount  
81 RESERVED_COST CRMT_CLA_REQUESTED_AMOUNT CRM_COND_VALUE CURR 19   2   Requested Amount  
82 CLAIMED_COST CRMT_CLA_CLAIMED_AMOUNT CRM_COND_VALUE CURR 19   2   Claimed Amount  
83 APPROVED_COST CRMT_CLA_VALIDATED_AMOUNT CRM_COND_VALUE CURR 19   2   Validated Amount  
84 REJECTED_COST CRMT_CLA_REJECTED_AMOUNT CRM_COND_VALUE CURR 19   2   Rejected Amount  
85 SETTLED_COST CRMT_CLA_SETTLED_AMOUNT CRM_COND_VALUE CURR 19   2   Settled Amount  
86 CHARGEBACK_COST CRMT_CLA_CHARGEBACK_AMOUNT CRM_COND_VALUE CURR 19   2   Chargeback Amount  
87 WRITEOFF_COST CRMT_CLA_WRITEOFF_AMOUNT CRM_COND_VALUE CURR 19   2   Write-Off Amount  
88 RECOVERED_COST CRMT_CLA_RECOVERED_AMOUNT CRM_COND_VALUE CURR 19   2   Recovered Amount  
89 COP_COST CRMT_CLA_CARRIED_OVER_AMOUNT CRM_COND_VALUE CURR 19   2   Carried-Over Amount  
90 COLL_COST CRMT_CLA_COLLECTIBLE_AMOUNT CRM_COND_VALUE CURR 19   2   Collectible Amount  
91 UNCOLL_COST CRMT_CLA_UNCOLLECTIBLE_AMOUNT CRM_COND_VALUE CURR 19   2   Uncollectible Amount  
92 VALIDATED_COST CRMT_CLA_VALIDATED_AMOUNT CRM_COND_VALUE CURR 19   2   Validated Amount  
93 CCB_FND_COST CRMT_CLA_CCB_FNDBASED_AMOUNT CRM_COND_VALUE CURR 19   2   Fund-Based Chargeback Amount  
94 CCB_PRJ_COST CRMT_CLA_CCB_PRJBASED_AMOUNT CRM_COND_VALUE CURR 19   2   Project-Based Chargeback Amount  
95 CCB_SUM_COST CRMT_CLA_CCB_SUMBASED_AMOUNT CRM_COND_VALUE CURR 19   2   Chargeback Sum Amount  
96 COP_CCB_COST CRMT_CLA_CARR_OVER_CCB_AMOUNT CRM_COND_VALUE CURR 19   2   Carried-Over Chargeback Amount  
97 COP_CSD_COST CRMT_CLA_CARR_OVER_CSD_AMOUNT CRM_COND_VALUE CURR 19   2   Carried-Over Claim Submission Amount  
98 COP_SUM_COST CRMT_CLA_CARR_OVER_SUM_AMOUNT CRM_COND_VALUE CURR 19   2   Carried-Over Sum Amount  
99 ORI_DISPUTE_COST CRMT_CLA_ORIG_DISPUTED_AMOUNT CRM_COND_VALUE CURR 19   2   Original Dispute Case Amount  
100 DISPUTED_COST CRMT_CLA_DISPUTED_AMOUNT CRM_COND_VALUE CURR 19   2   Dispute Case Amount  
101 PAID_COST CRMT_CLA_PAID_AMOUNT CRM_COND_VALUE CURR 19   2   Paid Amount  
102 CREDITED_COST CRMT_CLA_CREDITED_AMOUNT CRM_COND_VALUE CURR 19   2   Credited Amount  
103 MANU_CLEAR_COST CRMT_CLA_MANU_CLEARED_AMOUNT CRM_COND_VALUE CURR 19   2   Manually Cleared Amount  
104 AUT_WRITEOF_COST CRMT_CLA_AUTO_WRITE_OFF_AMOUNT CRM_COND_VALUE CURR 19   2   Automatically Written-Off Amount  
105 WRITEOF_SUM_COST CRMT_CLA_WRITE_OFF_SUM_AMOUNT CRM_COND_VALUE CURR 19   2   Written-Off Sum Amount  
106 REQUESTED_COST CRMT_CLA_REQUESTED_AMOUNT CRM_COND_VALUE CURR 19   2   Requested Amount  
107 UNASSIGNED_COST CRMT_CLA_UNASSIGNED_AMOUNT CRM_COND_VALUE CURR 19   2   Unassigned Amount  
108 UNRESOLVED_COST CRMT_CLA_UNRESOLVED_AMOUNT CRM_COND_VALUE CURR 19   2   Unresolved Amount  
109 UNCLEAR_REJ_COST CRMT_CLA_UNCLEAR_REJECT_AMOUNT CRM_COND_VALUE CURR 19   2   Unclear Rejected Amount  
110 REL_EXP_AMOUNT CRMT_CLA_REL_EXP_AMOUNT CRM_COND_VALUE CURR 19   2   Amount released after expiration of claim  
111 ALLOC_AMT_PAYEE CRMT_CLA_ALLOC_AMT_PAYEE CRM_COND_VALUE CURR 19   2   Allocated Amount Payee  
112 ALLOC_AMT_FUND CRMT_CLA_ALLOC_AMT_FUND CRM_COND_VALUE CURR 19   2   Allocated Amount Fund  
113 .INCLUDE       0   0   External reference numbers used in claims extract structures  
114 EXT_REF1 CRMT_EXT_REF_NUM TEXT35 CHAR 35   0   External Reference Number  
115 EXT_REF2 CRMT_EXT_REF_NUM TEXT35 CHAR 35   0   External Reference Number  
116 EXT_REF3 CRMT_EXT_REF_NUM TEXT35 CHAR 35   0   External Reference Number  
117 .INCLUDE       0   0   STATUS GROUPS Data for BW Datasources  
118 BWSTONESYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
119 BWSTONESYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
120 BWSTONESYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
121 BWSTONESYS3 CRMBWST J_STONR NUMC 2   0   BW Status  
122 BWSTONESYS4 CRMBWST J_STONR NUMC 2   0   BW Status  
123 BWSTONESYS5 CRMBWST J_STONR NUMC 2   0   BW Status  
124 BWSTONESYS6 CRMBWST J_STONR NUMC 2   0   BW Status  
125 BWSTONESYS7 CRMBWST J_STONR NUMC 2   0   BW Status  
126 BWSTONESYS8 CRMBWST J_STONR NUMC 2   0   BW Status  
127 BWSTONESYS9 CRMBWST J_STONR NUMC 2   0   BW Status  
128 BWSTONESYSA CRMBWST J_STONR NUMC 2   0   BW Status  
129 BWSTTECSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
130 BWSTTECSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
131 BWSTTECSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
132 BWSTLOCSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
133 BWSTLOCSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
134 BWSTLOCSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
135 BWSTONESYSB CRMBWST J_STONR NUMC 2   0   BW Status  
136 BWSTONESYSC CRMBWST J_STONR NUMC 2   0   BW Status  
137 .INCLUDE       0   0   PRICING_H Data for BW DataSources  
138 EXCHG_TYPE CRMT_EXCHG_TYPE KURST CHAR 4   0   Exchange Rate Type *
139 EXCHG_DATE CRMT_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Exchange Rate Date  
140 EXCHG_RATE CRMT_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Exchange Rate  
141 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency *
142 PRICE_DATE CRMT_PRICE_DATE CRM_PRICE_DATE DATS 8   0   Pricing Date  
143 REF_CURRENCY CRMT_REF_CURRENCY WAERS CUKY 5   0   Reference Currency *
144 PMNTTRMS CRMT_PMNTTRMS CRM_PMNTTRMS CHAR 4   0   Terms of Payment *
145 CUST_GROUP CRMT_CUST_GROUP CRM_CUST_GROUP CHAR 2   0   Customer Group *
146 CUSTOMER_TYPE CRMT_CUSTOMER_TYPE BU_KIND CHAR 4   0   Business Partner Type *
147 PAYMENT_LINE_ITEM SWO_TYPEID SWO_TYPEID CHAR 70   0   Object key  
148 ASSIGNED_AMOUNT CRMT_CLA_AMOUNT CRM_COND_VALUE CURR 19   2   Amount in Claims Management  
149 REPAYMENT_AMOUNT CRMT_CLA_AMOUNT CRM_COND_VALUE CURR 19   2   Amount in Claims Management  
150 CLEARED_AMOUNT CRMT_CLA_AMOUNT CRM_COND_VALUE CURR 19   2   Amount in Claims Management  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_BW_CHARGEBACK_RECOVERY OBJECT_TYPE CRMC_SUBOB_CAT SUBOBJ_CATEGORY    
History
Last changed by/on SAP  20130604 
SAP Release Created in 701