| Status | Revision in Progress |
|---|---|
| Owner | |
| Stakeholders |
Purpose
The purpose of this document is to define the conversion approach for uploading Purchasing Info Record data into SAP S/4HANA. This includes the end-to-end method for extracting legacy data, applying the required transformation and validation rules, and preparing the final load files according to the approved templates and mapped fields.
Conversion Scope
The scope of this document covers the approach for converting active Purchasing Info Records and Purchasing Conditions from legacy SAP ECC systems (PF2, WP2) into SAP S/4HANA, following the Purchasing Info Record MDS document. For Syensqo, Info Records will be migrated to support operational purchasing, sourcing strategies. These records will be validated, cleansed, and migrated to S4HANA based on MDS Fields and Governance rule.
From the current system landscape, Info Record data exists separately in the legacy systems (PF2 and WP2), with potential discrepancies in vendors, materials, pricing conditions. Harmonization and validation are required to ensure accurate and consolidated data in S/4HANA.
List of source systems and approximate number of records
Source Info Record
Source | Scope | Source Approx No. of Records | Target System | Target ApproxNo. of Records |
|---|---|---|---|---|
PF2 | An initial extract of the relevant* data will be provided to Business to make decisions (info records / contracts)Relevant Info Records that are not flagged for deletion, and Purchasing Organization (+Plant where applicable) fall within the defined Enterprise Structure. In addition, both the Vendor and the Material must also be within scope. *RELEVANT Info records that are not marked for the deletion for inscope Purchasing Org/Plant based on the Enterprise Structure and Material based on Relevancy rule for 2019-Basic View and Vendors based on Relevancy rule for 3007-BP general. | Info Records >>>9.815 (EINA) Info Records >>> 10.230 (EINE) | S4H | |
WP2 | Info Records >>> 32.314 (EINA) Info Records >>> 34.364 (EINE) | S4H | ||
PF2 / WP2 | Data Analysis: EINA|EINE|KONP PF2: A067, A017, A066, A018, A025 AND A028 ==> >163.554 records analysed - Condition Types PB00 & PC
WP2: A067, A017, A066, A018, A025 AND A028 ==> >311.123 records analysed - PB00 & ZI01
|
|
|
Source DCT for Services/Other Material Types
Source | Scope | Source Approx No. of Records | Target System | Target ApproxNo. of Records |
|---|---|---|---|---|
PF2 | DCT will be populated by Business for Service master records or other materials for creation of PIRs where Inforecords are not in Legacy or data cannot be cleansed in Legacy.*RELEVANT Info records that are not marked for the deletion for inscope Purchasing Org/Plant based on the Enterprise Structure and Material based on Relevancy rule for 2019-Basic View and Vendors based on Relevancy rule for 3007-BP general. | Services >>> 9.821 (PF2.ASMD) Services >>> 59 (PF2.MARA) | S4H | Services >>> 9.821 (ASMD) as DCT Services >>> 59 (MARA) as DCT |
WP2 | Services >>> 353 (WP2.ASMD) Services >>> 54 (WP2.MARA) | S4H | Services >>> 353 (ASMD) as DCT Services >>> 54 (MARA) as DCT |
Relevancy Rules
- Relevancy Rule from ECC (for non service materials)
Given rules to be followed for Materials:
1) PIRs for in-scope materials per the ObjectID CNV-2019 / CNV-2020 (Materials) relevancy rules will be migrated;
2) PIRs for in-scope Vendors per the ObjectID CNV-3007 / CNV-3026 / CNV-3027 (Vendors) relevancy rule will be migrated;
3) PIRs with in-scope and valid pricing conditions/scales (if used in legacy) will be migrated. PIRs without price are valid to be migrated.
4) Info records with current validity dates will be migrated.
5) Scales for valid Info records will be migrated.
6) if Info records are missing in ECC then data must be collected from Business (DCT).
7) Info records with given conditions will be out of scope:
i) deletion flag at Header/item level
ii) Blocked (HeaderLevel: IF EINA-SPINF is not initial. the entire Info Record is blocked (including the entries from EINE)) OR (ItemLevel: IF EINE-LOEKZ is not initial. The info record is blocked for the combination Vendor | Material | Purch Org | Plant)
iii) expired validity dates
iv) pricing conditions not in scope
v) Info records for Plants and/or Purchasing Organisations not in scope as per enterprise structure (ES)
8) PIRs Migration Rules (decision for migration of Info Records will depend on given conditions)
- IF Contract (Vendor/Material) exit at material level, than no PIR migration
- IF Contract (Vendor/Material) at Material Grp level then PIR is required to be migrated
- IF Consignment PIR, than PIR should be migrated
9) Decision on Intercompany PIRs TBC
- Relevancy Rule from DCT (mainly for service materials)
Given rules to be followed by Services:
1) For Service master records and Service materials (ASMD and MARA table), the Data Collection Template (DCT) must be completed by the Business.
2) List of Service master records will be provided by functional leads, after validation with Business and other PODs.
3) Pricing data for service masters will be collected in DCT to create PIRs.
Process for NON-Service Materials
- Extract the data from Production.
- Prepare Excel reports to support the decision-making process.
- Share the Excel reports with the Business, so they can identify which records are relevant for PIRs or Contracts.
- After the Business makes the decision, the final list will be extracted directly from ECC, and the necessary transformation rules will be applied.
NOTES
- If PIRs with materials do not have Plant populated then we must check with
Business that Price will be applied to all plants.
Synit Report
| Field Description | Usage of the field |
| UNIQUE_ID | Unique ID defined by Syniti |
| RELEASE NO. | Release of the object |
| SOURCE SYSTEM | Source System ID |
| TARGET SYSTEM | Target System ID |
| Purchase Info Record | PIR Code |
| Material Number | Material Code with leading zeros |
| Material Group | Material Group |
| Account Number of Supplier | Account Number of Supplier |
| Short Text For Purchasing Info Record | Short Text For Purchasing Info Record |
| Unit Of Measure | Unit Of Measure |
| Numerator for Conversion of Order Unit to Base Unit | Numerator for Conversion of Order Unit to Base Unit |
| Denominator for Conversion of Order Unit to Base Unit | Denominator for Conversion of Order Unit to Base Unit |
| Material Number Used by Supplier | Material Number Used by Supplier |
| Purchasing Organization | Purchasing Organization |
| Purchasing Info Record Category | Purchasing Info Record Category |
| Purchasing info record category Description | Purchasing info record category Description |
| Plant | Plant |
| Info Record consignment flag | <YES / NO> |
| Purchasing Group | Purchasing Group |
| Currency | Currency |
| Minimum Order Quantity | Min Order Quantity |
| Standard Purchase Order Quantity | Standard Purchase Order Quantity |
| Net Price in Purchasing Info Record | Net Price value (PB00, if missing then other conditions available) |
| ECC Contract Flag | <YES / NO> |
| Contract (Material number) | |
| Contract (Material group) | |
| Number of Contracts | |
| ICERTIS Contract flag | <YES / NO> The link key is Vendor | PurchOrg |
| Decision by Rule |
|
| Migrate_AS | Possible Values: BUSINESS INPUT ALLOWED |
| Choose Golden PIR | <X / ' '> |
| Deletion Flag | Exclude Info Record to be migrated BUSINESS INPUT ALLOWED |
| z Comment | <OPEN TEXT FIELD> BUSINESS INPUT ALLOWED |
Additional Information
MDS Documents
Languages to be extracted (available on Source Systems)
SAP standard supports all ISO languages, ensure that all standard languages are considered in scope. It was decided to don't apply data restrictions according to the language.
Data Deduplication
Deduplication is not applied directly to this object. However, if either the vendor or the material is present on multiple systems, the data must be clubbed into a unique combination of Vendor|Material|PurchPrg|Plant in order to avoid inconsistencies.
Document Management
N/A
Legal Requirement
Minor efforts with taxation mapping are foreseen for some specific countries having specific taxations, the topic is limited to have the tax codes mapping (from Old to New tax code - functional team task).
Special Requirements
N/ATarget Design
For Info Records the data hierarchy ID described below with the related SAP Tables expected to be Extracted / Transformed / Loaded. All target tables are being considered in the MDS document.
MDS : Migration Design Specification
List of Rules from MDS:
| Rule # | Rule description |
| 1 | Info Records can be created at only Purchasing Organization level or Purch Org + Plant level according to business requirements. |
| 2 | Decision (TBC) - For Intercompany, PIR will be used only for Consignment Process, Price condition will not be required to be loaded |
| 3 | Decision (TBC) - For the Intercompany, as per MDS 'Pricing condition records' to store the Transfer Price will be coming from PaPM tool or we should migrate Pricing from ECC |
Target Design
The technical design of the target for this conversion approach.
Follow MDS for Governance Rules.
| Technical Table-Field | Field Label | Description | Syensqo Requirement | Data Type | Length | Conditional Logic |
| EINA-INFNR | Info record number | Info record number | Automatic | NUMC | 10 | |
| EINA-MATNR | Material | Material | Required | CHAR | 18 | |
| EINA-MATKL | Material Group | Material Group | Automatic | CHAR | 9 | |
| EINA-LIFNR | Supplier | Supplier | Required | CHAR | 10 | |
| EINA-LOEKZ | Complete | Complete - Deletion flag | Conditional | CHAR | 1 | Applies only if the Info record is to be deleted |
| EINA-ERDAT | Created On | Created On | Automatic | DATS | 8 | |
| EINA-ERNAM | Created By | Created By | Automatic | CHAR | 12 | |
| EINA-TXZ01 | Info Short Text | Info Short Text | Required | CHAR | 40 | |
| EINA-MEINS | Order Unit | Order Unit | Automatic | UNIT | 3 | |
| EINA-UMREZ | Equal To | Equal To | Automatic | NUMC | 5 | |
| EINA-UMREN | Denominator | Denominator | Automatic | NUMC | 5 | |
| EINA-IDNLF | Supp. Mat. No. | Supp. Mat. No. | Conditional | CHAR | 35 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-VERKF | Salesperson | Salesperson | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-TELF1 | Telephone | Telephone | Conditional | CHAR | 16 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-MAHN1 | 1st Rem./Exped. | 1st Rem./Exped. | Automatic | NUMC | 1 | |
| EINA-MAHN2 | 2nd Rem./Exped. | 2nd Rem./Exped. | Automatic | NUMC | 1 | |
| EINA-MAHN3 | 3rd Rem./Exped. | 3rd Rem./Exped. | Automatic | NUMC | 1 | |
| EINA-URZNR | Certificate | Certificate | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-URZDT | Valid to | Valid to | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-URZLA | C/R. of Origin | C/R. of Origin | Automatic | CHAR | 30 | |
| EINA-URZTP | Certif. Cat. | Certif. Cat. | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-URZZT | Number | Number | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-LMEIN | Base Unit | Base Unit | Automatic | UNIT | 3 | |
| EINA-REGIO | Region | Region | Automatic | CHAR | 30 | |
| EINA-VABME | Var. Order Unit | Var. Order Unit | Automatic | UNIT | 3 | |
| EINA-LTSNR | Suppl. Subrange | Suppl. Subrange | Conditional | NUMC | 10 | Applies only if there subranges maintained in Supplier Master data |
| EINA-LTSSF | SSR Sort No. | SSR Sort No. | Automatic | CHAR | 30 | |
| EINA-WGLIF | Suppl. Mat. Grp | Suppl. Mat. Grp | Automatic | CHAR | 30 | |
| EINA-LIFAB | Available from | Available from | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-LIFBI | Available to | Available to | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-KOLIF | Prior Supplier | Prior Supplier | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-ANZPU | Points | Points | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-PUNEI | Points Unit | Points Unit | Conditional | UNIT | 3 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-RELIF | Reg. Supplier | Reg. Supplier | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-MFRNR | Manufacturer | Manufacturer | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-DUMMY_EINA_INCL_EEW_PS | Ext. Include | Ext. Include | Automatic | CHAR | 30 | |
| EINA-LASTCHANGEDATETIME | Time Stamp | Time Stamp | Automatic | TIMS | 6 | |
| EINA-ISEOPBLOCKED | Busin. Purp. Cmpltd. | Busin. Purp. Cmpltd. | Automatic | CHAR | 30 | |
| EINE-INFNR | Info record number | Info record number | Upfront Automated | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-IPRKZ | Period Ind. | Period Ind. | Upfront Automated | CHAR | 1 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-ESOKZ | Infotype | Infotype | Required | CHAR | 1 | |
| EINE-WERKS | Plant | Plant | Conditional | CHAR | 4 | The field specifies the plant in which procurement would happen for specified material and supplier in PIR |
| EINE-EKORG | Purch. Org. Data | Purch. Org. Data | Automatic | CHAR | 1 | |
| EINE-ERDAT | Created On | Created On | Automatic | DATS | 8 | |
| EINE-ERNAM | Created By | Created By | Automatic | CHAR | 12 | |
| EINE-EKGRP | Purch. Group | Purch. Group | Conditional | CHAR | 3 | Applies only if the PIR is linked to a specific Pgroup; Dependent on Configuration |
| EINE-WAERS | Currency | Currency | Automatic | CUKY | 5 | |
| EINE-MINBM | Minimum Qty | Minimum Qty | Conditional | QUAN | 13 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-NORBM | Standard Qty | Standard Qty | Required | QUAN | 13 | |
| EINE-APLFZ | Pl. Deliv. Time | Pl. Deliv. Time | Conditional | TIMS | 6 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-UEBTO | Overdeliv. Tol. | Overdeliv. Tol. | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-UEBTK | Unlimited | Unlimited | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-UNTTO | Underdel. Tol. | Underdel. Tol. | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-ANGNR | Quotation | Quotation | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-ANGDT | Quotation from | Quotation from | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-ANFNR | RFQ | RFQ | Automatic | NUMC | 10 | |
| EINE-ANFPS | Item | Item | Automatic | CHAR | 30 | |
| EINE-ABSKZ | Rejection Ind. | Rejection Ind. | Automatic | CHAR | 1 | |
| EINE-BSTYP | Doc. Category | Doc. Category | Automatic | CHAR | 30 | |
| EINE-EBELN | Purchasing Doc. | Purchasing Doc. | Automatic | CHAR | 30 | |
| EINE-EBELP | Item | Item | Automatic | CHAR | 30 | |
| EINE-DATLB | Document Date | Document Date | Automatic | DATS | 8 | |
| EINE-NETPR | Net Price | Net Price | Required | CURR | 11 | |
| EINE-PEINH | Price unit | Price unit | Required | DEC | 5 | |
| EINE-BPRME | Order Price Un. | Order Price Un. | Automatic | CURR | 11 | |
| EINE-PRDAT | Valid to | Valid to | Automatic | DATS | 8 | |
| EINE-BPUMZ | Qty Conversion | Qty Conversion | Automatic | QUAN | 13 | |
| EINE-BPUMN | Qty Conversion | Qty Conversion | Automatic | QUAN | 13 | |
| EINE-MTXNO | No Mat. Text | No Mat. Text | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-WEBRE | GR-Based IV | GR-Based IV | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier, region, or material category). |
| EINE-EFFPR | Effect. Price | Effect. Price | Automatic | CURR | 11 | |
| EINE-EKKOL | Condition Group | Condition Group | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-SKTOF | No Cash Disc. | No Cash Disc. | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-KZABS | Acknowl. Reqd. | Acknowl. Reqd. | Conditional | CHAR | 40 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-MWSKZ | Tax Code | Tax Code | Conditional | CHAR | 2 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-TXDAT_FROM | Tax Rate Valid-From | Tax Rate Valid-From | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-TAX_COUNTRY | Tax Ctry/Reg. | Tax Ctry/Reg. | Required | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-BWTAR | Valuation Type | Valuation Type | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-EVERS | Shipping Instr. | Shipping Instr. | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-EXPRF | Procedure | Procedure | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). Dependent on configuration. |
| EINE-BSTAE | Conf. Control | Conf. Control | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-MEPRF | Pr. Date Cat. | Pr. Date Cat. | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-INCO1 | Incoterms | Incoterms | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-INCO2 | Incoterms 2 | Incoterms 2 | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-XERSN | No ERS | No ERS | Conditional | CHAR | 1 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-MHDRZ | Rem. Shelf Life | Rem. Shelf Life | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-VERID | Prod. Version | Prod. Version | Automatic | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-BSTMA | Max. Quantity | Max. Quantity | Conditional | QUAN | 13 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-RDPRF | Rnding Profile | Rnding Profile | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-MEGRU | UoM Group | UoM Group | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-J_1BNBM | NCM Code | NCM Code | Conditional | CHAR | 30 | Required for Brazil |
| EINE-INCOV | Inco. Version | Inco. Version | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-INCO2_L | Inco. Location1 | Inco. Location1 | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-INCO3_L | Inco. Location2 | Inco. Location2 | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-INCO2_KEY | Incoterm Location 1 | Incoterm Location 1 | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-INCO3_KEY | Incoterm Location 2 | Incoterm Location 2 | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-INCO4_KEY | Dev. Destination | Dev. Destination | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-AUT_SOURCE | Auto. Sourcing | Auto. Sourcing | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A018-KAPPL | Application | Application | Conditional | CHAR | 30 | |
| A018-KSCHL | Condition Type | Condition Type | Conditional | CHAR | 30 | Dependent on Configuration |
| A018-DATBI | Valid To | Valid To | Conditional | DATS | 8 | |
| A018-DATAB | Valid From | Valid From | Conditional | DATS | 8 | |
| A018-KNUMH | Cond.Record No. | Cond.Record No. | Conditional | NUMC | 10 | |
| KONP-KOPOS | Sequent. No. of Cond | Sequent. No. of Cond | Conditional | NUMC | 3 | |
| KONP-KSCHL | Condition Type | Condition Type | Conditional | CHAR | 30 | Dependent on Configuration |
| KONP-KNUMT | Text number | Text number | Conditional | NUMC | 10 | |
| KONP-STFKZ | Scale Type | Scale Type | Conditional | CHAR | 1 | |
| KONP-KZBZG | Scale Base Type | Scale Base Type | Conditional | CHAR | 1 | |
| KONP-KSTBM | Scale Quantity | Scale Quantity | Conditional | QUAN | 13 | |
| KONP-KONMS | Scale UoM | Scale UoM | Conditional | CHAR | 30 | |
| KONP-KSTBW | Scale Value | Scale Value | Conditional | CURR | 11 | |
| KONP-KONWS | Scale Currency | Scale Currency | Conditional | CUKY | 5 | |
| KONP-KRECH | Calculat.Type | Calculat.Type | Conditional | CHAR | 30 | |
| KONP-KBETR | Amount | Amount | Conditional | CURR | 11 | |
| KONP-KONWA | Cond. Currency | Cond. Currency | Conditional | CUKY | 5 | |
| KONP-KPEIN | Pricing Unit | Pricing Unit | Conditional | DEC | 5 | |
| KONP-KMEIN | Unit of Measure | Unit of Measure | Conditional | UNIT | 3 | |
| KONP-PRSCH | Scale Group | Scale Group | Conditional | CHAR | 30 | |
| KONP-KUMZA | Numer.for Conv. | Numer.for Conv. | Conditional | CHAR | 30 | |
| KONP-KUMNE | Den. for Conv. | Den. for Conv. | Conditional | CHAR | 30 | |
| KONP-MEINS | Base Unit | Base Unit | Conditional | UNIT | 3 | |
| KONP-MXWRT | Lower limit | Lower limit | Conditional | CHAR | 30 | |
| KONP-GKWRT | Upper limit | Upper limit | Conditional | CHAR | 30 | |
| KONP-PKWRT | PlannedCondVal. | PlannedCondVal. | Conditional | CHAR | 30 | |
| KONP-FKWRT | Cumulative value | Cumulative value | Conditional | CURR | 11 | |
| KONP-RSWRT | Cumulative accr | Cumulative accr | Conditional | CHAR | 30 | |
| KONP-KWAEH | Cndn Currency | Cndn Currency | Conditional | CUKY | 5 | |
| KONP-UKBAS | Planned basis | Planned basis | Conditional | CHAR | 30 | |
| KONP-KZNEP | Exclusion | Exclusion | Conditional | CHAR | 1 | |
| KONP-KUNNR | Customer | Customer | Conditional | NUMC | 10 | |
| KONP-LIFNR | Supplier | Supplier | Conditional | CHAR | 10 | |
| KONP-MWSK1 | Tax Code | Tax Code | Conditional | CHAR | 30 | Dependent on Configuration |
| KONP-LOEVM_KO | Deletion Indic. | Deletion Indic. | Conditional | CHAR | 30 | |
| KONP-ZAEHK_IND | Cond.Item Index | Cond.Item Index | Conditional | CHAR | 30 | |
| KONP-BOMAT | Matl f. settl. | Matl f. settl. | Conditional | CHAR | 30 | |
| KONP-KBRUE | Accruals | Accruals | Conditional | CHAR | 30 | |
| KONP-KSPAE | Retroactive | Retroactive | Conditional | CHAR | 30 | |
| KONP-BOSTA | Cond.Rec Status | Cond.Rec Status | Conditional | CHAR | 30 | |
| KONP-KNUMA_PI | Promotion | Promotion | Conditional | CHAR | 30 | |
| KONP-KNUMA_AG | Sales Deal | Sales Deal | Conditional | CHAR | 30 | |
| KONP-KNUMA_SQ | Sales quote | Sales quote | Conditional | CHAR | 30 | |
| KONP-VALTG | Add. Value Days | Add. Value Days | Conditional | CURR | 11 | |
| KONP-VALDT | Fixed Val. Date | Fixed Val. Date | Conditional | DATS | 8 | |
| KONP-ZTERM | Pyt Terms | Pyt Terms | Conditional | CHAR | 30 | |
| KONP-ANZAUF | NumberOfOrders | NumberOfOrders | Conditional | NUMC | 10 | |
| KONP-MIKBAS | MinCondBaseVal. | MinCondBaseVal. | Conditional | CHAR | 30 | |
| KONP-MXKBAS | MaxCondBaseVal. | MaxCondBaseVal. | Conditional | CHAR | 30 | |
| KONP-KOMXWRT | MaxConditValue | MaxConditValue | Conditional | CURR | 11 | |
| KONP-KLF_STG | Increment scale | Increment scale | Conditional | CHAR | 30 | |
| KONP-KLF_KAL | Pricing scale | Pricing scale | Conditional | CHAR | 30 | |
| KONP-VKKAL | Rel. to Pricing | Rel. to Pricing | Conditional | CHAR | 30 | |
| KONP-AKTNR | Promotion | Promotion | Conditional | NUMC | 10 | |
| KONP-KNUMA_BO | Agreement | Agreement | Conditional | CHAR | 30 | |
| KONP-MWSK2 | W/Tax Code | W/Tax Code | Conditional | CHAR | 30 | Dependent on Configuration |
| KONP-VERTT | Contract Type | Contract Type | Conditional | CHAR | 30 | |
| KONP-VERTN | Contract Number | Contract Number | Conditional | NUMC | 10 | |
| KONP-VBEWA | Flow Type | Flow Type | Conditional | CHAR | 30 | |
| KONP-MDFLG | Matrix Maint. | Matrix Maint. | Conditional | CHAR | 30 | |
| KONP-KFRST | Release Status | Release Status | Conditional | CHAR | 30 | |
| KONP-UASTA | Status BV c/a | Status BV c/a | Conditional | CHAR | 30 | |
| KONP-CNDN_CHGREASON | Cndn Change Reason | Cndn Change Reason | Conditional | CHAR | 30 | |
| KONP-CMMDTYPRCGCNDNFMLAU | Doc. Cond. Item GUID | Doc. Cond. Item GUID | Conditional | CHAR | 32 | |
| KONH-KVEWE | Usage | Usage | Conditional | CHAR | 1 | |
| KONH-KOTABNR | Table Number | Table Number | Conditional | NUMC | 10 | |
| KONH-KSCHL | Condition Type | Condition Type | Conditional | CHAR | 30 | Dependent on Configuration |
| KONH-DATAB | Valid From | Valid From | Conditional | DATS | 8 | |
| KONH-DATBI | Valid To | Valid To | Conditional | DATS | 8 | |
| KONH-KOSRT | Search term | Search term | Conditional | CHAR | 30 | |
| KONH-KZUST | Responsibility | Responsibility | Conditional | CHAR | 30 | |
| KONH-LICNO | License Number | License Number | Conditional | CHAR | 35 | |
| KONH-LICDT | License Date | License Date | Conditional | DATS | 8 | |
| KONH-TKONN | Trading Contract | Trading Contract | Conditional | CHAR | 30 | |
| KONH-CCNUM | Condition Contract | Condition Contract | Conditional | CHAR | 35 | |
| KONH-EXTERNAL_GUID | External GUID | External GUID | Conditional | CHAR | 32 | |
| KONH-REFERENCE | Reference | Reference | Conditional | CHAR | 35 | |
| KONH-PRICEAPPROVALREQUEST | Approval Request | Approval Request | Conditional | CHAR | 30 | |
| KONH-KNUMH_PREV_APRVD | Cond.Record No. | Cond.Record No. | Conditional | CHAR | 30 | |
| KONH-UPD_TMSTMP | Time Stamp | Time Stamp | Conditional | TIMS | 6 | |
| STXH-TDOBJECT | Text object | Text object | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDNAME | Text Name | Text Name | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDID | Text ID | Text ID | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDSPRAS | Language | Language | Conditional | CHAR | 1 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDTITLE | Short Title | Short Title | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). Dependent on Configuration |
| STXH-TDFRELES | Release | Release | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDFUSER | Created By | Created By | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDFDATE | Date | Date | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDFTIME | Time | Time | Conditional | TIMS | 6 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDLRELES | Release | Release | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDLUSER | Changed by | Changed by | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDLDATE | Date | Date | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDLTIME | Time | Time | Conditional | TIMS | 6 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDVERSION | Version | Version | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDSTYLE | Style | Style | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDFORM | Form | Form | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDHYPHENAT | Hyphenation | Hyphenation | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDTRANSTAT | Translation | Translation | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDOSPRAS | Original Lang. | Original Lang. | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDMACODE1 | Short Title 1 | Short Title 1 | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDMACODE2 | Short Title 2 | Short Title 2 | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDTXTLINES | No. of Lines | No. of Lines | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDREF | Reference | Reference | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDREFOBJ | Reference obj. | Reference obj. | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDREFNAME | Reference name | Reference name | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDREFID | Reference ID | Reference ID | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDTEXTTYPE | Text format | Text format | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDCOMPRESS | Compressed | Compressed | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-TDOCLASS | Class | Class | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXH-LOGSYS | Logical system | Logical system | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXL-RELID | CHAR02 data element | CHAR02 data element | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXL-TDOBJECT | Text object | Text object | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXL-TDNAME | Text Name | Text Name | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXL-TDID | Text ID | Text ID | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXL-TDSPRAS | Language | Language | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXL-SRTF2 | BIN1 data element fo | BIN1 data element fo | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXL-CLUSTR | BIN2 data element fo | BIN2 data element fo | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| STXL-CLUSTD | Data | Data | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A017-KAPPL | Application | Application | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A017-KSCHL | Condition Type | Condition Type | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). Dependent on Configuration |
| A017-LIFNR | Supplier | Supplier | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A017-MATNR | Material | Material | Conditional | CHAR | 18 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A017-EKORG | Purchasing Org. | Purchasing Org. | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A017-WERKS | Plant | Plant | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). ; Dependent on Configuration |
| A017-ESOKZ | Infotype | Infotype | Conditional | CHAR | 1 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A017-DATBI | Valid To | Valid To | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A017-DATAB | Valid From | Valid From | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A017-KNUMH | Cond.Record No. | Cond.Record No. | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-KAPPL | Application | Application | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-KSCHL | Condition Type | Condition Type | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). Dependent on Configuration |
| A025-LIFNR | Supplier | Supplier | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-EKORG | Purchasing Org. | Purchasing Org. | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-MATKL | Material Group | Material Group | Conditional | CHAR | 9 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-INFNR | Info record | Info record | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-WERKS | Plant | Plant | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). ; Dependent on Configuration |
| A025-ESOKZ | Infotype | Infotype | Conditional | CHAR | 1 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-DATBI | Valid To | Valid To | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-DATAB | Valid From | Valid From | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A025-KNUMH | Cond.Record No. | Cond.Record No. | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-KAPPL | Application | Application | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-KSCHL | Condition Type | Condition Type | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). Dependent on Configuration |
| A028-LIFNR | Supplier | Supplier | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-EKORG | Purchasing Org. | Purchasing Org. | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-MATKL | Material Group | Material Group | Conditional | CHAR | 9 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-INFNR | Info record | Info record | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-ESOKZ | Infotype | Infotype | Conditional | CHAR | 1 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-DATBI | Valid To | Valid To | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-DATAB | Valid From | Valid From | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A028-KNUMH | Cond.Record No. | Cond.Record No. | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-KAPPL | Application | Application | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-KSCHL | Condition Type | Condition Type | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). Dependent on Configuration |
| A066-LIFNR | Supplier | Supplier | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-MATNR | Material | Material | Conditional | CHAR | 18 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-EKORG | Purchasing Org. | Purchasing Org. | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-ESOKZ | Infotype | Infotype | Conditional | CHAR | 1 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-BSTME | Order Unit | Order Unit | Conditional | UNIT | 3 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-DATBI | Valid To | Valid To | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-DATAB | Valid From | Valid From | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A066-KNUMH | Cond.Record No. | Cond.Record No. | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-KAPPL | Application | Application | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-KSCHL | Condition Type | Condition Type | Conditional | CHAR | 30 | Applies only if business condition is met (e.g. Supplier type, region, or material category). Dependent on Configuration |
| A067-LIFNR | Supplier | Supplier | Conditional | CHAR | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-MATNR | Material | Material | Conditional | CHAR | 18 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-EKORG | Purchasing Org. | Purchasing Org. | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-ESOKZ | Infotype | Infotype | Conditional | CHAR | 1 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-WERKS | Plant | Plant | Conditional | CHAR | 4 | Applies only if business condition is met (e.g. Supplier type, region, or material category). ; Dependent on Configuration |
| A067-BSTME | Order Unit | Order Unit | Conditional | UNIT | 3 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-DATBI | Valid To | Valid To | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-DATAB | Valid From | Valid From | Conditional | DATS | 8 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| A067-KNUMH | Cond.Record No. | Cond.Record No. | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONW-KNUMH | Cond.Record No. | Cond.Record No. | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONW-KOPOS | Sequent. No. of Cond | Sequent. No. of Cond | Conditional | NUMC | 3 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONW-KLFN1 | Line number | Line number | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONW-KSTBW | Scale Value | Scale Value | Conditional | CURR | 11 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONW-KBETR | Amount | Amount | Conditional | CURR | 11 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONM-KNUMH | Cond.Record No. | Cond.Record No. | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONM-KOPOS | Sequent. No. of Cond | Sequent. No. of Cond | Conditional | NUMC | 3 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONM-KLFN1 | Line number | Line number | Conditional | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONM-KSTBM | Scale Quantity | Scale Quantity | Conditional | CURR | 11 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| KONM-KBETR | Amount | Amount | Conditional | CURR | 11 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINA-SORTL | Sort Term | Sort Term | Conditional | CHAR | 20 | |
| EINE-INFNR | Info record number | Info record number | Automatic | NUMC | 10 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
| EINE-IPRKZ | Period Ind. | Period Ind. | Conditional | CHAR | 2 | Applies only if business condition is met (e.g. Supplier type, region, or material category). |
Data Cleansing
Reports
| Cleansing Description | Reference Table Code | Criteria | Expected Outcome |
| Vendor–Material Alignment Report | EINA / LFA1 / MARA | Checks that each valid Info Record, have an active vendor (LFA1-LOEVM = '') and active material (MARA-LVORM = ''). | Highlight valid Info Records referencing deleted or inactive vendors/materials. |
| Currency & UoM Validation Report | EINE / TCURC / MARM | Check that WAERS is valid and UoM ratios (UMREZ, UMREN) are consistent with MARM definitions. | Detect invalid currencies or inconsistent unit conversions for standardization. Consider that UOM and Currencies must be aligned with the TO-BE |
| Condition Record Linkage Report | KONH / KONP / EINE | Verify existence and correctness of linked pricing conditions (KNUMH, KSCHL, KBETR). | Highlight Info Records missing or inconsistently linked to valid condition records. |
| Vendor Block Check Report | EINA / LFA1 / | Flag Info Records linked to blocked vendors (LFA1-SPERR = 'X' or LFM1-LOEVM = 'X'). | Provide list of Info Records that should be deactivated or excluded. |
| Deleted entry in EINE | EINA / EINE | Provide list of active Info Records in EINA, but having all entries in EINE marked for deletion | Detect Invalid entries in EINE, but valid in EINA |
| PIR without Plant | EINE | Identify PIR without Plant Extension and report to Business Purch InfoRec | PurchOrg | Plant | Price | UoM | The cleansing report will highlight PIRs without plant extensions |
| Materials without Contract and PIR | MARA/EKKO/EINA | Identify Materials without PIR and Contract | Business should be able to identify materials not being covered by a Contract / PIR by Material Type |
| Validity Period in the future | EINE / KONP | Report for price conditions where validity date is in future (> today's date) | Business to check whether the Info Record is valid to migrated without a price |
| Validation of Prices | EINA / EINE | Report PIRs that are in scope, and have no price (EINE-NETPR) or the price is equal to 0,00 | Business to check whether the Info Record is valid to migrated without a price |
Conversion Process
The high-level process is represented by the diagram below:
DCT to be used for 1) Inforecords for Service Materials 2) Inforecords which are not found in ECC 3) Info Records cannot be cleansed in Source System.
e
Data Privacy and Sensitivity
N/AExtraction
Extraction Run Sheet
001 | Extract data from the source systems using the records identified in the ECC system (for non service materials) | Syniti |
| Req # | Requirement Description | Team Responsible |
|---|---|---|
| 001 | Verify connectivity and authorizations to source ECC systems before execution. | Syniti Team |
| 002 | Confirm selection scope: Purchasing Organizations, Plants, Vendors, and Materials to be included in the extraction. | Syniti Team |
| 005 | Extract Info Records for Vendors that are not marked for deletion (LFM1-LOEVM ≠ ‘X’) and are within scope. | Syniti Team |
| 006 | Extract Info Records for active Vendors and Materials only – exclude entries with deletion or obsolete flags. | Syniti Team |
| 007 | Extract Info Records for Materials that are not marked for deletion and belong to valid Info Record combinations. | Syniti Team |
| 008 | Extract condition records (KONH/KONP, A017/A018/...) corresponding to valid Info Records, using non-overlapping validity dates. | Syniti Team |
| 009 | Extract long texts (STXH/STXL) for valid Info Records and ensure language completeness (including all ISO languages and excluding out of scope languages) | Syniti Team |
| 012 | Submit extraction output for validation to Business | SyWay Data Team |
Selection Screen
A Target Ready Data Collection Template will be created for the required data, except for fields that need transformation as per the defined transformation rules. These templates will follow the format required by the target S/4HANA Info Record & Purchasing Pricing Configuration.| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| Topic N/A | ||||
Data Collection Template (DCT) - Material/Service Master records
This template captures the essential fields required for the Purchasing Info Record (PIR) object. The structure of DCT to be used when data needs to be collected or enriched manually, especially for services or records not available or incomplete in the legacy system; it should collect information for header / item / condition type / scales / long text (where required).
Basic Data Info
| Field Name | Data Type | Length | Description | Rule |
| INFNR | CHAR | 10 | Info Record Number | Required |
| EINA-MATNR | CHAR | 18 | Material Number | Required |
| EINA-MATKL | CHAR | 9 | Material Group | Conditional |
| EINA-LIFNR | CHAR | 10 | Vendor Number | Required |
| EINA-TXZ01 | CHAR | 40 | Sort term for Non-Stock Info Records | Conditional |
| EINA-TXZ01 | CHAR | 40 | Short Text | Conditional |
| EINA-MEINS | UNIT | 3 | Base Unit of Measure | Conditional |
| EINA-UMREZ | NUMC | 5 | Numerator for Conversion | Conditional |
| EINA-UMREN | NUMC | 5 | Denominator for Conversion | Conditional |
| EINA-IDNLF | CHAR | 35 | Material Number Used by Supplier | Conditional |
| EINA-VERKF | CHAR | 30 | Salesperson at vendor | Conditional |
| EINA-TELF1 | CHAR | 16 | Vendor’s telephone number | Conditional |
| EINA-MAHN1 | CURR | 11 | Dunning amount limit (level 1) | Conditional |
| EINA-MAHN2 | CURR | 11 | Dunning amount limit (level 2) | Conditional |
| EINA-MAHN3 | CURR | 11 | Dunning amount limit (level 3) | Conditional |
| EINA-LMEIN | UNIT | 3 | Order unit of measure | Conditional |
| EINA-VABME | CURR | 13 | Total value of purchase order items | Conditional |
| EINA-WGLIF | CHAR | 3 | Vendor country key | Conditional |
| EINA-KOLIF | CHAR | 10 | Collective number for vendor | Conditional |
| EINA-URZLA | CHAR | 3 | Terms of payment key | Conditional |
| EINA-REGIO | CHAR | 3 | Region (state, province, county) | Conditional |
| EINA-MFRNR | CHAR | 10 | Manufacturer number | Conditional |
| EINA-LIFAB | DATS | 8 | Validity start date of vendor record | Conditional |
| EINA-LIFBI | DATS | 8 | Validity end date of vendor record | Conditional |
| EINA-RELIF | CHAR | 1 | Relevant for automatic release (indicator) | Conditional |
Long Text General Data
| Field Name | Data Type | Length | Description | Rule |
| INFNR | CHAR | 10 | Info Record Number | Required |
| TDSPRAS | CHAR | 1 | Language Key | Required |
| TEXT | CHAR | Text | Required |
Purchasing Info
| Field Name | Data Type | Length | Description | Rule |
| INFNR | CHAR | 10 | Info Record Number | Required |
| EINE-EKORG | CHAR | 4 | Purchasing Organization | Required |
| EINE-ESOKZ | CHAR | 1 | Info Category (Standard/Subcontracting/Consignment) | Required |
| EINE-WERKS | CHAR | 4 | Plant | Required |
| EINE-EKGRP | CHAR | 3 | Purchasing Group | Required |
| EINE-WAERS | CUKY | 5 | Currency Key | Required |
| EINE-MINBM | QUAN | 13,3 | Minimum Order Quantity | Required |
| EINE-NORBM | QUAN | 13,3 | Normal Order Quantity | Conditional |
| EINE-APLFZ | DEC | 3 | Planned Delivery Time (in Days) | Conditional |
| EINE-UEBTO | DEC | 3 | Overdelivery Tolerance Limit (%) | Conditional |
| EINE-UEBTK | CHAR | 1 | Unlimited Overdelivery Allowed (Indicator) | Conditional |
| EINE-UNTTO | DEC | 3 | Underdelivery Tolerance Limit (%) | Conditional |
| EINE-BWTAR | CHAR | 10 | Valuation Type | Conditional |
| EINE-MTXNO | CHAR | 20 | Material Text Number | Conditional |
| EINE-WEBRE | CHAR | 1 | Goods Receipt-Based Invoice Verification | Conditional |
| EINE-KZABS | CHAR | 1 | Final Invoice Indicator | Conditional |
| EINE-MWSKZ | CHAR | 2 | Tax Code | Conditional |
| EINE-EVERS | CHAR | 2 | Shipping Instructions | Conditional |
| EINE-BSTAE | CHAR | 2 | Confirmation Control Key | Conditional |
| EINE-XERSN | CHAR | 1 | Reminder for Goods Receipt | Conditional |
| EINE-MHDRZ | DEC | 3 | Minimum Remaining Shelf Life (in Days) | Conditional |
| EINE-IPRKZ | CHAR | 1 | Info Record Update Indicator | Conditional |
| EINE-BSTMA | QUAN | 13 | Maximum Order Quantity | Conditional |
| EXPRF_LAND1 | CHAR | 3 | Country for Export/Import Processing | Conditional |
| EINE-EXPRF | CHAR | 1 | Export/Import Indicator | Conditional |
| EINE-RDPRF | CHAR | 1 | Rounding Profile | Conditional |
| EINE-VENDOR_RMA_REQ | CHAR | 1 | Vendor RMA (Return Material Authorization) Required | Conditional |
| EINE-AUT_SOURCE | CHAR | 1 | Automatic Source List Update Indicator | Conditional |
| EINE-SKTOF | CHAR | 1 | Cash Discount Indicator | Conditional |
| EINE-MEPRF | CHAR | 1 | Price Determination Schema (Pricing Profile) | Conditional |
| EINE-INCOV | CHAR | 3 | Incoterms Version | Conditional |
| EINE-INCO1 | CHAR | 3 | Incoterms (Part 1) | Conditional |
| EINE-INCO2_L | CHAR | 70 | Incoterms Location 1 (Long Text) | Conditional |
| EINE-INCO3_L | CHAR | 70 | Incoterms Location 2 (Long Text) | Conditional |
Conditions
| Field Name | Data Type | Length | Description | Rule |
| INFNR | CHAR | 10 | Info Record Number | Required |
| COND-EKORG | CHAR | 4 | Purchasing Organization | Required |
| COND-ESOKZ | CHAR | 1 | Purchasing Info Category (Standard, Subcontracting, Consignment, Pipeline) | Required |
| COND-WERKS | CHAR | 4 | Plant | Required |
| COND-KOPOS | NUMC | 3 | Sequential Number of Condition Record | Required |
| COND-COND_TYPE | CHAR | 4 | Condition Type (e.g., PB00, PBXX, RA01) | Required |
| COND-VALID_FROM | DATS | 8 | Validity Start Date for the Condition | Conditional |
| COND-VALID_TO | DATS | 8 | Validity End Date for the Condition | Conditional |
| KRECH | CHAR | 1 | Calculation Type for Condition (e.g., Percentage, Amount) | Conditional |
| COND-KBETR_EXT | CURR | 11 | Condition Amount (External Representation) | Conditional |
| COND-KONWA | CUKY | 5 | Currency Key for Condition | Conditional |
| COND-KPEIN | DEC | 5 | Pricing Unit (Base Quantity for Condition) | Conditional |
| COND-KMEIN | UNIT | 3 | Condition Unit (Unit of Measure for Condition) | Conditional |
| COND-KUMZA | DEC | 5 | Numerator for Condition Conversion Factor | Conditional |
| COND-KUMNE | DEC | 5 | Denominator for Condition Conversion Factor | Conditional |
| COND-MEINS | UNIT | 3 | Base Unit of Measure | Conditional |
| COND-KONMS | UNIT | 3 | Condition Unit of Measure (Alternative) | Conditional |
| COND-EXCLUSION_IND | CHAR | 1 | Exclusion Indicator (for Condition Exclusion Logic) | Conditional |
Scales
| Field Name | Data Type | Length | Description | Rule |
| INFNR | CHAR | 10 | Info Record Number | Required |
| EKORG | CHAR | 4 | Purchasing Organization | Required |
| ESOKZ | CHAR | 1 | Purchasing Info Category (Standard, Subcontracting, Consignment, Pipeline) | Required |
| WERKS | CHAR | 4 | Plant | Required |
| KOPOS | NUMC | 3 | Sequential Number of Condition Record | Required |
| COND_TYPE | CHAR | 4 | Condition Type (e.g., PB00, PBXX, RA01) | Required |
| VALID_FROM | DATS | 8 | Validity Start Date for Condition | Conditional |
| VALID_TO | DATS | 8 | Validity End Date for Condition | Conditional |
| LINE_NO | NUMC | 6 | Scale Line Number | Conditional |
| KSTBM | QUAN | 13 | Scale Quantity or Value Basis (threshold for scale) | Conditional |
| KBETR | CURR | 11 | Condition Rate (price or percentage) | Conditional |
| SCALE_VAL | CURR | 13 | Scale Value (e.g., price value corresponding to KSTBM) | Conditional |
| KBETR_VAL | CURR | 13 | Calculated Condition Amount for the Scale Level | Conditional |
Long Text Purchasing Organization
| Field Name | Data Type | Length | Description | Rule |
| INFNR | CHAR | 10 | Info Record Number | Required |
| EKORG | CHAR | 4 | Purchasing Organization | Required |
| ESOKZ | CHAR | 1 | Purchasing Info Category (Standard, Subcontracting, Consignment, Pipeline) | Required |
| WERKS | CHAR | 4 | Plant | Required |
| TDSPRAS | CHAR | 1 | Language Key | Required |
| TEXT | CHAR | Text | Required |
Extraction Dependencies
| Item # | Step Description | Team Responsible |
|---|---|---|
| 001 | ECC system access and table authorizations (connectivity) | Syniti team |
| 002 | SQL access to Production DB or a copy of it's relevant tables (connectivity) | Syniti team |
| 003 | Availability of DCT information for cases where Info Records are missing in ECC but required in S/4. | Data team |
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:
- 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
- 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 Mapping/Rules (Source ECC / DCT)
| Source Field Information | Transform Rules | Target Field Information | |||||||||||||
| Sequence | Technical Source Table | Field Name | Technical Source Field | Field Type | Field Length | Mapping Type | Transform Rule or Default Value | Validation Rule Inline with Governance Rule | Comments | Field Description | Type | Length | Decimal | Sap Table Name | Sap Field Name |
| EINA Table | |||||||||||||||
| 1.001 | EINA | INFNR | Legacy Number of Purchasing Info Record | NUMC | 10 | - Mandatory for Migration Cockpit | Legacy Number of Purchasing Info Record | NUMC | 10 | S_EINA | INFNR | ||||
| 1.002 | EINA | MATNR | (Material Number | CHAR | 18 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for <MATERIALS> and update the target field. | - Relevant for DataCleansing - Relevant for DataConversion (Mapping)
| Product Number | CHAR | 18 | S_EINA | MATNR | ||
| 1.003 | EINA | MATKL | Material Group - MATKL | CHAR | 9 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for <MATKL> and update the target field. | Dependent on Configuration | - Relevant for DataCleansing | Product Group | CHAR | 9 | S_EINA | MATKL | |
| 1.004 | EINA | LIFNR | Supplier's Account Number (Vendor Number - LIFNR) | CHAR | 10 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Vendor <LIFNR> and update the target field. | - Mandatory for Migration Cockpit | Supplier's Account Number | CHAR | 10 | S_EINA | LIFNR | ||
| 1.005 | EINA | TXZ01 | Short Text for Purchasing Info Record | CHAR | 40 | 1) Copy source field value as-is to the target field (1:1 direct mapping). | Short Text for Purchasing Info Record | CHAR | 40 | S_EINA | TXZ01 | ||||
| 1.006 | EINA | SORTL | Sort Term for Non-Stock Info Records | CHAR | 20 | 1) Copy source field value as-is to the target field (1:1 direct mapping). | Sort Term for Non-Stock Info Records | CHAR | 20 | S_EINA | SORTL | ||||
| 1.007 | EINA | MEINS | Order Unit (ISO Format) | UNIT | 3 | Transformation Rule | 1)Use the source value, and lookup on the mapping table for Unit of Measure - UOM <MEINS> and update the target field. | Dependent on Configuration | - Relevant for DataConversion (Mapping) | Order Unit (ISO Format) | UNIT | 3 | S_EINA | MEINS | |
| 1.008 | EINA | UMREZ | Numerator for Conversion of Order Unit | NUMC | 5 | 1) Copy source field value as-is to the target field (1:1 direct mapping). | Numerator for Conversion of Order Unit | NUMC | 5 | S_EINA | UMREZ | ||||
| 1.009 | EINA | UMREN | Denominator for Conversion of Order Unit | NUMC | 5 | 1) Copy source field value as-is to the target field (1:1 direct mapping). | Denominator for Conversion of Order Unit | NUMC | 5 | S_EINA | UMREN | ||||
| 1.010 | EINA | IDNLF | Material Number Used by Supplier | CHAR | 35 | 1) Copy source field value as-is to the target field (1:1 direct mapping). | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Product Number Used by Supplier | CHAR | 35 | S_EINA | IDNLF | |||
| 1.011 | EINA | VERKF | Salesperson Responsible | CHAR | 30 | 1) Copy source field value as-is to the target field (1:1 direct mapping). | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Salesperson Responsible | CHAR | 30 | S_EINA | VERKF | |||
| 1.012 | EINA | TELF1 | Supplier's Telephone Number | CHAR | 16 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Supplier's Telephone Number | CHAR | 16 | S_EINA | TELF1 | |||
| 1.013 | EINA | MAHN1 | Days for First Reminder/Expediter | NUMC | 1 | 1) Use the source value to update the target field AS-IS | Days for First Reminder/Expediter | NUMC | 1 | S_EINA | MAHN1 | ||||
| 1.014 | EINA | MAHN2 | Days for Second Reminder/Expediter | NUMC | 1 | 1) Use the source value to update the target field AS-IS | Days for Second Reminder/Expediter | NUMC | 1 | S_EINA | MAHN2 | ||||
| 1.015 | EINA | MAHN3 | Days for Third Reminder/Expediter | NUMC | 1 | 1) Use the source value to update the target field AS-IS | Days for Third Reminder/Expediter | NUMC | 1 | S_EINA | MAHN3 | ||||
| 1.016 | EINA | URZNR | Change Number | CHAR | 12 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure | Change Number | CHAR | 12 | S_EINA | URZNR | |||
| 1.017 | EINA | URZDT | Valid to | CHAR | 10 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure | Valid to | CHAR | S_EINA | URZDT | ||||
| 1.018 | EINA | URZLA | C/R. of Origin | CHAR | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure | C/R. of Origin | CHAR | S_EINA | URZLA | |||||
| 1.019 | EINA | URZTP | Certif. Cat. | CHAR | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure | Certif. Cat. | CHAR | S_EINA | URZTP | |||||
| 1.020 | EINA | URZZT | Time Stamp (UTC) | DEC (packed) | 15 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure | Time Stamp (UTC) | DEC (packed) | 15 | S_EINA | URZZT | |||
| 1.021 | EINA | LMEIN | Base Unit of Measure (ISO Format) | UNIT | 3 | Transformation Rule | 1)Use the source value, and lookup on the mapping table for Unit of Measure - UOM <MEINS> and update the target field. | - Relevant for DataConversion (Mapping) | Base Unit of Measure (ISO Format) | UNIT | 3 | S_EINA | LMEIN | ||
| 1.022 | EINA | REGIO | Region | CHAR | 30 | Copy source field value as-is to the target field (1:1 direct mapping). | Region | CHAR | 30 | S_EINA | REGIO | ||||
| 1.023 | EINA | VABME | Variable Purchase Order Unit Active | UNIT | 3 | Transformation Rule | 1) Use the source value to update the target field AS-IS | - Relevant for DataConversion (Mapping) | Variable Purchase Order Unit Active | UNIT | 3 | S_EINA | VABME | ||
| 1.024 | EINA | WGLIF | Supplier Material Group | CHAR | 30 | Transformation Rule | 1) Use the source value to update the target field AS-IS | Supplier Product Group | CHAR | 30 | S_EINA | WGLIF | |||
| 1.025 | EINA | LIFAB | Available (Deliverable) From | CHAR | 30 | Copy source field value as-is to the target field (1:1 direct mapping). Target field format: DD.MM.YYYY | Available (Deliverable) From | CHAR | 30 | S_EINA | LIFAB | ||||
| 1.026 | EINA | LIFBI | Available (Deliverable) Until | CHAR | 30 | Copy source field value as-is to the target field (1:1 direct mapping). Target field format: DD.MM.YYYY | Available (Deliverable) Until | CHAR | 30 | S_EINA | LIFBI | ||||
| 1.027 | EINA | KOLIF | Prior Supplier | CHAR | 10 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Vendor <LIFNR> and update the target fields. | - Relevant for DataCleansing | Prior Supplier | CHAR | 10 | S_EINA | KOLIF | ||
| 1.028 | EINA | ANZPU | Number of Price Units | DEC (packed) | 5 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure | Number of Price Units | DEC (packed) | 5 | S_EINA | ANZPU | |||
| 1.029 | EINA | PUNEI | Price Unit | UNIT (char) | 3 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure | Price Unit | UNIT (char) | 3 | S_EINA | PUNEI | |||
| 1.030 | EINA | RELIF | Indicator: Regular Supplier | CHAR | 10 | Copy source field value as-is to the target field (1:1 direct mapping). | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Indicator: Regular Supplier | CHAR | 10 | S_EINA | RELIF | |||
| 1.031 | EINA | URZLA | Country/Region of Origin | CHAR | 30 | Copy source field value as-is to the target field (1:1 direct mapping). | Country/Region of Origin | CHAR | 30 | S_EINA | URZLA | ||||
| 1.032 | EINA | MFRNR | Manufacturer | CHAR | 10 | Transformation Rule | Use the source value, and lookup on the mapping table for Vendors <LIFNR>. | Applies only if business condition is met (e.g. Supplier type, region, or material category). | - Relevant for DataConversion (Mapping) | Manufacturer | CHAR | 10 | S_EINA | MFRNR | |
| For a direct extraction - In order to select the data from STXL proceed as follow: STEP_1: Select * From STXL Where TDOBJECT = EINA TDNAME = <Info Record Number CHAR10) *Create one entry for each language STXL-TDSPRAS | |||||||||||||||
| 2.001 | EINA | INFNR | Legacy Number of Purchasing Info Record | NUMC | 10 | Maintain the same number for each Info Record transaction. Since data is being merged from both PF2 and WP2 systems, it is not recommended to reuse the source number, as this could lead to number clashes or duplication conflicts. | - Mandatory for Migration Cockpit | Legacy Number of Purchasing Info Record | NUMC | 10 | S_EINA_TEXT | INFNR | |||
| 2.002 | STXL | TDSPRAS | Language Key | LANG | 1 | Transformation Rule | After apply the data selection, use each line encountered in STXL-TDSPRAS | - Mandatory for Migration Cockpit | Language Key | LANG | 1 | S_EINA_TEXT | TDSPRAS | ||
| 2.003 | STXL | CLUSTD | Text | LRAW | 7902 | Target field is equal to STXL-CLUSTD | - Mandatory for Migration Cockpit | Text | LRAW | 7902 | S_EINA_TEXT | TEXT | |||
| 3.001 | EINE | INFNR | Legacy Number of Purchasing Info Record | NUMC | 10 | - Mandatory for Migration Cockpit | Legacy Number of Purchasing Info Record | NUMC | 10 | S_EINE | INFNR | ||||
| 3.002 | EINE | EKORG | Purchasing Organization | CHAR | 4 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Purchasing Organization <EKORG> | Dependent on Configuration | - Mandatory for Migration Cockpit | Purchasing Organization | CHAR | 4 | S_EINE | EKORG | |
| 3.003 | EINE | ESOKZ | Purchasing Info Record Category | CHAR | 1 | Copy source field value as-is to the target field (1:1 direct mapping). | - Mandatory for Migration Cockpit | Purchasing Info Record Category | CHAR | 1 | S_EINE | ESOKZ | |||
| 3.004 | EINE | WERKS | Plant | CHAR | 4 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Plant <WERKS> | Applies only if the PIR is applicable for a specific Plant, Dependent on Configuration | - Relevant for DataCleansing | Plant | CHAR | 4 | S_EINE | WERKS | |
| 3.005 | EINE | EKGRP | Purchasing Group | CHAR | 3 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Purchasing Group <EKGRP> | Applies only if the PIR is linked to a specific Pgroup; Dependent on Configuration | - Relevant for DataCleansing | Purchasing Group | CHAR | 3 | S_EINE | EKGRP | |
| 3.006 | EINE | WAERS | Currency Key(ISO Format) | CUKY | 5 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Currency <WAERS> | Dependent on Configuration | - Relevant for DataConversion (Mapping) | Currency Key(ISO Format) | CUKY | 5 | S_EINE | WAERS | |
| 3.007 | EINE | MINBM | Minimum Purchase Order Quantity | QUAN | 13 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Minimum Purchase Order Quantity | QUAN | 13 | S_EINE | MINBM | |||
| 3.008 | EINE | NORBM | Standard Purchase Order Quantity | QUAN | 13 | 1) Use the source value to update the target field AS-IS 2) If source field is empty, update the target field with value "1" | - Mandatory for Migration Cockpit | Standard Purchase Order Quantity | QUAN | 13 | S_EINE | NORBM | |||
| 3.009 | EINE | APLFZ | Planned Delivery Time in Days | TIMS | 6 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Planned Delivery Time in Days | TIMS | 6 | S_EINE | APLFZ | |||
| 3.010 | EINE | UEBTO | Overdelivery Tolerance Limit | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Overdelivery Tolerance Limit | CHAR | 30 | S_EINE | UEBTO | |||
| 3.011 | EINE | UEBTK | Indicator:Unlimited Overdelivery Allowed | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Indicator:Unlimited Overdelivery Allowed | CHAR | 30 | S_EINE | UEBTK | |||
| 3.012 | EINE | UNTTO | Underdelivery Tolerance Limit | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Underdelivery Tolerance Limit | CHAR | 30 | S_EINE | UNTTO | |||
| 3.013 | EINE | ANGNR | Quotation | CHAR | 10 | 1) Use the source value to update the target field AS-IS. | 20251127 *NOT PRESENT in Migration Cockpit structure. | Quotation | CHAR | 10 | S_EINE | ANGNR | |||
| 3.014 | EINE | ANGDT | Quotation from | DATS | 10 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure. | Quotation from | DATS | 10 | S_EINE | ANGDT | |||
| 3.015 | EINE | NETPR | Net Price | DEC | 11,2 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure. | Net Price | DEC | 11,2 | NETPR | ||||
| 3.016 | EINE | PEINH | Price Unit | DEC | 3 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure. | Price Unit | DEC | 3 | PEINH | ||||
| 3.017 | EINE | TAX_COUNTRY | Country for Tax Return | CHAR | 3 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure. | Country for Tax Return | CHAR | 3 | TAX_COUNTRY | ||||
| 3.018 | EINE | INCO2 | Incoterms (Part 2) | CHAR | 28 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure. | Incoterms (Part 2) | CHAR | 28 | INCO2 | ||||
| 3.019 | EINE | MEGRU | Quantity Conversion Group | CHAR | 4 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure. | Quantity Conversion Group | CHAR | 4 | MEGRU | ||||
| 3.020 | EINE | J_1BNBM | NCM Code | CHAR | 16 | 1) Use the source value to update the target field AS-IS | 20251127 *NOT PRESENT in Migration Cockpit structure. | Nota Fiscal: Base Calculation Indicator | CHAR | 16 | J_1BNBM | ||||
| 3.021 | EINE | BWTAR | Valuation Type | CHAR | 30 | Transformation Rule | Use the source value, and lookup on the mapping table for <VALUATION_TYPE) and update the target field. | - Relevant for DataConversion (Mapping) | Valuation Type | CHAR | 30 | S_EINE | BWTAR | ||
| 3.022 | EINE | MTXNO | Ind: Prod. Master Rec. PO Text Not Rele. | NUMC | 10 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Ind: Prod. Master Rec. PO Text Not Rele. | NUMC | 10 | S_EINE | MTXNO | |||
| 3.023 | EINE | WEBRE | Indicator: GR-Based Invoice Verification | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier, region, or material category). | Indicator: GR-Based Invoice Verification | CHAR | 30 | S_EINE | WEBRE | |||
| 3.024 | EINE | KZABS | Ind: Order Acknowledgment Requirement | CHAR | 40 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Ind: Order Acknowledgment Requirement | CHAR | 40 | S_EINE | KZABS | |||
| 3.025 | EINE | MWSKZ | Tax on Sales/Purchases Code | CHAR | 2 | Transformation Rule | Use the source value, and lookup on the mapping table for <TAX_CODE> and update the target field. | Applies only if business condition is met (e.g. Supplier type, region, or material category). Dependent on Configuration | - Relevant for DataConversion (Mapping) | Tax on Sales/Purchases Code | CHAR | 2 | S_EINE | MWSKZ | |
| 3.026 | EINE | TXDAT_FROM | Valid-From Date of the Tax Rate | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Valid-From Date of the Tax Rate | CHAR | 30 | S_EINE | TXDAT_FROM | ||||
| 3.027 | EINE | EVERS | Shipping Instructions | CHAR | 30 | Transformation Rule | 1) Use the source value to update the target field AS-IS applying Data Conversion | Applies only if business condition is met (e.g. Supplier type, region, or material category). | - Relevant for DataConversion (Mapping) | Shipping Instructions | CHAR | 30 | S_EINE | EVERS | |
| 3.028 | EINE | BSTAE | Confirmation Control Key | CHAR | 30 | Transformation Rule | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | - Relevant for DataConversion (Mapping)
| Confirmation Control Key | CHAR | 30 | S_EINE | BSTAE | |
| 3.029 | EINE | XERSN | Ind: No Evaluated Receipt Settlem. (ERS) | CHAR | 1 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Ind: No Evaluated Receipt Settlem. (ERS) | CHAR | 1 | S_EINE | XERSN | |||
| 3.030 | EINE | MHDRZ | Minimum Remaining Shelf Life | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Minimum Remaining Shelf Life | CHAR | 30 | S_EINE | MHDRZ | |||
| 3.031 | EINE | IPRKZ | Period Ind. for Min. Remain. Shelf Life | CHAR | 2 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Period Ind. for Min. Remain. Shelf Life | CHAR | 2 | S_EINE | IPRKZ | |||
| 3.032 | EINE | BSTMA | Maximum Purchase Order Quantity | QUAN | 13 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Maximum Purchase Order Quantity | QUAN | 13 | S_EINE | BSTMA | |||
| 3.033 | EINE | EXPRF_LAND1 | Foreign Trade: Country/Region | #N/A | 80 | Transformation Rule | Transformation Rule: 1) Use the source value to update the target field AS-IS | Foreign Trade: Country/Region | #N/A | 80 | S_EINE | EXPRF_LAND1 | |||
| 3.034 | EINE | EXPRF | Foreign Trade: Procedure | CHAR | 30 | Transformation Rule | 1) Use the source value to update the target field AS-IS | Applies only if the PIR is linked to a specific Pgroup; Dependent on Configuration | Foreign Trade: Procedure | CHAR | 30 | S_EINE | EXPRF | ||
| 3.035 | EINE | RDPRF | Rounding Profile | CHAR | 30 | Transformation Rule | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | - Relevant for DataConversion | Rounding Profile | CHAR | 30 | S_EINE | RDPRF | |
| 3.036 | EINE | VENDOR_RMA_REQ | Supplier RMA Number Required | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Supplier RMA Number Required | CHAR | 30 | S_EINE | VENDOR_RMA_REQ | ||||
| 3.037 | EINE | AUT_SOURCE | Relevant for Automatic Sourcing | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Relevant for Automatic Sourcing | CHAR | 30 | S_EINE | AUT_SOURCE | ||||
| 3.038 | EINE | SKTOF | Ind: Item Does Not Qualify for Cash Disc | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Ind: Item Does Not Qualify for Cash Disc | CHAR | 30 | S_EINE | SKTOF | ||||
| 3.039 | EINE | MEPRF | Price Determinat. (Pricing) Date Control | DATS | 8 | 1) Use the source value to update the target field AS-IS | Price Determinat. (Pricing) Date Control | DATS | 8 | S_EINE | MEPRF | ||||
| 3.040 | EINE | INCOV | Incoterms Version | CHAR | 30 | Transformation Rule | 1) Use the source value to update the target field AS-IS | Incoterms Version | CHAR | 30 | S_EINE | INCOV | |||
| 3.041 | EINE | INCO1 | Incoterms | CHAR | 30 | Transformation Rule | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | - Relevant for DataConversion (Mapping) | Incoterms | CHAR | 30 | S_EINE | INCO1 | |
| 3.042 | EINE | INCO2_L | Incoterms Location 1 | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Incoterms Location 1 | CHAR | 30 | S_EINE | INCO2_L | |||
| 3.043 | EINE | INCO3_L | Incoterms Location 2 | CHAR | 30 | 1) Use the source value to update the target field AS-IS | Applies only if business condition is met (e.g. Supplier type, region, or material category). | Incoterms Location 2 | CHAR | 30 | S_EINE | INCO3_L | |||
| 4.001 | EINE | INFNR | Legacy Number of Purchasing Info Record | Text | 80 | - Mandatory for Migration Cockpit | Legacy Number of Purchasing Info Record | Text | 80 | S_COND | INFNR | ||||
| 4.002 | EINE | EKORG | Purchasing Organization | Text | 80 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Purchasing Organization <EKORG> 1.1) SKIP record where the PurchOrg is out of scope | COND.EKORG ← EINE-EKORG | - Mandatory for Migration Cockpit | Purchasing Organization | Text | 80 | S_COND | EKORG | |
| 4.003 | EINE | ESOKZ | Purchasing Info Record Category | Text | 80 | Transformation Rule | Copy source field value as-is to the target field (1:1 direct mapping). | COND.ESOKZ ← EINE-ESOKZ | - Mandatory for Migration Cockpit | Purchasing Info Record Category | Text | 80 | S_COND | ESOKZ | |
| 4.004 | EINE | WERKS | Plant | Text | 80 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Plant <WERKS> | COND.WERKS ← EINE-WERKS | - Relevant for DataConversion (Mapping) | Plant | Text | 80 | S_COND | WERKS | |
| 4.005 | KONP | KOPOS | Condition Sequence Number | Number | 2 | 1) Use the source value to update the target field AS-IS | COND.KOPOS ← KONP-KOPOS | - Mandatory for Migration Cockpit | Condition Sequence Number | Number | 2 | S_COND | KOPOS | ||
| 4.006 | KONP | KSCHL | Condition Type | Text | 80 | Transformation Rule | 1) Use the source value to update the target field AS-IS |
Mandatory to have PB00 or equivalent condition type for each record, but not limited to have only this condition type. Dependent on Configuration | - Mandatory for Migration Cockpit - Relevant for DataConversion (Mapping) | Condition Type | Text | 80 | S_COND | COND_TYPE | |
| 4.007 | KONH | DATAB | Valid From | Date | 1) Use the source value to update the target field AS-IS | COND.VALID_FROM ← KONH-DATAB | - Mandatory for Migration Cockpit | Valid From | Date | S_COND | VALID_FROM | ||||
| 4.008 | KONH | DATBI | Valid To | Date | 1) Use the source value to update the target field AS-IS | COND.VALID_TO ← KONH-DATBI | - Mandatory for Migration Cockpit | Valid To | Date | S_COND | VALID_TO | ||||
| 4.009 | KONM | KRECH | Calculation Type | Text | 80 | Transformation Rule | 1) Use the source value to update the target field AS-IS | Calculation Type | Text | 80 | S_COND | KRECH | |||
| 4.010 | KONP | KBETR | Amount | Number | 31,3 | 1) Use the source value to update the target field AS-IS | Amount | Number | 31,3 | S_COND | KBETR_EXT | ||||
| 4.011 | KONP | KONWA | Condition Unit (Currency or Percentage) | Text | 80 | 1) Use the source value to update the target field AS-IS | Condition Unit (Currency or Percentage) | Text | 80 | S_COND | KONWA | ||||
| 4.012 | KONP | KPEIN | Condition Pricing Unit | Number | 5 | 1) Use the source value to update the target field AS-IS | Condition Pricing Unit | Number | 5 | S_COND | KPEIN | ||||
| 4.013 | KONP | KMEIN | Condition Unit of Measure ISO | Text | 80 | Transformation Rule | 1)Use the source value, and lookup on the mapping table for Unit of Measure - UOM <MEINS> and update the target field. | Condition Unit of Measure ISO | Text | 80 | S_COND | KMEIN | |||
| 4.014 | KONP | KUMZA | Numerator for Conversion | Number | 5 | 1) Use the source value to update the target field AS-IS | Numerator for Conversion | Number | 5 | S_COND | KUMZA | ||||
| 4.015 | KONP | KUMNE | Denominator for Conversion | Number | 5 | 1) Use the source value to update the target field AS-IS | Denominator for Conversion | Number | 5 | S_COND | KUMNE | ||||
| 4.016 | MARA | MEINS | Base Unit of Measure ISO | Text | 80 | Transformation Rule | 1)Use the source value, and lookup on the mapping table for Unit of Measure - UOM <MEINS> and update the target field. | Base Unit of Measure ISO | Text | 80 | S_COND | MEINS | |||
| 4.017 | KONM | KONMS | Condition Scale Unit of Measure ISO | Text | 80 | Transformation Rule | Transformation Rule: 1) Use the source value to update the target field AS-IS | Condition Scale Unit of Measure ISO | Text | 80 | S_COND | KONMS | |||
| 4.018 | COND | EXCLUSION_IND | Condition Exclusion Indicator | Text | 80 | Transformation Rule: NO RULE - send blanks | Condition Exclusion Indicator | Text | 80 | S_COND | EXCLUSION_IND | ||||
| 5.001 | EINE | INFNR | Legacy Number of Purchasing Info Record | NUMC | 10 | - Mandatory for Migration Cockpit | Legacy Number of Purchasing Info Record | Text | 80 | S_SCALES | INFNR | ||||
| 5.002 | EINE | EKORG | Purchasing Organization | CHAR | 4 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Purchasing Organization <EKORG> | - Mandatory for Migration Cockpit | Purchasing Organization | Text | 80 | S_SCALES | EKORG | ||
| 5.003 | EINE | ESOKZ | Purchasing Info Record Category | CHAR | 1 | Transformation Rule | Copy source field value as-is to the target field (1:1 direct mapping). | - Mandatory for Migration Cockpit | Purchasing Info Record Category | Text | 80 | S_SCALES | ESOKZ | ||
| 5.004 | EINE | WERKS | Plant | CHAR | 4 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Plant <WERKS> | - Relevant for DataConversion (Mapping) | Plant | Text | 80 | S_SCALES | WERKS | ||
| 5.005 | KONP | KOPOS | Condition Sequence Number | #N/A | #N/A | 1) Use the source value to update the target field AS-IS | - Mandatory for Migration Cockpit | Condition Sequence Number | Number | 2 | S_SCALES | KOPOS | |||
| 5.006 | KONP | KSCHL | Condition Type | #N/A | #N/A | Transformation Rule | 1) Use the source value to update the target field AS-IS | - Mandatory for Migration Cockpit - Relevant for DataConversion (Mapping) | Condition Type | Text | 80 | S_SCALES | COND_TYPE | ||
| 5.007 | KONH | DATAB | Valid From | #N/A | #N/A | 1) Use the source value to update the target field AS-IS | - Mandatory for Migration Cockpit | Valid From | Date | S_SCALES | VALID_FROM | ||||
| 5.008 | KONH | DATBI | Valid To | #N/A | #N/A | 1) Use the source value to update the target field AS-IS | - Mandatory for Migration Cockpit | Valid To | Date | S_SCALES | VALID_TO | ||||
| 5.009 | SCALES | LINE_NO | Scale Item Number | #N/A | #N/A | 1) ROW_NUMBER() OVER(PARTITION BY KONM-KNUMH, KONM-KOPOS ORDER BY KONM-KONMS) | - Mandatory for Migration Cockpit | Scale Item Number | Number | 4 | S_SCALES | LINE_NO | |||
| 5.010 | KONM | STFKZ | Scale Quantity | #N/A | #N/A | 1) Use the source value to update the target field AS-IS | Scale Quantity | Number | 15,3 | S_SCALES | KSTBM | ||||
| 5.011 | KONP | KBETR | Scale Rate | #N/A | #N/A | 1) Use the source value to update the target field AS-IS | Scale Rate | Number | 31,3 | S_SCALES | KBETR | ||||
| 5.012 | KONM | KONMS | Scale Value | #N/A | #N/A | 1) Use the source value to update the target field AS-IS | Scale Value | Number | 28,3 | S_SCALES | SCALE_VAL | ||||
| 5.013 | KONM | KONWS | Scale Rate | #N/A | #N/A | 1) Use the source value to update the target field AS-IS | Scale Rate | Number | 31,3 | S_SCALES | KBETR_VAL | ||||
| The entries from STXL table for EINE are composed as follow: STXL-TDOBJECT = EINE STXL-TDNAME = [INFO REC CODE-INFNR CHAR10] [ESOKZ CHAR1] [PLANT-WERKS CHAR4] Create one entry for each record, and apply data Conversion for Purchasing Org and Plant | |||||||||||||||
| 6.001 | STXL | TDOBJECT | Text Object | Text | 80 | Maintain the same number for each Info Record transaction. Since data is being merged from both PF2 and WP2 systems, it is not recommended to reuse the source number, as this could lead to number clashes or duplication conflicts. | - Mandatory for Migration Cockpit | Legacy Number of Purchasing Info Record | Text | 80 | S_EINE_TEXT | INFNR | |||
| 6.002 | STXL | EKORG | Purchasing Organization | Text | 80 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Purchasing Organization <EKORG> | - Mandatory for Migration Cockpit - Relevant for DataConversion (Mapping) | Purchasing Organization | Text | 80 | S_EINE_TEXT | EKORG | ||
| 6.003 | STXL | ESOKZ | Purchasing Info Record Category | Text | 80 | Transformation Rule | Copy source field value as-is to the target field (1:1 direct mapping). | - Mandatory for Migration Cockpit | Purchasing Info Record Category | Text | 80 | S_EINE_TEXT | ESOKZ | ||
| 6.004 | STXL | WERKS | Plant | Text | 80 | Transformation Rule | 1) Use the source value, and lookup on the mapping table for Plant <WERKS> | - Relevant for DataConversion (Mapping) | Plant | Text | 80 | S_EINE_TEXT | WERKS | ||
| 6.005 | STXL | TDSPRAS | Language Key | Text | 80 | Copy source field value as-is to the target field (1:1 direct mapping). | - Mandatory for Migration Cockpit | Language Key | Text | 80 | S_EINE_TEXT | TDSPRAS | |||
| 6.006 | STXL | TEXT | Text | Text | unrestricted | Copy source field value as-is to the target field (1:1 direct mapping). | - Mandatory for Migration Cockpit | Text | Text | unrestricted | S_EINE_TEXT | TEXT | |||
Transformation Run Sheet
| Item # | Step Description | Team Responsible |
| 1 | Identify target S/4HANA fields and determine applicable legacy source fields from both ECC systems WP2, PF2 | Functional Team (S2P)+ Data Team (S2P) |
| 2 | Map legacy field values to S/4HANA target values (including field-level mapping and technical names) | Data Team (S2P), Syniti team |
| 3 | Define value mapping rules for fields requiring standardization or harmonization across the two source systems WP2, PF2. | Functional Team (S2P)+ Data Team (S2P) |
| 4 | Identify and agree on default values where legacy data is incomplete or inconsistent | Business Team + Functional Team (S2P) |
| 5 | Configure transformation rules in Syniti Migrate (including calculated fields, formatting rules, etc.) | Syniti team |
| 6 | Review transformation logic and mappings with Business for confirmation | Business Team |
| 7 | Perform initial transformation run and generate draft target-ready dataset | Syniti team |
| 8 | Review draft target-ready data for structure and completeness | Data Team (S2P), Functional Team (S2P), Syniti |
| 9 | Share transformed data with Business for Pre-load Validation | Data Team (S2P) |
| 10 | Incorporate feedback from Business and refine mappings or transformation logic as needed | Data Team (S2P) |
| 12 | Syniti to transform the data | Syniti team |
| 13 | Material and Vendor must exist in the target system. Only include Info Records where both MARA-MATNR and LFA1-LIFNR are valid and being migrated to S4Hana; | Syniti team |
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
LIFNR (LFA1-LIFNR) | <Vendor> |
MATNR (MARA-MATNR) | <Material> |
WERKS (T001W-WERKS_ | |
EKORG (T024E-EKORG) | |
EKGRP (T024-EKGRP) | |
MATKL (T023-MATKL) | <Material Group> |
MEINS (T006-MEINS) | <Unit of Measure> |
MWSKZ (T007A-MWSKZ) | |
General Configuration for Info Records | |
Tax Jurisdiction Code |
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
| 001 | Value Mapping Tables are complete | Functional Team (S2P) + Data Team (S2P) |
| 002 | Info Record & Pricing configuration are complete | Functional Team (S2P) + Data Team (S2P) |
| 003 | Org structure configuration is complete | Functional Team (S2P) + Data Team (S2P) |
| 005 | Master Data – Vendor | Data Team (S2P) |
| 006 | Master Data – Material | Data Team (S2P) |
| 007 | Configuration – Purchasing Organization | Functional Team (S2P) |
| 008 | Configuration – Plant | Functional Team (S2P) |
| 012 | Configuration – Material Group | Functional Team (S2P) |
| 013 | Configuration – Unit of Measure | Functional Team (S2P) |
| 014 | Configuration – Purchasing Organization | Functional Team (S2P) |
| 015 | Configuration – Purchasing Group | Functional Team (S2P) |
| 016 | Configuration – Incoterms | Functional Team (S2P) |
| 017 | Configuration – Condition Types | Functional Team (S2P) |
| 018 | Configuration – Tax Code | Functional Team (S2P) |
Pre-Load Validation
Project Team
The following pre-load validations will be performed by the Project Team.
Frequency of running reports
Preload Reports
Run before every load execution (Mock Loads, Dress Rehearsals, Cutover).
Purpose: to validate source-to-target transformations, business rules, and check for data quality issues before pushing into the Migration Cockpit.
Typically executed each time you release a wave or object for load.
Completeness
| Task | Action |
|---|---|
| Configuration | Ensure necessary configurations are in place in target system and field mapping is aligned with access sequence, condition types |
| Review Mapping Table | Ensure all the source organization units are mapped with target values |
| Check Values | Validate the pre-load data confirming the values are aligned with target system format and |
| Validate template structure and required field population | Ensure mandatory fields are filled |
Total number of records | SyWay S2P Data Team to verify that the total number of records in the Preload and Load Sheets are equal |
Vendor Validation | Check if the vendor exists in the target system and is active for the Basic Data and Purchasing Organization. This object has to be loaded before Info Records and Price Conditions. |
Material Validation | Check if the material exists in the target system and is active for the purchasing organization. This object has to be loaded before Info Records and Price Conditions. |
Mandatory Field Check | Verify whether all mandatory Fields are properly updated: EINA-LIFNR |
Info Record Category | Check if the Info Record Category (EINE-ESOKZ) has been properly migrated and in case of conversion check the final result. |
Relevancy Rules | Develop automated reports to assess info record relevancy based on multiple criteria including Vendor (considering deletion flags, and purchasing organization), Material (and deletion flags) and price conditions validity |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | SyWay S2P Data Team to verify that all fields below meet pass the checks: |
Review Error Reports | Review and correct the errors. Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data |
Value Format Validation | Ensure fields follow correct format for Dates / Currency / Decimals (according to user’s logon) |
Code & Value Mapping Validation | Check if all legacy values are mapped to valid target values (generally applicable for Materials / Vendors / UOM / Currency) |
Referential Integrity Check | Validate that linked data exists and matches. Check cases like: |
Duplicate Detection | Identify and remove duplicate entries in the dataset |
Business Rule Compliance | Ensure compliance with agreed rules, for instance |
| Review Mapping Table | Ensure all the source organization units are mapped with target values |
| Check mapping rules against configuration, including the fields related to prices and conditions ( access sequences, condition tables) | Cross-check mapping sheet with customizing entries |
| Perform format validation (date, currency, decimal separators) | Standardize format to match SAP accepted input (e.g., YYYYMMDD for dates) |
| Implement logic to detect duplicate condition records | Example: Run duplicate checks using key combinations (e.g., MATNR + EKORG + WERKS) |
| Conduct dry runs using LTMC or BAPIs and review logs | Analyze load results and correct format or conversion errors |
Business
The following pre-load validations will be performed by the business.Completeness
| Task | Action |
|---|---|
| Review populated templates for missing or incorrect values ( | confirm that all mandatory fields are populated, values are in scope, and field formats align with target S/4HANA definitions. |
| Ensure all required fields are properly covered | Confirm that Vendor, Material, Plant, Purchasing Organisation, Price, and Conditions are fully populated and consistent across EINA, EINE, and KONH/KONP datasets. |
| Validate coverage of in-scope Purchasing Organisations and Plants | Verify that all mapped EKORG and WERKS combinations exist for the expected materials and vendors. |
| Check that all relevant Condition Types are present | Confirm that each Info Record contains required pricing condition types (e.g. PBXX, FRA1, RA01) according to target Pricing Procedure. Consider as being mandatory to have a price for each Info Rec. |
| Verify language coverage for texts | Ensure that long texts (STXH/STXL) exist for at least English or another Syensqo language, and that obsolete or duplicate texts are removed (in case was expected) |
| Confirm accuracy of mapped values | Review mapped fields (e.g. Incoterms, Payment Terms, Currency) to ensure harmonization with approved master data mappings. |
| Validate deletion and blocking flags | Ensure no record is incorrectly marked as deleted or blocked unless explicitly confirmed by Syensqo Business. |
| Review price validity and activity | Confirm that validity dates (DATAB, DATBI) cover the go-live date and that prices reflect the latest active vendor conditions |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Verify that all fields below meet pass the checks: |
Review Cleansing Reports | Review and correct the errors. Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data |
Value Format Validation | Ensure fields follow correct format for Dates / Currency / Decimals (according to user’s logon) |
Code & Value Mapping Validation | Check if all legacy values are mapped to valid target values (generally applicable for Materials / Vendors / UOM / Currency) |
Duplicate Detection | Identify duplicate entries in the dataset |
Business Rule Compliance | Ensure compliance with agreed rules, for instance |
Load
The loading process includes:
- Once the data is provided on the Staging Areas of Migration Cockpit and prerequisite activities are completed, the Data Loading process is ready to start
- 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 |
|---|---|---|
| 001 | Confirm readiness of final approved data sets for each ECC source system WP2 and PF2 | Business / Functional Team |
| 002 | Validate transformation rules and mappings in Syniti tool | Data Team (S2P-Data) |
| 003 | Generate target-ready load files based on S/4HANA condition table format | Data Team (Syniti) |
| 004 | Review and approve load files before execution | Business / Functional Team |
| 005 | Execute automated data load using Syniti into the S/4HANA system (or generate manual load files if required) | Data Team (Syniti) |
| 006 | Monitor load progress and capture load statistics (records loaded, errors, duplicates, etc.) | Data Team (Syniti) / Technical Team |
| 007 | Extract loaded data from S/4HANA for post-load validation | Data Team (Syniti) |
| 008 | Perform post-load data validation (compare target data with source/approved files) for all loaded pricing condition types | Data Team (S2P-Data) |
| 009 | Log and resolve any data load errors or mismatches identified during validation | Data Team (S2P-Data) + Functional Team |
| 010 | Obtain business sign-off on successful load and validation | Business Team |
| 011 | Generate post load report is all steps are validated | Data Team (S2P-Data) / Data Team (Syniti |
| 012 | Archive load logs, error reports, and validation results for audit/compliance | Data Team (S2P-Data) / Data Team (Syniti) / PMO |
Load Phase and Dependencies
Configuration
| Item # | Configuration Item | |
|---|---|---|
| 001 | Configurations | Ensure all configurations related to Info Records and Purchasing Conditions are active in the target S/4HANA environment. This includes condition tables (A017, A018), access sequences, condition types, calculation schema, and pricing procedures. |
| 002 | Organization Data | Confirm that all required Organizational Units (Purchasing Organizations, Plants, Company Codes, and Valuation Areas) are configured and available in the target system |
| 003 | Vendor Master Data | Vendors (LIFNR) must be loaded and extended to the relevant Purchasing Organizations and Company Codes before Info Records are created |
| 004 | Material Master Data | Materials (MATNR) must be loaded and extended to the relevant Plants and Purchasing Views before Info Record load execution |
| 005 | Unit of Measure & Currency | Validate that all UoM (MARM) and currency (TCUR*) configurations exist and match those used in the source Info Records and condition tables. |
| 006 | Tax and Incoterm Configuration | Ensure tax codes, Incoterm versions, and Incoterm values (INCO1/INCO2_L/INCOV) are configured in the target system |
| 007 | Purchasing Groups | Confirm all Purchasing Groups used in source Info Records are configured and mapped in S/4HANA. |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
Vendor | Execute a data conversion in order to retrieve the new vendor code |
Material | Execute a data conversion in order to retrieve the new material code |
Material Group | Execute a data conversion in order to retrieve the new material group |
Unit of Measure (UoM) | Execute a data conversion in order to retrieve the new UoM code |
Payment Terms | Execute a data conversion in order to retrieve the new Payment Term |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
| Invalid Date Range | Valid From (DATAB) is after Valid To (DATBI) | Corrected the date range to ensure DATAB < DATBI and in required date format |
| Duplicate Records | Identical key combinations found more than once in the load file | Duplicates removed or merged as per business rule. Aligned with Business and documented for future loads |
| Unmapped Values | Values for fields like UoM, Currency, etc. not mapped in Syniti | Updated mapping tables; ensured value conversion aligned with S/4HANA settings |
| Invalid Currency Format | Incorrect currency formatting or unsupported currency code | Standardized to valid ISO currency codes (e.g., USD, EUR, JPY) |
| Invalid Number Format | KBETR or KPEIN contains special characters or comma separators | Cleaned formatting; ensured decimal values used with '.' as separator |
| Authorization Errors | Lack of access to execute load in target client/system | Raised access request; obtained necessary authorizations |
| Transformation Miss | Required transformation logic not applied before load | Re-applied transformation rules and revalidated source-target mapping |
| Obsolete Master Data | Vendor or material master data no longer exists in target system | Replaced or removed based on business input |
| Technical Load Failure | File not processed due to syntax/format error or system issue | Reviewed logs; regenerated file; re-executed load after resolving issue |
Post-Load Validation
Project Team
The following post-load validations will be performed by the Project Team.
Frequency of running reports
Postload Reports
Run immediately after each load execution.
Purpose: to reconcile and confirm that what was loaded into SAP matches the expected records (counts, key fields, value checks, etc.).
Typically executed after every migration cycle (mock, dress rehearsal, final cutover).
Completeness
| Task | Action |
|---|---|
| Ensure all required fields are properly covered | Confirm that Vendor, Material, Plant, Purchasing Organisation, Price, and Conditions are fully populated and consistent across EINA, EINE, and KONH/KONP datasets |
| Validate coverage of in-scope Purchasing Organisations and Plants | Verify that all mapped EKORG and WERKS combinations exist for the expected materials and vendors. |
| Check that all relevant Condition Types are present | Confirm that each Info Record contains required pricing condition types (e.g. PBXX, FRA1, RA01) according to target Pricing Procedure. |
| Verify language coverage for texts | Ensure that long texts (STXH/STXL) exist for at least English and project languages (FR/NL/DE/PT-BR), and that obsolete or duplicate texts are removed |
| Confirm accuracy of mapped values | Review mapped fields (e.g. Incoterms, Payment Terms, Currency) to ensure harmonization with approved master data mappings |
| Validate deletion and blocking flags | Ensure no record is incorrectly marked as deleted or blocked unless explicitly confirmed by business |
| Review price validity | Confirm that validity dates (DATAB, DATBI) cover the go-live date and that prices reflect the latest active vendor conditions. |
Accuracy
| Task | Action |
|---|---|
| Compare uploaded data against source file values | Use Custom reconciliation tools to validate the following
|
| Verify Key Field Values | Ensure values like Condition Type, Material, Customer, Sales Org, Validity Dates, and Rates are correctly populated |
Business
The involvement of the business team is essential to confirm the completeness and accuracy of Purchasing Conditions once the data is loaded into S/4HANA. By reviewing Info Records and their related condition records, they help ensure that the migration meets business expectations. This early validation minimizes the risk of errors, supports a seamless cutover, and guarantees that pricing mechanisms work as intended from the first day of system usage.Completeness
| Task | Action |
|---|---|
| Participate in Post-Load Walkthroughs | Join scheduled validation sessions with the migration and functional teams |
| Review Loaded Condition Records | Access the S/4HANA system to view loaded info records and purchasing price conditions |
| Check for Missing Records | Identify any missing records that were expected but not loaded |
Accuracy
| Task | Action |
|---|---|
| Compare Against Approved Load File | Cross-check data in S/4HANA against the final business-approved load file used for migration |
| Validate Accuracy of Converted/Transformed Data | Review any transformed fields (e.g., currency conversion, unit mappings) for correctness |
| Log and Report Discrepancies | Use provided discrepancy log format or defect management tool to report any findings |
Key Assumptions
- Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
- is in scope based on data design and any exception requested by business.
See also
| Object | Date | Link |
|---|---|---|
| Reference Document | 20251110 | Material is flagged as in scope according to MDS CNV-2019 Materials – Basic Data View |
| Reference Document | 20251110 | Vendor is flagged as in scope according to MDS CNV-3007 Business Partners – General (Role 000000) |
| Reference Document | 20251110 | Purchasing Organization (EINE.EKORG) is in scope based on enterprise structure mapping |
| Reference Document | 20251110 | Plant (EINE.WERKS) is in scope based on enterprise structure mapping. |
Change log
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||