SAP Ariba and SAP ECC Integration: Key Mapping Fields

SAP Ariba and SAP ECC Integration: Key Mapping Fields

1. Master Data Mapping Fields

Vendor (Supplier) Master Data

• Ariba Supplier ID ↔ ECC Vendor Number (LIFNR)
• Supplier Name ↔ Name (NAME1, NAME2)
• Supplier Address ↔ Address (ADRNR)
• Supplier Country ↔ Country (LAND1)
• Supplier Tax ID ↔ Tax Number (STCEG)
• Supplier Contact Information ↔ Contact Data (KONZS)

Material Master Data

• Ariba Item ID ↔ ECC Material Number (MATNR)
• Item Description ↔ Material Description (MAKTX)
• Unit of Measure ↔ Base Unit of Measure (MEINS)
• Material Group ↔ Material Group (MATKL)
• Purchasing Group ↔ Purchasing Group (EKGRP)

Other Master Data

• Ariba Plant Code ↔ ECC Plant Code (WERKS)
• Ariba Company Code ↔ ECC Company Code (BUKRS)
• Ariba Purchase Organization ↔ ECC Purchase Organization (EKORG)

2. Transactional Data Mapping Fields

Purchase Orders (PO)

• Ariba PO Number ↔ ECC PO Number (EBELN)
• PO Line Item Number ↔ ECC PO Item Number (EBELP)
• Supplier ↔ Vendor (LIFNR)
• Material/Service ↔ Material/Service (MATNR or KTEXT)
• Quantity ↔ Quantity (MENGE)
• Unit Price ↔ Net Price (NETPR)
• Currency ↔ Currency (WAERS)

Goods Receipt (GR)

• Ariba GR Number ↔ ECC GR Document Number (MBLNR)
• Material Document Line Item ↔ ECC Line Item (ZEILE)
• Quantity Received ↔ Quantity (MENGE)
• Posting Date ↔ Posting Date (BUDAT)

Invoice

• Ariba Invoice Number ↔ ECC Invoice Number (BELNR)
• Invoice Date ↔ Invoice Date (BUDAT)
• Invoice Amount ↔ Invoice Amount (WRBTR)
• Tax Code ↔ Tax Code (MWSKZ)

Contracts

• Ariba Contract Number ↔ ECC Contract Number (KONNR)
• Contract Line Item ↔ ECC Contract Item (KPOSN)
• Start/End Date ↔ Validity Dates (DAT01/DAT02)

3. Accounting Data Mapping Fields

• Ariba Cost Center ↔ ECC Cost Center (KOSTL)
• Ariba G/L Account ↔ ECC G/L Account (HKONT)
• Ariba Profit Center ↔ ECC Profit Center (PRCTR)

4. Tax Data Mapping Fields

• Ariba Tax Code ↔ ECC Tax Code (MWSKZ)
• Tax Amount ↔ Tax Amount (MWSTS)
• Ariba Withholding Tax Code ↔ ECC Withholding Tax Code (QSSKZ)

5. Payment Data Mapping Fields

• Ariba Payment Terms ↔ ECC Payment Terms (ZTERM)
• Ariba Payment Method ↔ ECC Payment Method (ZLSCH)

6. Additional Key Mapping Fields

• Ariba Business Partner ID ↔ ECC Business Partner ID (BP)
• Ariba PR Number ↔ ECC Purchase Requisition Number (BANFN)
• Ariba Ship-to Address ↔ ECC Ship-to Address (ADRNR)
• Ariba Account Assignment ↔ ECC Account Assignment Category (KNTTP)

Common Integrations

• SAP PI/PO or SAP Cloud Integration are often used to facilitate the mapping between SAP Ariba and SAP ECC.

Note: This field mapping might vary depending on the specific business processes and configurations in your organization. It's essential to customize the integration to meet your specific requirements.

Let me know if you have any specific questions or would like to explore a particular integration scenario in more depth!