| Status | Approved |
|---|---|
| Owner | |
| Stakeholders |
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:
- LFM1: Vendor master record purchasing organization data
- WYT3: Partner Functions
- LFM2: Vendor Master Record: Purchasing Data - Plant Specific
- STXH: STXD SAPscript text file header
- STXL: STXD SAPscript text file lines
Relevancy Rule
The data from legacy system includes:
- 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
- Should be created to Purchasing Organization 'inscope' based on Enterprise Structure Catalog
- Should be extended to Standard list(approved list) of Partner Functions (based on MDS-3026).
- 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:
- 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
- Vendors extended in Purchasing organization which are not is scope based on Enterprise Structure.
- 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.
| Source | Scope | Source Approx No. of Records | Target System | Target 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.
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| LFM1 | LIFNR | LIFNR | Supplier* | CHAR | 10 | R |
| LFM1 | EKORG | EKORG | Purchasing Organization* | CHAR | 4 | R |
| LFM1 | EKGRP | EKGRP | Purchasing Group | CHAR | 3 | C |
| LFM1 | WAERS | WAERS | Order Currency | CUKY | 5 | C |
| LFM1 | VERKF | VERKF | Salesperson | CHAR | 30 | Not Used |
| LFM1 | TELF1 | TELF1 | Supplier's Telephone Number | CHAR | 16 | Not Used |
| LFM1 | MINBW | MINBW | Minimum Order Value | CURR | 16 | Not Used |
| LFM1 | ZTERM | ZTERM | Terms of Payment Key | CHAR | 4 | C |
| LFM1 | INCOV | INCOV | Inco. Version | CHAR | 4 | Not Used |
| LFM1 | INCO1 | INCO1 | Incoterms | CHAR | 3 | C |
| LFM1 | INCO2_L | INCO2_L | Incoterms Location 1 | CHAR | 70 | C |
| LFM1 | KALSK | KALSK | Group for Calculation Schema | CHAR | 2 | R |
| LFM1 | PLIFZ | PLIFZ | Planned Delivery Time in Days | DEC | 10 | Not Used |
| LFM1 | LFABC | LFABC | ABC Indicator | CHAR | 1 | Not Used |
| LFM1 | VSBED | VSBED | Shipping Conditions | CHAR | 2 | C |
| LFM1 | WEBRE | WEBRE | GR-Based Invoice Verification | CHAR | 1 | C |
| LFM1 | KZAUT | KZAUT | Automatic PO | CHAR | 1 | R |
| LFM1 | MEPRF | MEPRF | Pricing Date Control | CHAR | 1 | C |
| LFM1 | BSTAE | BSTAE | Confirmation Control Key | CHAR | 4 | C |
| LFM1 | KZRET | KZRET | Returns Supplier | CHAR | 1 | C |
| LFM1 | AUBEL | AUBEL | Automatic Debit | CHAR | 1 | Not Used |
| LFM1 | VALID_PRO | VALID_PRO | Settlement Profile | CHAR | 4 | Not Used |
| LFM1 | HSCABS | HSCABS | Absolute Handling Surcharge | CURR | 16 | Not Used |
| LFM1 | HSCPE | HSCPE | Percentage Handling Surcharge | DEC | 16 | Not Used |
| LFM1 | HSCMIN | HSCMIN | Minimum Handling Surcharge | CURR | 16 | Not Used |
| LFM1 | HSCMAX | HSCMAX | Maximum Handling Surcharge | CURR | 16 | Not Used |
| LFM1 | XERSY | XERSY | Autom Evaluated Receipt Settlement (ERS) | CHAR | 1 | C |
| LFM1 | XERSR | XERSR | Autom Evaluated GR Settlement Return | CHAR | 1 | C |
| LFM1 | KZABS | KZABS | Order Acknowledgment Requirement | CHAR | 1 | C |
| LFM1 | EIKTO | EIKTO | Account with supplier | CHAR | 12 | Not Used |
| LFM1 | NRGEW | NRGEW | Grant free goods | CHAR | 1 | Not Used |
| LFM1 | PAPRF | PAPRF | Proact control profile | CHAR | 4 | Not Used |
| LFM1 | BOLRE | BOLRE | Subsequent settlement | CHAR | 1 | Not Used |
| LFM1 | XNBWY | XNBWY | Revaluation | CHAR | 1 | Not Used |
| LFM1 | VENDOR_RMA_REQ | VENDOR_RMA_REQ | RMA required | CHAR | 1 | Not Used |
| LFM1 | PRFRE | PRFRE | Price determination | CHAR | 1 | Not Used |
| LFM1 | BOIND | BOIND | Subsequent settlement indicator active | CHAR | 1 | Not Used |
| LFM1 | BLIND | BLIND | Document index | CHAR | 1 | TBD |
| LFM1 | AGREL | AGREL | Relevant for settlement management | CHAR | 1 | Not Used |
| LFM1 | LOEVM | LOEVM | Deletion flag purchasing organization | CHAR | 1 | Not Used |
| LFM1 | SKRIT | SKRIT | Sort criterion | CHAR | 1 | Not Used |
| LFM1 | SPERM | SPERM | Selected purchasing organization block | CHAR | 1 | C |
| LFM1 | MRPPP | MRPPP | Planning calendar | CHAR | 3 | Not Used |
| LFM1 | LFRHY | LFRHY | Planning cycle | CHAR | 3 | Not Used |
| LFM1 | BOPNR | BOPNR | Order optimization restriction | CHAR | 4 | Not Used |
| LFM1 | LIBES | LIBES | Order entry by supplier | CHAR | 1 | Not Used |
| LFM1 | LIPRE | LIPRE | Price marking Supplier | CHAR | 2 | Not Used |
| LFM1 | LISER | LISER | Rack Jobbing | CHAR | 1 | Not Used |
| LFM1 | ZOLLA | ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | CHAR | 6 | C |
| LFM1 | INCO3_L | INCO3_L | Incoterms Location 2 | CHAR | 70 | Not Used |
| LFM1 | RDPRF | RDPRF | Rounding Profile | CHAR | 4 | Not Used |
| LFM1 | MEGRU | MEGRU | Unit of Measure Group | CHAR | 4 | Not Used |
| LFM1 | ABUEB | ABUEB | Release Creation Profile | CHAR | 4 | Not Used |
| LFM1 | LFM1_EEW_PS | LFM1_EEW_PS | Data Element Extensibility for purchase | CHAR | 1 | Not Used |
| LFM1 | J_1NBOESL | J_1NBOESL | Exchange Key for NF Processing | CHAR | 3 | C |
| LFM1 | FSH_SC_CID | FSH_SC_CID | Customer/Supplier Identifier | CHAR | 2 | Not Used |
| LFM1 | FSH_VAS_DETC | FSH_VAS_DETC | VAS Determination Mode | CHAR | 1 | Not Used |
| LFM1 | UPPRS | UPPRS | Pricing on Subitems (MPN/SUS) | CHAR | 1 | Not Used |
| LFM1 | ACTIVITY_PROFIL | ACTIVITY_PROFIL | Activity Profile for PO Controlling | CHAR | 4 | Not Used |
| LFM1 | TRANSPORT_CHAIN | TRANSPORT_CHAIN | Transportation Chain | CHAR | 10 | Not Used |
| LFM1 | STAGING_TIME | STAGING_TIME | Staging Time in Days | DEC | 3 | Not Used |
| LFM1 | EXPVZ | EXPVZ | Mode of Transport at the Border (Intrast | CHAR | 1 | Not Used |
| LFM1 | VENSL | VENSL | Supplier Service Level | DEC | 5 | Not Used |
| LFM1 | LEBRE | LEBRE | Service - based Invoice verification | CHAR | 1 | R |
| LFM1 | UMSAE | UMSAE | Comparison and agreement of business volumes | CHAR | 1 | Not Used |
| LFM2 | LIFNR | LIFNR | Supplier* | CHAR | 10 | R |
| LFM2 | EKORG | EKORG | Purchasing Organization* | CHAR | 4 | R |
| LFM2 | LTSNR | LTSNR | Suppl, Subrange* | CHAR | 6 | R |
| LFM2 | WERKS | WERKS | Plant* | CHAR | 4 | R |
| WRF02K(TBC) | HINZE | XDYNP | Indicator: plant level relevant - Purchasing Data | CHAR | 1 | C |
| WRF02K(TBC) | HINZP | XDYNP | Indicator: plant level relevant - Partner Functions | CHAR | 1 | C |
| LFM2 | EKGRP | EKGRP | Purchasing Group | CHAR | 3 | C |
| LFM2 | WAERS | WAERS | Order Currency | CUKY | 5 | C |
| LFM2 | VERKF | VERKF | Salesperson | CHAR | 30 | Not Used |
| LFM2 | TELF1 | TELF1 | Supplier's Telephone Number | CHAR | 16 | Not Used |
| LFM2 | MINBW | MINBW | Minimum Order Value | CURR | 16 | Not Used |
| LFM2 | ZTERM | ZTERM | Terms of Payment Key | CHAR | 4 | C |
| LFM2 | INCOV | INCOV | Inco. Version | CHAR | 4 | Not Used |
| LFM2 | INCO1 | INCO1 | Incoterms | CHAR | 3 | C |
| LFM2 | INCO2_L | INCO2_L | Incoterms Location 1 | CHAR | 70 | C |
| LFM2 | KALSK | KALSK | Group for Calculation Schema | CHAR | 2 | R |
| LFM2 | PLIFZ | PLIFZ | Planned Delivery Time in Days | DEC | 10 | Not Used |
| LFM2 | LFABC | LFABC | ABC Indicator | CHAR | 1 | Not Used |
| LFM2 | WEBRE | WEBRE | GR-Based Invoice Verification | CHAR | 1 | C |
| LFM2 | KZAUT | KZAUT | Automatic PO | CHAR | 1 | R |
| LFM2 | MEPRF | MEPRF | Pricing Date Control | CHAR | 1 | C |
| LFM2 | BSTAE | BSTAE | Confirmation Control Key | CHAR | 4 | C |
| LFM2 | XERSY | XERSY | Autom Evaluated Receipt Settlement (ERS) | CHAR | 1 | C |
| LFM2 | XERSR | XERSR | Autom Evaluated GR Settlement Return | CHAR | 1 | C |
| LFM2 | KZABS | KZABS | Order Acknowledgment Requirement | CHAR | 1 | C |
| LFM2 | PAPRF | PAPRF | Proact control profile | CHAR | 4 | Not Used |
| LFM2 | BOLRE | BOLRE | Subsequent settlement | CHAR | 1 | Not Used |
| LFM2 | XNBWY | XNBWY | Revaluation | CHAR | 1 | Not Used |
| LFM2 | KZABS | KZABS | Order Acknowledgment Requirement | CHAR | 1 | C |
| LFM2 | PAPRF | PAPRF | Proact control profile | CHAR | 4 | Not Used |
| LFM2 | BOLRE | BOLRE | Subsequent settlement | CHAR | 1 | Not Used |
| LFM2 | XNBWY | XNBWY | Revaluation | CHAR | 1 | Not Used |
| LFM2 | BOIND | BOIND | Subsequent settlement indicator active | CHAR | 1 | Not Used |
| LFM2 | LOEVM | LOEVM | Deletion flag purchasing organization | CHAR | 1 | Not Used |
| LFM2 | SPERM | SPERM | Selected purchasing organization block | CHAR | 1 | C |
| LFM2 | MRPPP | MRPPP | Planning calendar | CHAR | 3 | Not Used |
| LFM2 | LFRHY | LFRHY | Planning cycle | CHAR | 3 | Not Used |
| LFM2 | BOPNR | BOPNR | Order optimization restriction | CHAR | 4 | Not Used |
| LFM2 | LIBES | LIBES | Order entry by supplier | CHAR | 1 | Not Used |
| LFM2 | LIPRE | LIPRE | Price marking Supplier | CHAR | 2 | Not Used |
| LFM2 | LISER | LISER | Rack Jobbing | CHAR | 1 | Not Used |
| LFM2 | ZOLLA | ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | CHAR | 6 | C |
| LFM2 | INCO3_L | INCO3_L | Incoterms Location 2 | CHAR | 70 | Not Used |
| LFM2 | RDPRF | RDPRF | Rounding Profile | CHAR | 4 | Not Used |
| LFM2 | MEGRU | MEGRU | Unit of Measure Group | CHAR | 4 | Not Used |
| LFM2 | ABUEB | ABUEB | Release Creation Profile | CHAR | 4 | Not Used |
| LFM2 | TRANSPORT_CHAIN | TRANSPORT_CHAIN | Transportation Chain | CHAR | 10 | Not Used |
| LFM2 | STAGING_TIME | STAGING_TIME | Staging Time in Days | DEC | 3 | Not Used |
| LFM2 | EXPVZ | EXPVZ | Mode of Transport at the Border (Intrast | CHAR | 1 | Not Used |
| LFM2 | LEBRE | LEBRE | Service - based Invoice verification | CHAR | 1 | R |
| LFM2 | UMSAE | UMSAE | Comparison and agreement of business volumes | CHAR | 1 | Not Used |
| LFM2 | WEORA | WEORA | Origin acceptance | CHAR | 1 | Not Used |
| WYT3 | LIFNR | LIFNR | Supplier* | CHAR | 10 | R |
| WYT3 | PARVW | PARVW | Partner Function* | CHAR | 2 | R |
| WYT3 | LIFN2 | LIFN2 | Ref to vendor | CHAR | 10 | C |
| WYT3 | PERNR | PERNR | Personnel No. | NUMC | 8 | Not Used |
| WYT3 | PARNR | PARNR | Contact Person ID | NUMC | 10 | C |
| WYT3 | DEFPA | DEFPA | Default | CHAR | 1 | C |
| WYT3 | EKORG | EKORG | Purchasing organization | CHAR | 4 | R |
| WYT3 | LTSNR | LTSNR | Supplier Subrange | CHAR | 6 | Not used |
| WYT3 | WERKS | WERKS | Plant | CHAR | 4 | Not used |
| S_LFM1_TEXT | LIFNR | LIFNR | Supplier* | CHAR | 10 | R |
| S_LFM1_TEXT | EKORG | EKORG | Purchasing Organization* | CHAR | 4 | R |
| STXH | TDID | CHAR | Text ID | CHAR | 4 | C |
| STXH | TDSPRAS | TDSPRAS | Language | CHAR | 2 | C |
| STXH/STXK | TEXT_LINES(LTEXT) | TEXT_LINES | Long text | CHAR | 40 | C |
Data Cleansing
Analysis Report or Validation Reports path for the reference -
| ID | Criticality | Error Message/Report Description | Rule | Output | Source 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-002 | C-1 | Identify 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-003 | C-2 | Fill in mandatory fields based on master data standards
| 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-004 | C-2 | Validate 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
Data Privacy and Sensitivity
N/A
Extraction
Extract data from a source into Syniti Migrate for SAP relevant entities. There are 2 possibilities:
- The data exists. Syniti Migrate connects to the source and loads the data into Syniti Migrate. There are 3 methods:
- Perform full data extraction from relevant tables in the source system(s).
- Perform extraction through the application layer.
- Only if Syniti Migrate; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
- 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 Description | Team 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. | Syniti / Data team |
Extraction Methodology | Specify the extraction approach (full, incremental, or delta extraction). | Syniti |
Extraction Execution Plan | Establish execution timelines and batch processing schedules. | 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.
- The extracted report will be loaded into the required structure using the DCT.
- Standardization activities (including deduplication, standardization and additions) will be carried out within the DCT.
DCT Rules:
| Vendors Purchasing Organization Data: | |||
|---|---|---|---|
| Technical Table-Field | Field Label | Field Description | Rule |
| LFM1-LIFNR | Supplier* | Supplier* | R |
| LFM1-EKORG | Purchasing 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-EKGRP | Purchasing Group | Key for a buyer or a group of buyers responsible for the procurement of the product. | C |
| LFM1-WAERS | Order Currency | Key for the currency on which an order placed with a supplier is based. | C |
| LFM1-ZTERM | Terms of Payment Key | Key for defining payment terms composed of cash discount percentages and payment periods. | C |
| LFM1-INCO1 | Incoterms | Incoterms 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_L | Incoterms Location 1 | Provides 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-KALSK | Group for Calculation Schema | Determines which calculation schema (pricing procedure) is to be used in purchasing documents containing this supplier number. | R |
| LFM1-VSBED | Shipping Conditions | General shipping strategy for the delivery of goods from the supplier to the customer. | C |
| LFM1-WEBRE | GR-Based Invoice Verification | This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | C |
| LFM1-KZAUT | Automatic PO | This 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-MEPRF | Pricing Date Control | Determines which date is to be used for price determination (pricing) purposes. By default leave it blank. | C |
| LFM1-BSTAE | Confirmation Control Key | Determines which confirmation categories are expected for a PO item (for example order acknowledgment, shipping notification). | C |
| LFM1-KZRET | Returns Supplier | Indicates 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-XERSY | Autom Evaluated Receipt Settlement (ERS) | This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | C |
| LFM1-XERSR | Autom Evaluated GR Settlement Return | This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | C |
| LFM1-KZABS | Order Acknowledgment Requirement | Determines 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-BLIND | Document index | Indicates 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-SPERM | Selected purchasing organization block | Indicates whether or not the supplier master record is blocked for the purchasing organization for posting purposes. Based on Business Requirements | C |
| LFM1- ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | Specifies 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_1NBOESL | Exchange Key for NF Processing | Brazilian taxes | C |
| LFM1-LEBRE | Service - based Invoice verification | Indicates 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 Label | Field Description | Rule |
| WYT3-LIFNR | Supplier* | Supplier* | R |
| WYT3-PARVW | Partner Function* | The abbreviated form of the name that identifies the partner function. Aligned to the Governance column in "BP Role Matrix Organizations" ZB - BN4L: the value will be the same Main BP code | R |
| WYT3-LIFN2 | Ref to vendor | This partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory. | |
| WYT3-PARNR | Contact Person ID | This partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory. | |
| WYT3-DEFPA | Default | Specifies 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-EKORG | Purchasing organization | Purchasing 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 Label | Field Description | Rule |
| LFM2-LIFNR | Supplier* | Supplier* - key field for Supplier Range at plant level | R |
| LFM2-EKORG | Purchasing 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-LTSNR | Suppl, Subrange* | Supplier Subrange - Key field for Supplier Range at plant level. | R |
| LFM2-WERKS | Plant* | 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 Data | Flag. 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 Functions | Flag. Select in case the specific data within the plant refers to Partner function data. | C |
| LFM2-EKGRP | Purchasing Group | Key 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-WAERS | Order Currency | Key for the currency on which an order placed with a supplier is based. | C |
| LFM2-ZTERM | Terms of Payment Key | Key for defining payment terms composed of cash discount percentages and payment periods. | C |
| LFM2-INCO1 | Incoterms | Incoterms 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_L | Incoterms Location 1 | Provides 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-KALSK | Group for Calculation Schema | Determines 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-WEBRE | GR-Based Invoice Verification | This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | C |
| LFM2-KZAUT | Automatic PO | This 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-MEPRF | Pricing Date Control | Determines which date is to be used for price determination (pricing) purposes. By default leave it blank. | C |
| LFM2-BSTAE | Confirmation Control Key | Determines which confirmation categories are expected for a PO item (for example order acknowledgment, shipping notification). | C |
| LFM2-XERSY | Autom Evaluated Receipt Settlement (ERS) | This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | C |
| LFM2-XERSR | Autom Evaluated GR Settlement Return | This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | C |
| LFM2-KZABS | Order Acknowledgment Requirement | Determines 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-SPERM | Selected purchasing organization block | Indicates whether or not the supplier master record is blocked for the purchasing organization for posting purposes. Based on Business Requirements | C |
| LFM2- ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | Specifies 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-LEBRE | Service - based Invoice verification | Indicates 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 Label | Field Description | Rule |
| WYT3-LIFNR | Supplier* | Supplier* | R |
| WYT3-PARVW | Partner Function* | The abbreviated form of the name that identifies the partner function. Aligned to the Governance column in "BP Role Matrix Organizations" ZB - BN4L: the value will be the same Main BP code | R |
| WYT3-LIFN2 | Ref to vendor | This 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-PARNR | Contact Person ID | This 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-DEFPA | Default | Specifies 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-EKORG | Purchasing organization | Purchasing 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 Label | Field Description | Rule |
| S_LFM1_TEXT-LIFNR | Supplier* | Supplier* | R |
| S_LFM1_TEXT-EKORG | Purchasing 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-TDID | Text ID | Text 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-TDSPRAS | Language | The 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 text | A 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 Description | Team 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
| Syensqo IT |
| 4 | Data Structure
| Syniti |
| 5 | Referential Integrity
| Syniti |
| 6 | Extraction Methodology
| Syniti |
| 7 | Performance and Scalability Considerations
| Syniti |
| 8 | Security and Compliance
| Syniti |
Transformation
The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow Syniti Migrate to make the data Target ready:
- Perform value mapping and data transformation rules.
- Legacy values are mapped to the to-be values (this could include a default value)
- Values are transformed according to the rules defined in Syniti Migrate
- 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 Description | Team Responsible |
|---|---|---|
1 | Run LFM1, LFM2 and WYT3 Relevancy in Syniti | Syniti |
2 | Transformation Scope Definition | Data Team |
3 | Data Mapping and Standardization | Data Team |
4 | Business Rule Application | Data Team |
5 | Transformation Execution Plan | Syniti |
Transformation Rules
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation 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. |
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. |
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) |
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) 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. 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: |
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). |
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) 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) |
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. |
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. |
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 |
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 |
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. |
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. |
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. |
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) |
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) 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: |
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). |
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. |
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 |
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 |
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: 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 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 | LTSNR | Supplier Subrange | S/4 HANA | WYT3 | LTSNR | Supplier Subrange | Not used |
125 | PF2/WP2 | WYT3 | WERKS | Plant | S/4 HANA | WYT3 | WERKS | Plant | Not used |
126 | PF2/WP2 | S_LFM1_TEXT | LIFNR | Supplier* | S/4 HANA | S_LFM1_TEXT | LIFNR | Supplier* | XREF Supplier* - Key field only in case supplier maintains texts |
127 | PF2/WP2 | S_LFM1_TEXT | EKORG | Purchasing Organization* | S/4 HANA | S_LFM1_TEXT | EKORG | Purchasing 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 | STXH | TDID | Text ID | S/4 HANA | STXH | TDID | Text ID | Conditional Fill when additional texts need to be stored, selecting the relevant text type (e.g., notes, instructions, vip remarks). |
129 | PF2/WP2 | STXH | TDSPRAS | Language | S/4 HANA | STXH | TDSPRAS | Language | XREF Check table: T002 |
130 | PF2/WP2 | STXH/STXK | TEXT_LINES(LTEXT) | Long text | S/4 HANA | STXH/STXK | TEXT_LINES(LTEXT) | Long text | Conditional Fill when additional texts need to be stored, selecting the relevant text type (e.g., notes, instructions, vip remarks). |
DCT Build Tables including the transformation logic:
Target Ready Data Collection Template will be created for the Vendors Purchasing Organization:
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | DCT | 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 | DCT | DCT | 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 | DCT | DCT | 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 | DCT | DCT | WAERS | ORDER CURRENCY | S/4 HANA | LFM1 | WAERS | ORDER CURRENCY | XREF |
| Derive via legacy to SyWay S4 Purchasing Currency code mapping | |||||||||
| 5 | DCT | DCT | 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. | |||||||||
| 6 | DCT | DCT | 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 | |||||||||
| 7 | DCT | DCT | 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 | |||||||||
| 8 | DCT | DCT | 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. | |||||||||
| 9 | DCT | DCT | 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. | |||||||||
| 10 | DCT | DCT | 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. | |||||||||
| 11 | DCT | DXT | 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) | |||||||||
| 12 | DCT | DCT | MEPRF | PRICING DATE CONTROL | S/4 HANA | LFM1 | MEPRF | PRICING DATE CONTROL | Conditional |
| Direct Mapping | |||||||||
| 13 | DCT | DCT | 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) | |||||||||
| 14 | DCT | DCT | 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. | |||||||||
| 15 | DCT | DCT | 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. | |||||||||
| 16 | DCT | DCT | 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. | |||||||||
| 17 | DCT | DCT | KZABS | ORDER ACKNOWLEDGMENT REQUIREMENT | S/4 HANA | LFM1 | KZABS | ORDER ACKNOWLEDGMENT REQUIREMENT | Conditional |
| By default X - exception Plants (Grouping BPAB/Account Group = LIEF) | |||||||||
| 18 | DCT | DCT | BLIND | DOCUMENT INDEX | S/4 HANA | LFM1 | BLIND | DOCUMENT INDEX | TBD |
| 19 | DCT | DCT | 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. | |||||||||
| 20 | DCT | DCT | 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 | |||||||||
| 21 | DCT | DCT | J_1NBOESL | EXCHANGE KEY FOR NF PROCESSING | S/4 HANA | LFM1 | J_1NBOESL | EXCHANGE KEY FOR NF PROCESSING | Conditional |
| Direct Mapping | |||||||||
| 22 | DCT | DCT | 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' |
.Target Ready Data Collection Template will be created for the Vendors Purchasing Organization Partner Functions::
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | DCT | LIFNR | VENDOR | S/4 HANA | WYT3 | LIFNR | SUPPLIER | Required |
| Derive via legacy to SyWay S4 Business Partner mapping | |||||||||
| Supplier Automatically created by the system. | |||||||||
| 2 | DCT | DCT | EKORG | PURCHASING ORGANIZATION | S/4 HANA | WYT3 | EKORG | PURCHASING ORGANIZATION | Required |
| 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: | |||||||||
| 3 | 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: 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 UI the partner function is displayed language-dependent. |
| 4 | DCT | DCT | LIFN2 | REF TO VENDOR | S/4 HANA | WYT3 | LIFN2 | REF 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. |
| 5 | DCT | DCT | PARNR | CONTACT PERSON | S/4 HANA | WYT3 | PARNR | CONTACT PERSON | Conditional |
| Fill it in case Partner function is CP | |||||||||
| 6 | DCT | DCT | DEFPA | DEFAULT PARTNER | S/4 HANA | WYT3 | DEFPA | DEFAULT PARTNER | Conditional |
| Direct mapping |
Target Ready Data Collection Template will be created for the Vendors Plant Specific Purchasing Organization:
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | DCT | LIFNR | VENDOR NUMBER | S/4 HANA | LFM2 | LIFNR | SUPPLIER NUMBER | XREF |
| Derive via legacy to SyWay S4 Business Partner mapping | |||||||||
| Supplier Automatically created by the system. | |||||||||
| 2 | DCT | DCT | 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. | |||||||||
| 3 | PF2/WP2 | LFM2 | LTSNR | SUPPL. SUBRANGE | S/4 HANA | LFM2 | LTSNR | SUPPL. SUBRANGE | Required |
| Default value is " " | |||||||||
| 4 | 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) | |||||||||
| 5 | PF2/WP2 | WRF02K | HINZE | Indicator: plant level relevant - Purchasing Data | S/4 HANA | WRF02K | 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") | |||||||||
| 6 | DCT | DCT | HINZP | Indicator: plant level relevant - Partner Functions | S/4 HANA | WRF02K | 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") | |||||||||
| It is validated against relevant Purchasing Groups available in S/4 HANA. | |||||||||
| 7 | DCT | DCT | WAERS | ORDER CURRENCY | S/4 HANA | LFM2 | WAERS | ORDER CURRENCY | XREF |
| Derive via legacy to SyWay S4 Purchasing Currency code mapping | |||||||||
| 8 | DCT | DCT | 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. | |||||||||
| 9 | DCT | DCT | 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 | |||||||||
| 10 | DCT | DCT | 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 | |||||||||
| 11 | DCT | DCT | 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. | |||||||||
| 12 | DCT | DCT | 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. | |||||||||
| 13 | DCT | DXT | 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) | |||||||||
| 14 | DCT | DCT | MEPRF | PRICING DATE CONTROL | S/4 HANA | LFM2 | MEPRF | PRICING DATE CONTROL | Conditional |
| Direct Mapping | |||||||||
| 15 | DCT | DCT | BSTAE | CONFIRMATION CONTROL KEY | S/4 HANA | LFM2 | 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) | |||||||||
| 16 | DCT | DCT | 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. | |||||||||
| 17 | DCT | DCT | 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. | |||||||||
| 18 | DCT | DCT | KZABS | ORDER ACKNOWLEDGMENT REQUIREMENT | S/4 HANA | LFM2 | KZABS | ORDER ACKNOWLEDGMENT REQUIREMENT | Conditional |
| By default X - exception Plants (Grouping BPAB/Account Group = LIEF) | |||||||||
| 19 | DCT | DCT | 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. | |||||||||
| 20 | DCT | DCT | 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 | |||||||||
| 21 | DCT | DCT | 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' |
Target Ready Data Collection Template will be created for the Vendors Plant Specific Purchasing Organization Partner Functions::
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | DCT | LIFNR | VENDOR | S/4 HANA | WYT3 | LIFNR | SUPPLIER | Required |
| Derive via legacy to SyWay S4 Business Partner mapping | |||||||||
| Supplier Automatically created by the system. | |||||||||
| 2 | DCT | DCT | EKORG | PURCHASING ORGANIZATION | S/4 HANA | WYT3 | EKORG | PURCHASING ORGANIZATION | Required |
| 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: | |||||||||
| 3 | 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: 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 UI the partner function is displayed language-dependent. |
| 4 | DCT | DCT | LIFN2 | REF TO VENDOR | S/4 HANA | WYT3 | LIFN2 | REF 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. |
| 5 | DCT | DCT | PARNR | CONTACT PERSON | S/4 HANA | WYT3 | PARNR | CONTACT PERSON | Conditional |
| Fill it in case Partner function is CP | |||||||||
| 6 | DCT | DCT | DEFPA | DEFAULT PARTNER | S/4 HANA | WYT3 | DEFPA | DEFAULT PARTNER | Conditional |
| Direct mapping |
Target Ready Data Collection Template will be created for the Vendors Purchasing Long Text:
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | DCT | LIFNR | Supplier* | S/4 HANA | S_LFM1_TEXT | LIFNR | Supplier* | XREF |
| Supplier* - Key field only in case supplier maintains texts | |||||||||
| 2 | DCT | DCT | EKORG | Purchasing Organization* | S/4 HANA | S_LFM1_TEXT | EKORG | Purchasing Organization* | XREF |
| An organizational unit in Logistics, subdividing an enterprise according to the requirements of Purchasing. - - Key field only in case supplier maintains texts | |||||||||
| 3 | DCT | DCT | TDID | Text ID | S/4 HANA | STXH | TDID | Text ID | Conditional |
| Fill when additional texts need to be stored, selecting the relevant text type (e.g., notes, instructions, vip remarks). | |||||||||
| Otherwise, blank | |||||||||
| 4 | DCT | DCT | TDSPRAS | Language | S/4 HANA | STXH | TDSPRAS | Language | XREF |
| Check table: T002 | |||||||||
| Fill when additional texts need to be stored. | |||||||||
| Otherwise, blank | |||||||||
| 5 | DCT | DCT | TEXT_LINES(LTEXT) | Long text | S/4 HANA | STXH/STXK | TEXT_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 |
Transformation Mapping
Value mapping tables google drive path -
| Mapping Table Name | Mapping 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 |
Payment Terms Mapping | XREF -Legacy to SyWay S4 Payment Terms Mapping |
Incoterms Mapping | XREF -Legacy to SyWay S4 Incoterms Mapping |
Identifier for Incoterm Location 1 | XREF -Legacy to SyWay S4 Incoterms Location 1 Mapping |
Purchasing Group Mapping | XREF -Legacy to SyWay S4 Purchasing Group Mapping |
Group for Calculation Schema | XREF -Legacy to SyWay S4 Schema Group Mapping |
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 |
Partner Function Mapping | XREF -Legacy to SyWay S4 Partner Function Mapping |
Purchasing Currency Code Mapping | XREF -Legacy to SyWay S4 Purchasing Currency code mapping |
Plant Mapping |
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team 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 | Syniti |
8 | Referential Integrity | Syniti |
| 9 | Data Team | |
| 10 | Performance and Scalability Considerations | Syniti |
| 11 | Logging and Error Handling | Syniti |
Pre-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
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. |
| Test Referential Integrity | Confirm dependent records exist in related tables |
Accuracy
| Task | Action |
|---|---|
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 Consistency | Compare field values across systems Validate data formats and structures |
Business
Completeness
| Task | Action |
|---|---|
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
| Task | Action |
|---|---|
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:
- Execute the automated data load into target system using load tool or product the load file if the load must be done manually
- 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 Description | Team Responsible |
|---|---|---|
1 | Load Scope Definition | Data team |
2 | Load Methodology | Syniti |
3 | Data Quality and Validation | Syniti |
| 4 | Load Execution Plan | Syniti |
| 5 | Logging and Reporting | 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) |
| 7 | LFM1-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) |
| 15 | LFM2-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 Type | Error Description | Action 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
| Task | Action |
|---|---|
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
| Task | Action |
|---|---|
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
| Task | Action |
|---|---|
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
| Task | Action |
|---|---|
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
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||

