You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 28 Next »

Status

  Lead Approval

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create 9040 - Purchasing Contracts and outline agreement in S/4 HANA.

A purchasing contract is a legally-binding purchase agreement that contains special conditions that are negotiated between a buyer and a seller, covering the supply of goods or the performance of services. The contract is valid for a specific period, during which goods and services are released against the contract. The purchasing contract enables buyers to create purchasing contracts for frequently procured goods or services. A released contract can be used as a source of supply for the procurement of goods or services through a purchase order, a goods and service acknowledgement or a supplier invoice. The releases made against the contract by these documents are updated in the contract..

An outline agreement in SAP MM is a long-term purchasing agreement with a vendor, defining terms, prices, and quantities for materials or services over a set period. The two main types are Contracts and Scheduling agreements,

In SAP ECC, contracts are as per the below

  1. Quantity Contracts (Contract type MK)
  2. Value Contracts (Contract type WK)
  3. Catalog Contracts (Contract type ZWK)

in SAP ECC, there are few outline agreements to be migrated into S/4.

A quantity contract is defined as the type of contract where the total quantity to be ordered during the validity period of the contract is known in advance. The contract is regarded as fulfilled when release orders totaling a given quantity have been issued.  

When material is required,  a Purchase Order is created with reference to the Contract for delivery of the material. The Purchase Orders, created with reference to contracts, are also known as call-off orders.

A value contract is defined as is a long-term, legally binding agreement with a customer or vendor to purchase/supply goods or services up to a specified total monetary value within a set period. It does not specify exact delivery dates or quantities, allowing for flexible release orders until the target value is met.

A catalog contract in SAP is defined as specialized, legally binding, long-term procurement agreement (value or quantity) published within a digital catalog to enforce negotiated pricing, It streamlines compliant purchasing by automatically applying agreed rates to catalog items, enabling users to order directly from pre-approved, contract-covered items in SAP.

The outline purchase agreement is often referred to as a blanket or umbrella purchase order. It is basically a long-term agreement between the purchasing department and vendor for material or services for a defined period of time. The purchasing department negotiates with the vendor a set of terms and conditions that are fixed for the period of agreement.


Conversion Scope

The scope of this document covers the approach for converting active Purchasing Contracts from Legacy Source Systems into S/4HANA

The data from legacy system includes:

  1. The plants and purchasing organizations are in the migration scope.
  2. The material and vendor in the Contracts are in the migration scope.
  3. The contract is still within the validity period.
  4. Only approved and released contracts can be migrated.
  5. Meta data for the contracts from Icertis (TBC- main source and need the data from R2 team).
  6. ECC Source list will be the one of the source to identify the scope of the contracts.
  7. Contracts scope will be verified with the one year consumption (TBC)
  8. Company codes are in migration scope.
  9. Material Groups are in migration scope.
  10. Vendor + Purchasing Organizations combination is in migration scope at Purchasing Document Header data level
  11. Material + Plant combination is in migration scope at Purchasing Document Item data level.

The data from legacy system excludes:

  1. Deletion Indicator (EKKO-LOEKZ) = "X" at Purchasing Document Header level
  2. Validity period End (EKKO-KDATE) < System date at Purchasing Document Header level
  3. Deletion Indicator (EKKO-LOEKZ) = "X" at Purchasing Document Item Data level
  4. Header contracts with no line item data.
  5. Open Purchase Orders, Quotation requests
  6. Master Conditions - During the creation of outline agreements, you can specify just one time period for each variable key.
  7. Scales are not supported during the creation of outline agreements.

  8. Volume rebate conditions in outline agreements are not taken into account.

  9. Version management (document change management).

  10. ternal services (planned and unplanned services).
  11. Item categories (Third-Party, Enhanced Limits, Consignment, Subcontracting).
  12. Multilevel item hierarchy.

Notes (only for information):

  1. If multiple records exist for the same material and vendor, select only the one with the most recent effective date.
  2. Migrating SAP purchasing contracts requires converting released, approved legacy agreements into active S/4HANA contracts, often maintaining original contract IDs. 
  3. If Purchasing info record is already available, the price is taken from this info record.

Process-Flow diagram:


image.png


Important Tables for Purchasing Contracts:

  1. EKKO: Purchasing Document Header data.
  2. EKPO: Purchasing Document Item data.
  3. EKKN: Account Assignment in Purchasing Document

The following structures or features are supported in SAP S/4HANA:

  1. Header Data

  2. Supplier Address

  3. Header Texts

  4. Item Data

  5. Delivery Addresses

  6. Account Assignment

  7. Item Texts

List of source systems and approximate number of records 

SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2

Purchasing Contracts Header data




Purchasing Contracts Line Item data




Purchasing Contracts Account Assignment data




Purchasing Contracts Conditions data (Condition Types PB00 - Gross Price, PC- Percentage Contract) - S/4 will generate it.

3500

Value contracts - 2390
Quantity contracts - 534
Catalog contracts - 342


70257

Value contracts - 46935
Quantity contracts - 9837
Catalog contracts - 13485

 
70257

Value contracts - 46935
Quantity contracts - 9837
Catalog contracts - 13485


Around 80000

S4HANA

3500

Value contracts - 2390
Quantity contracts - 534
Catalog contracts - 342

 
70257

Value contracts - 46935
Quantity contracts - 9837
Catalog contracts - 13485

 
70257

Value contracts - 46935
Quantity contracts - 9837
Catalog contracts - 13485


Around 80000




WP2

Purchasing Contracts Header data




Purchasing Contracts Line Item data




Purchasing Contracts Account Assignment data




Purchasing Contracts Conditions data (Condition Types PB00 - Gross Price, PC- Percentage Contract)- S/4 will generate it.

1350

Value contracts - 537
Quantity contracts - 12
Catalog contracts - 801


42607

Value contracts - 21961
Quantity contracts - 41
Catalog contracts - 20605

 
42607

Value contracts - 21961
Quantity contracts - 41
Catalog contracts - 20605



Around 60000

S4HANA

1350

Value contracts - 537
Quantity contracts - 12
Catalog contracts - 801


42607

Value contracts - 21961
Quantity contracts - 41
Catalog contracts - 20605

 
42607

Value contracts - 21961
Quantity contracts - 41
Catalog contracts - 20605



Around 60000


Additional Information

Multi-language Requirement

N/A

Document Management

Legal Requirement

N/A

Special Requirements

Different countries/regions have differing legal requirements (TBC)

Any intercompany contracts (TBC)


Target Design

The technical design of the target for this conversion approach. . The below table shows the specific Tables and Key fields as per the Migration Cockpit Template will provide all the details for the target design


Field List for Migration Object: MM - Purchase contract
Sheet NameGroup NameField DescriptionImportanceTypeLengthDecimalSAP StructureSAP Field
Header Data (mandatory)

KeyLegacy Agreement Numbermandatory for sheetText80    
EKKOLEGACY_NUMBER
General DataCompany Codemandatory for sheetText80    
EKKOBUKRS
Agreement Typemandatory for sheetText80    
EKKOBSART
Supplier's Account Numbermandatory for sheetText80    
EKKOLIFNR
Purchasing Organizationmandatory for sheetText80    
EKKOEKORG
Purchasing Groupmandatory for sheetText80    
EKKOEKGRP
Currency Key (ISO Format)mandatory for sheetText80    
EKKOWAERS
Administrative DataAgreement Date
Date

EKKOBEDAT
Start of Validity Period
Date

EKKOKDATB
End of Validity Periodmandatory for sheetDate

EKKOKDATE
Terms of Delivery and PaymentTarget Value
Number15    2     EKKOKTWRT
Exchange Rate
Number9     5     EKKOWKURS
Indicator for Fixed Exchange Rate
Text1     
EKKOKUFIX
Terms of Payment Key
Text80    
EKKOZTERM
First Payment in Days
Number3     
EKKODSCNT1_TO
Discount for First Payment in %
Number5     3     EKKODSCT_PCT1
Second Payment in Days
Number3     
EKKODSCNT2_TO
Discount for Second Payment in %
Number5     3     EKKODSCT_PCT2
Cash Discount Days
Number3     
EKKODSCNT3_TO
Incoterms Version
Text80    
EKKOINCOV
Incoterms
Text80    
EKKOINCO1
Incoterms Location 1
Text70    
EKKOINCO2_L
Incoterms Location 2
Text70    
EKKOINCO3_L
Reference DataYour Reference
Text12    
EKKOIHREZ
Our Reference
Text12    
EKKOUNSEZ
Sales Person
Text30    
EKKOVERKF
Telephone
Text16    
EKKOTELF1
TaxesCountry/Region of Sales Tax ID Number
Text80    
EKKOSTCEG_L









Supplier Address (Not Applicable)

KeyLegacy Agreement Numbermandatory for sheetText80    
ADRCLEGACY_NUMBER
Supplier AddressCity
Text40    
ADRCCITY
City Postal Code
Text10    
ADRCPOSTL_COD1
Street
Text40    
ADRCSTREET
House Number
Text10    
ADRCHOUSE_NO
Country/Region
Text80    
ADRCCOUNTRY
Region
Text80    
ADRCREGION









Header Texts( Not Applicable)

KeyLegacy Purchasing Document Numbermandatory for sheetText80    
STXHLEGACY_NUMBER
TextText IDmandatory for sheetText80    
STXLTDID
Textmandatory for sheetTextunrestricted
STXLTEXT









Item Data (mandatory)

KeyLegacy Agreement Numbermandatory for sheetText80    
EKPOLEGACY_NUMBER
Item Number of Agreementmandatory for sheetNumber5     
EKPOEBELP
General DataHigher-Level Item
Number5     
EKPOHL_ITEM
Item Is an Item Set
Text1     
EKPOISOUTLINE
Item Category
Text80    
EKPOPSTYP
Account Assignment Category
Text80    
EKPOKNTTP
Product
Text80    
EKPOMATNR
Short Text
Text40    
EKPOTXZ01
Plant
Text80    
EKPOWERKS
Storage Location
Text80    
EKPOLGORT
Product Group
Text80    
EKPOMATKL
Product Type Group
Text80    
EKPOPRODUCTTYPE
Confirmation Control Key
Text80    
EKPOBSTAE
Quantity and PriceTarget Quantity
Number13    3     EKPOKTMNG
Release Order Quantity
Number13    3     EKPOABMNG
Order Unit of Measure (ISO Format)
Text80    
EKPOPO_UNIT_ISO
Net Price
Number28    2     EKPONETPR
Price Unit
Number5     
EKPOPEINH
Price Unit of Measure (ISO Format)
Text80    
EKPOBPRME
Numerator Conv. Price Unit -> Order Unit
Number5     
EKPOBPUMZ
Denominator Conv. Price Unit->Order Unit
Number5     
EKPOBPUMN
Update Info Record
Text80    
EKPOSPINF
HandlingFirst Reminder/Expediter
Number3     
EKPOMAHN1
Second Reminder/Expediter
Number3     
EKPOMAHN2
Third Reminder/Expediter
Number3     
EKPOMAHN3
Planned Delivery Duration in Days
Number3     
EKPOPLIFZ
Product Number Used by Supplier
Text35    
EKPOVEND_MAT
GR/IR ControlUnderdelivery Tolerance Limit
Number3     1     EKPOUNTTO
Overdelivery Tolerance Limit
Number3     1     EKPOUEBTO
Indicator:Unlimited Overdelivery Allowed
Text1     
EKPOUEBTK
Tax Code
Text80    
EKPOMWSKZ
Shipping Instruction
Text80    
EKPOEVERS
Kanban Indicator
Text80    
EKPOKANBA
Indicator: Invoice Receipt
Text1     
EKPOREPOS
Indicator: GR-Based Invoice Verification
Text1     
EKPOWEBRE
Indicator: Acceptance At Origin
Text1     
EKPOWEORA
Process Flow Multiple Account AssignmentDistribution
Text80    
EKPOVRTKZ
Partial Invoice
Text80    
EKPOTWRKZ
Terms of Delivery and PaymentIncoterms
Text80    
EKPOINCO1
Incoterms Location 1
Text70    
EKPOINCO2_L
Incoterms Location 2
Text70    
EKPOINCO3_L









Delivery Address (Not Applicable)

KeyLegacy Agreement Numbermandatory for sheetText80    
ADRCLEGACY_NUMBER
Item Number of Agreementmandatory for sheetNumber5     
ADRCITEM_NO
Delivery AddressCity
Text40    
ADRCCITY
City Postal Code
Text10    
ADRCPOSTL_COD1
Street
Text60    
ADRCSTREET
House Number
Text10    
ADRCHOUSE_NO
Country/Region
Text80    
ADRCCOUNTRY
Region
Text80    
ADRCREGION









Account Assignment

KeyLegacy Agreement Numbermandatory for sheetText80    
EKKNLEGACY_NUMBER
Item Number of Agreementmandatory for sheetNumber5     
EKKNITEM_NO
Sequential Number of Account Assignmentmandatory for sheetNumber2     
EKKNSERIAL_NO
Account AssignmentQuantity
Number13    3     EKKNMENGE
Distribution Percentage
Number3     1     EKKNVPROZ
G/L Account Number
Text80    
EKKNGL_ACCOUNT
Cost Center
Text80    
EKKNCOSTCENTER
Profit Center
Text80    
EKKNPROFIT_CTR
Order
Text80    
EKKNORDERID
Sales and Distribution Document Number
Text80    
EKKNSD_DOC
Sales Document Item
Number6     
EKKNITM_NUMBER
Sales Order Delivery Schedule Line Item
Number4     
EKKNETENR
WBS Element
Text80    
EKKNWBS_ELEMENT
Main Asset Number
Text80    
EKKNASSET_NO
Asset Subnumber
Text4     
EKKNSUB_NUMBER









Item Texts (Not Applicable)

KeyLegacy Agreement Numbermandatory for sheetText80    
STXH/STXLLEGACY_NUMBER
Item Number of Agreementmandatory for sheetNumber5     
STXH/STXLEBELP
TextText IDmandatory for sheetText80    
STXH/STXLTDID
Textmandatory for sheetTextunrestricted
STXH/STXL

TEXT


Conditions Data 

Conditions See notes on Condition records below.

KeyCondition Number
Text10

KNUMV


Item Number
Number6

KPOSN


Step Number
Number3

STUNR


Counter
Number2

ZAEHK

ConditionsApplication
Text2

KAPPL


Condition Type
Text4

KSCHL


Condition Pricing Date
Date


KDATU


Condition Base Value
Number152
KAWRT


Calculation Type
Text1

KRECH


Amount
Number112
KBETR


Currency Key
Text5

WAERS


Cond exchange rate
Number95
KKURS


Pricing Unit
Number50
KPEIN


Condition Unit
Text3

KMEIN


Numerator
Number50
KUMZA


Denominator
Number50
KUMNE


Condition Category
Text1

KNTYP

  

NOTES on CONDITION RECORDS ( (Confirmed by Youssef El Mokaddem)

In S/4HANA, purchasing Contracts Conditions data is stored in A016- Contract Item table  When Purchasing Contracts are migrated via the Migration Cockpit, the system automatically generates a new condition document number (KNUMV) during Purchasing Contracts creation.

SAP purchasing contract conditions are stored primarily in A016 (condition record numbers by contract/item) and KONP (condition items/values), with pricing details in PRCD_ELEMENTS (S/4HANA) or KONV (ECC). These tables link contract document data (EKKO/EKPO) to pricing, discounts, and validity periods

For the conditions data make sure during the migration of contracts, the net price field (EKPO-NETPR) is well maintained to reflect the conditions data.  All existing Price conditions (PB00 ; PC & ZI01) from ECC systems (WP2/PF2) will be migrated as part of Purchasing outline agreement creation with the new Price condition PMP0 in S/4.

Key SAP Purchasing Contract Condition Tables:

  • A016: Document Index: Variable Key (Links contract to condition record number).
  • KONP: Condition Item (Contains price, discount, or surcharge amount/percentage).
  • PRCD_ELEMENTS: Pricing Element (S/4HANA - replaces KONV).
  • KONV: Purchasing Condition Records (ECC).
  • EKKO: Purchasing Document Header (Contract number).
  • EKPO: Purchasing Document Item (Contract item). 

Key Fields & Usage:

  • Find Condition Records: Enter contract number (EBELN) and item (EBELP) in table A016 to find the condition record number (KNUMH).
  • Get Condition Values: Pass the KNUMH from A016 to table KONP to get prices or percentages.
  • Validity: Condition records are valid for specific periods stored within KONP. 


There is no need to:

  • Migrate A016 data
  • Migrate KONV/KONP
  • Maintain an XREF for KNUMV
  • Populate EKKO/EKPO-KNUMV manually
  • KNUMV is a technical, system-generated key and will be created automatically when the Purchasing Contracts and its conditions are loaded.

So the correct approach is to leave it blank — S/4 will generate it.

Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System
CR01C-1Purchasing Document Header with no line itemsExtract purchasing Document Header data from EKKO table and Purchasing Document Line Item data from EKPO table then produce the cleaning report to the business for the purchasing document numbers at the header level but there is no line item exists. Complete table extractPF2/WP2
CR02C-1Purchasing Document Header with no Account assignment dataExtract purchasing Document Header data from EKKO table, Purchasing Document Line Item data from EKPO table and Account Assignment data from EKKN table where the Item category is blank then  produce the cleaning report to the business for the purchasing document numbers at the header level but there is no Account Assignment dataComplete table extractPF2/WP2
CR03C-2Purchasing Document Header data is marked for the deletion but line item is activeGet the extract from EKKO where LOEKZ = "X" and generate the report from EKPO table where LOEKZ not equal to XComplete table extractPF2/WP2
CR04C-2Purchasing Document Header data is marked for the deletion but Account Assignment data is activeGet the extract from EKKO where LOEKZ = "X" and generate the report from EKKN table where LOEKZ not equal to XComplete table extractPF2/WP2
CR05C-2Purchasing Document Line Item data is marked for the deletion but Account Assignment data is activeGet the extract from EKPO where LOEKZ = "X" and generate the report from EKKN table where LOEKZ not equal to XComplete table extractPF2/WP2
VR01C-2Purchasing Contracts and Outline agreements with Invalid dateGenerate a validation report from EKKO table where the Validity Period End date (KDATE) is less than or equal to system date PF2/WP2
VR02C-2Purchasing Contracts and Outline agreements - Material is set for the deletion flag or blocked indicatorGenerate a validation report from EKKO table where the Material (MATNR) is marked for the deletion or blocked or both PF2/WP2
VR03C-2Purchasing Contracts and Outline agreements - Material is set for the deletion flag or blocked indicator at the plant levelGenerate a validation report from EKKO table where the Material (MATNR) and Plant (WERKS) combination is marked for the deletion or blocked or both PF2/WP2
VR04C-2Purchasing Contracts and Outline agreements - Vendor is set for the deletion flag or blocked indicator at the purchasing view levelGenerate a validation report from LFM1 table where the Vendor (LIFNR) and Purchasing Organization (EKORG) combination is marked for the deletion or blocked or both PF2/WP2



Conversion Process

The high-level process is represented by the diagram below:

image-2025-6-6_10-55-42-1 (1).png


Data Privacy and Sensitivity


Extraction

Extract data from a source into  Syniti Knowledge Platform's (SKP) staging tables. There are 2 possibilities:

  1. The data exists. Syniti Knowledge Platform's (SKP) connects to the source and loads the data into Syniti Knowledge Platform's (SKP) staging tables.
  2. . There are 3 methods:
    1. Perform full data extraction from relevant tables in the source system(s).
    2. Perform extraction through the application layer.
    3. Only if Syniti Knowledge Platform's (SKP); cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
  3. The data does not exist (or cannot be converted from its current state).  The data is manually collected by the business directly in Syniti Knowledge Platform's (SKP). This is to be conducted using DCT (Data Collection Template) in Syniti.  (TBC)

The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible
1Full extract of Purchase contracts and outline scheduling agreements data from legacy ECC systems, PF2/WP2. Application of filters to lower the volumesSyniti
2Extract of config tables to check if config/reference data is available in the system. These will be used in the Syniti 
jobs for validation purposes
Syniti
3Extraction Scope Definition - Identify the source systems and databases involved.
Define the data objects (tables, fields, records) to be extracted.
Establish business rules for data selection.
Syniti /  Data team
4Extraction Methodology - Specify the extraction approach (full, incremental, or delta extraction).
Determine the tools and technologies used.
Define data filtering criteria to exclude irrelevant records.
Syniti
5Extraction Execution Plan- Establish execution timelines and batch processing schedules.
Assign responsibilities for extraction monitoring.
Document dependencies on other migration tasks.
Syniti
6Data Quality and Validation - Define error handling mechanisms for extraction failures.Syniti


Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
N/A









Data Collection Template (DCT) - TBC

Target Ready Data Collection Template will be created for data with exception of some fields which require transformation as mentioned in the transformation rule.

if business confirms  that contract is needed then ‘DCT’ to be used to collect information for missing contracts (TBC)

DCT Rules

Field NameField DescriptionRule
TBC










Extraction Dependencies

Item #Step DescriptionTeam Responsible

1

Ensure that the necessary cleansing activities in legacy sources (PF2, WP2) are complete

Data/Business

2

Ensure that create, change and deletion of master data is freeze in PF2, WP2 Production system

Syensqo IT

3

Source System Availability

  • Ensure that the source database or application is accessible.
  • Confirm that necessary credentials and permissions are granted

Syensqo IT

4

Data Structure

  • Identify relationships between tables, views, and stored procedures.

Syniti

5

Referential Integrity

  • Ensure dependent records are extracted together.

Syniti

6

Extraction Methodology

  • Define whether extraction is full, incremental, or delta-based.
  • Establish batch processing schedules for large datasets.

Syniti

7

Performance and Scalability Considerations

  • Optimize extraction queries to prevent system overload.
  • Ensure network bandwidth supports data transfer volumes.

Syniti

8

Security and Compliance

  • Adhere to regulatory standards for sensitive information if applicable

Syniti


Transformation

The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow Syniti to make the data Target ready:

  1. Perform value mapping and data transformation rules.
    1. Legacy values are mapped to the to-be values (this could include a default value)
    2. Values are transformed according to the rules defined in Syniti.
  2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

Value Mappings Register Link: MM Config Values.xlsx - Google Sheets


Transformation Run Sheet

Item #Step DescriptionTeam Responsible

1

Run EKKO, EKPO and EKKN Relevancy in Syniti

Syniti

2

Transformation Scope Definition
- Identify the source and target data structures.
- Define business rules for data standardization.
- Establish data cleansing requirements to remove inconsistencies.

Data Team

3

Data Mapping and Standardization
- Align source fields with target fields.
- Ensure unit consistency (e.g., currency, measurement units)

Data Team

4

Business Rule Application
- Implement data enrichment/collection if applicable
- Apply conditional transformations based on predefined logic/business rules

Data Team

5

Transformation Execution Plan
- Define batch processing schedules.
- Assign responsibilities for monitoring execution.
- Establish error-handling mechanisms

Syniti





Transformation Rules

Sheet NameGroup NameField DescriptionImportanceTypeLengthDecimalTarget TableTarget FieldSource TableSource FieldSource Field DescriptionsTransformation Logic
Header Data (mandatory)












KeyLegacy Agreement Numbermandatory for sheetText80    
S_EKKOLEGACY_NUMBEREKKOEBELNPurchasing DocumentSystem Generated Number
Should be Unique
(Applicable for both preload and post load)
General DataCompany Codemandatory for sheetText80    
S_EKKOBUKRSEKKOBUKRSCompany CodeXREF
Derive via legacy to Skyway S4 Company Code mapping
It is validated against relevant Company Code available in S/4 HANA. Customizing. 
Values of the Company Code already included in the "MM configuration values document"- Enterprise Structure tab.







EKKOBSTYPPurch. Doc. CategoryData Migration Cockpit Load template should be run for the below Purchasing Document Categories

K - Contracts
L- Outline Scheduling Agreement
Agreement Typemandatory for sheetText80    
S_EKKOBSARTEKKOBSARTPurchasing Doc. TypeDirect Mapping
MK - Quantity Contract
WK-  Value Contract
Value Mapping
ZWK - CatLog contract
Supplier's Account Numbermandatory for sheetText80    
S_EKKOLIFNREKKOLIFNRVendor NumberXREF
Derive via legacy to Skyway S4 Business Partner mapping
Vendor used for Procurement & will take only those vendors which will be responsible for particular Purch Org and Plant.
(Applicable for both preload and post load)
Purchasing Organizationmandatory for sheetText80    
S_EKKOEKORGEKKOEKORGPurch. OrganizationXREF
Derive via legacy to Skyway S4 Purchasing Organization mapping
It is validated against relevant Purchase Organizations available in S/4 HANA. Customizing. 
Values of the Purchase Organizations already included in the "MM configuration values document"- Enterprise Structure tab.
Rule: Check table LFM1 whether Vendor is extended to Purchasing Organization(EKORG)

(Applicable for preload only as the record which are having vendors not extended to purchasing organization will fail in preload and hence won't pass through to load file and post load)
Purchasing Groupmandatory for sheetText80    
S_EKKOEKGRPEKKOEKGRPPurchasing GroupXREF
Derive via legacy to Skyway S4 Purchasing Group mapping
It is validated against relevant Purchasing Groups available in S/4 HANA.
Currency Key (ISO Format)mandatory for sheetText80    
S_EKKOWAERSEKKOWAERSCurrencyXREF
Derive via legacy to Skyway S4 Purchasing Currency code mapping

Defaulted from Vendor Master: LFM1-WAERS (in General)
Administrative DataAgreement Date
Date

S_EKKOBEDATEKKOBEDATDocument DateDirect Mapping

Date when Contract signed off
Start of Validity Period
Date

S_EKKOKDATBEKKOKDATBValidity Per. StartDirect Mapping

Start date of validity period of Contract.
End of Validity Periodmandatory for sheetDate

S_EKKOKDATEEKKOKDATEValidity Period EndDirect Mapping

End date of validity period of Contract. Only Contracts with End of validity period date in the future should be migrated
Terms of Delivery and PaymentTarget Value
Number15    2     S_EKKOKTWRTEKKOKTWRTTarget Val. (Header)TBC
Target value is Mandatory for Value Contract type - WK. For migration - only open Target value should be migrated
Exchange Rate
Number9     5     S_EKKOWKURSEKKOWKURSExchange RateDirect Mapping
Indicator for Fixed Exchange Rate
Text1     
S_EKKOKUFIXEKKOKUFIXExchange Rate FixedNot used in ECC
Only populated if exchange rate is fixed
X- Yes
Blank - No
Terms of Payment Key
Text80    
S_EKKOZTERMEKKOZTERMTerms of PaymentXREF
Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 
First Payment in Days
Number3     
S_EKKODSCNT1_TOEKKOZBD1TPayment inDirect Mapping
Discount for First Payment in %
Number5     3     S_EKKODSCT_PCT1EKKOZBD1PDisc.percent 1Direct Mapping
Second Payment in Days
Number3     
S_EKKODSCNT2_TOEKKODSCNT2_TOPayment inDirect Mapping
Discount for Second Payment in %
Number5     3     S_EKKODSCT_PCT2EKKODSCT_PCT2Disc.percent 2Direct Mapping
Cash Discount Days
Number3     
S_EKKODSCNT3_TON/AN/AN/AN/A
Incoterms Version
Text80    
S_EKKOINCOVEKKOINCOVNot UsedNot used
Incoterms
Text80    
S_EKKOINCO1EKKOINCO1IncotermsXREF
Derive via legacy to Skyway S4 Incoterms mapping
Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab:
Incoterms Location 1
Text70    
S_EKKOINCO2_LEKKOINCO2_LIncoterms (Part 2)Direct Mapping
Incoterms Location 2
Text70    
S_EKKOINCO3_LN/AN/AN/AN/A
Reference DataYour Reference
Text12    
S_EKKOIHREZEKKOIHREZYour ReferenceDirect Mapping
Our Reference
Text12    
S_EKKOUNSEZEKKOUNSEZOur ReferenceDirect Mapping
Sales Person
Text30    
S_EKKOVERKFEKKOVERKFSalespersonXREF
Telephone
Text16    
S_EKKOTELF1EKKOTELF1TelephoneDirect Mapping
TaxesCountry/Region of Sales Tax ID Number
Text80    
S_EKKOSTCEG_LEKKOSTCEG_LCountry sls.tax no.Direct Mapping
Item Data (mandatory)












KeyLegacy Agreement Numbermandatory for sheetText80    
S_EKPOLEGACY_NUMBER\EKPOEBELNPurchasing DocumentSystem Generated Number
Should be Unique
(Applicable for both preload and post load)
Item Number of Agreementmandatory for sheetNumber5     
S_EKPOEBELP\EKPOEBELPItemSystem Generated Number but make sure to have every line item in the scope for the purchasing Document Number.

Duplicacy need to be removed based on Material and Plant Combination with Agreement no.
General DataHigher-Level Item
Number5     
S_EKPOHL_ITEMN/AN/AN/AN/A
Item Is an Item Set
Text1     
S_EKPOISOUTLINEN/AN/AN/AN/A
Item Category
Text80    
S_EKPOPSTYP\EKPOPSTYPItem categoryXREF
Item category will be used on depending upon procurement. If we want to used o subcontracting, consignment and stock transfer process then we need to use item category K & L
Account Assignment Category
Text80    
S_EKPOKNTTP\EKPOKNTTPAcct Assignment Cat.XREF
It has to be decided based on the legacy data and map to the respective account assignment as per Global Template. Varies according to the purchase order.

If Item Category Blank and Account Assignment Blank, Material number is required
Product
Text80    
S_EKPOMATNR\EKPOMATNRMaterialXREF

Derive via legacy to Skyway S4 Material Master mapping.

Material number is optional. If material requires need to use mapping between legacy and new Material numbers
Short Text
Text40    
S_EKPOTXZ01\EKPOTXZ01Short TextDirect Mapping

When Material number provided material short text would be copied from material Master.
For Contracts without Materials Short text need to be populated manually or copied from Legacy Contract
Plant
Text80    
S_EKPOWERKS\EKPOWERKSPlantXREF

Derive via legacy to Skyway S4 Plant mapping.
Storage Location
Text80    
S_EKPOLGORT\EKPOLGORTStorage LocationXREF

Storage location is optional in the Contract and couldn’t be populated if Plant is blank
Product Group
Text80    
S_EKPOMATKL\EKPOMATKLMaterial GroupXREF

Derive via legacy to Skyway S4 Material Group mapping.

Material group is mandatory and need to be defined manually using mapping with Legacy system when Material master is not populated. Otherwise it would be copied from Material Master

Product Type Group
Text80    
S_EKPOPRODUCTTYPEN/AN/AN/AN/A
Confirmation Control Key
Text80    
S_EKPOBSTAE\EKPOBSTAEConfirmation ControlXREF
Quantity and PriceTarget Quantity
Number13    3     S_EKPOKTMNG\EKPOKTMNGTarget QuantityDirect Mapping

For Quantity Contract type MK Target quantity should be defined. For Value Contract type WK Target quantity could be defined as 1.

For migrated Contracts only open Target quantity should be populated
(Applicable for both preload and post load)
Release Order Quantity
Number13    3     S_EKPOABMNG\EKPOABMNGStand.rel.order.qty.Direct Mapping
Order Unit of Measure (ISO Format)
Text80    
S_EKPOPO_UNIT_ISON/AN/AN/AN/A
Net Price
Number28    2     S_EKPONETPR\EKPONETPRNet Order PriceDirect Mapping

If an info record already exists for this position, the price will be taken over from this info record.
Price Unit
Number5     
S_EKPOPEINH\EKPOPEINHPrice unitDirect Mapping

If an info record already exists for this position, the price unit will be taken over from this info record.
Price Unit of Measure (ISO Format)
Text80    
S_EKPOBPRME\EKPOBPRMEOrder Price UnitXREF

Value mapping template should be defined between legacy and s/4 for the Order Price Unit
Numerator Conv. Price Unit -> Order Unit
Number5     
S_EKPOBPUMZ\EKPOBPUMZQuantity ConversionDirect Mapping
Denominator Conv. Price Unit->Order Unit
Number5     
S_EKPOBPUMN\EKPOBPUMNQuantity ConversionDirect Mapping
Update Info Record
Text80    
S_EKPOSPINF\EKPOSPINFInfo Record UpdateDirect Mapping
HandlingFirst Reminder/Expediter
Number3     
S_EKPOMAHN1\EKPOMAHN11st Reminder/Exped.Direct Mapping
Second Reminder/Expediter
Number3     
S_EKPOMAHN2\EKPOMAHN22nd Reminder/Exped.Direct Mapping
Third Reminder/Expediter
Number3     
S_EKPOMAHN3\EKPOMAHN33rd Reminder/Exped.Direct Mapping
Planned Delivery Duration in Days
Number3     
S_EKPOPLIFZ\EKPOPLIFZPlanned Deliv. TimeDirect Mapping
Product Number Used by Supplier
Text35    
S_EKPOVEND_MAT\EKPOIDNLFVendor Material NumberDirect Mapping
GR/IR ControlUnderdelivery Tolerance Limit
Number3     1     S_EKPOUNTTO\EKPOUNTTOUnderdel. ToleranceDirect Mapping
Overdelivery Tolerance Limit
Number3     1     S_EKPOUEBTO\EKPOUEBTOOverdeliv. ToleranceDirect Mapping
Indicator:Unlimited Overdelivery Allowed
Text1     
S_EKPOUEBTK\EKPOUEBTKUnltd OverdeliveryDirect Mapping
Tax Code
Text80    
S_EKPOMWSKZ\EKPOMWSKZTax CodeXREF

Value mapping template should be defined between legacy and s/4 for the Tax Code
Shipping Instruction
Text80    
S_EKPOEVERS\EKPOEVERSShipping Instr.XREF

Value mapping template should be defined between legacy and s/4 for the shipping instructions
Kanban Indicator
Text80    
S_EKPOKANBA\EKPOKANBAKanban IndicatorNot used
Indicator: Invoice Receipt
Text1     
S_EKPOREPOS\EKPOREPOSInvoice receiptDirect Mapping
Indicator: GR-Based Invoice Verification
Text1     
S_EKPOWEBRE\EKPOWEBREGR-Based Inv. Verif.Direct Mapping
Indicator: Acceptance At Origin
Text1     
S_EKPOWEORA\EKPOWEORAOrigin AcceptanceNot used
Process Flow Multiple Account AssignmentDistribution
Text80    
S_EKPOVRTKZ\EKPOVRTKZDistribut. IndicatorDirect Mapping
Partial Invoice
Text80    
S_EKPOTWRKZ\EKPOTWRKZPartial invoiceDirect Mapping
Terms of Delivery and PaymentIncoterms
Text80    
S_EKPOINCO1\EKPOINCO1IncotermsXREF
Derive via legacy to Skyway S4 Incoterms mapping
Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab:
Incoterms Location 1
Text70    
S_EKPOINCO2_L\EKPOINCO2_LIncoterms (Part 2)Direct Mapping
Incoterms Location 2
Text70    
S_EKPOINCO3_L\EKPOINCO3_LIncoterms Location 2Not used
Account Assignment




KeyLegacy Agreement Numbermandatory for sheetText80    
S_EKKNLEGACY_NUMBEREKKNLEGACY_NUMBERPurchasing DocumentSystem Generated Number
Should be Unique
(Applicable for both preload and post load)

Applicable if Account Assignment Category is NOT BLANK
Item Number of Agreementmandatory for sheetNumber5     
S_EKKNITEM_NOEKKNEBELPItemSystem Generated Number but make sure to have every line item in the scope for the purchasing Document Number.

Duplicacy need to be removed based on Material and Plant Combination with Agreement no.

Applicable if Acc Assignment Category is NOT BLANK
Sequential Number of Account Assignmentmandatory for sheetNumber2     
S_EKKNSERIAL_NOEKKNZEKKNSeq,No,Acct,Ass.Mandatory

Will default it to 1. As multiple account assignment is not in scenario

Applicable if Acc Assignment Category is NOT BLANK
Account AssignmentQuantity
Number13    3     S_EKKNMENGEEKKNMENGEQuantityDirect Mapping
Distribution Percentage
Number3     1     S_EKKNVPROZEKKNVPROZDistributionDirect Mapping
G/L Account Number
Text80    
S_EKKNGL_ACCOUNTEKKNSAKTOG/L AccountXREF

Derive via legacy to Skyway S4 G/L Accounts Mapping (Business input and validation also required)

Applicable if Acc Assignment Category is NOT BLANK
Cost Center
Text80    
S_EKKNCOSTCENTEREKKNKOSTLCost CenterXREF

Derive via legacy to Skyway S4 Cost Centres Mapping (Business input and validation also required)

Applicable if Acc Assignment Category is NOT BLANK
Profit Center
Text80    
S_EKKNPROFIT_CTREKKNPRCTRProfit CenterXREF

Derive via legacy to Skyway S4 Cost Centres Mapping (Business input and validation also required)

Applicable if Acc Assignment Category is NOT BLANK
Order
Text80    
S_EKKNORDERIDEKKNAUFNROrder NumberDirect Mapping
Sales and Distribution Document Number
Text80    
S_EKKNSD_DOCEKKNVBELNSD DocumentXREF
Sales Document Item
Number6     
S_EKKNITM_NUMBEREKKNVBELPItemDirect Mapping
Sales Order Delivery Schedule Line Item
Number4     
S_EKKNETENREKKNVETENSchedule LineDirect Mapping
WBS Element
Text80    
S_EKKNWBS_ELEMENTEKKNWBS_ELEMENTWBS ElementXREF

Derive via legacy to Skyway S4 WBS Elements Mapping (Business input and validation also required)

WBS populated if Account Assignment Category  is P
Main Asset Number
Text80    
S_EKKNASSET_NOEKKNANLN1AssetDirect Mapping

Asset Number populated if Account Assignment Category is A
Asset Subnumber
Text4     
S_EKKNSUB_NUMBEREKKNANLN2Sub-numberDirect Mapping

Asset Number populated if Account Assignment Category is A


Transformation Mapping

Value mapping tables google drive path - MM Config Values.xlsx - Google Sheets

Transformation mapping sheet google drive path - Conversion Specification - Mappings - Google Sheets


Mapping Table NameMapping Table Description
MaterialXREF - Legacy to SyWay S4
PlantXREF - Legacy to SyWay S4
Vendor NumberXREF - Legacy to SyWay S4
Company CodeXREF - Legacy to SyWay S4
Purchasing OrganizationXREF - Legacy to SyWay S4
Purchasing GroupXREF - Legacy to SyWay S4
IncotermsXREF - Legacy to SyWay S4
Shipping InstructionsXREF - Legacy to SyWay S4
Storage LocationXREF - Legacy to SyWay S4
Tax codeXREF - Legacy to SyWay S4
CurrencyXREF - Legacy to SyWay S4
Terms of PaymentXREF - Legacy to SyWay S4
Item CategoryXREF - Legacy to SyWay S4
Acct Assignment Cat.XREF - Legacy to SyWay S4
Material GroupXREF - Legacy to SyWay S4
Confirmation ControlXREF - Legacy to SyWay S4
Order Price UnitXREF - Legacy to SyWay S4
G/L AccountXREF - Legacy to SyWay S4
Cost CenterXREF - Legacy to SyWay S4
Profit CenterXREF - Legacy to SyWay S4
WBS ElementXREF - Legacy to SyWay S4
Sales Document NumberXREF - Legacy to SyWay S4
Sales document item numberXREF - Legacy to SyWay S4
Sales personXREF - Legacy to SyWay S4

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Data has been extracted from sources systems from the relevant tablesSyniti
2Data mergedSyniti
3Ensure that all required Configurations are in S/4 HANA - (Config documents should be complete)Data Team/Syniti
4XREF tables are ready Data Team/Syniti

5

Source Data Integrity
- Ensure extracted data is complete, accurate, and consistent.
- Validate that data types and formats align with transformation requirements.5

Syniti

6

Referential Integrity
- Ensure dependent records are transformed together or in advance, 

Syniti

7

Transformation Logic and Mapping
- Define data mapping rules between source and target schemas.

Value Mappings Google Drive path - TBC

Data Team

8

Performance and Scalability Considerations
- Optimize transformation processes for large datasets.
- Ensure system resources can handle transformation workloads

Syniti

9

Logging and Error Handling
- Maintain detailed logs of transformation activities.
- Define error-handling procedures for failed transformations

Syniti


Pre-Load Validation

Project Team

Completeness

TaskAction

Verify Count

Verify that the record count in the pre-load file is the same as the record count based on the relevancy (including deduplication) results

Verify Count (Others)

Pre-Load validations record counts will be done to verify completeness and accuracy of the transformed data against DCT approved. - TBC

Validate the mandatory fields

Validate there is value for all the mandatory fields

Validate Primary Keys and Unique Constraints

Check for duplicate or missing primary key values, 
Ensure unique constraints are maintained

Test Referential Integrity

Confirm dependent records exist in related tables


Accuracy

TaskAction
Conversion accuracyData team to verify that the data staged in the preload tables are correct in terms of the mapping rules.
Valid to datesCheck valid to dates are migrated correctly
Valid from datesCheck valid from dates are migrated correctly
Valid to and from 
date
Verify date formats YYYYMMDD

Error Reports

Verify that all necessary error reports have been validated and that errors have been addressed.

Check Data Consistency

Compare field values across systems Validate data formats and structures


Business

Completeness

TaskAction
Count and Completeness 
check
All fields required as per mapping template rules must be completed. Validity reports checking each field in Syniti must 
be built to help check.
Valid to datesCheck valid to dates are migrated correctly
Valid from datesCheck valid from dates are migrated correctly
Valid to and from datesVerify date formats YYYYMMDD

Verify Count (Others)

Pre-Load validations record counts will be done to verify completeness and accuracy of the transformed data against DCT approved. (TBC)

Verify Relevancy Rules

Verify that the relevancy rules were correctly applied


Accuracy

TaskAction
Conversion 
accuracy
Business team to verify that the data staged in the preload tables are correct in terms of the mapping rules. This will be done via Syniti reports/SAP reports

Review Error Reports

Verify that all necessary error reports have been validated, and that errors have been addressed.

Verify Transformation Rules

Verify that the transformation rules are correct and have been carried out correctly


Load

The load process includes:

  1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
  2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation

Load Run Sheet

Item #Step DescriptionTeam Responsible

1

Verify data extracted

Data Team/Functional - S2P

2

Verify data merged

Data Team/Functional - S2P

3

Verify XREF's are ready

Data Team/Functional - S2P

4

Verify reference data is in the system

Data Team/Functional - S2P

5

Verify Config is in the system

Data Team/Functional - S2P

6

Verify other necessary data has been loaded int he system (Plant, Material, Vendor, Company Code...)

Data Team/Functional - S2P

7

Release - Load signoff and go-ahead by Functional/Data Owner

Functional/Data Owner - S2P

8

Approval to stage/Pre-stage steps

Functional/Data Owner - S2P

9

Cross references/Value mappings imported into environment

Syniti

10

Extraction from source

Syniti

11

Extraction from S4 where needed

Syniti

12

Stage data for transformations

Syniti

13

Run transforms

Syniti

15

Provide access to Business to view the data in SKP 

Syniti

16

Execute pre-load report

Syniti

17

Validate preload report - release

Syniti

18

Prepare and simulate

Syniti

19

Pre-load verification and approval to load

Functional/Data Owner - S2P

20

Load to S4

Syniti

21

Complete Jira steps, Volumes and Timings

All - where applicable

22

Execute post-load report

Syniti

23

Post-load report verification/validation

Data Team/Functional/Data Owner - S2P

24

Object load completion approval

Data Owner - S2P

25

Load Scope Definition
- Identify the target system and database structure.
- Define data objects (tables, fields, records) to be loaded.
- Establish business rules for data validation.

Data team

26

Load Methodology
- Specify the loading tools and technologies (Migration Cockpit, LSMW, custom loading program).

Syniti

27

Data Quality and Validation
- Ensure data integrity checks (null values, duplicates, format validation).
- Perform pre-load validations to verify completeness.
- Define error handling mechanisms for load failures

Syniti

28

Load Execution Plan
- Establish execution timelines and batch processing schedules.
- Assign responsibilities for monitoring execution.
- Document dependencies on other migration tasks

Syniti

29

Logging and Reporting
- Maintain detailed logs of loading activities.
- Generate summary reports on loaded data volume and quality.
- Define escalation procedures for errors

Syniti


Load Phase and Dependencies

Pre-requisites:

1) Vendor Master Data

2) Material Master data

3) Material Groups

4) Purchasing Info Records

5) G/L Accounts

6) Cost Centers

7) Profit Centers

8) WBS Elements

9) Asset Master Data

10) Sales Order data

S/4 HANA Data Migration Cockpit Template (for the reference to Syniti team to help the technical build for the conversion program:

Field List for Migration Object: MM - Purchase contract

Sheet Name

Group Name

Field Description

Importance

Type

Length

Decimal

SAP Structure

SAP Field

Header Data (mandatory)


Key

Legacy Agreement Number

mandatory for sheet

Text

80    


S_EKKO

LEGACY_NUMBER

General Data

Company Code

mandatory for sheet

Text

80    


S_EKKO

BUKRS

Agreement Type

mandatory for sheet

Text

80    


S_EKKO

BSART

Supplier's Account Number

mandatory for sheet

Text

80    


S_EKKO

LIFNR

Purchasing Organization

mandatory for sheet

Text

80    


S_EKKO

EKORG

Purchasing Group

mandatory for sheet

Text

80    


S_EKKO

EKGRP

Currency Key (ISO Format)

mandatory for sheet

Text

80    


S_EKKO

WAERS

Administrative Data

Agreement Date


Date



S_EKKO

BEDAT

Start of Validity Period


Date



S_EKKO

KDATB

End of Validity Period

mandatory for sheet

Date



S_EKKO

KDATE

Terms of Delivery and Payment

Target Value


Number

15    

2     

S_EKKO

KTWRT

Exchange Rate


Number

9     

5     

S_EKKO

WKURS

Indicator for Fixed Exchange Rate


Text

1     


S_EKKO

KUFIX

Terms of Payment Key


Text

80    


S_EKKO

ZTERM

First Payment in Days


Number

3     


S_EKKO

DSCNT1_TO

Discount for First Payment in %


Number

5     

3     

S_EKKO

DSCT_PCT1

Second Payment in Days


Number

3     


S_EKKO

DSCNT2_TO

Discount for Second Payment in %


Number

5     

3     

S_EKKO

DSCT_PCT2

Cash Discount Days


Number

3     


S_EKKO

DSCNT3_TO

Incoterms Version


Text

80    


S_EKKO

INCOV

Incoterms


Text

80    


S_EKKO

INCO1

Incoterms Location 1


Text

70    


S_EKKO

INCO2_L

Incoterms Location 2


Text

70    


S_EKKO

INCO3_L

Reference Data

Your Reference


Text

12    


S_EKKO

IHREZ

Our Reference


Text

12    


S_EKKO

UNSEZ

Sales Person


Text

30    


S_EKKO

VERKF

Telephone


Text

16    


S_EKKO

TELF1

Taxes

Country/Region of Sales Tax ID Number


Text

80    


S_EKKO

STCEG_L










Supplier Address (Not Applicable)


Key

Legacy Agreement Number

mandatory for sheet

Text

80    


S_ADRC

LEGACY_NUMBER

Supplier Address

City


Text

40    


S_ADRC

CITY

City Postal Code


Text

10    


S_ADRC

POSTL_COD1

Street


Text

40    


S_ADRC

STREET

House Number


Text

10    


S_ADRC

HOUSE_NO

Country/Region


Text

80    


S_ADRC

COUNTRY

Region


Text

80    


S_ADRC

REGION










Header Texts( Not Applicable)


Key

Legacy Purchasing Document Number

mandatory for sheet

Text

80    


S_EKKO_TEXT

LEGACY_NUMBER

Text

Text ID

mandatory for sheet

Text

80    


S_EKKO_TEXT

TDID

Text

mandatory for sheet

Text

unrestricted


S_EKKO_TEXT

TEXT










Item Data (mandatory)


Key

Legacy Agreement Number

mandatory for sheet

Text

80    


S_EKPO

LEGACY_NUMBER

Item Number of Agreement

mandatory for sheet

Number

5     


S_EKPO

EBELP

General Data

Higher-Level Item


Number

5     


S_EKPO

HL_ITEM

Item Is an Item Set


Text

1     


S_EKPO

ISOUTLINE

Item Category


Text

80    


S_EKPO

PSTYP

Account Assignment Category


Text

80    


S_EKPO

KNTTP

Product


Text

80    


S_EKPO

MATNR

Short Text


Text

40    


S_EKPO

TXZ01

Plant


Text

80    


S_EKPO

WERKS

Storage Location


Text

80    


S_EKPO

LGORT

Product Group


Text

80    


S_EKPO

MATKL

Product Type Group


Text

80    


S_EKPO

PRODUCTTYPE

Confirmation Control Key


Text

80    


S_EKPO

BSTAE

Quantity and Price

Target Quantity


Number

13    

3     

S_EKPO

KTMNG

Release Order Quantity


Number

13    

3     

S_EKPO

ABMNG

Order Unit of Measure (ISO Format)


Text

80    


S_EKPO

PO_UNIT_ISO

Net Price


Number

28    

2     

S_EKPO

NETPR

Price Unit


Number

5     


S_EKPO

PEINH

Price Unit of Measure (ISO Format)


Text

80    


S_EKPO

BPRME

Numerator Conv. Price Unit -> Order Unit


Number

5     


S_EKPO

BPUMZ

Denominator Conv. Price Unit->Order Unit


Number

5     


S_EKPO

BPUMN

Update Info Record


Text

80    


S_EKPO

SPINF

Handling

First Reminder/Expediter


Number

3     


S_EKPO

MAHN1

Second Reminder/Expediter


Number

3     


S_EKPO

MAHN2

Third Reminder/Expediter


Number

3     


S_EKPO

MAHN3

Planned Delivery Duration in Days


Number

3     


S_EKPO

PLIFZ

Product Number Used by Supplier


Text

35    


S_EKPO

VEND_MAT

GR/IR Control

Underdelivery Tolerance Limit


Number

3     

1     

S_EKPO

UNTTO

Overdelivery Tolerance Limit


Number

3     

1     

S_EKPO

UEBTO

Indicator:Unlimited Overdelivery Allowed


Text

1     


S_EKPO

UEBTK

Tax Code


Text

80    


S_EKPO

MWSKZ

Shipping Instruction


Text

80    


S_EKPO

EVERS

Kanban Indicator


Text

80    


S_EKPO

KANBA

Indicator: Invoice Receipt


Text

1     


S_EKPO

REPOS

Indicator: GR-Based Invoice Verification


Text

1     


S_EKPO

WEBRE

Indicator: Acceptance At Origin


Text

1     


S_EKPO

WEORA

Process Flow Multiple Account Assignment

Distribution


Text

80    


S_EKPO

VRTKZ

Partial Invoice


Text

80    


S_EKPO

TWRKZ

Terms of Delivery and Payment

Incoterms


Text

80    


S_EKPO

INCO1

Incoterms Location 1


Text

70    


S_EKPO

INCO2_L

Incoterms Location 2


Text

70    


S_EKPO

INCO3_L










Delivery Address (Not Applicable)


Key

Legacy Agreement Number

mandatory for sheet

Text

80    


S_ADRC_2

LEGACY_NUMBER

Item Number of Agreement

mandatory for sheet

Number

5     


S_ADRC_2

ITEM_NO

Delivery Address

City


Text

40    


S_ADRC_2

CITY

City Postal Code


Text

10    


S_ADRC_2

POSTL_COD1

Street


Text

60    


S_ADRC_2

STREET

House Number


Text

10    


S_ADRC_2

HOUSE_NO

Country/Region


Text

80    


S_ADRC_2

COUNTRY

Region


Text

80    


S_ADRC_2

REGION










Account Assignment


Key

Legacy Agreement Number

mandatory for sheet

Text

80    


S_EKKN

LEGACY_NUMBER

Item Number of Agreement

mandatory for sheet

Number

5     


S_EKKN

ITEM_NO

Sequential Number of Account Assignment

mandatory for sheet

Number

2     


S_EKKN

SERIAL_NO

Account Assignment

Quantity


Number

13    

3     

S_EKKN

MENGE

Distribution Percentage


Number

3     

1     

S_EKKN

VPROZ

G/L Account Number


Text

80    


S_EKKN

GL_ACCOUNT

Cost Center


Text

80    


S_EKKN

COSTCENTER

Profit Center


Text

80    


S_EKKN

PROFIT_CTR

Order


Text

80    


S_EKKN

ORDERID

Sales and Distribution Document Number


Text

80    


S_EKKN

SD_DOC

Sales Document Item


Number

6     


S_EKKN

ITM_NUMBER

Sales Order Delivery Schedule Line Item


Number

4     


S_EKKN

ETENR

WBS Element


Text

80    


S_EKKN

WBS_ELEMENT

Main Asset Number


Text

80    


S_EKKN

ASSET_NO

Asset Subnumber


Text

4     


S_EKKN

SUB_NUMBER










Item Texts (Not Applicable)


Key

Legacy Agreement Number

mandatory for sheet

Text

80    


S_EKPO_TEXT

LEGACY_NUMBER

Item Number of Agreement

mandatory for sheet

Number

5     


S_EKPO_TEXT

EBELP

Text

Text ID

mandatory for sheet

Text

80    


S_EKPO_TEXT

TDID

Text

mandatory for sheet

Text

unrestricted


S_EKPO_TEXT

TEXT

Configuration

Item #Configuration Item
N/A




Conversion Objects

Object #Preceding Object Conversion Approach

1

Purchase Info Record/Pricing Conditions (1094)

2

Material Master - Basic View (2019)

3

Materials - Additional data (2021)

4

Materials Purchasing View (2020)

5

Business Partners - General (3007)

6

Business Partners (Vendor)- (3027)

7

Vendor Subrange (TBC)

10

WBS Elements

11

Company Codes

12

Cost center

13

G/L Account

14

Profit center

15

Fixed Asset

16

Storage Locations

17

Sales Orders (Third party)

Error Handling

Error TypeError DescriptionAction Taken

Data

Vendor missing or blocked

Either exclude the record, or unblock/load the Vendor

Config

Necessary number ranges not correct

Internal numbering must be set.

Data

Incorrect document types

Fix incorrect data or missing entries

Data

Material missing or blocked.

Either exclude the record, or unblock/load the Vendor

Data

Invalid dates

Fix incorrect data or missing entries

Data

Invalid data formats

Fix incorrect data or missing entries

Pre-req

Missing Value mappings

Add missing value mappings and retry

Data

Duplicates

Fix incorrect data or missing entries

Data

Transformation misses

Build transformation and retry.

Load

Authorization errors

Apply for the applicable authorization permission and retry

Load

Technical load failures - If using Migration Cockpit- Simulation errors, etc

Investigate error and rectify. Retry simulation and/or load

Data

Condition records contained in PO is not available in the target system.

Investigate, load condition record, or exclude the PO/Line

Configuration

Configuration value for the field is not valid/missing

If it is a missing configuration item then engage Functional team to expedite and fix the error in the system.

Invalid Data

Configuration value for the field is not valid.

The parameter entry needs to be reviewed (ex. invalid payment terms).

If it is an invalid data, business needs to review and correct the source of the data either in PF2/WP2 or if it’s mapped in DCT. (TBC)

Value Mappings (Transformation Mappings)

Missing or Invalid value mapping for the fields 

If it is a missing or invalid value mapping fields then engage Functional team to expedite and fix the error in the system.

Technical Setup

Interface / Connection issue within target system’s landscape

N/A – the data will be loaded directly to S/4HANA environment

Authorization Error

<USER ID> is not authorized to access Business Partner create

Contact Basis to obtain Fire Fighter ID (or SyWay S4 approved data loading ID) or fix the authorization setup


Post-Load Validation

Project Team

Completeness

TaskAction

Task

Action

Verify count

The number of records presented in the preload needs to be compared to the post load. – Syniti report

Field by field check

Compare source data to target data.

Valid to dates

Check valid to dates are migrated correctly

Valid from dates

Check valid from dates are migrated correctly

Valid to and from dates

Verify date formats YYYYMMDD

Verify Count (Others)

Post-Load validations record counts will be done to verify completeness and accuracy of the transformed data against DCT approved. (TBC)


Accuracy

TaskAction

Conversion accuracy

Data team to verify that the data staged in the preload tables are correct in terms of the mapping rules. This will be done via Syniti DSP reports/SAP reports

Valid to dates

Check valid to dates are migrated correctly

Valid from dates

Check valid from dates are migrated correctly

Valid to and from dates

Verify date formats YYYYMMDD

Post Load Error Reports

Verify that all necessary post-load error reports have been validated, and that errors have been addressed.


Business

Completeness

TaskAction

Verify count

The number of records presented in the preload needs to be compared to the post-load. – Syniti report

Missing data

Check missing data which was supposed to be loaded

Reconciliation

Participate in Post-load walkthroughs

Verify Count (Others)

Post-Load validations record counts will be done to verify completeness and accuracy of the transformed data against DCT approved. (TBC)

Validate Loaded Data

Validate, as per the loads files signed-off, that all records are in the target system


Accuracy

TaskAction

Conversion accuracy

Business team to verify that the data staged in the preload tables are correct in terms of the mapping rules. This will be done via Syniti DSP reports/SAP reports

Load failures

Value presented for load must be in the system

Valid to dates

Check valid to dates are migrated correctly

Valid from dates

Check valid from dates are migrated correctly

Valid to and from dates

Verify date formats YYYYMMDD

Review Post Load Error Reports

Verify that all necessary post load error reports have been validated, and that errors have been addressed.

Validate Loaded Data

Validate, as per the loads files signed-off, that all records are in the target system


Key Assumptions

  • Purchasing Contracts are in scope based on data design and any exception requested by business.
  • Migrate released and approved contracts only. Note that the supplier is not informed again after migration of a purchasing contract because only released purchasing contracts are migrated to the SAP solution.
  •  If a contract has not been released or approved in the legacy system, create a new purchasing contract with a new contract ID in the SAP solution and copy the data from the legacy system into the new purchasing contract in your SAP solution manually.
  • The contract ID in your SAP solution must be the same as in the legacy system. Change the contract ID for technical reasons only (for . if the number range of the migrated contracts would exceed the number range in the SAP solution).

  • If the purchasing contract is related to materials or services, the purchasing status must be set to active in the corresponding materials or services.

  • Migration of change history, document flow history and approval history is not supported.

  • Migration of administrative data is not supported, for example, creation date and time, creation user, last changed date and time.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 28) Apr 16, 2026 13:21 MADHOK-ext, Jasleen
v. 35 Apr 15, 2026 15:16 BATTINI-ext, Srinivasarao
v. 34 Apr 15, 2026 12:56 BATTINI-ext, Srinivasarao
v. 33 Apr 02, 2026 08:33 BATTINI-ext, Srinivasarao
v. 32 Mar 24, 2026 13:14 BATTINI-ext, Srinivasarao
v. 31 Mar 24, 2026 12:03 BATTINI-ext, Srinivasarao
v. 30 Mar 24, 2026 11:38 BATTINI-ext, Srinivasarao
v. 29 Mar 24, 2026 07:00 BATTINI-ext, Srinivasarao
v. 28 Mar 24, 2026 06:46 BATTINI-ext, Srinivasarao
v. 27 Mar 24, 2026 06:33 BATTINI-ext, Srinivasarao

Go to Page History

  • No labels