| Status | Revision in Progress |
|---|---|
| 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 views 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 mainly using the ETL process for the vendors purchasing view including partner functions data, Vendor purchasing Texts data and plant specific vendors purchasing view including partner functions But it might be required DCT process for the partner functions data.
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)):
- 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
The data from legacy system excludes:
- Vendors blocked or marked for deletion.
- Vendors extended in Purchasing organization which are not is scope based on Enterprise Structure.
- Inactive vendors with no transactions based on the relevancy criteria of CNV-3007
- Employee Vendor where account group LFA1-KTOKK is ('ZZPE' in PF2, 'Z012' in WP2)
- Intercompany Vendor Class LFA1-ZZR_SEGT_ATTR is 'G'
| 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 | S/4 HANA | 40,000 |
PF2, WP2 | Plant specific vendors purchasing data including the partner functions data | 100 | S/4 HANA | 100 |
PF2, WP2 | Vendor master purchasing texts data | TBC | S/4 HANA | TBC |
Additional Information
Multi-language Requirement
Will follow multi-language allowed and created in 3007-Business Partners - General (Role 000000)
The customer and vendor general data may contain international address. Therefore, the conversion will also need to support the multi-language address. Below languages (International versions) are supported.
International Version | Description |
C | Simplified Chinese |
M | Traditional Chinese |
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_3XXX_Consolidated-Business Partners.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 | HINZE | XDYNP | Indicator: plant level relevant - Purchasing Data | CHAR | 1 | C |
| WRF02K | 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 | VSBED | VSBED | Shipping Conditions | CHAR | 2 | C |
| 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 | Supplier ID | 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 | C |
| S_LFM1_TEXT | EKORG | EKORG | Purchasing Organization* | CHAR | 4 | C |
| STXH | TDID | CHAR | Text ID | CHAR | 4 | C |
| STXH | TDSPRAS | TDSPRAS | Language | CHAR | 2 | C |
| STXH/STXK | TEXT_LINES | TEXT_LINES | Long text | CHAR | 40 | C |
Data Cleansing
3026-001 | C1 | Deduplication | Deduplication of supplier records with parent and child approach. Vendors with same name, VAT ID, bank details, etc., should be unified to avoid redundant BP creation. Same or similar name | PF2/WP2 | |
| 3026-005 | C2 | Missing Emails | Check if correct 'Email' is not populated for Purchasing Organization | PF2/WP2 | |
3026-006 | C2 | Not Approved Payment Terms | Check the Payment Terms assigned to the vendor and verify if it exists in the mapping table | 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 new partner functions data that need to be created to support the to-be design.
- For new partner functions data which is not in SAP ECC
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.
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 Additional Partner Functions (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.
Vendors - Partner Functions DCT Rules:
| Technical Table-Field | Field Label | Field Description | Rule |
|---|---|---|---|
| WYT3-LIFNR | Supplier* | Supplier Number | R |
| WYT3-PARVW | Partner Function* | The abbreviated form of the name that identifies the partner function. Default values: The UI the partner function is displayed language-dependent. | R |
| WYT3-LIFN2 | Supplier 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-PERNR | Personnel No. | This partner is only mandatory if you choose a partner role which refers to this partner. One of the partner fields is always mandatory. | Not Used |
| 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 | 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 |
| WYT3-LTSNR | Supplier Subrange | Supplier Subrange. Derived by the system. | S |
| WYT3-WERKS | Plant | Plant. Derived by the system | S |
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 LFA1 Relevancy in Syniti | Syniti |
2 | Run LFM1 Relevancy in Syniti | Syniti |
3 | Transformation Scope Definition | Data Team |
4 | Data Mapping and Standardization | Data Team |
5 | Business Rule Application | Data Team |
6 | 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 | Required 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 | Required 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 | Conditional 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 | Conditional 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 | Conditional 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 | Conditional 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 | Conditional 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 | Required 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 | Conditional 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 | 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) |
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 | Conditional (Not in LTMC - S/4 HANA Template) Direct Mapping |
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 | Not Used |
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 | LFM1 | 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) Flag X/blank - Ariba Requirement |
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 | LFM1 | XZEMP | INDICATOR: ALTERNATIVE PAYEE IN DOCUMENT ALLOWED? | S/4 HANA | LFM1 | XZEMP | INDICATOR: ALTERNATIVE PAYEE IN DOCUMENT ALLOWED? | Conditional Direct Mapping |
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 | Not Used |
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 | LFM2 | LIFNR | SUPPLIER NUMBER | Required Derive via legacy to SyWay S4 Business Partner mapping Supplier Automatically created by the system. |
69 | PF2/WP2 | LFM2 | EKORG | PURCHASING ORGANISATION | S/4 HANA | LFM2 | EKORG | PURCHASING ORGANISATION | Required 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 |
71 | PF2/WP2 | LFM2 | WERKS | PLANT* | S/4 HANA | LFM2 | WERKS | PLANT* | Required Key that uniquely identifies a plant. |
72 | PF2/WP2 | WRF02K | HINZE | Indicator: plant level relevant - Purchasing Data | S/4 HANA | WRF02K | HINZE | Indicator: plant level relevant - Purchasing Data | Required |
73 | PF2/WP2 | WRF02K | HINZP | Indicator: plant level relevant - Partner Functions | S/4 HANA | WRF02K | HINZP | Indicator: plant level relevant - Partner Functions | Required |
74 | PF2/WP2 | LFM2 | EKGRP | PURCHASING GROUP | S/4 HANA | LFM2 | EKGRP | PURCHASING GROUP | Conditional 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 | Conditional 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 | Conditional 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 | Conditional 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 | Conditional 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 | Required 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 | VSBED | SHIPPING CONDITIONS | S/4 HANA | LFM2 | VSBED | SHIPPING CONDITIONS | Conditional 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) |
87 | 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. |
88 | 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. |
89 | PF2/WP2 | LFM2 | MEPRF | PRICING DATE CONTROL | S/4 HANA | LFM2 | MEPRF | PRICING DATE CONTROL | Conditional Direct Mapping |
90 | 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) |
91 | 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 |
92 | 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 |
93 | 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) |
94 | PF2/WP2 | LFM2 | PAPRF | PROACT CONTROL PROFILE | S/4 HANA | LFM2 | PAPRF | PROACT CONTROL PROFILE | Not Used |
95 | PF2/WP2 | LFM2 | BOLRE | SUBSEQUENT SETTLEMENT | S/4 HANA | LFM2 | BOLRE | SUBSEQUENT SETTLEMENT | Not Used |
96 | PF2/WP2 | LFM2 | XNBWY | REVALUATION | S/4 HANA | LFM2 | XNBWY | REVALUATION | Not Used |
97 | PF2/WP2 | LFM2 | PRFRE | PRICE DETERMINATION | S/4 HANA | LFM2 | PRFRE | PRICE DETERMINATION | Not Used |
98 | PF2/WP2 | LFM2 | BOIND | SUBSEQUENT SETTLEMENT INDICATOR ACTIVE | S/4 HANA | LFM2 | BOIND | SUBSEQUENT SETTLEMENT INDICATOR ACTIVE | Not Used |
99 | PF2/WP2 | LFM2 | LOEVM | DELETION FLAG PURCHASING ORGANIZATION | S/4 HANA | LFM2 | LOEVM | DELETION FLAG PURCHASING ORGANIZATION | Not Used |
100 | 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) Flag X/blank - Ariba Requirement |
101 | PF2/WP2 | LFM2 | MRPPP | PLANNING CALENDAR | S/4 HANA | LFM2 | MRPPP | PLANNING CALENDAR | Not Used |
102 | PF2/WP2 | LFM2 | LFRHY | PLANNING CYCLE | S/4 HANA | LFM2 | LFRHY | PLANNING CYCLE | Not Used |
103 | PF2/WP2 | LFM2 | BOPNR | ORDER OPTIMIZATION RESTRICTION | S/4 HANA | LFM2 | BOPNR | ORDER OPTIMIZATION RESTRICTION | Not Used |
104 | PF2/WP2 | LFM2 | LIBES | ORDER ENTRY BY SUPPLIER | S/4 HANA | LFM2 | LIBES | ORDER ENTRY BY SUPPLIER | Not Used |
105 | PF2/WP2 | LFM2 | LIPRE | PRICE MARKING SUPPLIER | S/4 HANA | LFM2 | LIPRE | PRICE MARKING SUPPLIER | Not Used |
106 | PF2/WP2 | LFM2 | LISER | RACK JOBBING | S/4 HANA | LFM2 | LISER | RACK JOBBING | Not Used |
107 | 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 |
108 | PF2/WP2 | LFM2 | INCO3_L | INCOTERMS LOCATION 2 | S/4 HANA | LFM2 | INCO3_L | INCOTERMS LOCATION 2 | Not Used |
109 | PF2/WP2 | LFM2 | RDPRF | ROUNDING PROFILE | S/4 HANA | LFM2 | RDPRF | ROUNDING PROFILE | Not Used |
110 | PF2/WP2 | LFM2 | MEGRU | UNIT OF MEASURE GROUP | S/4 HANA | LFM2 | MEGRU | UNIT OF MEASURE GROUP | Not Used |
111 | PF2/WP2 | LFM2 | ABUEB | RELEASE CREATION PROFILE | S/4 HANA | LFM2 | ABUEB | RELEASE CREATION PROFILE | Not Used |
112 | PF2/WP2 | LFM2 | TRANSPORT_CHAIN | TRANSPORTATION CHAIN | S/4 HANA | LFM2 | TRANSPORT_CHAIN | TRANSPORTATION CHAIN | Not Used |
113 | PF2/WP2 | LFM2 | STAGING_TIME | STAGING TIME IN DAYS | S/4 HANA | LFM2 | STAGING_TIME | STAGING TIME IN DAYS | Not Used |
114 | 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 |
115 | 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' |
116 | PF2/WP2 | LFM2 | UMSAE | COMPARISON AND AGREEMENT OF BUSINESS VOLUMES | S/4 HANA | LFM2 | UMSAE | COMPARISON AND AGREEMENT OF BUSINESS VOLUMES | Not Used |
117 | PF2/WP2 | LFM2 | WEORA | ORIGIN ACCEPTANCE | S/4 HANA | LFM2 | WEORA | ORIGIN ACCEPTANCE | Not Used |
118 | 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. |
119 | PF2/WP2 | WYT3 | PARVW | PARTNER FUNCTION | S/4 HANA | WYT3 | PARVW | PARTNER FUNCTION | Required Customizing. Values of the partner functions already included in the "MM configuration values document"- BP Suppliers tab: Note: Contact person must be included in the Returns Supplier for invoicing - VIM requirement) The UI the partner function is displayed language-dependent. |
120 | PF2/WP2 | WYT3 | LIFN2 | REF TO VENDOR | S/4 HANA | WYT3 | LIFN2 | REF TO VENDOR | Conditional Fill it in case Partner function is
|
121 | PF2/WP2 | WYT3 | PERNR | PERSONAL NO | S/4 HANA | WYT3 | PERNR | PERSONAL NO | Not Used |
122 | PF2/WP2 | WYT3 | PARNR | CONTACT PERSON | S/4 HANA | WYT3 | PARNR | CONTACT PERSON | Conditional Fill it in case Partner function is CP |
123 | PF2/WP2 | WYT3 | DEFPA | DEFAULT PARTNER | S/4 HANA | WYT3 | DEFPA | DEFAULT PARTNER | Conditional Direct mapping |
124 | PF2/WP2 | WYT3 | 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: |
125 | PF2/WP2 | WYT3 | LTSNR | SUPPLIER SUBRANGE | S/4 HANA | WYT3 | LTSNR | SUPPLIER SUBRANGE | Not used |
126 | PF2/WP2 | WYT3 | WERKS | PLANT | S/4 HANA | WYT3 | WERKS | PLANT | Not used |
127 | PF2/WP2 | S_LFM1_TEXT | LIFNR | Supplier* | S/4 HANA | S_LFM1_TEXT | LIFNR | Supplier* | C |
128 | PF2/WP2 | S_LFM1_TEXT | EKORG | Purchasing Organization* | S/4 HANA | S_LFM1_TEXT | EKORG | Purchasing Organization* | C |
128 | PF2/WP2 | STXH | TDID | Text ID | S/4 HANA | STXH | TDID | Text ID | C |
129 | PF2/WP2 | STXH | TDSPRAS | Language | S/4 HANA | STXH | TDSPRAS | Language | C |
130 | PF2/WP2 | STXH/STXK | TEXT_LINES | Long text | S/4 HANA | STXH/STXK | TEXT_LINES | Long text | C |
Target Ready Data Collection Template will be created for the Additional Partner Functions Data (f needed):
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
1 | 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 | PARVW | PARTNER FUNCTION | S/4 HANA | WYT3 | PARVW | PARTNER FUNCTION | Required Customizing. Values of the partner functions already included in the "MM configuration values document"- BP Suppliers tab: Note: Contact person must be included in the Returns Supplier for invoicing - VIM requirement) The UI the partner function is displayed language-dependent. | |
3 | DCT | LIFN2 | REF TO VENDOR | S/4 HANA | WYT3 | LIFN2 | REF TO VENDOR | Conditional Fill it in case Partner function is
| |
4 | DCT | PERNR | PERSONAL NO | S/4 HANA | WYT3 | PERNR | PERSONAL NO | Not Used | |
5 | DCT | PARNR | CONTACT PERSON | S/4 HANA | WYT3 | PARNR | CONTACT PERSON | Conditional Fill it in case Partner function is CP | |
6 | DCT | DEFPA | DEFAULT PARTNER | S/4 HANA | WYT3 | DEFPA | DEFAULT PARTNER | Conditional Direct mapping | |
7 | 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: | |
8 | DCT | LTSNR | SUPPLIER SUBRANGE | S/4 HANA | WYT3 | LTSNR | SUPPLIER SUBRANGE | System generated | |
9 | DCT | WERKS | PLANT | S/4 HANA | WYT3 | WERKS | PLANT | System generated |
Transformation Mapping
Value mapping tables google drive path -
| Mapping Table Name | Mapping Table Description |
|---|---|
Legacy Vendor-BP Master Mapping | Legacy to SyWay S4 Business Partner mapping |
Purchasing Organization Mapping | Legacy to SyWay S4 Purchasing Organization Mapping |
Payment Terms Mapping | Legacy to SyWay S4 Payment Terms Mapping |
Incoterms Mapping | Legacy to SyWay S4 Incoterms Mapping |
Identifier for Incoterm Location 1 | Legacy to SyWay S4 Incoterms Location 1 Mapping |
Purchasing Group Mapping | Legacy to SyWay S4 Purchasing Group Mapping |
Group for Calculation Schema | 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 | Legacy to SyWay S4 Confirmation Control Key Mapping |
Partner Function Mapping | *Legacy to SyWay S4 Partner Function Mapping |
Purchasing Currency Code Mapping | Legacy to SyWay S4 Purchasing Currency code mapping |
Vendor deDupe mapping (Purchasing Organization Data) | Dedupe Golden-Child (Purchasing Organization) Mapping |
Business Partner deDupe mapping (Global Data) | Dedupe Golden-Child (Global) 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 | Ensure all vendor master data collection templates, deduplication and cleansing completeness and no errors | Syniti / Data Team |
3 | Ensure that Business Partner – General is loaded | Syniti |
4 | Ensure that all required Configurations are in S/4 HANA | Data Team |
5 | Source Data Integrity | Syniti |
6 | Referential Integrity | Syniti |
| 7 | Data Team | |
| 8 | Performance and Scalability Considerations | Syniti |
| 9 | 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.
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. |
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)
See also
Change log
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||