Purpose

The purpose of the document is to define the data conversion approach to create Business Partners – 3rd Party Suppliers through FLVN01 Supplier Role including Purchasing Organization,  partner function, Plant Specific Purchasing including partner Function data and purchasing Text in S/4 HANA.(TBC - There will be 3 SAP instances, one for ROW, one for China and one for CUI only).

In SAP ECC, the Vendor Master Purchasing View (including the Partner Functions) is part of the Vendor Master Data, which is used to store vendor-related information for purchasing transactions. The setup typically involves maintaining vendor records separately for different purchasing organizations..

In SAP S/4HANA, the Vendor Purchasing View is integrated into the Business Partner (BP) model, which replaces the traditional customer/vendor objects from ECC. The Business Partner serves as a central entity, allowing a single record to hold multiple roles (e.g., customer and vendor). The Vendor Purchasing View in S/4HANA is represented under the BP role FLVN001, which contains-specific data such as purchasing organization, purchasing group, payment terms, purchasing currency, incoterms, shipping conditions and partner functions.

 In SAP ECC and SAP S/4 HANA Vendor purchasing texts are stored in the the general text tables STXH (SAPScript Text Header) and STXL (SAPScript Test Lines) and the specific text for a vendor is linked using object type LFM1 and text IDs in these tables. Vendor purchasing text refers to the process and configuration that automatically copies predefined text from the vendor master record into the purchasing documents like purchase orders.

 In SAP ECC and SAP S/4 HANA, Plant specific vendor purchasing data is maintained in within the purchasing organization section in SAP ECC and within the Business Partner(BP) master record under the FLVN01 Supplier Role in the purchasing organization section with an additional plant key. The data is used to define procurement conditions unique to a specific plant overriding the general purchasing organization data where applicable. If alternative data is greyed out then, to activate this field data retention at plant level to be allowed at the general data level.


Conversion Scope

The scope of this document covers the approach for converting active Vendor Master purchasing attributes records from Legacy Source Systems into Business Partner – Supplier Role FLVN001 in S/4 HANA following the Vendor Master Data Design Standard.

MDS and Conversion Specification is referring to the tables and fields - LFA1: Supplier Master (General Section),LFA1: Vendor tax data, LFBK - Vendor bank data, LFBW-Withholding tax data which will be covered part of 3007-Business Partners - General (Role 000000 ETL , Conversion Specification and Design.

CNV-3026 Business Partners – 3rd Party Suppliers (FLVN001) is  using both ETL and DCT conversion processes for the vendors purchasing view including partner functions data, Vendor purchasing Texts data and plant specific vendors purchasing view including partner functions.

Tables Includes for the CNV-3026 Business Partners – 3rd Party Suppliers (FLVN001) are:

  1. LFM1: Vendor master record purchasing organization data
  2. WYT3: Partner Functions
  3. LFM2: Vendor Master Record: Purchasing Data - Plant Specific
  4. STXH: STXD SAPscript text file header
  5. STXL:  STXD SAPscript text file lines


Relevancy Rule

The data from legacy system includes:

  1. Vendors which pass Relevancy Rules under Data Object (3007-Business Partners - General (Role 000000)), CNV Google drive path - CNV-3007 Business Partners - General (Role 000000) - SyWay Project - Syensqo - Wiki knowledge base
  2. Should be created to Purchasing Organization 'inscope' based on Enterprise Structure Catalog
  3. Should be extended to Standard list(approved list) of Partner Functions (based on MDS-3026).
  4. Vendors’ relevant purchasing data with potential duplicate records as per the criteria - Vendors Purchasing Data Deduplication will be mainly based on the  Deduplication process of the CNV 3007 and If there are multiple records identified as duplicates with the combination of vendor and purchasing organization but the different attribute values business needs to select the master record to create in S/4.

The data from legacy system excludes:

  1. Vendors which pass Relevancy Rules under Data Object (3007-Business Partners - General (Role 000000)), CNV Google drive path - CNV-3007 Business Partners - General (Role 000000) - SyWay Project - Syensqo - Wiki knowledge base
  2. Vendors extended in Purchasing organization which are not is scope based on Enterprise Structure.
  3. Vendors blocked or marked for deletion at Purchasing Organization level

Inclusion Table Criteria: Inclusion table should be build or in place where data got excluded for some Vendor + Purchasing data due to the vendor relevancy rule or any data is missing as part of the extraction process or based on the Business input.

Exclusion Table Criteria: Exclusion table should be build or in place where data got included for the Vendor + Purchasing data due to the vendor relevancy rule or not needed now as per the Business or migrate the data as a DCT not using the ETL process.

Note: There is open Jira defect [PDM-1085] 3026 - Business Partners - 3rd Party Suppliers-FLVN01 - New Regulatory Requirement : ensuring that a vendor/carrier Business Partner is authorized to transport Dangerous Goods. - Jira for the new requirement and any other new fields to be added which will be coming in future, These will be included into the CS using CR route in future and moving ahead with the CS approval process based on the MDS checked in so far.


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2, WP2

Supplier role is applicable only for legally registered entities and strictly adheres to Master Data Standards (MDS) which elaborates out these criteria and other requirements such as Partner Function, being mandatory information used across Business Partner. 

Identified relevant suppliers from the Global level relevancy. Relevant suppliers with valid purchasing organization extensions in source systems will be in-scope for deduplication analysis.

Deduplication exercise will check duplicates at purchasing organization level and business will choose the source of supplier role attributes to be used for migration. Otherwise, if record has no duplicates, it automatically becomes the source for supplier master data transformation.

(for further relevancy scope, refer to Business Partner – General DCS - 3007-Business Partners - General (Role 000000))

40,000 (Suppliers)

130,000 (Suppliers partner functions data)

S/4 HANA

40,000 (Suppliers)

130,000 (Suppliers partner functions data)

PF2, WP2

Plant specific vendors purchasing data including the partner functions data 

TBC

S/4 HANA

TBC

PF2, WP2

Vendor master purchasing texts data

TBC

S/4 HANA

TBC

Additional Information

Multi-language Requirement (TBC as this is based on the multi-language criteria from 3007-Business Partners - General (Role 000000))

Will follow multi-language allowed and created in 3007-Business Partners - General (Role 000000)


Document Management

N/A

Legal Requirement

N/A

Special Requirements

N/A


Target Design

The Business Partner - Supplier master data strictly adheres to Master Data Standards as specified below.

MDS Rules and Google Drive path for the MDS - DD-FUN-050 Master Data Standard_BP_3026-Supplier Role_3031_Supplier Doc. Attachments.xlsx - Google Sheets

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirement
LFM1LIFNRLIFNRSupplier*CHAR10R
LFM1EKORGEKORGPurchasing Organization*CHAR 4R
LFM1EKGRPEKGRPPurchasing GroupCHAR 3C
LFM1WAERSWAERSOrder CurrencyCUKY5C
LFM1VERKFVERKFSalespersonCHAR 30Not Used
LFM1TELF1TELF1Supplier's Telephone NumberCHAR 16Not Used
LFM1MINBWMINBWMinimum Order ValueCURR16Not Used
LFM1ZTERMZTERMTerms of Payment KeyCHAR 4C
LFM1INCOVINCOVInco. VersionCHAR 4Not Used
LFM1INCO1INCO1IncotermsCHAR 3C
LFM1INCO2_LINCO2_LIncoterms Location 1CHAR70C
LFM1KALSKKALSKGroup for Calculation SchemaCHAR2R
LFM1PLIFZPLIFZPlanned Delivery Time in DaysDEC10Not Used
LFM1LFABCLFABCABC IndicatorCHAR1Not Used
LFM1VSBEDVSBEDShipping ConditionsCHAR2C
LFM1WEBREWEBREGR-Based Invoice VerificationCHAR1C
LFM1KZAUTKZAUTAutomatic POCHAR1R
LFM1MEPRFMEPRFPricing Date ControlCHAR1C
LFM1BSTAEBSTAEConfirmation Control KeyCHAR4C
LFM1KZRETKZRETReturns SupplierCHAR1C
LFM1AUBELAUBELAutomatic DebitCHAR1Not Used
LFM1VALID_PROVALID_PROSettlement ProfileCHAR4Not Used
LFM1HSCABSHSCABSAbsolute Handling SurchargeCURR16Not Used
LFM1HSCPEHSCPEPercentage Handling SurchargeDEC16Not Used
LFM1HSCMINHSCMINMinimum Handling SurchargeCURR16Not Used
LFM1HSCMAXHSCMAXMaximum Handling SurchargeCURR16Not Used
LFM1XERSYXERSYAutom Evaluated Receipt Settlement (ERS)CHAR1C
LFM1XERSRXERSRAutom Evaluated GR Settlement ReturnCHAR1C
LFM1KZABSKZABSOrder Acknowledgment RequirementCHAR1C
LFM1EIKTOEIKTOAccount with supplierCHAR12Not Used
LFM1NRGEWNRGEWGrant free goodsCHAR1Not Used
LFM1PAPRFPAPRFProact control profileCHAR4Not Used
LFM1BOLREBOLRESubsequent settlementCHAR1Not Used
LFM1XNBWYXNBWYRevaluationCHAR1Not Used
LFM1VENDOR_RMA_REQVENDOR_RMA_REQRMA requiredCHAR1Not Used
LFM1PRFREPRFREPrice determinationCHAR1Not Used
LFM1BOINDBOINDSubsequent settlement indicator activeCHAR1Not Used
LFM1BLINDBLINDDocument indexCHAR1TBD
LFM1AGRELAGRELRelevant for settlement managementCHAR1Not Used
LFM1LOEVMLOEVMDeletion flag purchasing organizationCHAR1Not Used
LFM1SKRITSKRITSort criterionCHAR1Not Used
LFM1SPERMSPERMSelected purchasing organization blockCHAR1C
LFM1MRPPPMRPPPPlanning calendarCHAR3Not Used
LFM1LFRHYLFRHYPlanning cycleCHAR3Not Used
LFM1BOPNRBOPNROrder optimization restrictionCHAR4Not Used
LFM1LIBESLIBESOrder entry by supplierCHAR1Not Used
LFM1LIPRELIPREPrice marking SupplierCHAR2Not Used
LFM1LISERLISERRack JobbingCHAR1Not Used
LFM1ZOLLA ZOLLACustoms Office: Office of Exit/Entry for Foreign TradeCHAR6C
LFM1 INCO3_L INCO3_LIncoterms Location 2CHAR70Not Used
LFM1 RDPRF RDPRFRounding ProfileCHAR4Not Used
LFM1 MEGRU MEGRUUnit of Measure GroupCHAR4Not Used
LFM1ABUEB ABUEBRelease Creation ProfileCHAR4Not Used
LFM1LFM1_EEW_PSLFM1_EEW_PSData Element Extensibility for purchaseCHAR1Not Used
LFM1J_1NBOESL J_1NBOESLExchange Key for NF ProcessingCHAR3C
LFM1 FSH_SC_CID FSH_SC_CIDCustomer/Supplier IdentifierCHAR2Not Used
LFM1 FSH_VAS_DETC FSH_VAS_DETCVAS Determination ModeCHAR1Not Used
LFM1 UPPRS UPPRSPricing on Subitems (MPN/SUS)CHAR1Not Used
LFM1 ACTIVITY_PROFIL ACTIVITY_PROFILActivity Profile for PO ControllingCHAR4Not Used
LFM1 TRANSPORT_CHAIN TRANSPORT_CHAINTransportation ChainCHAR10Not Used
LFM1 STAGING_TIME STAGING_TIMEStaging Time in DaysDEC3Not Used
LFM1EXPVZEXPVZMode of Transport at the Border (IntrastCHAR1Not Used
LFM1 VENSL VENSLSupplier Service LevelDEC5Not Used
LFM1LEBRELEBREService - based Invoice verificationCHAR1R
LFM1UMSAEUMSAEComparison and agreement of business volumesCHAR1Not Used
LFM2LIFNRLIFNRSupplier*CHAR10R
LFM2EKORGEKORGPurchasing Organization*CHAR 4R
LFM2LTSNRLTSNRSuppl, Subrange*CHAR 6R
LFM2WERKSWERKSPlant*CHAR 4R
WRF02K(TBC)HINZEXDYNPIndicator: plant level relevant - Purchasing DataCHAR1C
WRF02K(TBC)HINZPXDYNPIndicator: plant level relevant - Partner FunctionsCHAR1C
LFM2EKGRPEKGRPPurchasing GroupCHAR 3C
LFM2WAERSWAERSOrder CurrencyCUKY5C
LFM2VERKFVERKFSalespersonCHAR 30Not Used
LFM2TELF1TELF1Supplier's Telephone NumberCHAR 16Not Used
LFM2MINBWMINBWMinimum Order ValueCURR16Not Used
LFM2ZTERMZTERMTerms of Payment KeyCHAR 4C
LFM2INCOVINCOVInco. VersionCHAR 4Not Used
LFM2INCO1INCO1IncotermsCHAR 3C
LFM2INCO2_LINCO2_LIncoterms Location 1CHAR70C
LFM2KALSKKALSKGroup for Calculation SchemaCHAR2R
LFM2PLIFZPLIFZPlanned Delivery Time in DaysDEC10Not Used
LFM2LFABCLFABCABC IndicatorCHAR1Not Used
LFM2WEBREWEBREGR-Based Invoice VerificationCHAR1C
LFM2KZAUTKZAUTAutomatic POCHAR1R
LFM2MEPRFMEPRFPricing Date ControlCHAR1C
LFM2BSTAEBSTAEConfirmation Control KeyCHAR4C
LFM2XERSYXERSYAutom Evaluated Receipt Settlement (ERS)CHAR1C
LFM2XERSRXERSRAutom Evaluated GR Settlement ReturnCHAR1C
LFM2KZABSKZABSOrder Acknowledgment RequirementCHAR1C
LFM2PAPRFPAPRFProact control profileCHAR4Not Used
LFM2BOLREBOLRESubsequent settlementCHAR1Not Used
LFM2XNBWYXNBWYRevaluationCHAR1Not Used
LFM2KZABSKZABSOrder Acknowledgment RequirementCHAR1C
LFM2PAPRFPAPRFProact control profileCHAR4Not Used
LFM2BOLREBOLRESubsequent settlementCHAR1Not Used
LFM2XNBWYXNBWYRevaluationCHAR1Not Used
LFM2BOINDBOINDSubsequent settlement indicator activeCHAR1Not Used
LFM2LOEVMLOEVMDeletion flag purchasing organizationCHAR1Not Used
LFM2SPERMSPERMSelected purchasing organization blockCHAR1C
LFM2MRPPPMRPPPPlanning calendarCHAR3Not Used
LFM2LFRHYLFRHYPlanning cycleCHAR3Not Used
LFM2BOPNRBOPNROrder optimization restrictionCHAR4Not Used
LFM2LIBESLIBESOrder entry by supplierCHAR1Not Used
LFM2LIPRELIPREPrice marking SupplierCHAR2Not Used
LFM2LISERLISERRack JobbingCHAR1Not Used
LFM2 ZOLLA ZOLLACustoms Office: Office of Exit/Entry for Foreign TradeCHAR6C
LFM2 INCO3_L INCO3_LIncoterms Location 2CHAR70Not Used
LFM2 RDPRF RDPRFRounding ProfileCHAR4Not Used
LFM2 MEGRU MEGRUUnit of Measure GroupCHAR4Not Used
LFM2 ABUEB ABUEBRelease Creation ProfileCHAR4Not Used
LFM2 TRANSPORT_CHAIN TRANSPORT_CHAINTransportation ChainCHAR10Not Used
LFM2 STAGING_TIME STAGING_TIMEStaging Time in DaysDEC3Not Used
LFM2EXPVZEXPVZMode of Transport at the Border (IntrastCHAR1Not Used
LFM2LEBRELEBREService - based Invoice verificationCHAR1R
LFM2UMSAEUMSAEComparison and agreement of business volumesCHAR1Not Used
LFM2WEORAWEORAOrigin acceptanceCHAR1Not Used
WYT3LIFNRLIFNRSupplier*CHAR10R
WYT3PARVWPARVWPartner Function*CHAR2R
WYT3LIFN2LIFN2Ref to vendorCHAR10C
WYT3PERNRPERNRPersonnel No.NUMC8Not Used
WYT3PARNRPARNRContact Person IDNUMC10C
WYT3DEFPADEFPADefaultCHAR1C
WYT3EKORGEKORGPurchasing organizationCHAR4R
WYT3LTSNRLTSNRSupplier SubrangeCHAR6Not used
WYT3WERKSWERKSPlantCHAR4Not used
S_LFM1_TEXTLIFNRLIFNRSupplier*CHAR10R
S_LFM1_TEXTEKORGEKORGPurchasing Organization*CHAR4R
STXHTDIDCHARText IDCHAR4C
STXHTDSPRASTDSPRASLanguageCHAR2C
STXH/STXKTEXT_LINES(LTEXT)TEXT_LINESLong textCHAR40C


Data Cleansing

Analysis Report or Validation Reports path for the reference -

IDCriticalityError Message/Report DescriptionRuleOutputSource System

3026-001

C-1

Deduplication

Purchasing Organization extensions from Vendors identified in global relevancy and will undergo a deduplication exercise to determine record source of purchasing data for Business Partner – 3rd Party Suppliers.

This is where business needs to select which record to use as valid source of Purchasing Organization data.

Parent and child approach will be used for selection of golden record.  


Scenario 1: Non-Duplicate Vendor (Global) having multiple active Purchasing Organization extensions

Vendor has no duplicates at global level.  However, vendor has multiple Purchasing Organization data within same name, country, etc. 


Scenario 2: Duplicate Vendors (Global) having multiple active Purchasing Organizations

Duplication of vendor exist in Vendor Global duplicate group and extended to same purchasing organization.



PF2/WP2
3026-002C-1Identify Vendor not used in the existing purchasing organization

Needs to be verified for the active vendors based on the relevancy criteria of CNV-3007  


PF2/WP2
3026-003C-2

Fill in mandatory fields based on master data standards

  1. Purchasing Organization
  2. Payment Terms
  3. Incoterms and incoterms location
  4. Purchasing Group
  5. Schema Group
  6. Shipping Conditions
  7. Conformation Control Key
  8. Purchasing Currency
  9. Partner Functions
  10. Plant

For all the active vendors purchasing data in migration scope, make sure to fill all the mandatory fields based on the value mappings agreed to generate the report for the business for the cleansing if needed.


Report should be generated for any missing data for the mandatory fields to do the needed cleansing activity by the business


PF2/WP2
3026-004C-2Validate obsolete payment term maintained or Not Approved Payment Terms

For all the active vendors  in migration scope, if there is payment term, and the payment term value is not in S4 Hana design

Check the Payment Terms assigned to the vendor and verify if it  exists in the mapping table


PF2/WP2

3026-005

 C-2

Not Approved Payment Terms

Check the Payment Terms assigned to the vendor and verify if it  exists in the mapping table


PF2/WP2

3026-006

 C-1

Vendors Purchasing Long Text Report

Needs to be verified for the active vendors based on the relevancy criteria of CNV-3007  

Get the Vendors Purchasing Long Text data from ECC system 


PF2/WP2

3026-007

 C-2

Vendors Partner Functions Report

Get the Vendors Partner Functions Report  where the PI and OA vendors are different from the VN partner  from ECC system 


PF2/WP2

3026-008

 C-2

Vendors Plant Specific Purchasing Organization data (Additional data at Purchasing Organization level)

Get the Vendors Plant Specific Purchasing Organization Report from ECC system 


PF2/WP2

3026-009

 C-2

Vendors Plant Specific Purchasing Organization Partner Functions data (Additional data at Purchasing Organization level)

Get the Vendors Plant Specific Purchasing Organization Partner Functions Report from ECC system 


PF2/WP2



Conversion Process

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

The ETL (Extract, Transform, Load) process is a structured approach to data migration and management, ensuring high-quality data is seamlessly transferred across systems with the exception of DCT for any additional vendor partner functions data . Here’s a breakdown of its key components:

1. Extraction
The process begins with extracting metadata and raw data from source systems, such as Syensqo ECC system (i.e., WP2/PF2) periodically. The extracted data is then staged for transformation.


2. Transformation
Once extracted, the data undergoes cleansing, consolidation, and governance. This step ensures data integrity, consistency, and compliance with business rules. The transformation process includes:
- Data validation to remove inconsistencies.
- Standardization to align formats across datasets.
- Business rule application to refine data for operational use.


3. Loading


The transformed data is then loaded into the target S4 Hana system using migration cockpit. 


DCT Process- Collection will be done manually in the Data Collection Template for the following scenarios:

  • For the vendors purchasing view including partner functions data, Vendor purchasing Texts data and plant specific vendors purchasing view including partner functions data that need to be created to support the to-be design.
  • For the vendors purchasing view including partner functions data, Vendor purchasing Texts data and plant specific vendors purchasing view including partner functions data that need to be created to support the to-be design. which is not in SAP ECC

High Level Conversion Process - Source - DCT.png


Data Privacy and Sensitivity

N/A

Extraction

Extract data from a source into Syniti Migrate for SAP relevant entities. There are 2 possibilities:

  1. The data exists. Syniti Migrate connects to the source and loads the data into Syniti Migrate. 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 Migrate; 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 Syniti Migrate. This is to be conducted using DCT (Data Collection Template) in Syniti Migrate

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

Refresh Criteria

Refresh LFM1, LFM2, WYT3 tables via Syniti Tool (Vendor data)

Data team

Extraction 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


Extraction 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

Extraction Execution Plan

Establish execution timelines and batch processing schedules.
Assign responsibilities for extraction monitoring.
Document dependencies on other migration tasks.

Syniti

Data Quality and Validation

Define error handling mechanisms for extraction failures.

Syniti


Selection Screen

N/A




Data Collection Template (DCT)

Target Ready Data Collection Template will be created for the vendors purchasing view including partner functions data, Vendor purchasing Texts data and plant specific vendors purchasing view including partner functions data.

(if needed) data with exception of some fields which require transformation as mentioned in the transformation rule.

  1. The extracted report will be loaded into the required structure using the DCT.
  2. Standardization activities (including deduplication, standardization and additions)  will be carried out within the DCT.

DCT Rules:

Vendors Purchasing Organization Data:
Technical Table-Field Field LabelField DescriptionRule
LFM1-LIFNRSupplier*Supplier*R
LFM1-EKORGPurchasing Organization*An organizational unit in Logistics, subdividing an enterprise according to the requirements of Purchasing.
 A purchasing organization procures products and services, negotiates conditions of purchase with suppliers, and is responsible for such transactions.
 You specify the form of procurement by assigning purchasing organizations to company codes and plants.
R
LFM1-EKGRPPurchasing GroupKey for a buyer or a group of buyers responsible for the procurement of the product.C
LFM1-WAERSOrder CurrencyKey for the currency on which an order placed with a supplier is based.C
LFM1-ZTERMTerms of Payment KeyKey for defining payment terms composed of cash discount percentages and payment periods.C
LFM1-INCO1IncotermsIncoterms specify certain internationally recognized procedures that the shipper and the receiving party must follow for the shipping transaction to be successfully completed.C
LFM1-INCO2_LIncoterms Location 1Provides additional information for the Incoterms. This field is only available if mentioned incoterm is customized for location 2.
Logic:
If LFM1-INCO1 (incoterms)=  
CFR
CIF
CIP
CPT 
FOB
-------> INCO2_ID Mandatory and INCO2_L automatically updated from (INCO2_ID) and not editable
C
LFM1-KALSKGroup for Calculation SchemaDetermines which calculation schema (pricing procedure) is to be used in purchasing documents containing this supplier number.R
LFM1-VSBEDShipping ConditionsGeneral shipping strategy for the delivery of goods from the supplier to the customer.C
LFM1-WEBREGR-Based Invoice VerificationThis is an indicator field. If the criterion is met, enter X. If not, leave the field empty.C
LFM1-KZAUTAutomatic POThis is an indicator field. If the criterion is met, enter X. If not, leave the field empty. Allows you to automatically generate purchase orders from purchase requisitions if the requisition has been assigned to a supplier (source of supply).R
LFM1-MEPRFPricing Date ControlDetermines which date is to be used for price determination (pricing) purposes.

By default leave it blank.
C
LFM1-BSTAEConfirmation Control KeyDetermines which confirmation categories are expected for a PO item (for example order acknowledgment, shipping notification).C
LFM1-KZRETReturns SupplierIndicates that a supplier return is carried out using shipping processing. You can also use shipping processing for supplier returns. Enter X or leave the indicator field empty.
 If you use the return supplier indicator, the customer master record must exists in the system. The customer reference field is at General Data sheet.
C
LFM1-XERSYAutom Evaluated Receipt Settlement (ERS)This is an indicator field. If the criterion is met, enter X. If not, leave the field empty.C
LFM1-XERSRAutom Evaluated GR Settlement ReturnThis is an indicator field. If the criterion is met, enter X. If not, leave the field empty.C
LFM1-KZABSOrder Acknowledgment RequirementDetermines whether the purchasing document (as purchase order, and so on.) is to be acknowledged by the supplier.
 Enter X or leave the indicator field empty.
C
LFM1-BLINDDocument indexIndicates that a document index is allowed for purchase orders issued to this supplier. The index is used for determining the relevant purchasing documents affected by changes to conditions offered by the supplier.TBD
LFM1-SPERMSelected purchasing organization blockIndicates whether or not the supplier master record is blocked for the purchasing organization for posting purposes.
 Based on Business Requirements
C
LFM1- ZOLLACustoms Office: Office of Exit/Entry for Foreign TradeSpecifies the code of the customs office through which the goods enter or leave the country. This information is used for compiling export/import data for foreign trade statistics.C
LFM1- J_1NBOESLExchange Key for NF ProcessingBrazilian taxesC
LFM1-LEBREService - based Invoice verificationIndicates that service-based invoice verification is defined for a purchase order item.
 In service-based invoice verification, the quantities and values of services performed and ordered to date are available for checking purposes. As in the case of invoice verification for materials, you are able to change quantities and values within the permitted tolerances.
 In addition, if service-based invoice verification is active, the acceptance posting is carried out at the level of the services in the entry sheet, and the quantities and values of the accepted and invoiced services are shown in the PO history.
 For a service PO, It will be always flagged as it is driven by the item category used in the Purchase order (Always Item Category ‘D’ for services).
R
Vendors Purchasing Organization Partner Functions Data:
Technical Table-Field Field LabelField DescriptionRule
WYT3-LIFNRSupplier*Supplier*R
WYT3-PARVWPartner Function*

The abbreviated form of the name that identifies the partner function. Aligned to the Governance column in "BP Role Matrix Organizations"
 The partner function that you enter for the data migration differs from the value you see on the UI.
 Default values: 
PI – Invoicing Party
The partner to whom the payment should be made. Controls invoice processing.
GS – Goods Supplier
The actual party delivering the goods; used if the delivery source differs from the supplier on PO.
OA – Ordering Address
The address where the purchase order is sent. Useful when the vendor has multiple branches.
VN - Vendor
CR - Carrier - TBD
The logistics provider or freight forwarder responsible for transporting goods.
ZA - TMS4S: the value will be the same Main BP code

ZB - BN4L: the value will be the same Main BP code
ZC - Transwide : the value will be the same Main BP code
In case of CASS-> PI partner function with BP code equal to the Main BP can be used- Note: currently it will be only maintained when the email address is different in case of legal entity (Different BP code)

R
WYT3-LIFN2Ref to vendorThis partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory.
WYT3-PARNRContact Person IDThis partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory.
WYT3-DEFPADefaultSpecifies a partner as the default for a particular partner function. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty.C
WYT3-EKORGPurchasing organizationPurchasing organization. An organizational unit in Logistics, subdividing an enterprise according to the requirements of Purchasing.
 A purchasing organization procures products and services, negotiates conditions of purchase with suppliers, and is responsible for such transactions.
 You specify the form of procurement by assigning purchasing organizations to company codes and plants.
R




Vendors Plant Specific Purchasing Organization Data:
Technical Table-Field Field LabelField DescriptionRule
LFM2-LIFNRSupplier*Supplier* - key field for Supplier Range at plant levelR
LFM2-EKORGPurchasing Organization*Key field for Supplier Range at plant level
An organizational unit in Logistics, subdividing an enterprise according to the requirements of Purchasing.
 A purchasing organization procures products and services, negotiates conditions of purchase with suppliers, and is responsible for such transactions.
 You specify the form of procurement by assigning purchasing organizations to company codes and plants.
R
LFM2-LTSNRSuppl, Subrange*Supplier Subrange - Key field for Supplier Range at plant level.R
LFM2-WERKSPlant*Key that uniquely identifies a plant.
GENERAL RULE: All the fields equal to the fields coming from LFM1 (the only one field that could be different is "Customs Office: Office of Exit/Entry for Foreign Trade (LFM2- ZOLLA)
R
WRF02K-HINZE(TBC)Indicator: plant level relevant - Purchasing DataFlag. Select in case the specific data within the plant refers to Purchasing Data. GENERAL RULE: All the fields equal to the fields coming from LFM1 (the only one field that could be different is "Customs Office: Office of Exit/Entry for Foreign Trade (LFM2- ZOLLA)C
WRF02K-HINZP(TBC)Indicator: plant level relevant - Partner FunctionsFlag. Select in case the specific data within the plant refers to Partner function data.C
LFM2-EKGRPPurchasing GroupKey for a buyer or a group of buyers responsible for the procurement of the product. Equal to the value at Purchas. Organiz level (LFM1 - inherited)C
LFM2-WAERSOrder CurrencyKey for the currency on which an order placed with a supplier is based.C
LFM2-ZTERMTerms of Payment KeyKey for defining payment terms composed of cash discount percentages and payment periods.C
LFM2-INCO1IncotermsIncoterms specify certain internationally recognized procedures that the shipper and the receiving party must follow for the shipping transaction to be successfully completed.C
LFM2-INCO2_LIncoterms Location 1Provides additional information for the Incoterms. This field is only available if mentioned incoterm is customized for location 2.
Logic:
If LFM1-INCO1 (incoterms)=  
CFR
CIF
CIP
CPT 
FOB
-------> INCO2_ID Mandatory and INCO2_L automatically updated from (INCO2_ID) and not editable
C
LFM2-KALSKGroup for Calculation SchemaDetermines which calculation schema (pricing procedure) is to be used in purchasing documents containing this supplier number. Equal than at Purchas. Organ. level.(table LFM1 -inherited)R
LFM2-WEBREGR-Based Invoice VerificationThis is an indicator field. If the criterion is met, enter X. If not, leave the field empty.C
LFM2-KZAUTAutomatic POThis is an indicator field. If the criterion is met, enter X. If not, leave the field empty. Allows you to automatically generate purchase orders from purchase requisitions if the requisition has been assigned to a supplier (source of supply).R
LFM2-MEPRFPricing Date ControlDetermines which date is to be used for price determination (pricing) purposes.

By default leave it blank.
C
LFM2-BSTAEConfirmation Control KeyDetermines which confirmation categories are expected for a PO item (for example order acknowledgment, shipping notification).C
LFM2-XERSYAutom Evaluated Receipt Settlement (ERS)This is an indicator field. If the criterion is met, enter X. If not, leave the field empty.C
LFM2-XERSRAutom Evaluated GR Settlement ReturnThis is an indicator field. If the criterion is met, enter X. If not, leave the field empty.C
LFM2-KZABSOrder Acknowledgment RequirementDetermines whether the purchasing document (as purchase order, and so on.) is to be acknowledged by the supplier.
 Enter X or leave the indicator field empty.
C
LFM2-SPERMSelected purchasing organization blockIndicates whether or not the supplier master record is blocked for the purchasing organization for posting purposes.
 Based on Business Requirements
C
LFM2- ZOLLACustoms Office: Office of Exit/Entry for Foreign TradeSpecifies the code of the customs office through which the goods enter or leave the country. This information is used for compiling export/import data for foreign trade statistics.
Note: GENERAL RULE at plant level: All the fields equal to the fields coming from LFM1 (the only one field that could be different is "Customs Office: Office of Exit/Entry for Foreign Trade (LFM2- ZOLLA)
C
LFM2-LEBREService - based Invoice verificationIndicates that service-based invoice verification is defined for a purchase order item.
 In service-based invoice verification, the quantities and values of services performed and ordered to date are available for checking purposes. As in the case of invoice verification for materials, you are able to change quantities and values within the permitted tolerances.
 In addition, if service-based invoice verification is active, the acceptance posting is carried out at the level of the services in the entry sheet, and the quantities and values of the accepted and invoiced services are shown in the PO history.
 For a service PO, It will be always flagged as it is driven by the item category used in the Purchase order (Always Item Category ‘D’ for services).
R
Vendors Plant Specific Purchasing Organization Partner Functions Data:
Technical Table-Field Field LabelField DescriptionRule
WYT3-LIFNRSupplier*Supplier*R
WYT3-PARVWPartner Function*

The abbreviated form of the name that identifies the partner function. Aligned to the Governance column in "BP Role Matrix Organizations"
 The partner function that you enter for the data migration differs from the value you see on the UI.
 Default values: 
PI – Invoicing Party
The partner to whom the payment should be made. Controls invoice processing.
GS – Goods Supplier
The actual party delivering the goods; used if the delivery source differs from the supplier on PO.
OA – Ordering Address
The address where the purchase order is sent. Useful when the vendor has multiple branches.
VN - Vendor
CR - Carrier - TBD
The logistics provider or freight forwarder responsible for transporting goods.
ZA - TMS4S: the value will be the same Main BP code

ZB - BN4L: the value will be the same Main BP code
ZC - Transwide : the value will be the same Main BP code
In case of CASS-> PI partner function with BP code equal to the Main BP can be used- Note: currently it will be only maintained when the email address is different in case of legal entity (Different BP code)

R
WYT3-LIFN2Ref to vendorThis partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory.C
WYT3-PARNRContact Person IDThis partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory.C
WYT3-DEFPADefaultSpecifies a partner as the default for a particular partner function. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty.C
WYT3-EKORGPurchasing organizationPurchasing organization. An organizational unit in Logistics, subdividing an enterprise according to the requirements of Purchasing.
 A purchasing organization procures products and services, negotiates conditions of purchase with suppliers, and is responsible for such transactions.
 You specify the form of procurement by assigning purchasing organizations to company codes and plants.
R
Vendors Purchasing Long Text:
Technical Table-Field Field LabelField DescriptionRule
S_LFM1_TEXT-LIFNRSupplier*Supplier*R
S_LFM1_TEXT-EKORGPurchasing Organization*An organizational unit in Logistics, subdividing an enterprise according to the requirements of Purchasing.
 A purchasing organization procures products and services, negotiates conditions of purchase with suppliers, and is responsible for such transactions.
 You specify the form of procurement by assigning purchasing organizations to company codes and plants.
R
STXH-TDIDText IDText ID
The text ID defines the various types of texts related to a text object. For example, the object "TEXT" (standard texts) can have the following text IDs:

ST for user-specific standard texts (individual texts)
SYST for cross-application system texts
various IDs for specific application departments. You must have the appropriate access authorization in order to access these texts.
Maintain when additional texts need to be stored for a business partner, selecting the relevant text type (e.g., notes, instructions, vip remarks). Not required otherwise.
C
STXH-TDSPRASLanguageThe language key indicates

- the language in which texts are displayed,
- the language in which you enter texts,
- the language in which the system prints texts.
C
STXH/STXK-TEXT_LINES(LTEXT)Long textA text that describes the object to which it refers in greater detail.
Maintain when additional texts need to be stored for a business partner, selecting the relevant text type (e.g., notes, instructions, vip remarks). Not required otherwise.
C

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


Indicator: plant level relevant - Purchasing Data

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

1

Run LFM1, LFM2 and WYT3 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

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

1

PF2/WP2

LFM1

LIFNR

VENDOR NUMBER

S/4 HANA

LFM1

LIFNR

SUPPLIER NUMBER

XREF

Derive via legacy to SyWay S4 Business Partner mapping

Supplier Automatically created by the system.

2

PF2/WP2

LFM1

EKORG

PURCHASING ORGANISATION

S/4 HANA

LFM1

EKORG

PURCHASING ORGANISATION

XREF

Derive via legacy to SyWay 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.

3

PF2/WP2

LFM1

EKGRP

PURCHASING GROUP

S/4 HANA

LFM1

EKGRP

PURCHASING GROUP

XREF

Derive via legacy to SyWay S4 Purchasing Group mapping

It is validated against relevant Purchasing Groups available in S/4 HANA.

4

PF2/WP2

LFM1

WAERS

ORDER CURRENCY

S/4 HANA

LFM1

WAERS

ORDER CURRENCY

XREF

Derive via legacy to SyWay S4 Purchasing Currency code mapping

5

PF2/WP2

LFM1

VERKF

SALESPERSON

S/4 HANA

LFM1

VERKF

SALESPERSON

Not Used

It is free text in S4HANA.

6

PF2/WP2

LFM1

TELF1

TELEPHONE

S/4 HANA

LFM1

TELF1

TELEPHONE

Not Used

7

PF2/WP2

LFM1

MINBW

MINIMUM ORDER VALUE

S/4 HANA

LFM1

MINBW

MINIMUM ORDER VALUE

Not Used

8

PF2/WP2

LFM1

ZTERM

PAYMENT TERMS

S/4 HANA

LFM1

ZTERM

PAYMENT TERMS

XREF

Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 

In the PO - in case we have PIR/CTR will come from here.
Otherwise, it will take it from the BP. S4HANA.

9

PF2/WP2

LFM1

INCOV

INCO VERSION

S/4 HANA

LFM1

INCOV

INCO VERSION

Not Used

10

PF2/WP2

LFM1

INCO1

INCOTERMS

S/4 HANA

LFM1

INCO1

INCOTERMS

XREF

Derive via legacy to SyWay S4 Incoterms mapping

Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 

Set as Conditional because it must be mandatory only for the BPs that trigger Transportation module. The BP subjected to TM must have it as mandatory (as this field should be inherited to the corresponding POs)

Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank

11

PF2/WP2

LFM1

INCO2_L (INCO2_ID (TMINCO_LOC_DATA))

INCOTERMS LOCATION 1

S/4 HANA

LFM1

INCO2_L (INCO2_ID (TMINCO_LOC_DATA))

INCOTERMS LOCATION 1

XREF

Derive via legacy to SyWay S4 Incoterms Location mapping

Conditional. It is validated against relevant Incoterms available in S/4 HANA.  Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 

Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank
Logic: 
If LFM1-INCO1 (incoterms)=   
CFR
CIF
CIP
CPT  
FOB

 INCO2_ID Mandatory and INCO2_L automatically updated from (INCO2_ID) and not editable

12

PF2/WP2

LFM1

INCO3_L (INCO2_L)

INCOTERMS LOCATION 2

S/4 HANA

LFM1

INCO3_L (INCO2_L)

INCOTERMS LOCATION 2

Conditional. It is validated against relevant Inco. location 1 available in S/4 HANA. 
Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank
Logic: 
If LFM1-INCO1 (incoterms)=   
CFR
CIF
CIP
CPT  
FOB 

 INCO2_ID Mandatory and INCO2_L automatically updated from (INCO2_ID) and not editable

13

PF2/WP2

LFM1

KALSK

SCHEMA GROUP SUPPLIER

S/4 HANA

LFM1

KALSK

SCHEMA GROUP SUPPLIER

XREF

Values of the Calculation Schemas already included in the "MM configuration values document"- BP Suppliers tab: 

There are 3 pricing procedures: 
01        Default vendor schema group
02        Vendor schema group Intercomp
03        Schema Group for TM
Based on the supplier the pricing procedure will be determined.

14

PF2/WP2

LFM1

PLIFZ

PLANNED DELIVERY TIME

S/4 HANA

LFM1

PLIFZ

PLANNED DELIVERY TIME

Not Used

15

PF2/WP2

LFM1

LFABC

ABC INDICATOR

S/4 HANA

LFM1

LFABC

ABC INDICATOR

Not used

A-Category A (high-value, most critical): The smallest number of suppliers that account for a large portion of the total spend (e.g., 10-20% of suppliers representing 70-80% of value).
B-Category B (medium-value): The middle group, with moderate spend and value.
C-Category C (low-value, least critical) : The largest group of suppliers that represent a small portion of the total spend.

16

PF2/WP2

LFM1

VSBED

SHIPPING CONDITIONS

S/4 HANA

LFM1

VSBED

SHIPPING CONDITIONS

XREF

Values of the shipping conditions should be included in the "SD configuration values document"

Conditional for the relevant for TM (01- Sea/02-Sea FCL/03-Air/04-Road/05-Road FTL/06- Rail/07- Customer Collection/08- Parcel Standard/10-Parcel Express) 
Others (09- Non TM) - blank.    

Set as Conditional because it must be mandatory only for the BPs that trigger Transportation module. The BP subjected to TM must have it as mandatory (as this field should be inherited to the corresponding POs)
General shipping strategy for the delivery of goods from the supplier to the customer.

17

PF2/WP2

LFM1

WEBRE

GR-BASED INVOICE VERIFICATION

S/4 HANA

LFM1

WEBRE

GR-BASED INVOICE VERIFICATION

Conditional

By default always flag (X), exception for Grouping BPAB/Account Group = LIEF (BP Plants) that should be blank.

18

PF2/WP2

LFM1

KZAUT

AUTOMATIC PURCHASE ORDER

S/4 HANA

LFM1

KZAUT

AUTOMATIC PURCHASE ORDER

Required

By default always flag (X), exception: Suppliers with Carrier role (CRM010) AND Grouping BPAB/Account Group: LIEF (BP Plants) - that should be blank

It is a flag. Always X. 
PO creation without a previous PR is only in TM (supplier has the carrier role)  and IC SO (supplier is a plant)

19

PF2/WP2

LFM1

MEPRF

PRICING DATE CONTROL

S/4 HANA

LFM1

MEPRF

PRICING DATE CONTROL

Conditional 

Direct Mapping

20

PF2/WP2

LFM1

BSTAE

CONFIRMATION CONTROL KEY

S/4 HANA

LFM1

BSTAE

CONFIRMATION CONTROL KEY

XREF 

Valid if the criteria is fit by the supplier. Depending on the way of working (order acknowledgment, shipping notification) of the vendor (few filled in ECC)



21

PF2/WP2

LFM1

KZRET

RETURNS SUPPLIER

S/4 HANA

LFM1

KZRET

RETURNS SUPPLIER

Conditional , Direct Mapping

By default X for all suppliers that supply products. 
Additionally: the customer master record must exists in the system (customer roles) AND the "customer reference" field filled at General Data role.


22

PF2/WP2

LFM1

AUBEL

AUTOMATIC DEBIT

S/4 HANA

LFM1

AUBEL

AUTOMATIC DEBIT

Not Used

23

PF2/WP2

LFM1

VALID_PRO

SETTLEMENT PROFILE

S/4 HANA

LFM1

VALID_PRO

SETTLEMENT PROFILE

Not Used

24

PF2/WP2

LFM1

HSCABS

ABSOLUTE HANDLING SURCHARGE

S/4 HANA

LFM1

HSCABS

ABSOLUTE HANDLING SURCHARGE

Not Used

25

PF2/WP2

LFM1

HSCPE

PERCENTAGE HANDLING SURCHARGE

S/4 HANA

LFM1

HSCPE

PERCENTAGE HANDLING SURCHARGE

Not Used

26

PF2/WP2

LFM1

HSCMIN

MINIMUM HANDLING SURCHARGE

S/4 HANA

LFM1

HSCMIN

MINIMUM HANDLING SURCHARGE

Not Used

27

PF2/WP2

LFM1

HSCMAX

MAXIMUM HANDLING SURCHARGE

S/4 HANA

LFM1

HSCMAX

MAXIMUM HANDLING SURCHARGE

Not Used

28

PF2/WP2

LFM1

XERSY

AUTOM EVALUATED RECEIPT SETTLEMENT (ERS)

S/4 HANA

LFM1

XERSY

AUTOM EVALUATED RECEIPT SETTLEMENT (ERS)

Conditional, Direct Mapping

It is a flag. Valid if the criteria is fit by the supplier.

For the suppliers relevant to ERS - flag X
Others, keep it blank.
The Business could provide the list of the relevant suppliers.

29

PF2/WP2

LFM1

XERSR

AUTOM EVALUATED GR SETTLEMENT RETURN

S/4 HANA

LFM1

XERSR

AUTOM EVALUATED GR SETTLEMENT RETURN

Conditional, Direct Mapping

It is a flag. Valid if the criteria is fit by the supplier.

For the suppliers relevant to ERS - flag X
Others, keep it blank.
The Business could provide the list of the relevant suppliers.

30

PF2/WP2

LFM1

KZABS

ORDER ACKNOWLEDGMENT REQUIREMENT

S/4 HANA

LFM1

KZABS

ORDER ACKNOWLEDGMENT REQUIREMENT

Conditional

By default X - exception Plants (Grouping BPAB/Account Group = LIEF) 


31

PF2/WP2

LFM1

EIKTO

ACCOUNT WITH SUPPLIER

S/4 HANA

LFM1

EIKTO

ACCOUNT WITH SUPPLIER

Not Used

32

PF2/WP2

LFM1

NRGEW

GRANT FREE GOODS

S/4 HANA

LFM1

NRGEW

GRANT FREE GOODS

Not Used

33

PF2/WP2

LFM1

PAPRF

PROACT CONTROL PROFILE

S/4 HANA

LFM1

PAPRF

PROACT CONTROL PROFILE

Not Used

34

PF2/WP2

LFM1

BOLRE

SUBSEQUENT SETTLEMENT

S/4 HANA

LFM1

BOLRE

SUBSEQUENT SETTLEMENT

Not Used

35

PF2/WP2

LFM1

XNBWY

REVALUATION

S/4 HANA

LFM1

XNBWY

REVALUATION

Not Used

36

PF2/WP2

LFM1

VENDOR_RMA_REQ

RMA REQUIRED

S/4 HANA

LFM1

VENDOR_RMA_REQ

RMA REQUIRED

Not Used

37

PF2/WP2

LFM1

PRFRE

PRICE DETERMINATION

S/4 HANA

LFM1

PRFRE

PRICE DETERMINATION

Not Used

38

PF2/WP2

LFM1

BOIND

SUBSEQUENT SETTLEMENT INDICATOR ACTIVE

S/4 HANA

LFM1

BOIND

SUBSEQUENT SETTLEMENT INDICATOR ACTIVE

Not Used

39

PF2/WP2

LFM1

BLIND

DOCUMENT INDEX

S/4 HANA

LFM1

BLIND

DOCUMENT INDEX

TBD

40

PF2/WP2

LFM1

AGREL

RELEVANT FOR SETTLEMENT MANAGEMENT

S/4 HANA

LFM1

AGREL

RELEVANT FOR SETTLEMENT MANAGEMENT

Not Used

41

PF2/WP2

LFM1

LOEVM

DELETION FLAG PURCHASING ORGANIZATION

S/4 HANA

LFM1

LOEVM

DELETION FLAG PURCHASING ORGANIZATION

Not Used

42

PF2/WP2

LFM1

SKRIT

SORT CRITERION

S/4 HANA


SKRIT

SORT CRITERION

Not Used

43

PF2/WP2

LFM1

SPERM

SELECTED PURCHASING ORGANIZATION BLOCK

S/4 HANA

LFM1

SPERM

SELECTED PURCHASING ORGANIZATION BLOCK

Conditional (Not in LTMC - S/4 HANA Template)

Set X in case block is needed for posting / purchasing  purposes. 

44

PF2/WP2

LFM1

MRPPP

PLANNING CALENDAR

S/4 HANA

LFM1

MRPPP

PLANNING CALENDAR

Not Used

45

PF2/WP2

LFM1

LFRHY

PLANNING CYCLE

S/4 HANA

LFM1

LFRHY

PLANNING CYCLE

Not Used

46

PF2/WP2

LFM1

BOPNR

ORDER OPTIMIZATION RESTRICTION

S/4 HANA

LFM1

BOPNR

ORDER OPTIMIZATION RESTRICTION

Not Used

47

PF2/WP2

LFM1

LIBES

ORDER ENTRY BY SUPPLIER

S/4 HANA

LFM1

LIBES

ORDER ENTRY BY SUPPLIER

Not Used

48

PF2/WP2

LFM1

LIPRE

PRICE MARKING SUPPLIER

S/4 HANA

LFM1

LIPRE

PRICE MARKING SUPPLIER

Not Used

49

PF2/WP2

LFM1

LISER

RACK JOBBING

S/4 HANA

LFM1

LISER

RACK JOBBING

Not Used

50

PF2/WP2

LFA1

XZEMP

INDICATOR: ALTERNATIVE PAYEE IN DOCUMENT ALLOWED?

S/4 HANA

LFM1

XZEMP

INDICATOR: ALTERNATIVE PAYEE IN DOCUMENT ALLOWED?

Not Used Part of LFA1


51

PF2/WP2

LFM1

 ZOLLA

CUSTOMS OFFICE: OFFICE OF EXIT/ENTRY FOR FOREIGN TRADE

S/4 HANA

LFM1

 ZOLLA

CUSTOMS OFFICE: OFFICE OF EXIT/ENTRY FOR FOREIGN TRADE

Conditional (Not in LTMC - S/4 HANA Template)

Direct Mapping

Valid for Eugenia Tataru - GTS

52

PF2/WP2

LFM1

INCO3_L

INCOTERMS LOCATION 2

S/4 HANA

LFM1

INCO3_L

INCOTERMS LOCATION 2

Not Used

53

PF2/WP2

LFM1

RDPRF

ROUNDING PROFILE

S/4 HANA

LFM1

RDPRF

ROUNDING PROFILE

Not Used

54

PF2/WP2

LFM1

MEGRU

UNIT OF MEASURE GROUP

S/4 HANA

LFM1

MEGRU

UNIT OF MEASURE GROUP

Not Used

55

PF2/WP2

LFM1

ABUEB

RELEASE CREATION PROFILE

S/4 HANA

LFM1

ABUEB

RELEASE CREATION PROFILE

Not Used

56

PF2/WP2

LFM1

LFM1_EEW_PS

DATA ELEMENT EXTENSIBILITY FOR PURCHASE

S/4 HANA

LFM1

LFM1_EEW_PS

DATA ELEMENT EXTENSIBILITY FOR PURCHASE

Not Used

57

PF2/WP2

LFM1

J_1NBOESL

EXCHANGE KEY FOR NF PROCESSING

S/4 HANA

LFM1

J_1NBOESL

EXCHANGE KEY FOR NF PROCESSING

Conditional

Direct Mapping

58

PF2/WP2

LFM1

FSH_SC_CID

CUSTOMER/SUPPLIER IDENTIFIER

S/4 HANA

LFM1

FSH_SC_CID

CUSTOMER/SUPPLIER IDENTIFIER

Not Used

59

PF2/WP2

LFM1

FSH_VAS_DETC

VAS DETERMINATION MODE

S/4 HANA

LFM1

FSH_VAS_DETC

VAS DETERMINATION MODE

Not Used

60

PF2/WP2

LFM1

UPPRS

PRICING ON SUBITEMS (MPN/SUS)

S/4 HANA

LFM1

UPPRS

PRICING ON SUBITEMS (MPN/SUS)

Not Used

61

PF2/WP2

LFM1

ACTIVITY_PROFIL

ACTIVITY PROFILE FOR PO CONTROLLING

S/4 HANA

LFM1

ACTIVITY_PROFIL

ACTIVITY PROFILE FOR PO CONTROLLING

Not Used

62

PF2/WP2

LFM1

TRANSPORT_CHAIN

TRANSPORTATION CHAIN

S/4 HANA

LFM1

TRANSPORT_CHAIN

TRANSPORTATION CHAIN

Not Used

63

PF2/WP2

LFM1

STAGING_TIME

STAGING TIME IN DAYS

S/4 HANA

LFM1

STAGING_TIME

STAGING TIME IN DAYS

Not Used

64

PF2/WP2

LFM1

EXPVZ

MODE OF TRANSPORT AT THE BORDER (INTRAST

S/4 HANA

LFM1

EXPVZ

MODE OF TRANSPORT AT THE BORDER (INTRAST

Not Used

65

PF2/WP2

LFM1

VENSL

SUPPLIER SERVICE LEVEL

S/4 HANA

LFM1

VENSL

SUPPLIER SERVICE LEVEL

Not Used

66

PF2/WP2

LFM1

LEBRE

SERVICE - BASED INVOICE VERIFICATION

S/4 HANA

LFM1

LEBRE

SERVICE - BASED INVOICE VERIFICATION

Required (Not in LTMC - S/4 HANA Template)

Default to 'X'

67

PF2/WP2

LFM1

UMSAE

COMPARISON AND AGREEMENT OF BUSINESS VOLUMES

S/4 HANA

LFM1

UMSAE

COMPARISON AND AGREEMENT OF BUSINESS VOLUMES

Not Used

68

PF2/WP2

LFM2

LIFNR

VENDOR NUMBER

S/4 HANA

LFMLFM12

LIFNR

SUPPLIER NUMBER

XREF

Derive via legacy to SyWay S4 Business Partner mapping

Supplier Automatically created by the system.

for Plant level Purchasing data to be populated in LFM2 :

1) Plant-level flag should be ticked 

2) VSR flag should be maintained - Please check 

69

PF2/WP2

LFM2

EKORG

PURCHASING ORGANISATION

S/4 HANA

LFM2

EKORG

PURCHASING ORGANISATION

XREF

Derive via legacy to SyWay 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.

70

PF2/WP2

LFM2

LTSNR

SUPPL. SUBRANGE

S/4 HANA

LFM2

LTSNR

SUPPL. SUBRANGE

Required

Default value is " "

71

PF2/WP2

LFM2

WERKS

PLANT*

S/4 HANA

LFM2

WERKS

PLANT*

Required

Key that uniquely identifies a plant. 
GENERAL RULE: All the fields equal to the fields coming from LFM1 (the only one field that could be different is "Customs Office: Office of Exit/Entry for Foreign Trade (LFM2- ZOLLA)

72

PF2/WP2

 WRF02K(TBC)

HINZE

Indicator: plant level relevant - Purchasing Data

S/4 HANA

  WRF02K(TBC)

HINZE

Indicator: plant level relevant - Purchasing Data

Required

For Plant level Purchasing data to be populated in LFM2 - Indicator: plant level relevant - Purchasing Flag should be ticked ("X")

73

PF2/WP2

  WRF02K(TBC)

HINZP

Indicator: plant level relevant - Partner Functions

S/4 HANA

 WRF02K(TBC)

HINZP

Indicator: plant level relevant - Partner Functions

Required

For Plant level Purchasing data to be populated in LFM2 - Indicator: plant level relevant - Partner Functions Flag should be ticked ("X")

74

PF2/WP2

LFM2

EKGRP

PURCHASING GROUP

S/4 HANA

LFM2

EKGRP

PURCHASING GROUP

XREF

Derive via legacy to SyWay S4 Purchasing Group mapping

It is validated against relevant Purchasing Groups available in S/4 HANA.

75

PF2/WP2

LFM2

WAERS

ORDER CURRENCY

S/4 HANA

LFM2

WAERS

ORDER CURRENCY

XREF

Derive via legacy to SyWay S4 Purchasing Currency code mapping

76

PF2/WP2

LFM2

VERKF

SALESPERSON

S/4 HANA

LFM2

VERKF

SALESPERSON

Not Used

It is free text in S4HANA.

77

PF2/WP2

LFM2

TELF1

TELEPHONE

S/4 HANA

LFM2

TELF1

TELEPHONE

Not Used

78

PF2/WP2

LFM2

MINBW

MINIMUM ORDER VALUE

S/4 HANA

LFM2

MINBW

MINIMUM ORDER VALUE

Not Used

79

PF2/WP2

LFM2

ZTERM

PAYMENT TERMS

S/4 HANA

LFM2

ZTERM

PAYMENT TERMS

XREF

Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 

In the PO - in case we have PIR/CTR will come from here.
Otherwise, it will take it from the BP. S4HANA.

80

PF2/WP2

LFM2

INCOV

INCO VERSION

S/4 HANA

LFM2

INCOV

INCO VERSION

Not Used

81

PF2/WP2

LFM2

INCO1

INCOTERMS

S/4 HANA

LFM2

INCO1

INCOTERMS

XREF

Derive via legacy to SyWay S4 Incoterms mapping

Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 

Set as Conditional because it must be mandatory only for the BPs that trigger Transportation module. The BP subjected to TM must have it as mandatory (as this field should be inherited to the corresponding POs)

Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank

82

PF2/WP2

LFM2

INCO2_L (INCO2_ID (TMINCO_LOC_DATA))

INCOTERMS LOCATION 1

S/4 HANA

LFM2

INCO2_L (INCO2_ID (TMINCO_LOC_DATA))

INCOTERMS LOCATION 1

XREF

Derive via legacy to SyWay S4 Incoterms Location mapping

Conditional. It is validated against relevant Incoterms available in S/4 HANA.  Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 

Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank
Logic: 
If LFM1-INCO1 (incoterms)=   
CFR
CIF
CIP
CPT  
FOB

 INCO2_ID Mandatory and INCO2_L automatically updated from (INCO2_ID) and not editable

83

PF2/WP2

LFM2

KALSK

SCHEMA GROUP SUPPLIER

S/4 HANA

LFM2

KALSK

SCHEMA GROUP SUPPLIER

XREF

Values of the Calculation Schemas already included in the "MM configuration values document"- BP Suppliers tab: 

There are 3 pricing procedures: 
01        Default vendor schema group
02        Vendor schema group Intercomp
03        Schema Group for TM
Based on the supplier the pricing procedure will be determined.

84

PF2/WP2

LFM2

PLIFZ

PLANNED DELIVERY TIME

S/4 HANA

LFM2

PLIFZ

PLANNED DELIVERY TIME

Not Used

85

PF2/WP2

LFM2

LFABC

ABC INDICATOR

S/4 HANA

LFM2

LFABC

ABC INDICATOR

Not used

A-Category A (high-value, most critical): The smallest number of suppliers that account for a large portion of the total spend (e.g., 10-20% of suppliers representing 70-80% of value).
B-Category B (medium-value): The middle group, with moderate spend and value.
C-Category C (low-value, least critical) : The largest group of suppliers that represent a small portion of the total spend.

86

PF2/WP2

LFM2

WEBRE

GR-BASED INVOICE VERIFICATION

S/4 HANA

LFM2

WEBRE

GR-BASED INVOICE VERIFICATION

Conditional

By default always flag (X), exception for Grouping BPAB/Account Group = LIEF (BP Plants) that should be blank.

87

PF2/WP2

LFM2

KZAUT

AUTOMATIC PURCHASE ORDER

S/4 HANA

LFM2

KZAUT

AUTOMATIC PURCHASE ORDER

Required

By default always flag (X), exception: Suppliers with Carrier role (CRM010) AND Grouping BPAB/Account Group: LIEF (BP Plants) - that should be blank

It is a flag. Always X. 
PO creation without a previous PR is only in TM (supplier has the carrier role)  and IC SO (supplier is a plant)

88

PF2/WP2

LFM2

MEPRF

PRICING DATE CONTROL

S/4 HANA

LFM2

MEPRF

PRICING DATE CONTROL

Conditional 

Direct Mapping

89

PF2/WP2

LFM2

BSTAE

CONFIRMATION CONTROL KEY

S/4 HANA

LFM2

BSTAE

CONFIRMATION CONTROL KEY

Conditional, Direct Mapping

Valid if the criteria is fit by the supplier. Depending on the way of working (order acknowledgment, shipping notification) of the vendor (few filled in ECC)



90

PF2/WP2

LFM2

XERSY

AUTOM EVALUATED RECEIPT SETTLEMENT (ERS)

S/4 HANA

LFM2

XERSY

AUTOM EVALUATED RECEIPT SETTLEMENT (ERS)

Conditional, Direct Mapping

It is a flag. Valid if the criteria is fit by the supplier.

For the suppliers relevant to ERS - flag X
Others, keep it blank.
The Business could provide the list of the relevant suppliers.

91

PF2/WP2

LFM2

XERSR

AUTOM EVALUATED GR SETTLEMENT RETURN

S/4 HANA

LFM2

XERSR

AUTOM EVALUATED GR SETTLEMENT RETURN

Conditional, Direct Mapping

It is a flag. Valid if the criteria is fit by the supplier.

For the suppliers relevant to ERS - flag X
Others, keep it blank.
The Business could provide the list of the relevant suppliers.

92

PF2/WP2

LFM2

KZABS

ORDER ACKNOWLEDGMENT REQUIREMENT

S/4 HANA

LFM2

KZABS

ORDER ACKNOWLEDGMENT REQUIREMENT

Conditional

By default X - exception Plants (Grouping BPAB/Account Group = LIEF) 


93

PF2/WP2

LFM2

PAPRF

PROACT CONTROL PROFILE

S/4 HANA

LFM2

PAPRF

PROACT CONTROL PROFILE

Not Used

94

PF2/WP2

LFM2

BOLRE

SUBSEQUENT SETTLEMENT

S/4 HANA

LFM2

BOLRE

SUBSEQUENT SETTLEMENT

Not Used

95

PF2/WP2

LFM2

XNBWY

REVALUATION

S/4 HANA

LFM2

XNBWY

REVALUATION

Not Used

96

PF2/WP2

LFM2

PRFRE

PRICE DETERMINATION

S/4 HANA

LFM2

PRFRE

PRICE DETERMINATION

Not Used

97

PF2/WP2

LFM2

BOIND

SUBSEQUENT SETTLEMENT INDICATOR ACTIVE

S/4 HANA

LFM2

BOIND

SUBSEQUENT SETTLEMENT INDICATOR ACTIVE

Not Used

98

PF2/WP2

LFM2

LOEVM

DELETION FLAG PURCHASING ORGANIZATION

S/4 HANA

LFM2

LOEVM

DELETION FLAG PURCHASING ORGANIZATION

Not Used

99

PF2/WP2

LFM2

SPERM

SELECTED PURCHASING ORGANIZATION BLOCK

S/4 HANA

LFM2

SPERM

SELECTED PURCHASING ORGANIZATION BLOCK

Conditional (Not in LTMC - S/4 HANA Template)

Set X in case block is needed for posting / purchasing  purposes.

100

PF2/WP2

LFM2

MRPPP

PLANNING CALENDAR

S/4 HANA

LFM2

MRPPP

PLANNING CALENDAR

Not Used

101

PF2/WP2

LFM2

LFRHY

PLANNING CYCLE

S/4 HANA

LFM2

LFRHY

PLANNING CYCLE

Not Used

102

PF2/WP2

LFM2

BOPNR

ORDER OPTIMIZATION RESTRICTION

S/4 HANA

LFM2

BOPNR

ORDER OPTIMIZATION RESTRICTION

Not Used

103

PF2/WP2

LFM2

LIBES

ORDER ENTRY BY SUPPLIER

S/4 HANA

LFM2

LIBES

ORDER ENTRY BY SUPPLIER

Not Used

104

PF2/WP2

LFM2

LIPRE

PRICE MARKING SUPPLIER

S/4 HANA

LFM2

LIPRE

PRICE MARKING SUPPLIER

Not Used

105

PF2/WP2

LFM2

LISER

RACK JOBBING

S/4 HANA

LFM2

LISER

RACK JOBBING

Not Used

106

PF2/WP2

LFM2

 ZOLLA

CUSTOMS OFFICE: OFFICE OF EXIT/ENTRY FOR FOREIGN TRADE

S/4 HANA

LFM2

 ZOLLA

CUSTOMS OFFICE: OFFICE OF EXIT/ENTRY FOR FOREIGN TRADE

Conditional (Not in LTMC - S/4 HANA Template)

Direct Mapping

Valid for Eugenia Tataru - GTS

107

PF2/WP2

LFM2

INCO3_L

INCOTERMS LOCATION 2

S/4 HANA

LFM2

INCO3_L

INCOTERMS LOCATION 2

Not Used

108

PF2/WP2

LFM2

RDPRF

ROUNDING PROFILE

S/4 HANA

LFM2

RDPRF

ROUNDING PROFILE

Not Used

109

PF2/WP2

LFM2

MEGRU

UNIT OF MEASURE GROUP

S/4 HANA

LFM2

MEGRU

UNIT OF MEASURE GROUP

Not Used

110

PF2/WP2

LFM2

ABUEB

RELEASE CREATION PROFILE

S/4 HANA

LFM2

ABUEB

RELEASE CREATION PROFILE

Not Used

111

PF2/WP2

LFM2

TRANSPORT_CHAIN

TRANSPORTATION CHAIN

S/4 HANA

LFM2

TRANSPORT_CHAIN

TRANSPORTATION CHAIN

Not Used

112

PF2/WP2

LFM2

STAGING_TIME

STAGING TIME IN DAYS

S/4 HANA

LFM2

STAGING_TIME

STAGING TIME IN DAYS

Not Used

113

PF2/WP2

LFM2

EXPVZ

MODE OF TRANSPORT AT THE BORDER (INTRAST

S/4 HANA

LFM2

EXPVZ

MODE OF TRANSPORT AT THE BORDER (INTRAST

Not Used

114

PF2/WP2

LFM2

LEBRE

SERVICE - BASED INVOICE VERIFICATION

S/4 HANA

LFM2

LEBRE

SERVICE - BASED INVOICE VERIFICATION

Required (Not in LTMC - S/4 HANA Template)

Default to 'X'

115

PF2/WP2

LFM2

UMSAE

COMPARISON AND AGREEMENT OF BUSINESS VOLUMES

S/4 HANA

LFM2

UMSAE

COMPARISON AND AGREEMENT OF BUSINESS VOLUMES

Not Used

116

PF2/WP2

LFM2

WEORA

ORIGIN ACCEPTANCE

S/4 HANA

LFM2

WEORA

ORIGIN ACCEPTANCE

Not Used

117

PF2/WP2

WYT3

LIFNR

VENDOR

S/4 HANA

WYT3

LIFNR

SUPPLIER

Required

Derive via legacy to SyWay S4 Business Partner mapping

Supplier Automatically created by the system.

118

PF2/WP2

WYT3

PARVW

PARTNER FUNCTION

S/4 HANA

WYT3

PARVW

PARTNER FUNCTION

XREF

Customizing. Values of the partner functions already included in the "MM configuration values document"- BP Suppliers tab: 
Values confirmed: 
VN        Vendor
PI        Invoicing Party
GS        Goods supplier
OA        Ordering address

ZA - TMS4S: the value will be the same Main BP code

ZB - BN4L: the value will be the same Main BP code

ZC - Transwide : the value will be the same Main BP code

In case of CASS-> PI partner function with BP code equal to the Main BP can be used- Note: currently it will be only maintained when the email address is different in case of legal entity (Different BP code)

Note: Contact person must be included in the Returns Supplier for invoicing - VIM requirement)
The abbreviated form of the name that identifies the partner function.

 The UI the partner function is displayed language-dependent.

119

PF2/WP2

WYT3

LIFN2

REF TO VENDOR

S/4 HANA

WYT3

LIFN2

REF TO VENDOR

Conditional

Fill it in case Partner function is VN, OA,PI,GS,,ZA, ZB, ZC

This partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory.

120

PF2/WP2

WYT3

PERNR

PERSONAL NO

S/4 HANA

WYT3

PERNR

PERSONAL NO

Not Used

121

PF2/WP2

WYT3

PARNR

CONTACT PERSON

S/4 HANA

WYT3

PARNR

CONTACT PERSON

Conditional

Fill it in case Partner function is CP

122

PF2/WP2

WYT3

DEFPA

DEFAULT PARTNER

S/4 HANA

WYT3

DEFPA

DEFAULT PARTNER

Conditional

Direct mapping



123

PF2/WP2

WYT3

EKORG

PURCHASING ORGANIZATION

S/4 HANA

WYT3

EKORG

PURCHASING ORGANIZATION

XREF

Derive via legacy to SyWay S4 Purchasing Organization mapping

Values of the Purchase Organizations already included in the "MM configuration values document"- Enterprise Structure tab: 

124

PF2/WP2

WYT3

LTSNRSupplier Subrange

S/4 HANA

WYT3

LTSNRSupplier Subrange

Not used

125

PF2/WP2

WYT3

WERKS

Plant

S/4 HANA

WYT3

WERKS

Plant

Not used

126

PF2/WP2

S_LFM1_TEXTLIFNRSupplier*

S/4 HANA

S_LFM1_TEXTLIFNRSupplier*

XREF

Supplier* - Key field only in case supplier maintains texts

127

PF2/WP2

S_LFM1_TEXTEKORGPurchasing Organization*

S/4 HANA

S_LFM1_TEXTEKORGPurchasing Organization*

XREF

An organizational unit in Logistics, subdividing an enterprise according to the requirements of Purchasing. -  - Key field only in case supplier maintains texts


128

PF2/WP2

STXHTDIDText ID

S/4 HANA

STXHTDIDText ID

Conditional

Fill when additional texts need to be stored, selecting the relevant text type (e.g., notes, instructions, vip remarks). 
Otherwise, blank

129

PF2/WP2

STXHTDSPRASLanguage

S/4 HANA

STXHTDSPRASLanguage

XREF

Check table: T002
Fill when additional texts need to be stored.
Otherwise, blank

130

PF2/WP2

STXH/STXKTEXT_LINES(LTEXT)Long text

S/4 HANA

STXH/STXKTEXT_LINES(LTEXT)Long text

Conditional

Fill when additional texts need to be stored, selecting the relevant text type (e.g., notes, instructions, vip remarks). 
Otherwise, blank


DCT Build Tables including the transformation logic:

Target Ready Data Collection Template will be created for the Vendors Purchasing Organization:

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTDCTLIFNRVENDOR NUMBERS/4 HANALFM1LIFNRSUPPLIER NUMBER

XREF

Derive via legacy to SyWay S4 Business Partner mapping

Supplier Automatically created by the system.

2DCTDCTEKORGPURCHASING ORGANISATIONS/4 HANALFM1EKORGPURCHASING ORGANISATIONXREF
Derive via legacy to SyWay 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.
3DCTDCTEKGRPPURCHASING GROUPS/4 HANALFM1EKGRPPURCHASING GROUPXREF
Derive via legacy to SyWay S4 Purchasing Group mapping
It is validated against relevant Purchasing Groups available in S/4 HANA.
4DCTDCTWAERSORDER CURRENCYS/4 HANALFM1WAERSORDER CURRENCYXREF
Derive via legacy to SyWay S4 Purchasing Currency code mapping
5DCTDCTZTERMPAYMENT TERMSS/4 HANALFM1ZTERMPAYMENT TERMSXREF
Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 
In the PO - in case we have PIR/CTR will come from here.
Otherwise, it will take it from the BP. S4HANA.
6DCTDCTINCO1INCOTERMSS/4 HANALFM1INCO1INCOTERMSXREF
Derive via legacy to SyWay S4 Incoterms mapping
Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 
Set as Conditional because it must be mandatory only for the BPs that trigger Transportation module. The BP subjected to TM must have it as mandatory (as this field should be inherited to the corresponding POs)
Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank
7DCTDCTINCO2_L (INCO2_ID (TMINCO_LOC_DATA))INCOTERMS LOCATION 1S/4 HANALFM1INCO2_L (INCO2_ID (TMINCO_LOC_DATA))INCOTERMS LOCATION 1XREF
Derive via legacy to SyWay S4 Incoterms Location mapping
Conditional. It is validated against relevant Incoterms available in S/4 HANA.  Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 
Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank
Logic: 
If LFM1-INCO1 (incoterms)=   
CFR
CIF
CIP
CPT  
FOB
 INCO2_ID Mandatory and INCO2_L automatically updated from (INCO2_ID) and not editable
8DCTDCTKALSKSCHEMA GROUP SUPPLIERS/4 HANALFM1KALSKSCHEMA GROUP SUPPLIERXREF
Values of the Calculation Schemas already included in the "MM configuration values document"- BP Suppliers tab: 
There are 3 pricing procedures: 
01        Default vendor schema group
02        Vendor schema group Intercomp
03        Schema Group for TM
Based on the supplier the pricing procedure will be determined.
9DCTDCTVSBEDSHIPPING CONDITIONSS/4 HANALFM1VSBEDSHIPPING CONDITIONSXREF
Values of the shipping conditions should be included in the "SD configuration values document"
Conditional for the relevant for TM (01- Sea/02-Sea FCL/03-Air/04-Road/05-Road FTL/06- Rail/07- Customer Collection/08- Parcel Standard/10-Parcel Express) 
Others (09- Non TM) - blank.    
Set as Conditional because it must be mandatory only for the BPs that trigger Transportation module. The BP subjected to TM must have it as mandatory (as this field should be inherited to the corresponding POs)
General shipping strategy for the delivery of goods from the supplier to the customer.
10DCTDCTWEBREGR-BASED INVOICE VERIFICATIONS/4 HANALFM1WEBREGR-BASED INVOICE VERIFICATIONConditional
By default always flag (X), exception for Grouping BPAB/Account Group = LIEF (BP Plants) that should be blank.
11DCTDXTKZAUTAUTOMATIC PURCHASE ORDERS/4 HANALFM1KZAUTAUTOMATIC PURCHASE ORDERRequired
By default always flag (X), exception: Suppliers with Carrier role (CRM010) AND Grouping BPAB/Account Group: LIEF (BP Plants) - that should be blank
It is a flag. Always X. 
PO creation without a previous PR is only in TM (supplier has the carrier role)  and IC SO (supplier is a plant)
12DCTDCTMEPRFPRICING DATE CONTROLS/4 HANALFM1MEPRFPRICING DATE CONTROLConditional 
Direct Mapping
13DCTDCTBSTAECONFIRMATION CONTROL KEYS/4 HANALFM1BSTAECONFIRMATION CONTROL KEYXREF 
Valid if the criteria is fit by the supplier. Depending on the way of working (order acknowledgment, shipping notification) of the vendor (few filled in ECC)
14DCTDCTKZRETRETURNS SUPPLIERS/4 HANALFM1KZRETRETURNS SUPPLIERConditional , Direct Mapping
By default X for all suppliers that supply products. 
Additionally: the customer master record must exists in the system (customer roles) AND the "customer reference" field filled at General Data role.
15DCTDCTXERSYAUTOM EVALUATED RECEIPT SETTLEMENT (ERS)S/4 HANALFM1XERSYAUTOM EVALUATED RECEIPT SETTLEMENT (ERS)Conditional, Direct Mapping
It is a flag. Valid if the criteria is fit by the supplier.
For the suppliers relevant to ERS - flag X
Others, keep it blank.
The Business could provide the list of the relevant suppliers.
16DCTDCTXERSRAUTOM EVALUATED GR SETTLEMENT RETURNS/4 HANALFM1XERSRAUTOM EVALUATED GR SETTLEMENT RETURNConditional, Direct Mapping
It is a flag. Valid if the criteria is fit by the supplier.
For the suppliers relevant to ERS - flag X
Others, keep it blank.
The Business could provide the list of the relevant suppliers.
17DCTDCTKZABSORDER ACKNOWLEDGMENT REQUIREMENTS/4 HANALFM1KZABSORDER ACKNOWLEDGMENT REQUIREMENTConditional
By default X - exception Plants (Grouping BPAB/Account Group = LIEF) 
18DCTDCTBLINDDOCUMENT INDEXS/4 HANALFM1BLINDDOCUMENT INDEXTBD
19DCTDCTSPERMSELECTED PURCHASING ORGANIZATION BLOCKS/4 HANALFM1SPERMSELECTED PURCHASING ORGANIZATION BLOCKConditional (Not in LTMC - S/4 HANA Template)

Set X in case block is needed for posting / purchasing  purposes.

20DCTDCT ZOLLACUSTOMS OFFICE: OFFICE OF EXIT/ENTRY FOR FOREIGN TRADES/4 HANALFM1 ZOLLACUSTOMS OFFICE: OFFICE OF EXIT/ENTRY FOR FOREIGN TRADEConditional (Not in LTMC - S/4 HANA Template)
Direct Mapping
Valid for Eugenia Tataru - GTS
21DCTDCTJ_1NBOESLEXCHANGE KEY FOR NF PROCESSINGS/4 HANALFM1J_1NBOESLEXCHANGE KEY FOR NF PROCESSINGConditional
Direct Mapping
22DCTDCTLEBRESERVICE - BASED INVOICE VERIFICATIONS/4 HANALFM1LEBRESERVICE - BASED INVOICE VERIFICATIONRequired (Not in LTMC - S/4 HANA Template)
Default to 'X'

 .Target Ready Data Collection Template will be created for the Vendors Purchasing Organization Partner Functions::

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTDCTLIFNRVENDORS/4 HANAWYT3LIFNRSUPPLIERRequired
Derive via legacy to SyWay S4 Business Partner mapping
Supplier Automatically created by the system.
2DCTDCTEKORGPURCHASING ORGANIZATIONS/4 HANAWYT3EKORGPURCHASING ORGANIZATIONRequired
Derive via legacy to SyWay S4 Purchasing Organization mapping
Values of the Purchase Organizations already included in the "MM configuration values document"- Enterprise Structure tab: 
3PF2/WP2WYT3PARVWPARTNER FUNCTIONS/4 HANAWYT3PARVWPARTNER FUNCTION

XREF

Customizing. Values of the partner functions already included in the "MM configuration values document"- BP Suppliers tab: 
Values confirmed: 
VN        Vendor
PI        Invoicing Party
GS        Goods supplier
OA        Ordering address

ZA - TMS4S: the value will be the same Main BP code

ZB - BN4L: the value will be the same Main BP code

ZC - Transwide : the value will be the same Main BP code

In case of CASS-> PI partner function with BP code equal to the Main BP can be used- Note: currently it will be only maintained when the email address is different in case of legal entity (Different BP code)

Note: Contact person must be included in the Returns Supplier for invoicing - VIM requirement)
The abbreviated form of the name that identifies the partner function.

 The UI the partner function is displayed language-dependent.

4DCTDCTLIFN2REF TO VENDORS/4 HANAWYT3LIFN2REF TO VENDOR

Conditional

Conditional

Fill it in case Partner function is VN, OA,PI,GS,,ZA, ZB, ZC

This partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory.

5DCTDCTPARNRCONTACT PERSONS/4 HANAWYT3PARNRCONTACT PERSONConditional
Fill it in case Partner function is CP
6DCTDCTDEFPADEFAULT PARTNERS/4 HANAWYT3DEFPADEFAULT PARTNERConditional
Direct mapping


 Target Ready Data Collection Template will be created for the Vendors Plant Specific Purchasing Organization:

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTDCTLIFNRVENDOR NUMBERS/4 HANALFM2LIFNRSUPPLIER NUMBERXREF


Derive via legacy to SyWay S4 Business Partner mapping


Supplier Automatically created by the system.
2DCTDCTEKORGPURCHASING ORGANISATIONS/4 HANALFM2EKORGPURCHASING ORGANISATIONXREF
Derive via legacy to SyWay 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.
3PF2/WP2LFM2LTSNRSUPPL. SUBRANGES/4 HANALFM2LTSNRSUPPL. SUBRANGERequired
Default value is " "
4PF2/WP2LFM2WERKSPLANT*S/4 HANALFM2WERKSPLANT*Required
Key that uniquely identifies a plant. 
GENERAL RULE: All the fields equal to the fields coming from LFM1 (the only one field that could be different is "Customs Office: Office of Exit/Entry for Foreign Trade (LFM2- ZOLLA)
5PF2/WP2 WRF02KHINZEIndicator: plant level relevant - Purchasing DataS/4 HANA WRF02KHINZEIndicator: plant level relevant - Purchasing DataRequired
For Plant level Purchasing data to be populated in LFM2 - Indicator: plant level relevant - Purchasing Flag should be ticked ("X")
6DCT DCTHINZPIndicator: plant level relevant - Partner FunctionsS/4 HANA WRF02KHINZPIndicator: plant level relevant - Partner FunctionsRequired
For Plant level Purchasing data to be populated in LFM2 - Indicator: plant level relevant - Partner Functions Flag should be ticked ("X")









It is validated against relevant Purchasing Groups available in S/4 HANA.
7DCTDCTWAERSORDER CURRENCYS/4 HANALFM2WAERSORDER CURRENCYXREF
Derive via legacy to SyWay S4 Purchasing Currency code mapping
8DCTDCTZTERMPAYMENT TERMSS/4 HANALFM2ZTERMPAYMENT TERMSXREF
Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 
In the PO - in case we have PIR/CTR will come from here.
Otherwise, it will take it from the BP. S4HANA.
9DCTDCTINCO1INCOTERMSS/4 HANALFM2INCO1INCOTERMSXREF
Derive via legacy to SyWay S4 Incoterms mapping
Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 
Set as Conditional because it must be mandatory only for the BPs that trigger Transportation module. The BP subjected to TM must have it as mandatory (as this field should be inherited to the corresponding POs)
Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank
10DCTDCTINCO2_L (INCO2_ID (TMINCO_LOC_DATA))INCOTERMS LOCATION 1S/4 HANALFM2INCO2_L (INCO2_ID (TMINCO_LOC_DATA))INCOTERMS LOCATION 1XREF
Derive via legacy to SyWay S4 Incoterms Location mapping
Conditional. It is validated against relevant Incoterms available in S/4 HANA.  Customizing. Values of the payment terms already included in the "MM configuration values document"- BP Suppliers tab: 
Fill always when the BP has Carrier Role (CRM010)
Otherwise, blank
Logic: 
If LFM1-INCO1 (incoterms)=   
CFR
CIF
CIP
CPT  
FOB
 INCO2_ID Mandatory and INCO2_L automatically updated from (INCO2_ID) and not editable
11DCTDCTKALSKSCHEMA GROUP SUPPLIERS/4 HANALFM2KALSKSCHEMA GROUP SUPPLIERXREF
Values of the Calculation Schemas already included in the "MM configuration values document"- BP Suppliers tab: 
There are 3 pricing procedures: 
01        Default vendor schema group
02        Vendor schema group Intercomp
03        Schema Group for TM
Based on the supplier the pricing procedure will be determined.
12DCTDCTWEBREGR-BASED INVOICE VERIFICATIONS/4 HANALFM2WEBREGR-BASED INVOICE VERIFICATIONConditional
By default always flag (X), exception for Grouping BPAB/Account Group = LIEF (BP Plants) that should be blank.
13DCTDXTKZAUTAUTOMATIC PURCHASE ORDERS/4 HANALFM2KZAUTAUTOMATIC PURCHASE ORDERRequired
By default always flag (X), exception: Suppliers with Carrier role (CRM010) AND Grouping BPAB/Account Group: LIEF (BP Plants) - that should be blank
It is a flag. Always X. 
PO creation without a previous PR is only in TM (supplier has the carrier role)  and IC SO (supplier is a plant)
14DCTDCTMEPRFPRICING DATE CONTROLS/4 HANALFM2MEPRFPRICING DATE CONTROLConditional 
Direct Mapping
15DCTDCTBSTAECONFIRMATION CONTROL KEYS/4 HANALFM2BSTAECONFIRMATION CONTROL KEYXREF 
Valid if the criteria is fit by the supplier. Depending on the way of working (order acknowledgment, shipping notification) of the vendor (few filled in ECC)
16DCTDCTXERSYAUTOM EVALUATED RECEIPT SETTLEMENT (ERS)S/4 HANALFM2XERSYAUTOM EVALUATED RECEIPT SETTLEMENT (ERS)Conditional, Direct Mapping
It is a flag. Valid if the criteria is fit by the supplier.
For the suppliers relevant to ERS - flag X
Others, keep it blank.
The Business could provide the list of the relevant suppliers.
17DCTDCTXERSRAUTOM EVALUATED GR SETTLEMENT RETURNS/4 HANALFM2XERSRAUTOM EVALUATED GR SETTLEMENT RETURNConditional, Direct Mapping
It is a flag. Valid if the criteria is fit by the supplier.
For the suppliers relevant to ERS - flag X
Others, keep it blank.
The Business could provide the list of the relevant suppliers.
18DCTDCTKZABSORDER ACKNOWLEDGMENT REQUIREMENTS/4 HANALFM2KZABSORDER ACKNOWLEDGMENT REQUIREMENTConditional
By default X - exception Plants (Grouping BPAB/Account Group = LIEF) 
19DCTDCTSPERMSELECTED PURCHASING ORGANIZATION BLOCKS/4 HANALFM2SPERMSELECTED PURCHASING ORGANIZATION BLOCKConditional (Not in LTMC - S/4 HANA Template)

Set X in case block is needed for posting / purchasing  purposes.

20DCTDCT ZOLLACUSTOMS OFFICE: OFFICE OF EXIT/ENTRY FOR FOREIGN TRADES/4 HANALFM2 ZOLLACUSTOMS OFFICE: OFFICE OF EXIT/ENTRY FOR FOREIGN TRADEConditional (Not in LTMC - S/4 HANA Template)
Direct Mapping
Valid for Eugenia Tataru - GTS
21DCTDCTLEBRESERVICE - BASED INVOICE VERIFICATIONS/4 HANALFM2LEBRESERVICE - BASED INVOICE VERIFICATIONRequired (Not in LTMC - S/4 HANA Template)
Default to 'X'


Target Ready Data Collection Template will be created for the Vendors Plant Specific Purchasing Organization Partner Functions::

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTDCTLIFNRVENDORS/4 HANAWYT3LIFNRSUPPLIERRequired
Derive via legacy to SyWay S4 Business Partner mapping
Supplier Automatically created by the system.
2DCTDCTEKORGPURCHASING ORGANIZATIONS/4 HANAWYT3EKORGPURCHASING ORGANIZATIONRequired
Derive via legacy to SyWay S4 Purchasing Organization mapping
Values of the Purchase Organizations already included in the "MM configuration values document"- Enterprise Structure tab: 
3PF2/WP2WYT3PARVWPARTNER FUNCTIONS/4 HANAWYT3PARVWPARTNER FUNCTION

XREF

Customizing. Values of the partner functions already included in the "MM configuration values document"- BP Suppliers tab: 
Values confirmed: 
VN        Vendor
PI        Invoicing Party
GS        Goods supplier
OA        Ordering address

ZA - TMS4S: the value will be the same Main BP code

ZB - BN4L: the value will be the same Main BP code

ZC - Transwide : the value will be the same Main BP code

In case of CASS-> PI partner function with BP code equal to the Main BP can be used- Note: currently it will be only maintained when the email address is different in case of legal entity (Different BP code)

Note: Contact person must be included in the Returns Supplier for invoicing - VIM requirement)
The abbreviated form of the name that identifies the partner function.

 The UI the partner function is displayed language-dependent.

4DCTDCTLIFN2REF TO VENDORS/4 HANAWYT3LIFN2REF TO VENDOR

Conditional

Conditional

Fill it in case Partner function is VN, OA,PI,GS,,ZA, ZB, ZC

This partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory.

5DCTDCTPARNRCONTACT PERSONS/4 HANAWYT3PARNRCONTACT PERSONConditional
Fill it in case Partner function is CP
6DCTDCTDEFPADEFAULT PARTNERS/4 HANAWYT3DEFPADEFAULT PARTNERConditional
Direct mapping


Target Ready Data Collection Template will be created for the Vendors Purchasing Long Text:

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTDCTLIFNRSupplier*S/4 HANAS_LFM1_TEXTLIFNRSupplier*XREF
Supplier* - Key field only in case supplier maintains texts
2DCTDCTEKORGPurchasing Organization*S/4 HANAS_LFM1_TEXTEKORGPurchasing Organization*XREF
An organizational unit in Logistics, subdividing an enterprise according to the requirements of Purchasing. -  - Key field only in case supplier maintains texts
3DCTDCTTDIDText IDS/4 HANASTXHTDIDText IDConditional
Fill when additional texts need to be stored, selecting the relevant text type (e.g., notes, instructions, vip remarks). 
Otherwise, blank
4DCTDCTTDSPRASLanguageS/4 HANASTXHTDSPRASLanguageXREF
Check table: T002
Fill when additional texts need to be stored.
Otherwise, blank
5DCTDCTTEXT_LINES(LTEXT)Long textS/4 HANASTXH/STXKTEXT_LINES(LTEXT)Long textConditional
Fill when additional texts need to be stored, selecting the relevant text type (e.g., notes, instructions, vip remarks). 
Otherwise, blank

 Transformation Mapping

Value mapping tables google drive path -

Mapping Table NameMapping Table Description

Legacy Vendor-BP Master Mapping

XREF - Legacy to SyWay S4 Business Partner mapping

Purchasing Organization Mapping

XREF -Legacy to SyWay S4 Purchasing Organization Mapping

MM Config Values.xlsx - Google Sheets

Payment Terms Mapping

XREF -Legacy to SyWay S4 Payment Terms Mapping

MM Config Values.xlsx - Google Sheets

Incoterms Mapping

XREF -Legacy to SyWay S4 Incoterms Mapping

MM Config Values.xlsx - Google Sheets

Identifier for Incoterm Location 1

XREF -Legacy to SyWay S4 Incoterms Location 1 Mapping

MM Config Values.xlsx - Google Sheets

Purchasing Group Mapping

XREF -Legacy to SyWay S4 Purchasing Group Mapping

MM Config Values.xlsx - Google Sheets

Group for Calculation Schema

XREF -Legacy to SyWay S4 Schema Group Mapping

MM Config Values.xlsx - Google Sheets

Shipping Conditions

Values of the shipping conditions should be included in the "SD configuration values document"

Confirmation Control Key

XREF -Legacy to SyWay S4 Confirmation Control Key Mapping

00_R4_S2P_Process Variants Matrix.xlsx - Google Sheets

Partner Function Mapping

XREF -Legacy to SyWay S4 Partner Function Mapping

MM Config Values.xlsx - Google Sheets

Purchasing Currency Code Mapping

XREF -Legacy to SyWay S4 Purchasing Currency code mapping

Plant Mapping

XREF -Legacy to SyWay S4 Plant mapping

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible

1

Extract PF2,WP2 source tables – LFM1, LFM2, WYT3

Syniti / Data Team

2

Vendor deDupe mapping (Purchasing Organization Data) -Dedupe Golden-Child (Purchasing Organization) Mapping

Syniti

3

Business Partner deDupe mapping (Global Data) - Dedupe Golden-Child (Global) mapping

Syniti

4

Ensure all vendor master data collection templates, deduplication and cleansing completeness and no errors

Syniti / Data Team

5

Ensure that Business Partner – General is loaded

Syniti

6

Ensure that all required Configurations are in S/4 HANA

Data Team

7

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

Syniti

8

Referential Integrity
- Ensure dependent records are transformed together or in advance, such as CNV-3007 Business Partner General 

Syniti

9

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

Value Mappings Google Drive path -

Data Team

10

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

Syniti

11

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 for External Vendor Purchasing Organization extensions/BP Supplier Role

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.

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, i.e., if there is same BP number.
Ensure unique constraints are maintained

Test Referential IntegrityConfirm dependent records exist in related tables

Accuracy

TaskAction

Data Accuracy

Data team to verify that all the data in the load table/file is accurate as per signed-off transformation rules and DCT contents

Error Reports

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

Check Data ConsistencyCompare field values across systems
Validate data formats and structures

Business

Completeness

TaskAction

Verify Count for External Vendor Purchasing Organization extensions/BP Supplier Role

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.

Verify Relevancy Rules

Verify that the relevancy rules were correctly applied


Accuracy

TaskAction

Verify Data Accuracy

Verify that all the data in the load table/file is accurate as per signed-off transformation rules and DCT contents

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

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

2

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

Syniti

3

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

4

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

Syniti

5

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

The Business Partner General will be loaded in the pre-cutover period.

To enable the Plant Specific Purchasing data and partner functions data at the additional data - purchasing level below are the two main conditions.
1) Plant relevant (LFA1-WERKR) flag should be ticked (field is available as part of CNV-3007)
2) VSR relevant (LFA1-LTSNA) flag should be ticked (field is available as part of CNV-3007)


Before loading, it will have dependency on the configuration. 

Configuration

R4 Config Template and Config Workbook Google drive path for the reference - R4 Config Templates and Config workbooks - Google Sheets

Item #Configuration Item

1

Obtain the approved upload USER ID’s to be used (e.g. Firefighter ID)

2

SAP USER profile (SU3) Date and Decimal Notation Formats are in sync with the load format

3

LFM1-EKORG. LFM2-EKORG & WYT3-EKORG - Purchasing Organization Configuration (Check table T024E)

4

LFM1-EKGRP - Purchasing Group Configuration (Check table T024)

5

LFM1-WAERS - Order Currency Configuration (Check table TCURC)

6

LFM1-INCO1 - Incoterms Configuration (Check table TINC)

7LFM1-KALSK - Group for Calculation Schema Configuration (Check table TMKK)

8

LFM1-VSBED - Shipping Conditions Configuration (Check table TVSB)

9

LFM1-BSTAE - Confirmation Control Key Configuration (Check table T163L)

10

LFM1- ZOLLA - Customs Office: Office of Exit/Entry for Foreign Trade (Check table T615)

11

LFM1-ZTERM - Payment Terms Configuration (Check table T052)

12

LFM2-EKGRP - Purchasing Group Configuration (Check table T024)

13

LFM2-WAERS - Order Currency Configuration (Check table TCURC)

14

LFM2-INCO1 - Incoterms Configuration (Check table TINC)

15LFM2-KALSK - Group for Calculation Schema Configuration (Check table TMKK)

16

LFM2-VSBED - Shipping Conditions Configuration (Check table TVSB)

17

LFM2-BSTAE - Confirmation Control Key Configuration (Check table T163L)

18

LFM2- ZOLLA - Customs Office: Office of Exit/Entry for Foreign Trade (Check table T615)

19

LFM2-ZTERM - Payment Terms Configuration (Check table T052)

20

WYT3-PARVW - Partner Function Configuration (Check table TPAR)

21

WYT3-LTSNR - Supplier Subrange. Derived by the system (Check table WYT1)

22

WYT3-WERKS - Plant Configuration (Check table T001W)

Conversion Objects

Object #Preceding Object Conversion Approach

3007

Business Partners - General

3018

Business Partners – FI Vendor



Error Handling


Error TypeError DescriptionAction Taken

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.

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

Verify Count for External Vendor Purchasing Organization extensions/BP Supplier Role

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

Verify Count (Others)

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




Accuracy

TaskAction

Data Accuracy

Data team to verify that all the data in the target tables is accurate as per signed-off transformation rules and DCT contents

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 for External Vendor Purchasing Organization extensions/BP Supplier Role

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

Verify Count (Others)

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

Validate Loaded Data

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


Accuracy

TaskAction

Verify Data Accuracy

Verify that all the data in the target tables is accurate as per signed-off transformation rules and DCT contents

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

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • Business Partner - Vendor Purchasing View including the Partner Functions Data Object is in scope based on data design and any exception requested by business.
  • There will be 3 SAP instances, one for ROW, one for China and one for CUI only (TBC - mentioned in the CNV 3007)
  • BP General data will be loaded into all 3 SAP instances. (TBC - mentioned in the CNV 3007)
  • This conversion Specification document is finalized based on the MDS valid on 04-Dec-2025


See also

Change log

Version Published Changed By Comment
CURRENT (v. 48) Apr 21, 2026 13:43 BATTINI-ext, Srinivasarao
v. 61 Apr 09, 2026 06:48 BATTINI-ext, Srinivasarao
v. 60 Apr 09, 2026 06:41 BATTINI-ext, Srinivasarao
v. 59 Apr 09, 2026 06:28 BATTINI-ext, Srinivasarao
v. 58 Apr 09, 2026 06:19 BATTINI-ext, Srinivasarao
v. 57 Apr 09, 2026 06:02 BATTINI-ext, Srinivasarao
v. 56 Apr 08, 2026 12:47 BATTINI-ext, Srinivasarao
v. 55 Apr 02, 2026 11:16 BATTINI-ext, Srinivasarao
v. 54 Apr 02, 2026 09:42 BATTINI-ext, Srinivasarao
v. 53 Mar 31, 2026 14:36 BATTINI-ext, Srinivasarao

Go to Page History

Workflow history

Title Last Updated By Updated Status  
There are no pages at the moment.