Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Status

Page Status

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach for migrating Purchasing Info Records into S/4HANA from multiple SAP ECC source systems. The migration of Purchasing Requisitions (PRs) aims to ensure business continuity by transferring relevant and open requisition data from one or more legacy systems into the SAP S/4HANA environment. This process is essential for preserving in-flight procurement processes, avoiding disruption in material and service availability, and maintaining traceability of internal purchasing demands.


---CHECKLIST---

  •  Logical Source and Target Systems are identified. 
  •  Processing Type is specified (i.e. Direct Input, BAPI, IDoc, Web Service, OData API, etc.)
  •  Standard or custom load program name/BAPI/IDoc is specified to support this functionality.
  •  Data Mapping is provided for mappings which are not obvious to a suitably-skilled and experienced developer
  •  All translation requirements are clearly defined (including data validation rules, data derivation/calculation and default values, if applicable)Input and/or Output file layouts are provided for all record types possible
  •  Transaction volume is specifiedExecution specified Execution frequency is specifiedRestart/Recovery requirements have been defined
  •  Error handling requirements are specified, including alerting requirement and expected action on failure. 
  •  Application log requirement if applicable to be specified.
  •  
---
  • Additional topics to check
---
  •  Update the Data Volume with a actual figures
  •  (ABUOS)
    •  Rules for Data Merging (all systems)
    •  
    Mapping Rules & Conversion Rules
    • Conversion Scope
    •  Data Loading Details


Conversion Scope

The scope of this document covers This document outlines the approach for converting migrating active and relevant Purchase Requisitions (PR) from Purchasing Requisitions from Syensqo's legacy SAP ECC systems (PF2 and WP2) into SAP S/4HANA following , in alignment with the Procurement Master Data Design Standard.

Purchasing Requisitions will be migrated to support operational procurement, sourcing strategies, and Ariba integration. All requisitions will be validated, cleansed, and centrally loaded using standardized templates and mapped fields, ensuring consistency with the target S/4HANA data model.

Due to the decentralized nature of the current system landscape—where requisition data is stored across PF2 and WP2—discrepancies in materials, vendors, and organizational data may exist. As a result, data harmonization, cleansing, and mapping are critical to ensure accurate and reliable information in the target system. These efforts will also ensure that load templates are properly formatted and aligned with the S/4HANA requirements.


The data from legacy system includes:

  • Standard, Subcontracting, and Consignment Info Records

    1. Requisitions from multiple source systems referring to the same Vendor and Material
    2. Valid combinations of Material (MATNR), Plant, and Purchasing Group
    3. Requisitions with active Purchasing Organization and account assignment details
    4. Open requisitions or those converted into Purchase Orders in the last 2 years
    5. Requisitions with key control data
    Purchasing Conditions
    1. (e.g.,
    PB00
    1. Delivery Date,
    FRA1
    1. Quantity,
    Z*
    1. Account Assignment)
    Valid texts and long texts for PR
    1. Requisitions relevant for open sourcing processes or planned purchases


    The data from legacy system excludes:

    1. Requisitions flagged for deletion or already fully processed (PO/Item received or deleted)
    2. Requisitions with blocked or deleted materials or vendors
    3. Requisitions referencing Plants, Vendors, or Materials that are Out of Scope (OOS)
    4. Draft or incomplete requisitions missing essential data (e.g., Material, Quantity)
    5. Requisitions created solely for test or training purposes
    6.  Obsolete PRs marked for deletion

    7. PRs not used within last 3 years (unless flagged for business exception)

    8. PRs with incomplete vendor or material references


    List of source systems and approximate number of records
    SourceScope

    Source Approx No. of Records

    Target SystemTarget Approx

    No. of Records

    WP2

    The Purchasing Requisitions will be extracted/collected via DCT. An initial extract of the relevant data will be provided in Google Sheet format to support business decisions regarding the inclusion of any relevant requisitions from Source Systems.

    Any additional requisition data required to support the new design may be added directly into the DCT.

    A data review and standardization process will be performed across all Purchasing Requisitions in the DCT. 

    3.885S4/Hana2.100
    PF22.245S4/Hana1.200

    *The figures described above, are restricted to one 1W Period.
    **The objective is to reduce the data volume to be migrated by 80%, retaining only manually created Purchase Requisitions.


    Additional Information

    Multi-language Requirement

    Long Texts must be migrated in all languages relevant to global purchasing defined in the Source System (when availableon source system/PurchReq)

    Data Deduplication

    For this data object, deduplication rules are not applicable. This is due to the fact that the object represents a transactional entity exclusively created and maintained within the target system. As such, there is no risk of duplicate records originating from external sources or legacy systems. The object’s lifecycle is fully controlled within the system, ensuring uniqueness by design.

    Therefore, no deduplication logic or validation needs to be implemented for this object in the data migration or integration processes.

    Document Management

    N/A

    Legal Requirement

    Legal Requirement: Retention of pricing data history should comply with local audit regulations.N/A

    Special Requirements

    N/A





    Target Design

    The technical design of the target for this conversion approach.

    TableFieldData ElementField DescriptionData TypeLengthRequirement
    EBANBANFNBANFNPurchase Requisition NumberCHAR10Required
    EBANBNFPOBNFPOItem Number of Purchase RequisitionNUMC5Required
    EBANBSARTBSARTDocument TypeCHAR4Required
    EBANMATNRMATNRMaterial NumberCHAR18Optional
    EBANWERKSWERKS_DPlantCHAR4Required
    EBANMENGEMENGEQuantityQUAN13Required
    EBANMEINSMEINSBase Unit of MeasureUNIT3Required
    EBANLFDATLFDATDelivery DateDATS8Optional
    EBANLIFNRLIFNRVendorCHAR10Optional

    EBNABANFNBANFNPurchase Requisition NumberCHAR10Required
    EBNABNFPOBNFPOItem Number of Purchase RequisitionNUMC5Required
    EBNAKNTTPKNTTPAccount Assignment CategoryCHAR1Required
    EBNAKOSTLKOSTLCost CenterCHAR10Optional

    EBKNBANFNBANFNPurchase Requisition NumberCHAR10Required
    EBKNBNFPOBNFPOItem Number of Purchase RequisitionNUMC5Required
    EBKNKNTTPKNTTPAccount Assignment CategoryCHAR1Required
    EBKNKOSTLKOSTLCost CenterCHAR10Optional
    EBKNAUFNRAUFNROrder NumberCHAR12Optional

    EBUBBANFNBANFNPurchase Requisition NumberCHAR10Required
    EBUBBNFPOBNFPOItem Number of Purchase RequisitionNUMC5Required
    EBUBFRGGRFRGGRRelease GroupCHAR2Required
    EBUBFRGSXFRGSXRelease StrategyCHAR2Required
    EBUBFRGZUFRGZURelease IndicatorCHAR1Required


    Data Merging Strategy

    Purchasing Requisitions (PRs) typically do not require data merging like master data does for the reason they are related to transactional and historical records. However this topic can be considered as Not Applicable (N/A).

    ID

    Scenario

    Action












    Data Cleansing

    IDCriticalityError Message/Report DescriptionRuleOutputSource System


























    Conversion Process

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

    image-2025-6-20_9-51-38.pngImage Added


    Image Added


    Data Privacy and Sensitivity


    Extraction

    Extract data from a source into . There are 2 possibilities:

    1. The data exists. connects to the source and loads the data into . 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 ; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
    2. The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in . This is to be conducted using DCT (Data Collection Template) in

    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
    001

    Only select records with the following criteria

    EBAN-BSTYP = 'B' (Document cat.)

    EBAN-LOEKZ = '' (Deletion ind.)

    EBAN-ESTKZ <> 'B' (Creation ind.)

    EBAN-MARNR <> '' (Materials in scope)

    EBAN-BADAT>= 01.01.2023 (Creation Date)

    EBAN-STATU = ' ' or 'M' or 'F' or 'R'

    EBAN-EKORG = SCOPE ONLY (Purchasing Organization)

    EBAN-WERKS = SCOPE ONLY (Plant) or '' (empty)

    EBAN-LGORT = SCOPE ONLY (Storage Location) or '' (empty)

    EBAN-EBAKZ = ''

    Syniti Team
    002EBAN-MATNR=Extract Only Materials that are present in scopeSyniti Team
    003EBAN-LIFNR =Extract Only Vendors that are present in scope OR vendor is emptySyniti Team
    004EBAN-WERKS =Extract Only Plants that are present in scope OR plant is emptySyniti Team
    005

    EBAN-LGORT = Extract Only Storage Locations that are present in scope OR plant is empty



    Selection Screen

    Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















    Data Collection Template (DCT)

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

    DCT Rules

    Field NameField DescriptionRule
    EBAN-BSARTDocument TypeSelect the document types that are in scope
    EBAN-MATNRMaterial NumberSelect the materials that are in scope
    EBAN-WERKSPlantSelect the plants that are in scope
    EBAN-MENGEQuantitySelect entries that are bigger (>) than zero
    EBAN-LFDATDelivery DateSelect entries that are bigger (>) or equal (=) than today
    EBAN-LIFNRVendorSelect the vendors that are in scope

    Extraction Dependencies

    Item #Step DescriptionTeam Responsible

    001

    Vendor - The Info Record is created for a specific vendor, therefore the vendor must exist and be active

    S2P

    002

    Material - The Info Record is for a specific material, therefore the material must exist and be active

    S2P

    003

    Purchasing Organization - Mandatory organizational level (configuration). Must be valid for both the vendor and material

    S2P

    004

    Plant (optional) - The plant must be valid (included on scope) and maintained

    FICO

    005

    Storage Location (optional) - The Storage Location must be valid (included on scope) and maintained for the Material / Plant

    S2P

    005

    Currency & UoM - Must align with vendor master and material master data

    S2P

    006

    Vendor Master Settings - The vendor must have the purchasing organization maintained in purchasing view

    S2P


    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 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
    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

    Transformation Run Sheet

    Item #Step DescriptionTeam Responsible
    001Identify target S/4HANA fields and determine applicable legacy source fields from both ECC systems WP2, PF2Functional Team (S2P)+ Data Team (S2P)
    002Map legacy field values to S/4HANA target values (including field-level mapping and technical names)Data Team (S2P), Data Team (Syniti)
    003Define value mapping rules for fields requiring standardization or harmonization across the two source systems WP2, PF2.Functional Team (S2P)+ Data Team (S2P)
    004Identify and agree on default values where legacy data is incomplete or inconsistentBusiness Team + Functional Team (S2P)
    005Configure transformation rules in Syniti Migrate (including calculated fields, formatting rules, etc.)Data Team (Syniti), Data Team (S2P)
    006Review transformation logic and mappings with Business for confirmationBusiness Team + Functional Team (S2P)
    007Perform initial transformation run and generate draft target-ready datasetData Team (Syniti),
    008Review draft target-ready data for structure and completenessData Team (S2P), Functional Team (S2P)
    009Share transformed data with Business for Pre-load ValidationBusiness Team
    010Incorporate feedback from Business and refine mappings or transformation logic as neededData Team (S2P)
    011Finalize and approve transformed data as Target Ready Load FileBusiness + Functional (S2P) + Data Team (S2P)
    012Handover final file to Load Team or trigger the load via Syniti Load WorkbenchData Team (Syniti), Data Load Team


    Transformation Rules

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

    9044-001

    Legacy

    EBAN

    MATNR

    Material

    S/4HANA

    EBAN

    MATNR

    Material

    Select the new Material Code from the mapping table and update the corresponding target structure accordingly.

    9044-002

    Legacy

    EBAN

    MATKL

    Material Group

    MATKL

    Material Group

    MATKL

    Material Group

    Select the new Material Group from the mapping table and update the corresponding target structure accordingly.

    9044-003

    Legacy

    EBAN

    LIFNR

    Vendor

    S/4HANA

    EBAN

    LIFNR

    Vendor

    Select the new Vendor Code from the mapping table and update the corresponding target structure accordingly.

    9044-004

    Legacy

    EBAN

    MEINS

    Order Unit

    S/4HANA

    EBAN

    MEINS

    Order Unit

    Select the new Order Unit Code from the mapping table and update the corresponding target structure accordingly.

    9044-005

    Legacy

    EBAN

    WERKS

    Plant

    S/4HANA

    EBAN

    WERKS

    Plant

    Select the new Plant Code from the mapping table and update the corresponding target structure accordingly.

    9044-006

    Legacy

    EBAN

    WAERS

    Currency

    S/4HANA

    EBAN

    WAERS

    Currency

    Select the new Currency Code from the mapping table and update the corresponding target structure accordingly.


    Transformation Mapping

    Tables are not yet available to be mentioned here.

    Mapping Table NameMapping Table Description






    Transformation Dependencies

    List the steps that need to occur before transformation can commence
    Item #Step DescriptionTeam Responsible
    001Value Mapping Tables are completeFunctional Team (S2P) + Data Team (S2P)
    002Configurations for Purchasing Requisitions are completeFunctional Team (S2P) + Data Team (S2P)
    003Org structure configuration is completeFunctional Team (S2P) + Data Team (S2P)
    004Dependent Master Data records for Customer and Material are loadedFunctional Team (S2P) + Data Team (S2P)
    005

    Configuration – Purchasing Organization

    Functional Team (S2P)

    006

    Configuration – Plant

    Functional Team (S2P)

    007

    Configuration – Product Group

    Functional Team (S2P)

    008

    Configuration – Vendor

    Functional Team (S2P)

    009

    Configuration – Material

    Functional Team (S2P)

    010

    Configuration – Material Group

    Functional Team (S2P)

    011

    Configuration – Unit of Measure

    Functional Team (S2P)

    012

    Configuration – Purchasing Organization

    Functional Team (S2P)

    013

    Configuration – Purchasing Group

    Functional Team (S2P)


    Pre-Load Validation

    Project Team

    Completeness

    TaskAction
    Configuration

    Ensure necessary configurations are in place in target system and field mapping is aligned with access sequence, condition types

    Review Mapping TableEnsure all the source organization units are mapped with target values
    Check ValuesValidate the pre-load data confirming the values are aligned with target system format and 
    Validate template structure and required field populationEnsure mandatory fields are filled

    Total number of records

    SyWay S2P Data Team to verify that the total number of relevant records from the  DCT is equal to the total number of records in the Preload and Load Sheets.

    Vendor Validation

    Check if the vendor exists in the target system and is active for the purchasing organization. This object has to be loaded before Info Records and Price Conditions.

    Material Validation

    Check if the material exists in the target system and is active for the purchasing organization. This object has to be loaded before Info Records  and Price Conditions. 

    Mandatory Field Check

    Verify whether all mandatory Fields are properly updated: 

    EINA-LIFNR
    EINA-MATNR
    EINE-EKORG
    EINE-WERKS
    EINE-WAERS
    EINE-NETPR
    EINE-BPRME
    EINE-PEINH
    EINE-WAERS
    EINA-MEINS

    Info Record Category

    Check if the Info Record Category (EINE-ESOKZ) has been properly migrated and in case of conversion check the final result.
    - Standard
    - Subcontracting
    - Consignment
    - Pipeline


    Accuracy

    TaskAction





    Business

    Completeness

    TaskAction





    Accuracy

    TaskAction





    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


    Processing Details:

    Image Added

    Load Method:  We are using LSMW (Legacy System Migration Workbench) to perform the data migration for this object.

    Tool: LSMW (Legacy System Migration Workbench)

    Technical Approach: Utilization of BAPI BAPI_REQUISITION_CREATE (or BAPI_PR_CREATE) to create Purchasing Requisitions.



     Load Run Sheet

    Item #Step DescriptionTeam Responsible













    Load Phase and Dependencies

    Configuration

    Item #Configuration Item






    Conversion Objects

    Object #Preceding Object Conversion Approach

    list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)




    Error Handling

    Error TypeError DescriptionAction Taken










    Post-Load Validation

    Project Team

    Completeness

    TaskAction





    Accuracy

    TaskAction





    Business

    Completeness

    TaskAction





    Accuracy

    TaskAction





    Key Assumptions

    • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
    • is in scope based on data design and any exception requested by business.


    See also

    Change log

    Change History
    limit10