CRM Sales Order fields mapping to ECC Sales Order fields - Standard

[lovekush_singh]

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

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	0	Customer condition group 4
CSTCNDGRP5	KDKG5	CHAR	2	0	Customer condition group 5
DLV_TIME	DELCO	CHAR	3	0	Agreed delivery time
CURRENCY	WAERK	CUKY	5	0	SD document currency
CURR_ISO	WAERS_ISO	CHAR	3	0	ISO code currency
CREATED_BY	ERNAM	CHAR	12	0	Name of Person who Created the Object
TAXDEP_CTY	LANDTX	CHAR	3	0	Tax Departure Country
TAXDST_CTY	LAND1TX	CHAR	3	0	Tax Destination Country
EUTRI_DEAL	XEGDR	CHAR	1	0	Indicator: Triangular deal within the EU ?
MAST_CONTR	VBELN_GRP	CHAR	10	0	Group Master Contract
REF_PROC	SCHEME_GRP	CHAR	4	0	Referencing requirement: Procedure
CHKPRTAUTH	ABRUF_PART	CHAR	1	0	Check partner authorizations
CMLQTY_DAT	DAT_FZAU	DATS	8	0	Cml delivery order qty date
VERSION	VSNMR_V	CHAR	12	0	Sales document version number
NOTIF_NO	QMNUM	CHAR	12	0	Message Number
WBS_ELEM	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
EXCH_RATE_FI_V	KURRF_V	DEC	9	5	Indirectly quoted exchange rate for FI postings
EXCHG_RATE_V	KURSK_V	DEC	9	5	Indirectly Quoted Exchange Rate for Pricing and Statistics
FKK_CONACCT	FKK_CONACCT_DUMMY	CHAR	12	0	Dummy Contract Account FI-CA (not in standard)
CAMPAIGN	SYSUUID_X	RAW	16	0	UUID in X form (binary)
DOC_CLASS	VBKLA	CHAR	9	0	unused (sales doocument class)
H_CURR	WAERS	CUKY	5	0	Currency Key
H_CURR_ISO	ISOCD	CHAR	3	0	ISO currency code
SHIP_TYPE	VSARTTR	CHAR	2	0	Shipping type
S_PROC_IND	SDABW	CHAR	4	0	Special Processing Indicator
REF_DOC_L_LONG	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
LINE_TIME	EZEIT_VBAK	TIMS	6	0	Proposed schedule line time (local with ref. to sales org.)
CALC_MOTIVE	BEMOT	CHAR	2	0	Accounting Indicator

Sales Order Item Fields

CRM Field	ECC Field	Data Type	Length	Decimal	Description
ITM_NUMBER	POSNR_VA	NUMC	6	0	Sales Document Item
HG_LV_ITEM	UEPOS	NUMC	6	0	Higher-level item in bill of material structures
PO_ITM_NO	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
MATERIAL	MATNR	CHAR	18	0	Material Number
ALT_TO_ITM	GRPOS	NUMC	6	0	Item for which this item is an alternative
CUST_MAT22	MATNR_KU1	CHAR	22	0
BATCH	CHARG_D	CHAR	10	0	Batch Number
DLV_GROUP	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
PART_DLV	KZTLF	CHAR	1	0	Partial delivery at item level
REASON_REJ	ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
BILL_BLOCK	FAKSP	CHAR	2	0	Lock
BILL_DATE	FKDAT	DATS	8	0	Billing date for billing index and printout
PLANT	WERKS_D	CHAR	4	0	Plant
STORE_LOC	LGORT_D	CHAR	4	0	Storage location
TARGET_QTY	DZMENG	QUAN	13	3	Target quantity in sales units
TARGET_QU	DZIEME	UNIT	3	0	Target quantity UoM
T_UNIT_ISO	ISO_ZIEME	CHAR	3	0	Target quantity unit of measure in ISO code
ITEM_CATEG	PSTYV	CHAR	4	0	Sales document item category
SHORT_TEXT	ARKTX	CHAR	40	0	Short text for sales order item
PRC_GROUP1	MVGR1	CHAR	3	0	Material group 1
PRC_GROUP2	MVGR2	CHAR	3	0	Material group 2
PRC_GROUP3	MVGR3	CHAR	3	0	Material group 3
PRC_GROUP4	MVGR4	CHAR	3	0	Material group 4
PRC_GROUP5	MVGR5	CHAR	3	0	Material group 5
PROD_HIERA	PRODH_D	CHAR	18	0	Product Hierarchy
MATL_GROUP	MATKL	CHAR	9	0	Material Group
PURCH_NO_C	BSTKD	CHAR	35	0	Customer purchase order number
PURCH_DATE	BSTDK	DATS	8	0	Customer purchase order date
PO_METHOD	BSARK	CHAR	4	0	Customer Order Type
REF_1	IHREZ	CHAR	12	0	Your Reference
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
POITM_NO_S	POSEX_E	CHAR	6	0	Item Number of the Underlying Purchase Order
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)
ORDCOMP_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
EX_RATE_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
PMNTTRMS	DZTERM	CHAR	4	0	Terms of payment key
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
PRICE_DATE	PRSDT	DATS	8	0	Date for pricing and exchange rate
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
PROMOTION	WAKTION	CHAR	10	0	Promotion
PMTGAR_PRO	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure
DOC_NUM_FI	LCNUM	CHAR	10	0
DEPARTM_NO	ABTNR	CHAR	4	0	Department number
REC_POINT	EMPST	CHAR	25	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	0	Customer condition group 4
CSTCNDGRP5	KDKG5	CHAR	2	0	Customer condition group 5
DLV_TIME	DELCO	CHAR	3	0	Agreed delivery time
SALES_UNIT	VRKME	UNIT	3	0	Sales unit
S_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
TRG_QTY_NO	UMZIZ	DEC	5	0	Factor for converting sales units to base units (target qty)
TRGQTY_DEN	UMZIN	DEC	5	0	Factor for converting sales units to base units (target qty)
RNDDLV_QTY	ABLFZ	QUAN	13	3	Rounding quantity for delivery
MAXDEVAMNT	ABSFZ	QUAN	13	3	Allowed deviation in quantity (absolute)
MAXDEVPER	KBVER	DEC	3	0	Allowed deviation in quantity (in percent)
MAXDEV_DAY	KEVER	DEC	3	0	Days by which the quantity can be shifted
USAGE_IND	VKAUS	CHAR	3	0	Unused - Reserve Length 3
FIXED_QUAN	FMENG	CHAR	1	0	Quantity is fixed
UNLMT_DLV	UEBTK	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
OVERDLVTOL	CRMT_OVER_DLV_TOL	DEC	3	1	Overdelivery Tolerance Limit
UNDDLV_TOL	CRMT_UNDER_DLV_TOL	DEC	3	1	Underdelivery Tolerance Limit
DIVISION	SPART	CHAR	2	0	Division
SALQTYNUM	UMVKZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
SALQTYDEN	UMVKN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
GROSS_WGHT	BRGEW_AP	QUAN	15	3	Gross weight of item
NET_WEIGHT	NTGEW_AP	QUAN	15	3	Net weight of item
UNTOF_WGHT	GEWEI	UNIT	3	0	Weight Unit
UNOF_WTISO	GEWEI_ISO	CHAR	3	0	Unit of weight in ISO code
VOLUME	VOLUM_AP	QUAN	15	3	Volume of the item
VOLUNIT	VOLEH	UNIT	3	0	Volume unit
VOLUNITISO	VOLEH_ISO	CHAR	3	0	Volume unit in ISO code
DLV_PRIO	LPRIO	NUMC	2	0	Delivery priority
SHIP_POINT	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
ROUTE	ROUTE	CHAR	6	0	Route
CREATED_BY	ERNAM	CHAR	12	0	Name of Person who Created the Object
TAX_CLASS1	TAXMT	CHAR	1	0	Tax classification material
TAX_CLASS2	TAXMT	CHAR	1	0	Tax classification material
TAX_CLASS3	TAXMT	CHAR	1	0	Tax classification material
TAX_CLASS4	TAXMT	CHAR	1	0	Tax classification material
TAX_CLASS5	TAXMT	CHAR	1	0	Tax classification material
TAX_CLASS6	TAXMT	CHAR	1	0	Tax classification material
TAX_CLASS7	TAXMT	CHAR	1	0	Tax classification material
TAX_CLASS8	TAXMT	CHAR	1	0	Tax classification material
TAX_CLASS9	TAXMT	CHAR	1	0	Tax classification material
MAT_PR_GRP	KONDM	CHAR	2	0	Material Pricing Group
VAL_TYPE	BWTAR_D	CHAR	10	0	Valuation type
FIXDAT_QTY	FIXMG	CHAR	1	0	Delivery date and quantity fixed
BOMEXPL_NO	SERNR	CHAR	8	0	BOM explosion number
RESANALKEY	ABGR_SCHL	CHAR	6	0	Results Analysis Key
REQMTS_TYP	BEDAE	CHAR	4	0
NO_GR_POST	NACHL	CHAR	1	0	Customer has not posted goods receipt
BUS_TRANST	EXART	CHAR	2	0
OVERHD_KEY	AUFZSCHL	CHAR	6	0	Overhead key
CSTG_SHEET	AUFKALSM	CHAR	6	0	Costing Sheet
MATFRGTGRP	MFRGR	CHAR	8	0	Material freight group
PLDLVSHDIN	PLAVO	CHAR	4	0	Planning Release Regulation
SEQ_NO	KANNR	CHAR	35	0	KANBAN/sequence number
BIL_FORM	FAKTF	CHAR	2	0	Billing Form
DLI_PROFIL	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile
REV_TYPE	RR_RELTYP	CHAR	1	0	Revenue recognition category
BEGDEM_PER	RR_ACDATV	CHAR	1	0	Proposed start date for accrual period
PR_REF_MAT	PMATN	CHAR	18	0	Pricing Reference Material
REFOBJTYPE	SWO_OBJTYP	CHAR	10	0	Object Type
REFOBJKEY	SWO_TYPEID	CHAR	70	0	Object key
REFLOGSYS	LOGSYS	CHAR	10	0	Logical system
ORDER_PROB	AWAHR	NUMC	3	0	Order probability of the item
MAX_PL_DLV	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
CFOP_CODE	J_1BCFOP	CHAR	5	0	CFOP code and extension
TAXLAWICMS	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS
TAXLAWIPI	J_1BTAXLW2	CHAR	3	0	Tax law: IPI
SD_TAXCODE	J_1BTXSDC_	CHAR	2	0	SD tax code
ASSORT_MOD	W_SORTK	CHAR	18	0	Assortment Module
COMP_QUANT	KMPMG	QUAN	13	3	Component Quantity
TARGET_VAL	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
CURRENCY	WAERK	CUKY	5	0	SD document currency
CURR_ISO	WAERS_ISO	CHAR	3	0	ISO code currency
PROFIT_CTR	PRCTR	CHAR	10	0	Profit Center
ORDERID	AUFNR	CHAR	12	0	Order Number
WBS_ELEM	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
DEPREC_PER	AKPRZ	DEC	5	2
REF_DOC	VGBEL	CHAR	10	0	Document number of the reference document
REF_DOC_IT	VGPOS	NUMC	6	0	Item number of the reference item
REF_DOC_CA	VBTYP_V	CHAR	1	0	Document category of preceding SD document
CUST_MAT35	KDMAT	CHAR	35	0	Material belonging to the customer
EXCH_RATE_FI_V	KURRF_V	DEC	9	5	Indirectly quoted exchange rate for FI postings
EXCHG_RATE_V	KURSK_V	DEC	9	5	Indirectly Quoted Exchange Rate for Pricing and Statistics
ITEMGUID_ATP	POSGUID	CHAR	22	0	ATP: Encryption of DELNR and DELPS
VAL_CONTR	WKTNR	CHAR	10	0	Value contract no.
VAL_CON_I	WKTPS	NUMC	6	0	Value contract item
CONFIG_ID	CUXCFG_ID	CHAR	6	0
INST_ID	CU_INST_ID	CHAR	8	0	Instance Number in Configuration
MAT_EXT	MGV_MATERIAL_EXTERNAL	CHAR	40	0	Long Material Number for MATERIAL Field
MAT_GUID	MGV_MATERIAL_GUID	CHAR	32	0	External GUID for MATERIAL Field
MAT_VERS	MGV_MATERIAL_VERSION	CHAR	10	0	Version Number for MATERIAL Field
P_MAT_EXT	MGV_PR_REF_MAT_EXTERNAL	CHAR	40	0	Long Material Number for PR_REF_MAT Field
P_MAT_GUID	MGV_PR_REF_MAT_GUID	CHAR	32	0	External GUID for PR_REF_MAT Field
P_MAT_VERS	MGV_PR_REF_MAT_VERSION	CHAR	10	0	Version Number for PR_REF_MAT Field
FUNC_AREA	FKBER_SHORT	CHAR	4	0	Functional Area
ALTERN_BOM	STLAL	CHAR	2	0	Alternative BOM
FKK_CONACCT	CHAR12	CHAR	12	0	Character Field of Length 12
EAN_UPC	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
PRODCAT	WMINR	CHAR	10	0	Product catalog number
SHIP_TYPE	VSARTTR	CHAR	2	0	Shipping type
S_PROC_IND	SDABW	CHAR	4	0	Special Processing Indicator
FUNC_AREA_LONG	CHAR16	CHAR	16	0	Field of length 16
BILL_REL	CRMT_BILLING_RELEVANT	CHAR	1	0	Billing Relevance
VW_UEPOS	UEPVW	CHAR	1	0	ID for higher-level item usage
CAMPAIGN	CGPL_GUID16_R3	RAW	16	0	Generic project planning: GUID from external R/3 system
DLVSCHDUSE	ABRVW	CHAR	3	0	Usage Indicator
CFOP_LONG	CHAR10	CHAR	10	0	Character Field Length = 10
SELECTION	COMT_VBX_SEL_GUID	CHAR	32	0	Selection ID (Not Persistent)
MAT_ENTRD	MATWA	CHAR	18	0	Material entered
LOG_SYSTEM_OWN	LOGSYS	CHAR	10	0	Logical system
ITM_TYPE_USAGE	VWPOS	CHAR	4	0	Item usage
TAXLAWISS	J_1BTAXLW3	CHAR	3	0	Tax law: ISS
MAT_ENTRD_EXTERNAL	MGV_MAT_ENTRD_EXTERNAL	CHAR	40	0	Long Material Number for MAT_ENTRD Field
MAT_ENTRD_GUID	MGV_MAT_ENTRD_GUID	CHAR	32	0	External GUID for MAT_ENTRD Field
MAT_ENTRD_VERSION	MGV_MAT_ENTRD_VERSION	CHAR	10	0	Version Number for MAT_ENTRD Field
LOC_TAXCAT	LOC_TAXCAT	CHAR	2	0	Tax Category
LOC_ZEROVAT	LOC_ZEROVAT	CHAR	1	0	Reason for Zero-Rated VAT
LOC_ACTCODE	LOC_ACTCODE	CHAR	2	0	Activity Code for Gross Income Tax
LOC_DISTTYPE	LOC_DISTTYPE	CHAR	2	0	Distribution Type for Employment Tax
LOC_TXRELCLAS	LOC_TXRELCLAS	CHAR	10	0	Tax Relevance Classification
CALC_MOTIVE	BEMOT	CHAR	2	0	Accounting Indicator
COMPREAS	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
FUND	BP_GEBER	CHAR	10	0	Fund
FUNDS_CTR	FISTL	CHAR	16	0	Funds Center
CMMT_ITEM	FM_FIPEX	CHAR	24	0	Commitment item
GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
BUDGET_PERIOD	CHAR10	CHAR	10	0	Character Field Length = 10
TAXLAWCOFINS	CHAR3	CHAR	3	0	3-Byte field
TAXLAWPIS	CHAR3	CHAR	3	0	3-Byte field

4.0 Further Work

Consultants can further explore the CRM functional modules to better undestand the replication process between CRM and ECC.

5.0 References

1. SAP Note 1053817 - Distributing customer-specific fields from CRM to R/3
2. SAP CRM Middleware Optimization Guide by Juliane Bode, Stephan Golze, Thomas Schröder – SAP Press