One of the most frequently asked question in any CRM implementaion project is “Is there any table where we can see the mapping of standard fields between CRM and ECC”. This document has been created to help SAP consultants and others to answer the mapping question and to have easy reference for field mapping between CRM sales order and ECC sales order.
Comments are highly appreciated and if you like the article please marked it as “like”
1.0 Introduction
Scenario : You create, change and save sales orders in CRM database. Sales orders, complaints replicate to ECC for fullfilment.
As soon as a CRM Sales Order is saved without any error, the transaction is transferred to SAP ERP. Sales order exists in both the systems. The subsequent logistics processes, for example delivery of the sales order, take place in ECC.
2.0 CRM Middleware
Date transfer between CRM and ECC take place through CRM middleware. Once CRM sales order data is saved the sales order data is written to an mBDoc message and then to CSA queue. Date replication service decides the destination of the data and R/3 adaptor convert the mBDoc data into BAPI structure. In the next step data is written to R3A outbound queue to be processed in ECC.
3.0 Field Mapping
The standard mapping module in CRM is CRM_SALESDOC_MAP_MBDOC2BAPI. One can find the CRM to ECC sales order fields mapping using structures BAPISDHD1 and BAPISDITM. There are many more structure for partners, schedule linne and others.
Sales Order Header Fields
<td
| CRM Field | ECC Field | Data Type | Length | Decimal | Description |
| REFOBJTYPE | SWO_OBJTYP | CHAR | 10 | 0 | Object Type |
| REFOBJKEY | SWO_TYPEID | CHAR | 70 | 0 | Object key |
| REFDOCTYPE | REFDOCTYPE | CHAR | 10 | 0 | |
| DOC_TYPE | AUART | CHAR | 4 | 0 | Sales Document Type |
| COLLECT_NO | SUBMI_SD | CHAR | 10 | 0 | Collective number (SD) |
| SALES_ORG | VKORG | CHAR | 4 | 0 | Sales Organization |
| DISTR_CHAN | VTWEG | CHAR | 2 | 0 | Distribution Channel |
| DIVISION | SPART | CHAR | 2 | 0 | Division |
| SALES_GRP | VKGRP | CHAR | 3 | 0 | Sales group |
| SALES_OFF | VKBUR | CHAR | 4 | 0 | Sales office |
| REQ_DATE_H | EDATU_VBAK | DATS | 8 | 0 | Requested delivery date |
| DATE_TYPE | PRGRS_VBAK | CHAR | x` | 0 | Proposed Period for Date |
| PURCH_DATE | BSTDK | DATS | 8 | 0 | Customer purchase order date |
| PO_METHOD | BSARK | CHAR | 4 | 0 | Customer Order Type |
| PO_SUPPLEM | BSTZD | CHAR | 4 | 0 | Customer purchase order number supplement |
| REF_1 | IHREZ | CHAR | 12 | 0 | Your Reference |
| NAME | BNAME_V | CHAR | 35 | 0 | Name of orderer |
| TELEPHONE | TELF1_VP | CHAR | 16 | 0 | Telephone Number |
| PRICE_GRP | KONDA | CHAR | 2 | 0 | Price Group (Customer) |
| CUST_GROUP | KDGRP | CHAR | 2 | 0 | Customer group |
| SALES_DIST | BZIRK | CHAR | 6 | 0 | Sales district |
| PRICE_LIST | PLTYP | CHAR | 2 | 0 | Price list type |
| INCOTERMS1 | INCO1 | CHAR | 3 | 0 | Incoterms (Part 1) |
| INCOTERMS2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) |
| PMNTTRMS | DZTERM | CHAR | 4 | 0 | Terms of payment key |
| DLV_BLOCK | LIFSK | CHAR | 2 | 0 | Delivery block (document header) |
| BILL_BLOCK | FAKSK | CHAR | 2 | 0 | Billing block in SD document |
| ORD_REASON | AUGRU | CHAR | 3 | 0 | Order reason (reason for the business transaction) |
| COMPL_DLV | AUTLF | CHAR | 1 | 0 | Complete delivery defined for each sales order? |
| PRICE_DATE | PRSDT | DATS | 8 | 0 | Date for pricing and exchange rate |
| QT_VALID_F | ANGDT_V | DATS | 8 | 0 | Quotation/Inquiry is valid from |
| QT_VALID_T | SMO3BNDDT | DATS | 8 | 0 | Date until which bid/quotation is binding (valid-to date) |
| CT_VALID_F | GUEBG | DATS | 8 | 0 | Valid-from date (outline agreements, product proposals) |
| CT_VALID_T | GUEEN | DATS | 8 | 0 | Valid-to date (outline agreements, product proposals) |
| CUST_GRP1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 |
| CUST_GRP2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 |
| CUST_GRP3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 |
| CUST_GRP4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 |
| CUST_GRP5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 |
| PURCH_NO_C | BSTKD | CHAR | 35 | 0 | Customer purchase order number |
| PURCH_NO_S | BSTKD_E | CHAR | 35 | 0 | Ship-to Party’s Purchase Order Number |
| PO_DAT_S | BSTDK_E | DATS | 8 | 0 | Ship-to party’s PO date |
| PO_METH_S | BSARK_E | CHAR | 4 | 0 | Ship-to party purchase order type |
| REF_1_S | IHREZ_E | CHAR | 12 | 0 | Ship-to party character |
| SD_DOC_CAT | VBTYP | CHAR | 1 | 0 | SD document category |
| DOC_DATE | AUDAT | DATS | 8 | 0 | Document date (date received/sent) |
| WAR_DATE | GWLDT | DATS | 8 | 0 | Guarantee date |
| SHIP_COND | VSBED | CHAR | 2 | 0 | Shipping conditions |
| PP_SEARCH | KTEXT_V | CHAR | 40 | 0 | Search term for product proposal |
| DUN_COUNT | MAHZA | DEC | 3 | 0 | Number of reminder notices, reminders for delivery purchase |
| DUN_DATE | MAHDT | DATS | 8 | 0 | Last Delivery Reminder Notice |
| DLVSCHDUSE | ABRVW | CHAR | 3 | 0 | Usage Indicator |
| PLDLVSTYP | ABDIS | CHAR | 1 | 0 | MRP for Release Types |
| REF_DOC | VGBEL | CHAR | 10 | 0 | Document number of the reference document |
| COMP_CDE_B | BUKRS_VF | CHAR | 4 | 0 | Company code to be billed |
| ALTTAX_CLS | TAXK1_AK | CHAR | 1 | 0 | Alternative tax classification |
| TAX_CLASS2 | TAXK2 | CHAR | 1 | 0 | Tax classification 2 for customer |
| TAX_CLASS3 | TAXK3 | CHAR | 1 | 0 | Tax classification 3 for customer |
| TAX_CLASS4 | TAXK4 | CHAR | 1 | 0 | Tax classification 4 for customer |
| TAX_CLASS5 | TAXK5 | CHAR | 1 | 0 | Tax classification 5 for customer |
| TAX_CLASS6 | TAXK6 | CHAR | 1 | 0 | Tax classification 6 for customer |
| TAX_CLASS7 | TAXK7 | CHAR | 1 | 0 | Tax classification 7 for customer |
| TAX_CLASS8 | TAXK8 | CHAR | 1 | 0 | Tax classification 8 for customer |
| TAX_CLASS9 | TAXK9 | CHAR | 1 | 0 | Tax classification 9 for customer |
| REF_DOC_L | XBLNR_V | CHAR | 16 | 0 | Reference Document Number |
| ***_NUMBER | ORDNR_V | CHAR | 18 | 0 | Assignment Number |
| REFDOC_CAT | VBTYP_V | CHAR | 1 | 0 | Document category of preceding SD document |
| ORDCOMB_IN | KZAZU_D | CHAR | 1 | 0 | Order combination indicator |
| BILL_SCHED | PERFK | CHAR | 2 | 0 | Invoice dates (calendar identification) |
| INVO_SCHED | PERRL | CHAR | 2 | 0 | Invoice list schedule (calendar identification) |
| MN_INVOICE | MRNKZ | CHAR | 1 | 0 | Manual invoice maintenance |
| EXRATE_FI | KURRF_P | DEC | 9 | 5 | Directly quoted exchange rate for FI postings |
| ADD_VAL_DY | VALTG | NUMC | 2 | 0 | Additional value days |
| FIX_VAL_DY | VALDT | DATS | 8 | 0 | Fixed value date |
| PYMT_METH | DZLSCH | CHAR | 1 | 0 | Payment method |
| ACCNT_ASGN | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer |
| EXCHG_RATE | KURSK_P | DEC | 9 | 5 | Directly Quoted Exchange Rate for Pricing and Statistics |
| BILL_DATE | FKDAT | DATS | 8 | 0 | Billing date for billing index and printout |
| SERV_DATE | FBUDA | DATS | 8 | 0 | Date When Services Rendered |
| DUNN_KEY | MSCHL | CHAR | 1 | 0 | Dunning key |
| DUNN_BLOCK | MANSP | CHAR | 1 | 0 | Dunning block |
| PMTGAR_PRO | ABSSCHE_CM | CHAR | 6 | 0 | Payment Guarantee Procedure |
| DEPARTM_NO | ABTNR | CHAR | 4 | 0 | Department number |
| REC_POINT | EMPST | CHAR | 25 | 0 | |
| DOC_NUM_FI | LCNUM | CHAR | 10 | 0 | |
| CSTCNDGRP1 | KDKG1 | CHAR | 2 | 0 | Customer condition group 1 |
| CSTCNDGRP2 | KDKG2 | CHAR | 2 | 0 | Customer condition group 2 |
| CSTCNDGRP3 | KDKG3 | CHAR | 2 | 0 | Customer condition group 3 |
| CSTCNDGRP4 | KDKG4 | CHAR | 2 |