| Status | Revision in Progress |
|---|---|
| Owner | |
| Stakeholders |
Purpose
The purpose of this document is to define the conversion approach to create Materials - Basic Data View in S/4 HANA.
---CHECKLIST - DATA TEAM---
- 1) Legacy systems (Logical Source and Target Systems are identified)
- 2) Extraction methods and file types
- 3) Scope relevancy criteria
- 4) Target structure/ Rules
- 5) MDS links
- 6) Cleansing rules
- 6a) Cleansing reports with technical information
- 6b) Profiling
- 6c) Cleansing reports which you need to be developed by Syniti
- 6d) Deduplication (with technical details of Table-Fields, Conditions)
- 6e) Frequency of running reports
- 7) Transformation - and for this DOMD template must be populate and final version of DOMD template should be copied to Transformation section in CSpecs
- 8) Configuration/Value mapping file link
- 9) Value Mappings (Data Mapping is provided for mappings which are not obvious to a suitably-skilled and experienced developer)E
- 10) Load template link
- 11) Loading method (Processing Type is specified, i.e. Direct Input, BAPI, IDoc, Web Service, OData API, etc.)
- 12) Loading sequence or dependency
- 13Error handling requirements are specified / including alerting requirement / expected action on failure.E
- 13) Data Analysis
- 14) Pre load validation
- 15) Post load validation
- 16) any Exceptions (Data Mapping is provided for mappings which are not obvious to a suitably-skilled and experienced developer)
- 17)Application log requirement if applicable to be specified.
- 18) Signoff
Conversion Scope
The scope of this document covers the approach for converting active Materials - Basic Data View from Legacy Source Systems into S/4HANA following the Materials Master Data Design Standard.
From the current system landscape, Material data exists separately in the legacy systems (PF2 and WP2), with potential discrepancies in both organizations. Harmonization and validation are required to ensure accurate and consolidated data in S/4HANA. While PF2 and WP2 serve as source systems, extensive mapping and transformation logic will be necessary to produce properly formatted load templates in line with the target design.
Relevancy Rules
- All materials created in the previous 6 months will be included unless flagged for deletion
- Material Types ZUNB, ZBOM, ZPRC will be included regardless of activity (unless flagged for deletion). Material Types PROD, ZINT will be excluded. Maintenance Assemblies are excluded (MTypes Z750, ZIBA).
- We will only include materials that are extended to the following according to the Enterprise Structure (excluding ZPRC material type as these do not require plant extension):
- Company Codes in scope
- Plants in scope
- Purchasing Orgs in scope
- Sales Orgs in scope
- We will include for migration all materials that have activity over the previous 48 months for non ZIND/ZABF materials, or 60 months for ZIND/ZABF materials:
- For procurement data use EKKO/EKPO tables (remove any records in EKKO/EKPO where EKKO.LOEKZ = C,X EKPO.LOEKZ = L,S and use EKPO/AEDAT for date range
- For sales data use VBAK/VBAP tables
- For work order data use AUFK/AFKO/AFPO tables. Check date using AUFK.ERDAT. Enter Order Category AUFK.AUTYP 40 for Process Orders and 30 for Maintenance Orders.
- Valid PIRs and Source List (this includes Not Deleted/Validity Date not expired/In scope Purchasing Orgs and Plants based on Enterprise Structure) Check tables EINA/EINE/EORD. Check EORD.NOTKZ is showing as not blocked. Check that EORD.BDATU is greater than current date.
- Additionally, we can check material movements by querying MKPF/MSEG tables for the last 48 months for non ZIND/ZABF materials and 60 months for ZIND/ZABF materials. Link MKPF.MBLNR (Document Number) to MSEG.MBLNR. Enter dates with MKPF.BLDAT. WP2 may have to be restricted to quarterly data due to the number of records. In MKPF.VGART (Transaction Types) add: IB,ID,IZ,RS,SI,WA,WE,WF,WH,WI,WL,WO,WQ,WR,WS,WV,WZ.
- We will include for migration all materials that have open documents including the following:
- Open PO and STO. (EKPO-ELIKZ ≠ 'X') (EKKO.BSTYP = F)
- Open contracts and scheduling agreements. (EKPO-ELIKZ ≠ 'X') (EKKO.BSTYP = K)
- Open SO. VBUK.GBSTK = ('A','B')
- Open WO. Use AUFK for checking open Process orders. Link field AUFK.OBJNR to JEST.OBNR to get status codes not equal to TECO AND JEST.INACT ≠ 'X'.
- Have current stock/open inventory
For Open Inventory use the following tables:
MARD
MKOL (Consignment stock)
MSKA (Sales Order stock)
MSLB (Special stock)
MSPR (Project stock)
- We will include BOM data for materials in scope using tables: MAST/STKO/STPO. We will include all Production, Plant Maintenance and Sales BOMs and their related components. MAST data will include BOM Usage (STLAN) 1 (Production), 4 (Plant Maintenance) & 5 (Sales and Distribution). STKO data will include BOM Category STKO.STLTY = E (Equipment) F (Functional Location) & M (Material). All BOM components will be included in relevancy regardless of activity (unless flagged for deletion). Exclude any deleted records STKO.LOEKZ, STKO.LKENZ= X, STPO.LKENZ = X.
- Materials with Deletion Flags will be excluded unless appearing in the following open transactions:
- Open PO/STO
- Open contracts and scheduling agreements
- Open SO
- Open WO
- Deletion Flags (Table/Field) are as follows: MARA/LVORM = 'X' MARA/MSTAE = Z3, Z4, ZZ (PF2 system) Z0 (WP2 system)
- Materials with the word 'OBSOLETE' or 'DELETED' contained within the Short Description will be excluded. Also excluded are Materials where Short Description contains '**OBS', '**OBS**', '**OBS***', '*OBS*', '*OBS**', '***OBS***'
- Include ZIND/ZABF materials with Purchase Requisition for the last 60 months. Check table EBAN. Check for validity date EBAN.ERDAT. Check EBAN.BSTYP = B. Check valid Purchase Org/Plant/Company Code according to the Enterprise Structure
- Include non ZIND/ZABF materials with Purchase Requisition for the last 48 months. Check table EBAN. Check for validity date EBAN.ERDAT. Check EBAN.BSTYP = B. Check valid Purchase Org/Plant according to the Enterprise Structure
- Include all materials with PIR(Planned Independent Requirements). Check table PBIM/PBED for materials PBIM.MATNR. Check PBIM.LOEVR ≠ 'D'. Check PBIM.WERKS for in scope Plants.
- Include all materials with planned orders for external procurement. Check table PLAF. Check date PLAF.PSTTR for previous 4 years activity. Check for special procurement in field PLAF.SOBES = 0.
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| PF2,WP2 | The Material Master Records will be extracted/collected via DCT. An initial extract of the relevant data will be provided in Google Sheet format to assist business in decision making on including any relevant data from Source Systems. Any additional data that need to be created to support the new design may be added in the DCT. A data review and standardization will be done across all Info Records in the DCT. | 1,200,000 | S4H | 260,000 |
Additional Information
MDS Documents
Data Extraction
Data has been extracted from Production and files are kept here:
202511XX | Extraction Pending |
Multi-language Requirement
Languages to be extracted (available on Source Systems)
SAP standard supports all ISO languages, ensure that all standard languages are considered in scope.
Material Master will have a default description available in English.
Multi language is supported for Materials. Login via a different language will show the description displayed in the logon language if the language key is maintained.
- Core languages: EN - English, FR - French, IT - Italian and ZH - Mandarin.
- Additional languages: PT - Portuguese, DE - German, ES - Spanish
- Supplier languages that are possible: FR - French, EN - English, ES - Spanish, DE - German, IT - Italian, NL - Dutch, PT - Portuguese, ZH - Mandarin, PL - Polish, JA - Japanese, KO - Korean, FI - Finnish, BG - Bulgarian, RU - Russian, TH- Thai, ZF - Chinese traditional, SK - Slovak, Z9 - Brazil Portuguese.
Document Management
Not Applicable
Legal Requirement
Not Applicable
Special Requirements
Target Design
This section defines the structure and configuration of the target system in SAP S/4HANA. It specifies how each target field is designed, including data types, field lengths, and business rules, ensuring alignment between functional requirements and technical implementation for the conversion process.
DOMD Documents
The mapping document can be accessed using the link below.
Material Master: Source ECC Material (all material types in scope) → Target S4H Material Master
| Source Field Information | Transformation/Business Rules | Target Field Information | |||||||||||||||||||||
| Sequence | Technical Source Table | Field Description | Technical Source Field | Field Format | Field Length | Comments | Mapping Type | Transform Rule or Default Value | Validation Rule | Comments | Dataload Template | Sheet Name | Group | Field Description | Business Description | Check Table | Business Mandatory Y/N/C | System Mandatory Y/N/C | Type | Length | Decimal | Sap Table Name | Sap Field Name |
| 001 | MARA | Material Number | MATNR | Text (CHAR) | 40 | Default Value | <EMPTY> | - Mandatory for Migration Cockpit | Material Number | YES | YES | Text (CHAR) | 18 | MARA | MATNR | ||||||||
| 002 | MARA | Material Type | MTART | Text (CHAR) | 4 | - Mandatory for Migration Cockpit | Material Type | YES | YES | Text (CHAR) | 4 | MARA | MTART | ||||||||||
| 003 | MARA | Material Group | MATKL | Text (CHAR) | 9 | Material Group | Text (CHAR) | 9 | MARA | MATKL | |||||||||||||
| 004 | MARA | Industry Sector | MBRSH | Text (CHAR) | 1 | Update Target Field using the Source field as-is | Industry Sector | Text (CHAR) | 1 | MARA | MBRSH | ||||||||||||
| 005 | MARA | Description | MAKTX | Text (CHAR) | 40 | - Mandatory for Migration Cockpit | Description | YES | YES | Text (CHAR) | 40 | MARA | MAKTX | ||||||||||
| 006 | MARA | Language Key | SPRAS | Text (CHAR) | 1 | - Mandatory for Migration Cockpit | Language Key | YES | YES | Text (CHAR) | 1 | MARA | SPRAS | ||||||||||
| 007 | MARA | Base Unit of Measure (ISO Format) | MEINS | Text (CHAR) | 3 | - Mandatory for Migration Cockpit | Base Unit of Measure (ISO Format) | YES | YES | Text (CHAR) | 3 | MARA | MEINS | ||||||||||
| 008 | MARA | Change Number | AENNR | Text (CHAR) | 6 | Change Number | Text (CHAR) | 6 | MARA | AENNR | |||||||||||||
| 009 | MARA | Revision Level | REVLV | Text (CHAR) | 2 | Revision Level | Text (CHAR) | 2 | MARA | REVLV | |||||||||||||
| 010 | MARA | GTIN | EAN11 | Text (CHAR) | 18 | GTIN | Text (CHAR) | 18 | MARA | EAN11 | |||||||||||||
| 011 | MARA | GTIN Category | NUMTP | Text (CHAR) | 1 | GTIN Category | Text (CHAR) | 1 | MARA | NUMTP | |||||||||||||
| 012 | MARA | Division | SPART | Text (CHAR) | 2 | Division | Text (CHAR) | 2 | MARA | SPART | |||||||||||||
| 013 | MARA | Old Material Number | BISMT | Text (CHAR) | 40 | Old Material Number | Text (CHAR) | 40 | MARA | BISMT | |||||||||||||
| 014 | MARA | Product Hierarchy | PRDHA | Text (CHAR) | 18 | Product Hierarchy | Text (CHAR) | 18 | MARA | PRDHA | |||||||||||||
| 015 | MARA | Batch Management Required Ind. | XCHPF | Text (CHAR) | 1 | Batch Management Required Ind. | Text (CHAR) | 1 | MARA | XCHPF | |||||||||||||
| 016 | MARA | Has Empties | MLGUT | Text (CHAR) | 1 | Has Empties | Text (CHAR) | 1 | MARA | MLGUT | |||||||||||||
| 017 | MARA | Valid From | DATAB | Date | Valid From | Date | MARA | DATAB | |||||||||||||||
| 018 | MARA | Deletion Date | LIQDT | Date | Deletion Date | Date | MARA | LIQDT | |||||||||||||||
| 019 | MARA | Industry Standard Description | NORMT | Text (CHAR) | 18 | Industry Standard Description | Text (CHAR) | 18 | MARA | NORMT | |||||||||||||
| 020 | MARA | Size/Dimensions | GROES | Text (CHAR) | 32 | Size/Dimensions | Text (CHAR) | 32 | MARA | GROES | |||||||||||||
| 021 | MARA | Laboratory / Design Office | LABOR | Text (CHAR) | 4 | Laboratory / Design Office | Text (CHAR) | 4 | MARA | LABOR | |||||||||||||
| 022 | MARA | External Product Group | EXTWG | Text (CHAR) | 18 | External Product Group | Text (CHAR) | 18 | MARA | EXTWG | |||||||||||||
| 022 | MARA | General Item Category Group | MTPOS_MARA | Text (CHAR) | 4 | General Item Category Group | Text (CHAR) | 4 | MARA | MTPOS_MARA | |||||||||||||
| 023 | MARA | Authorization Group | BEGRU | Text (CHAR) | 4 | Authorization Group | Text (CHAR) | 4 | MARA | BEGRU | |||||||||||||
| 024 | MARA | Cross-Plant Product Status | MSTAE | Text (CHAR) | 2 | Cross-Plant Product Status | Text (CHAR) | 2 | MARA | MSTAE | |||||||||||||
| 025 | MARA | Valid-From Date | MSTDE | Date | Valid-From Date | Date | MARA | MSTDE | |||||||||||||||
| 026 | MARA | Quality Manag. in Procurement Is Active | QMPUR | Text (CHAR) | 1 | Quality Manag. in Procurement Is Active | Text (CHAR) | 1 | MARA | QMPUR | |||||||||||||
| 027 | MARA | ANP Code | ANP | Number (NUMC) | 9 | ANP Code | Number (NUMC) | 9 | MARA | ANP | |||||||||||||
| 028 | MARA | Gross Weight | BRGEW | Number (NUMC) | 13,3 | Gross Weight | Number (NUMC) | 13,3 | 3 | MARA | BRGEW | ||||||||||||
| 029 | MARA | Net Weight | NTGEW | Number (NUMC) | 13,3 | Net Weight | Number (NUMC) | 13,3 | 3 | MARA | NTGEW | ||||||||||||
| 030 | MARA | Unit of Weight (ISO Format) | GEWEI | Text (CHAR) | 3 | Unit of Weight (ISO Format) | Text (CHAR) | 3 | MARA | GEWEI | |||||||||||||
| 031 | MARA | Length | LAENG | Number (NUMC) | 13,3 | Length | Number (NUMC) | 13,3 | 3 | MARA | LAENG | ||||||||||||
| 032 | MARA | Width | BREIT | Number (NUMC) | 13,3 | Width | Number (NUMC) | 13,3 | 3 | MARA | BREIT | ||||||||||||
| 033 | MARA | Height | HOEHE | Number (NUMC) | 13,3 | Height | Number (NUMC) | 13,3 | 3 | MARA | HOEHE | ||||||||||||
| 034 | MARA | Unit for Length/Width/Height(ISO Format) | MEABM | Text (CHAR) | 3 | Unit for Length/Width/Height(ISO Format) | Text (CHAR) | 3 | MARA | MEABM | |||||||||||||
| 035 | MARA | Volume | VOLUM | Number (NUMC) | 13,3 | Volume | Number (NUMC) | 13,3 | 3 | MARA | VOLUM | ||||||||||||
| 036 | MARA | Volume Unit | VOLEH | Text (CHAR) | 3 | Volume Unit | Text (CHAR) | 3 | MARA | VOLEH | |||||||||||||
| 037 | MARA | Capacity Usage | CAPAUSE | Number | 15 | Capacity Usage | Number | 15 | MARA | CAPAUSE | |||||||||||||
| 038 | MARA | Compliance Relevant | CHML_CMPLNC_RLVNCE_IND | Text (CHAR) | 1 | Compliance Relevant | Text (CHAR) | 1 | MARA | CHML_CMPLNC_RLVNCE_IND | |||||||||||||
| 039 | MARA | Product Is Configurable | KZKFG | Text (CHAR) | 1 | Product Is Configurable | Text (CHAR) | 1 | MARA | KZKFG | |||||||||||||
| 040 | MARA | Order Unit of Measure (ISO Format) | BSTME | Text (CHAR) | 3 | Order Unit of Measure (ISO Format) | Text (CHAR) | 3 | MARA | BSTME | |||||||||||||
| 041 | MARA | Purchasing Value Key | EKWSL | Text (CHAR) | 2 | Purchasing Value Key | Text (CHAR) | 2 | MARA | EKWSL | |||||||||||||
| 042 | MARA | State of Variable Purchase Order Unit | VABME | Text (CHAR) | 1 | State of Variable Purchase Order Unit | Text (CHAR) | 1 | MARA | VABME | |||||||||||||
| 043 | MARA | Internal Product Number | BMATN | Text (CHAR) | 18 | Internal Product Number | Text (CHAR) | 18 | MARA | BMATN | |||||||||||||
| 044 | MARA | Manufacturer Part Number | MFRPN | Text (CHAR) | 40 | Manufacturer Part Number | Text (CHAR) | 40 | MARA | MFRPN | |||||||||||||
| 045 | MARA | Manufacturer Number | MFRNR | Text (CHAR) | 10 | Manufacturer Number | Text (CHAR) | 10 | MARA | MFRNR | |||||||||||||
| 046 | MARA | Manufacturer Part Profile | MPROF | Text (CHAR) | 4 | Manufacturer Part Profile | Text (CHAR) | 4 | MARA | MPROF | |||||||||||||
| 047 | MARA | Transportation Group | TRAGR | Text (CHAR) | 4 | Transportation Group | Text (CHAR) | 4 | MARA | TRAGR | |||||||||||||
| 048 | MARA | Cross-Distribution Chain Product Status | MSTAV | Text (CHAR) | 2 | Cross-Distribution Chain Product Status | Text (CHAR) | 2 | MARA | MSTAV | |||||||||||||
| 049 | MARA | DG Indicator Profile | PROFL | Text (CHAR) | 3 | DG Indicator Profile | Text (CHAR) | 3 | MARA | PROFL | |||||||||||||
| 050 | MARA | Environmentally Relevant | KZUMW | Text (CHAR) | 1 | Environmentally Relevant | Text (CHAR) | 1 | MARA | KZUMW | |||||||||||||
| 051 | MARA | In Bulk/Liquid | ILOOS | Text (CHAR) | 1 | In Bulk/Liquid | Text (CHAR) | 1 | MARA | ILOOS | |||||||||||||
| 052 | MARA | Highly Viscous | IHIVI | Text (CHAR) | 1 | Highly Viscous | Text (CHAR) | 1 | MARA | IHIVI | |||||||||||||
| 053 | MARA | Valid From Date for Status | MSTDV | Date | Valid From Date for Status | Date | MARA | MSTDV | |||||||||||||||
| 054 | MARA | Material Category | ATTYP | Text (CHAR) | 2 | Material Category | Text (CHAR) | 2 | MARA | ATTYP | |||||||||||||
| 055 | MARA | Product Group: Packaging Materials | MAGRV | Text (CHAR) | 80 | Product Group: Packaging Materials | Text (CHAR) | 80 | MARA | MAGRV | |||||||||||||
| 056 | MARA | Packaging Product Type | VHIART | Text (CHAR) | 80 | Packaging Product Type | Text (CHAR) | 80 | MARA | VHIART | |||||||||||||
| 057 | MARA | Allowed Packaging Weight | ERGEW | Text (CHAR) | 13 | Allowed Packaging Weight | Text (CHAR) | 13 | MARA | ERGEW | |||||||||||||
| 058 | MARA | Unit of Allowed Packaging Weight | ERGEI | Text (CHAR) | 80 | Unit of Allowed Packaging Weight | Text (CHAR) | 80 | MARA | ERGEI | |||||||||||||
| 059 | MARA | Allowed Packaging Volume | ERVOL | Text (CHAR) | 13 | Allowed Packaging Volume | Text (CHAR) | 13 | MARA | ERVOL | |||||||||||||
| 060 | MARA | Unit of Allowed Packaging Volume | ERVOE | Text (CHAR) | 80 | Unit of Allowed Packaging Volume | Text (CHAR) | 80 | MARA | ERVOE | |||||||||||||
| 061 | MARA | Packaging Product Is Closed Packaging | KZGVH | Text (CHAR) | 1 | Packaging Product Is Closed Packaging | Text (CHAR) | 1 | MARA | KZGVH | |||||||||||||
| 062 | MARA | Excess Volume Tolerance for HU | VOLTO | Number | 3 | Excess Volume Tolerance for HU | Number | 3 | MARA | VOLTO | |||||||||||||
| 063 | MARA | Period Indicator for Shelf Life | IPRKZ | Text (CHAR) | 80 | Period Indicator for Shelf Life | Text (CHAR) | 80 | MARA | IPRKZ | |||||||||||||
| 064 | MARA | Storage Conditions | RAUBE | Text (CHAR) | 80 | Storage Conditions | Text (CHAR) | 80 | MARA | RAUBE | |||||||||||||
| 065 | MARA | Temperature Conditions Indicator | TEMPB | Text (CHAR) | 2 | Temperature Conditions Indicator | Text (CHAR) | 2 | MARA | TEMPB | |||||||||||||
| 066 | MARA | Hazardous Product Number | STOFF | Text (CHAR) | 40 | Hazardous Product Number | Text (CHAR) | 40 | MARA | STOFF | |||||||||||||
| 067 | MARA | Number of Goods Receipt/Issue Slips | WESCH | Number | 13 | Number of Goods Receipt/Issue Slips | Number | 13 | MARA | WESCH | |||||||||||||
| 068 | MARA | Indicator: Approved Batch Rec. Required | XGCHP | Text (CHAR) | 1 | Indicator: Approved Batch Rec. Required | Text (CHAR) | 1 | MARA | XGCHP | |||||||||||||
| 069 | MARA | Total Shelf Life | MHDHB | Number | 4 | Total Shelf Life | Number | 4 | MARA | MHDHB | |||||||||||||
| 070 | MARA | Minimum Remaining Shelf Life | MHDRZ | Number | 4 | Minimum Remaining Shelf Life | Number | 4 | MARA | MHDRZ | |||||||||||||
| 071 | MARA | Indi. for the Shelf Life Expiration Date | SLED_BBD | Text (CHAR) | 80 | Indi. for the Shelf Life Expiration Date | Text (CHAR) | 80 | MARA | SLED_BBD | |||||||||||||
| 072 | MARA | Storage Percentage | MHDLP | Number | 3 | Storage Percentage | Number | 3 | MARA | MHDLP | |||||||||||||
| 073 | MARA | Rounding Rule for Calculation of SLED | RDMHD | Text (CHAR) | 80 | Rounding Rule for Calculation of SLED | Text (CHAR) | 80 | MARA | RDMHD | |||||||||||||
| 074 | MARA | Serial Number Profile | SERIAL | Text (CHAR) | 80 | Serial Number Profile | Text (CHAR) | 80 | MARA | SERIAL | |||||||||||||
| 075 | MARA | Relevant for Hazardous Substances | HAZMAT | Text (CHAR) | 1 | Relevant for Hazardous Substances | Text (CHAR) | 1 | MARA | HAZMAT | |||||||||||||
| 076 | MARA | ABC Indicator | MAABC | Text (CHAR) | 1 | ABC Indicator | Text (CHAR) | 1 | MARA | MAABC | |||||||||||||
| 077 | MARA | Country/Region of Origin | HERKL | Text (CHAR) | 3 | Country/Region of Origin | Text (CHAR) | 3 | MARA | HERKL | |||||||||||||
| 078 | MARA | Purchasing Group | EKGRP | Text (CHAR) | 3 | Purchasing Group | Text (CHAR) | 3 | MARA | EKGRP | |||||||||||||
| 079 | MARA | Tax Classification | TAKLV | Text (CHAR) | 1 | Tax Classification | Text (CHAR) | 1 | MARA | TAKLV | |||||||||||||
| 80 | MARA | Loading Group | LADGR | Text (CHAR) | 4 | Loading Group | Text (CHAR) | 4 | MARA | LADGR | |||||||||||||
| 081 | MARA | Indicator: Quality | PSTATQ | Text (CHAR) | 1 | Indicator: Quality | Text (CHAR) | 1 | MARA | PSTATQ | |||||||||||||
| 082 | MARA | Indicator: Sales | PSTATV | Text (CHAR) | 1 | Indicator: Sales | Text (CHAR) | 1 | MARA | PSTATV | |||||||||||||
| 083 | MARA | Indicator: Storage | PSTATL | Text (CHAR) | 1 | Indicator: Storage | Text (CHAR) | 1 | MARA | PSTATL | |||||||||||||
| 084 | MARA | Indicator: Purchasing | PSTATE | Text (CHAR) | 1 | Indicator: Purchasing | Text (CHAR) | 1 | MARA | PSTATE | |||||||||||||
Material Master: Source ECC Service Master → Target S4H Material Master
| Source Field Information | Transformation/Business Rules | Target Field Information | |||||||||||||||||||||
| Sequence | Technical Source Table | Field Description | Technical Source Field | Field Format | Field Length | Comments | Mapping Type | Transform Rule or Default Value | Validation Rule | Comments | Dataload Template | Sheet Name | Group | Field Description | Business Description | Check Table | Business Mandatory Y/N/C | System Mandatory Y/N/C | Type | Length | Decimal | Sap Table Name | Sap Field Name |
| 001 | ASMD | Activity Number | ASNUM | Text (CHAR) | 18 | Default Value | <EMPTY> | - Mandatory for Migration Cockpit | Material Number | YES | YES | Text (CHAR) | 18 | MARA | MATNR | ||||||||
| 002 | ASMD | Material Group | MATKL | Text (CHAR) | 9 | Mapping Rule | If Source Field is empty do not send the data, ElseApply data conversion based on the MAPPING_FILE | - Mandatory for Migration Cockpit | Material Group | YES | YES | Text (CHAR) | 9 | MARA | MATKL | ||||||||
| 003 | ASMD | Base Unit of Measure | MEINS | UNIT | 3 | Mapping Rule | If the source field exists in the MAPPING_FILE, apply the corresponding data conversion and update the target field accordingly. | - Mandatory for Migration Cockpit | Base Unit of Measure (ISO Format) | YES | YES | Text (CHAR) | 3 | MARA | MEINS | ||||||||
| 004 | ASMD | Service Category | ASTYP | Text (CHAR) | 4 | ||||||||||||||||||
| 005 | ASMD | Package Number | PAKNR | NUMC | 10 | ||||||||||||||||||
| 006 | ASMD | International Article Number (EAN/UPC) | EAN11 | Text (CHAR) | 18 | Copy AS-IS | Update target field using the source field AS-IS | GTIN | Text (CHAR) | 18 | MARA | EAN11 | |||||||||||
| 007 | ASMD | Category of International Article Number (EAN) | NUMTP | Text (CHAR) | 2 | Copy AS-IS | Update target field using the source field AS-IS | GTIN Category | Text (CHAR) | 1 | MARA | NUMTP | |||||||||||
| 008 | ASMD | General Purchasing Status for Service | MSTAE | Text (CHAR) | 2 | Mapping Rule | If the source field exists in the MAPPING_FILE, apply the corresponding data conversion and update the target field accordingly. | Cross-Plant Product Status | Text (CHAR) | 2 | MARA | MSTAE | |||||||||||
| 009 | ASMD | Validity Date for “Purchasing” Status | MSTDE | DATS | 8 | Update 1:1 | Copy from source AS-IS | Valid-From Date | Date | MARA | MSTDE | ||||||||||||
| 010 | ASMD | Valuation Class | BKLAS | Text (CHAR) | 4 | ||||||||||||||||||
| 011 | ASMD | Hierarchy Service Number | LSTHI | Text (CHAR) | 18 | ||||||||||||||||||
| 012 | ASMD | Primary Language for Object Texts | MLANG | LANG | 1 | ||||||||||||||||||
| 013 | ASMD | Numerator for Conversion of MEINS into IWEIN | IWUMZ | DEC | 5 | ||||||||||||||||||
| 014 | ASMD | Denominator for Conversion (MEINS ↔ IWEIN) | IWUMN | DEC | 5 | ||||||||||||||||||
| 015 | ASMD | Unit for Work | IWEIN | UNIT | 3 | ||||||||||||||||||
| 016 | ASMD | Formula Number | FORMELNR | Text (CHAR) | 10 | ||||||||||||||||||
| 017 | ASMD | Short Text Change Allowed | CHGTEXT | Text (CHAR) | 1 | ||||||||||||||||||
| 018 | ASMD | Tax Tariff Code | TAXTARIFFCODE | Text (CHAR) | 16 | ||||||||||||||||||
| 019 | ASMDT | Language | SPRAS | Text (CHAR) | 2 | YES | YES | MAKT | SPRAS | ||||||||||||||
| 020 | ASMDT | Description | ASKTX | Text (CHAR) | 40 | YES | YES | MAKT | MAKTX | ||||||||||||||
Data Cleansing
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
|---|---|---|---|---|---|
2019-001 | C1 | English description missing or EN description not English language | All materials require English description by default, so need to be provided if missing. Current EN descriptions not in English language need to be translated. | PF2/WP2 | |
2019-002 | C1 | Description format | Material descriptions must adhere to S4 standardization so no special characters etc and must not exceed character limit | PF2/WP2 | |
2019-003 | C1 | UoM alignment | All material UoMs to adhere to S4 ISO standard. | PF2/WP2 | |
2019-004 | C1 | Check Gross and Net Weights | Check for missing weights and that Gross Weight >= Net | PF2/WP2 | |
2019-006 | C1 | Duplicate materials excluded | Check for materials with same Long/Short Description | PF2/WP2 |
Conversion Process
The high-level process is represented by the diagram below:
The high level process for Classes that will be captured in a DCT are represented by the diagram below:
e
Data Privacy and Sensitivity
Not ApplicableExtraction
The source for Basic data for Materials is PF2 & WP2. This will be extracted by Syniti based on the Relevancy criteria.
Extraction Run Sheet
| Req # | Requirement Description | Team Responsible |
|---|---|---|
| 1 | Extract Material Master data (MARA) from PF2 and WP2 ECC systems according to the defined Relevancy Rules (scope by Material Type, and Activity). | SyWay Data Team |
| 2 | Validate the extracted data volumes against ECC totals to ensure completeness before applying any filtering (count check per Material Type and per Plant). | SyWay Data Team |
| 3 | Apply exclusion criteria (e.g., deletion flags, obsolete status, test materials, invalid UoM, invalid descriptions). | SyWay Data Team |
| 4 | Include recent transactional linkage (e.g., materials used in open PO, SO, or movements within last 3 years). | SyWay Data Team |
| 5 | Validate UoM conversions and ensure all Base Units (MEINS) exist in T006 (UoM ISO mapping). | SyWay Data Team |
| 6 | Generate Google Sheet report pre-populated with PF2 and WP2 extracted data for Business validation (showing only relevant fields from MDS_2019). | SyWay Data Team |
| 7 | Submit the validated dataset for peer review and final sign-off by Functional and Business teams before transformation load. | SyWay Data Team |
Selection Screen
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| Not Applicable |
Data Collection Template (DCT)
Service Master
| SAP Structure | SAP Field | Type | Length | Field Description | Importance | |
| MARA - General Material Master Data (client-level basic material data) | ||||||
| MARA | MATERIAL | Text | 80 | Material Number | mandatory for sheet | Product Number* A key that uniquely identifies the product. |
| MARA | MTART | Text | 80 | Product Type | mandatory for sheet | Product Type* Key that assigns the product to a group of products such as raw product, finished product or trading goods. |
| MARA | ATTYP | Text | 80 | Product Category | Product Category Specifies the category of the product. For example, whether it is a single product, a sales set, a generic product or a variant. | |
| MARA | SATNR | Text | 80 | Configuration Product for Retail Variant | Configuration Product for Retail Variant Key uniquely identifying a generic product to which the variant is linked. | |
| MARA | MATKL | Text | 80 | Product Group | Product Group Key that you use to group together several products or services with the same attributes, and to assign them to a particular product group. | |
| MARA | MBRSH | Text | 80 | Industry Sector | Industry Sector Key that specifies the branch of industry to which the product is assigned. | |
| MARA | MAKTX | Text | 40 | Description | mandatory for sheet | Description* Text that describes the product in more detail. Note: You can maintain additional descriptions (for languages other than those provided on the 'Basic Data' sheet). |
| MARA | SPRAS | Text | 80 | Language Key | mandatory for sheet | Language Key* Please provide the language for the product description. |
| MARA | MEINS | Text | 80 | Base Unit of Measure (ISO Format) | mandatory for sheet | Base Unit of Measure (ISO Format)* Unit of measure in which stocks of the product are managed. The system converts all the quantities you enter in other units of measure (alternative units of measure) to the base unit of measure. Note: define your alternative units of measure in sheet 'Alternative Unit of Measure'. |
| MARA | AENNR | Text | 80 | Change Number | Change Number Number used to uniquely identify a change master record. | |
| MARA | REVLV | Text | 80 | Revision Level | Revision Level Indicates a product or document's change status in addition to the change number. | |
| MARA | EAN11 | Text | 18 | GTIN | GTIN The GTIN on the Basic Data sheet always relates to the base unit of measure. Note: if you have additional GTIN's for this unit please enter them on the Additional GTIN sheet. The GTIN entered here is always the Main GTIN. With internal number assignment, you enter the GTIN category but not a GTIN. | |
| MARA | NUMTP | Text | 80 | GTIN Category | GTIN Category The EAN category defines the following attributes of the corresponding EAN: Type/method of number assignment (internal and/or external number assignment) and details as to whether alphanumerical EANs are allowed Check-digit algorithm that checks whether a check digit is required Prefix (for perishables EANs) Length of the EAN. | |
| MARA | SPART | Text | 80 | Division | Division A way of grouping products, or services. The system uses divisions to determine the sales areas and the business areas for a product, or service. Please maintain the division for all sales relevant products. | |
| MARA | BISMT | Text | 40 | Old Product Number | Old Product Number Number under which you have managed the product so far or still manage it, for example, in another system or in a card index. The maximum length of field Old Product Number is identical with the defined length for product numbers in your system. | |
| MARA | PRDHA | Text | 80 | Product Hierarchy | Product Hierarchy Alphanumeric character string for grouping together products by combining different characteristics. It is used for analyses and price determination. | |
| MARA | BRAND_ID | Text | 80 | Brand | Brand Where applicable specify the manufacturer brand or private label of the product. | |
| MARA | XCHPF | Text | 1 | Batch Management Required Ind. | Batch Management Required Ind. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. Specifies whether the product is managed in batches ('X') or not (<blank>). Note: to assign the batch class to your product please use migration object 'Material classification'. | |
| MARA | MLGUT | Text | 1 | Has Empties | Has Empties This is an indicator field. If you want to create an empties bill of material for this product the indicator should be set to X. If not, leave the field empty. | |
| MARA | DATAB | Date | Valid From | Valid From Date indicating until when the product is valid. This date must not be later than the beginning of the listing periods.\ | ||
| MARA | LIQDT | Date | Deletion Date | Deletion Date Date on which the product is to be deleted. This is the latest possible date of all "To-dates" referring to the product. (Usually, this date is set to 31.12.9999.) | ||
| MARA | KUNNR | Text | 80 | Competitor | Competitor Customer number of the competitor. The competitor number in the product master record serves to identify a competitive product as that of a particular competitor. | |
| MARA | NORMT | Text | 18 | Industry Standard Description | Industry Standard Description Description of the product in accordance with the appropriate industry standard (such as ANSI or ISO). This field is purely for information. | |
| MARA | GROES | Text | 32 | Size/Dimensions | Size/Dimensions Text field that you can use as you like, for example, to record the size or dimensions of the product. The data you enter is merely for information and is not used by the system. | |
| MARA | LABOR | Text | 80 | Laboratory / Design Office | Laboratory / Design Office Key for the design office, laboratory, or laboratory worker responsible. | |
| MARA | INHAL | Number | 13 | Net Contents | Net Contents Specify the net contents for the base unit of measure of the product. The relevant content unit is maintained in the next column. The information in the content fields can be used to calculate the basic price/unit price of a product (for example a price per kg), that allows consumers to compare prices of products with different weights. | |
| MARA | INHME | Text | 80 | Net Contents Unit (ISO Format) | Net Contents Unit (ISO Format) Specify the unit of measure (UoM) which is related to the statement of net and gross contents. | |
| MARA | INHBR | Number | 13 | Gross Contens | Gross Contens Specify the gross contents for the base unit of measure for the product. | |
| MARA | VPREH | Number | 5 | Comparison Price Unit | Comparison Price Unit Number of units of measure in the content unit to which the comparison price relates. | |
| MARA | EXTWG | Text | 80 | External Product Group | External Product Group Key that you can use to assign the product to an external product group or to a product group determined according to external systematics. | |
| MARA | MTPOS_MARA | Text | 80 | General Item Category Group | General Item Category Group Products grouping that helps the system to determine item categories during sales document processing. | |
| MARA | BEGRU | Text | 4 | Authorization Group | Authorization Group The authorization group enables you protect access to certain objects. | |
| MARA | MSTAE | Text | 80 | Cross-Plant Product Status | Cross-Plant Product Status The product status determines how a product is handled in different applications and in business operations (for example, purchasing, products planning, usage in bills of material ..). If a product has a product status, the system will issue either a warning or an error message (depending on which status you have chosen) if the product is used. Note: The cross-plant product status restricts the usability of the product for all plants. Please see further information in the migration object documentation under Mapping instructions. | |
| MARA | MSTDE | Date | Valid-From Date | Valid-From Date Date from which the cross-plant product status is valid. | ||
| MARA | SERLV | Text | 80 | Level of Explicitness for Serial Number | Level of Explicitness for Serial Number Level on which the serial number must be unique. | |
| MARA | QMPUR | Text | 1 | Quality Manag. in Procurement Is Active | Quality Manag. in Procurement Is Active This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. Note: This field must only be filled if there will be a related Quality Info record existing in the system. If the fields are filled and the QIR is missing, the business process will run into an error. | |
| MARA | ANIMAL_ORIGIN | Text | 1 | Animal Origin | Animal Origin This is an indicator field. If the product contains non-textile parts of animal origin enter X. If not, leave the field empty. | |
| MARA | ANP | Text | 80 | ANP Code | ANP Code For Brazil only ! Identifies the products that are controlled by the Brazilian Oil Agency. | |
| MARA | BRGEW | Number | 13 | Gross Weight | Gross Weight Gross weight expressed in the unit of weight specified by you in the Unit of weight field. The system can use the gross weight at a later stage, depending on what kind of capacity check you run, to check storage bin capacity for warehouse management purposes. | |
| MARA | NTGEW | Number | 13 | Net Weight | Net Weight Net weight expressed in the unit of weight specified by you in the Unit of weight field. | |
| MARA | GEWEI | Text | 80 | Unit of Weight (ISO Format) | Unit of Weight (ISO Format) Unit referring to the gross weight or net weight of the product. If a product is created with sales data, the field unit of weight gets mandatory. Please provide an entry in this field or a default unit of weight is defined in product groups settings. | |
| MARA | LAENG | Number | 13 | Length | Length Length of the product or its packaging, measured in the unit of dimension. | |
| MARA | BREIT | Number | 13 | Width | Width Width of the product or its packaging, measured in the unit of dimension. | |
| MARA | HOEHE | Number | 13 | Height | Height Height of the product or its packaging, measured in the unit of dimension. | |
| MARA | MEABM | Text | 80 | Unit for Length/Width/Height(ISO Format) | Unit for Length/Width/Height(ISO Format) Unit in which the dimensions of length, breadth, and height of a product or its packaging are measured. | |
| MARA | VOLUM | Number | 13 | Volume | Volume Space that the product occupies per unit of volume. The volume refers to the unit specified in the "Volume unit" field. The volume and its unit always refer to the base unit of measure. | |
| MARA | VOLEH | Text | 80 | Volume Unit | Volume Unit If you specify a volume, you have to enter the corresponding volume unit here. | |
| MARA | CAPAUSE | Number | 15 | Capacity Usage | Capacity Usage | |
| MARA | CHML_CMPLNC_RLVNCE_IND | Text | 80 | Compliance Relevant | Compliance Relevant Indicates whether the product needs to be assessed for Compliance. | |
| MARA | KZKFG | Text | 1 | Product Is Configurable | Product Is Configurable This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. Indicator that determines whether the product is configurable. If this indicator is set, you can assign a variant class to the product, making it possible to use it as a configurable product. Consider: if you are dealing with product type 'KMAT' the system will set this indicator automatically in the product master. This is described in detail in the migration object documentation. | |
| MARA | BSTME | Text | 80 | Order Unit of Measure (ISO Format) | Order Unit of Measure (ISO Format) Enter a value in this field only if you want to use a unit of measure differing from the base unit of measure. | |
| MARA | EKWSL | Text | 80 | Purchasing Value Key | Purchasing Value Key Key defining the reminder days and tolerance limits valid, as well as the shipping instructions and order acknowledgment requirement of the product for Purchasing. | |
| MARA | VABME | Text | 80 | State of Variable Purchase Order Unit | State of Variable Purchase Order Unit Activation of the variable purchase order unit. The information from the field in the product master record is adopted in the purchasing info record. In the purchase order and in the source list, you can enter an order unit that differs from the one in the purchasing info record. If you wish to specify a different order unit for a requisition, you must assign a source with a different order unit to the requisition. The field also determines whether you work with conditions for each order unit. | |
| MARA | BMATN | Text | 80 | Internal Product Number | Internal Product Number Number of firm's own (internal) inventory-managed product. | |
| MARA | MFRPN | Text | 40 | Manufacturer Part Number | Manufacturer Part Number Specifies the number used by the manufacturer, or also by the supplier, to manage a product. | |
| MARA | MFRNR | Text | 80 | Manufacturer Number | Manufacturer Number Specifies the manufacturer of the MPN product or the manufacturer's plant for which a manufacturer master record has been created. | |
| MARA | MPROF | Text | 80 | Manufacturer Part Profile | Manufacturer Part Profile Defines how you can work with MPN products in the procurement process. If you wish to work with MPN products, enter a profile. The profile then applies to all MPN products that are assigned to this firm's own, inventory-managed product. | |
| MARA | TRAGR | Text | 80 | Transportation Group | Transportation Group A grouping of products that share the same route and transportation requirements. The transportation group is product specific and therefore valid for all plants (where the loading group can be maintained at plant level). Transportation groups are used for automatic route scheduling during requirements. | |
| MARA | MSTAV | Text | 80 | Cross-Distribution Chain Product Status | Cross-Distribution Chain Product Status Indicates whether the product may be used in individual functions in Sales and Distribution for all distribution chains. The cross-distribution-chain product status restricts the usability of the product for all the distribution chains, that is, it defines whether a warning or error message is displayed if you include the product in a particular function. | |
| MARA | MSTDV | Date | Valid From Date for Status | Valid From Date for Status Date from which the cross-distribution-chain product status is valid.\ | ||
| MARA | PMATA | Text | 80 | Pricing Reference Product | Pricing Reference Product Product master record that the system uses as a reference for pricing purposes. When maintaining this field for a variant make sure to enter the number of the generic article here if the variant price should correspond to that of the generic product. | |
| MARA | SPROF | Text | 80 | Pricing Profile for Variants | Pricing Profile for Variants Specifies how you can maintain the sales prices of the variants of a generic product. You have the following options: - The sales prices of the variants correspond to that of the generic product. - The sales prices of the variants differ from that of the generic product. | |
| MARA | ALLOW_PMAT_IGNO | Text | 1 | Variant Price Allowed | Variant Price Allowed This is an indicator field. Setting this indicator to X for a generic product will permit the overwriting of the pricing reference article for variants that are price dependant on the generic product within a promotion. | |
| MARA | SOM_CYCLE | Text | 80 | Billing Cycle | Billing Cycle Defines periodic billing periods and specifies the following: - The frequency of a billing period - The length of a billing period (defined by a start and end date) - The rule for determining the period end | |
| MARA | SOM_CYCLE_RULE | Text | 80 | Billing Cycle Determination Rule | Billing Cycle Determination Rule | |
| MARA | SOM_TC_SCHEMA | Text | 80 | Assignment Schema | Assignment Schema | |
| MARA | BBTYP | Text | 80 | Assortment List Type | Assortment List Type Key that assigns a product to an assortment list type. The assortment list type controls the chronological supply of product data to the assortment list. | |
| MARA | SERVV | Text | 80 | Service Agreement | Service Agreement You can define a particular service profile according to which the product is staged for customers. This profile is for information and is used in organizational arrangements. | |
| MARA | MAGRV | Text | 80 | Product Group: Packaging Materials | Product Group: Packaging Materials Groups together products that require similar packaging products. | |
| MARA | VHIART | Text | 80 | Packaging Product Type | Packaging Product Type Enter a code for a grouping of similar products, such as crates, trucks or pallets. | |
| MARA | ERGEW | Number | 13 | Allowed Packaging Weight | Allowed Packaging Weight Maximum weight of other products that are packed in this packaging product. | |
| MARA | ERGEI | Text | 80 | Unit of Allowed Packaging Weight | Unit of Allowed Packaging Weight Unit referring to the allowed packaging weight of the product. If you specify an allowed packaging weight, you must enter the corresponding unit of weight here. Please note that the entered value needs to be mapped to a valid ISO code value after uploading the file and starting the transfer process. | |
| MARA | GEWTO | Number | 3 | Excess Weight Tolerance for HU | Excess Weight Tolerance for HU Specifies the tolerance limit for exceeding the maximum weight allowed for a particular packaging material during packing. | |
| MARA | ERVOL | Number | 13 | Allowed Packaging Volume | Allowed Packaging Volume Maximum volume of other products that are packed in this packaging product. | |
| MARA | ERVOE | Text | 80 | Unit of Allowed Packaging Volume | Unit of Allowed Packaging Volume Unit referring to the allowed packaging volume of the product. If you specify an allowed packaging volume, you must enter the corresponding volume unit here. Please note that the entered value needs to be mapped to a valid ISO code value after uploading the file and starting the transfer process. | |
| MARA | KZGVH | Text | 1 | Packaging Product Is Closed Packaging | Packaging Product Is Closed Packaging For closed packaging products, during packing the total volume is not increased by the loading volume of the contents. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | |
| MARA | VOLTO | Number | 3 | Excess Volume Tolerance for HU | Excess Volume Tolerance for HU Specifies the tolerance limit for the maximum packing volume allowed for a particular packaging product. | |
| MARA | IPRKZ | Text | 80 | Period Indicator for Shelf Life | Period Indicator for Shelf Life Period Indicator for Shelf Life Expiration Date The period indicator specifies the unit of measurement for a period of time. Like day, week, month, year. | |
| MARA | RAUBE | Text | 80 | Storage Conditions | Storage Conditions Indicates what storage conditions are required for the product. | |
| MARA | TEMPB | Text | 80 | Temperature Conditions Indicator | Temperature Conditions Indicator Indicates the temperature conditions in which the product should be stored. | |
| MARA | BEHVO | Text | 80 | Container Requirements | Container Requirements Key for the regulation that governs which type of container the product must be stored and shipped in. | |
| MARA | STOFF | Text | 40 | Hazardous Product Number | Hazardous Product Number The hazardous product number indicates that the product is dangerous, making special precautions necessary for its storage and shipment. | |
| MARA | ETIAR | Text | 80 | Label Type | Label Type Determines the way labels are created. The label type specifies, for example, whether labels are preprinted by the supplier or created on a central printer. | |
| MARA | ETIFO | Text | 80 | Label Form | Label Form Determines the size and layout of the label. The label form specifies, for example, whether the label is an adhesive or a pin-on label. | |
| MARA | WESCH | Number | 13 | Number of Goods Receipt/Issue Slips | Number of Goods Receipt/Issue Slips In the case of a goods receipt with reference to a purchase order or production order, the system automatically calculates the number of GR/GI slips to be printed for the product document item as a quotient from the goods receipt quantity and the quantity defined here. | |
| MARA | XGCHP | Text | 1 | Indicator: Approved Batch Rec. Required | Indicator: Approved Batch Rec. Required This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | |
| MARA | MHDHB | Number | 4 | Total Shelf Life | Total Shelf Life Period for which the product will keep in total, that is, from the date of production to the shelf life expiration date. The period (day, week, month, year) depends on the entry in the Period indicator field. | |
| MARA | MHDRZ | Number | 4 | Minimum Remaining Shelf Life | Minimum Remaining Shelf Life Minimum amount of time for which the product must keep upon goods receipt for the goods receipt to be accepted by the system. The period (day, week, month, year) depends on the entry in the Period indicator field. | |
| MARA | SLED_BBD | Text | 80 | Indi. for the Shelf Life Expiration Date | Indi. for the Shelf Life Expiration Date Indicator for the shelf life expiration date or expiration date. In batch management, the shelf life expiration date or expiration date can be specified. You select the date type you want by using this indicator. | |
| MARA | MHDLP | Number | 3 | Storage Percentage | Storage Percentage Percentage specifying how much of the minimum remaining shelf life must be left if the product is to be sent to another plant (such as a store) from a central plant (such as a distribution center). | |
| MARA | RDMHD | Text | 80 | Rounding Rule for Calculation of SLED | Rounding Rule for Calculation of SLED Example: Total shelf life in product master = 3 Period indicator in product master = M (month) Production date, specified at goods receipt = 10.01.2016 => SLED = 10.01.2016 + 3 months = 10.04.2016 Rounding indicator = MHD = 10.04.2016 (no rounding) Rounding indicator = '-' = 01.04.2016 (first day of month) Rounding indicator = '+' = 30.04.2016 (last day of month). | |
| MARA | HNDLCODE | Text | 80 | Handling Indicator | Handling Indicator Indicator that specifies how products are handled in the warehouse. The handling code could have the attribute Fragile, for example, and would therefore need to be stored in a special section of the warehouse. | |
| MARA | WHMATGR | Text | 80 | Warehouse Product Group | Warehouse Product Group Groups products by warehousing points of view. | |
| MARA | WHSTC | Text | 80 | Warehouse Storage Condition | Warehouse Storage Condition Describes the storage condition that should be used to store the product. | |
| MARA | HUTYP_DFLT | Text | 80 | Standard Handling Unit Type | Standard Handling Unit Type Describes the standard handling unit type for mixed handling units, where no packing instruction is used for creating the HU. | |
| MARA | SERIAL | Text | 80 | Serial Number Profile | Serial Number Profile Combined data, grouped in a four-figure abbreviation, that determines the conditions and business transactions for issuing serial numbers to serialized materials. You must enter the serial number profile in the product master record for products that need serial numbers. | |
| MARA | PILFERABLE | Text | 1 | Pilferable | Pilferable The product is pilferable, and possibly requires special storage in a secure storage type/section within the warehouse. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | |
| MARA | HAZMAT | Text | 1 | Relevant for Hazardous Substances | Relevant for Hazardous Substances There is hazardous substance data for this product. The system has to read additional data because this hazardous substance is relevant for storage. | |
| MARA | QQTIME | Number | 3 | Quarantine Period | Quarantine Period | |
| MARA | QQTIMEUOM | Text | 80 | Time Unit for Quarantine Period | Time Unit for Quarantine Period | |
| MARA | QGRP | Text | 80 | Quality Inspection Group | Quality Inspection Group | |
| MARA | HUTYP | Text | 80 | Handling Unit Type | Handling Unit Type Specifies the HU type of the packaging product used for creating handling units. | |
| MARA | MAXC | Number | 15 | Maximum Capacity | Maximum Capacity Maximum allowed capacity of packaging product. | |
| MARA | MAXC_TOL | Number | 3 | Overcapacity Tolerance | Overcapacity Tolerance Defines the tolerance limit for the maximum packaging capacity of a packaging product. | |
| MARA | TARE_VAR | Text | 1 | Variable Tare Weight | Variable Tare Weight Flags all packaging products for this packaging product type as packaging products with a variable tare weight. If a change in the total weight occurs, then the tare weight is adjusted and not the loading weight. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | |
| MARA | MAXL | Number | 15 | Max. Pack. Length | Max. Pack. Length Maximum packing length of packaging product. | |
| MARA | MAXDIM_UOM | Text | 80 | UoM for Max. Pack. Length (ISO Format) | UoM for Max. Pack. Length (ISO Format) Unit of Measure for Maximum Packing Length/Width/Height in ISO | |
| MARA | MAXB | Number | 15 | Max. Pack. Width | Max. Pack. Width Maximum packing width of packaging product. | |
| MARA | MAXH | Number | 15 | Max. Pack. Height | Max. Pack. Height Maximum packing height of packaging product. | |
| MARA | RBNRM | Text | 80 | Catalog Profile | Catalog Profile A combination of code groups from several catalogs. A catalog profile is defined in Customizing and then assigned to the notification type. It restricts the list of values for the information contained in the quality notification. | |
| MARA | SSTUF | Text | 80 | Assortment Grade | Assortment Grade The assortment grade is an optional criterion to structure assortments. Maintain the assortment grade to which the product is assigned if you use a listing procedure where the assortment grade is relevant. | |
| MARA | LSTVZ | Text | 80 | Listing Procedure | Listing Procedure Specify the procedure to be used for the automatic selection of distribution center assortments where the product is to be listed. The listing procedure determines which checks are made to identify the relevant assortments for the product. | |
| MARA | LDVZL | Date | Listing Period Start Date | Listing Period Start Date Date from which the product is listed in the distribution center. | ||
| MARA | LDBZL | Date | Listing Period End Date | Listing Period End Date Date to which the product is listed in the distribution center. | ||
| MARA | LSTFL | Text | 80 | Listing Procedure | Listing Procedure Specify the procedure to be used for the automatic selection of store assortments where the product is to be listed. The listing procedure determines which checks are made to identify the relevant assortments for the product. | |
| MARA | LDVFL | Date | Listing Period Start Date | Listing Period Start Date Date from which the product is listed in the stores. | ||
| MARA | LDBFL | Date | Listing Period End Date | Listing Period End Date Date to which the product is listed in the stores. | ||
| MARA | VDVZL | Date | Sales Period Start Date | Sales Period Start Date Date from which the product is sold in the distribution center. | ||
| MARA | VDBZL | Date | Sales Period End Date | Sales Period End Date Date to which the product is sold in the distribution center. | ||
| MARA | VDVFL | Date | Sales Period Start Date | Sales Period Start Date Date from which the product is sold in the stores. | ||
| MARA | VDBFL | Date | Sales Period End Date | Sales Period End Date Date to which the product is sold in the stores. | ||
| MARA | WAUSM | Text | 80 | Delivery Unit of Measure (ISO Format) | Delivery Unit of Measure (ISO Format) Unit in which the product is issued from the warehouse. | |
| MARA | WVRKM | Text | 80 | Sales Unit of Measure (ISO Format) | Sales Unit of Measure (ISO Format) Unit in which the product is sold. If you need to differentiate the sales unit of measure depending on the used sales channel you can do so in the sheet distribution chains. | |
| MARA | WMAAB | Text | 80 | ABC Indicator | ABC Indicator Indicator that classifies a product for an ABC analysis as an A, B, or C part according to its consumption value. | |
| MARA | WBKLA | Text | 80 | Valuation Class | Valuation Class The valuation class plays a role in the determination of the G/L accounts that are updated for a valuation relevant transaction such as a goods movement. | |
| MARA | WHERL | Text | 80 | Country/Region of Origin | Country/Region of Origin Country/Region in which the product has been produced. | |
| MARA | WHERR | Text | 80 | Region of Origin | Region of Origin Region of Origin of the product. | |
| MARA | WEKGR | Text | 80 | Purchasing Group | Purchasing Group Key for a buyer or a group of buyers responsible for the procurement of the product. | |
| MARA | BWSCL | Text | 80 | Source of Supply | Source of Supply Restricts the search for sources of supply for this product to external (normal) or internal (stock transfer) sources of supply, and also allows you to define a search sequence. | |
| MARA | TAKLV | Text | 80 | Tax Classification | Tax Classification Key that identifies the tax classification of a product. The value entered here serves as the default value for the tax classification of the tax categories to be taken into account (for example, for the tax category value-added tax in Germany). | |
| MARA | WLADG | Text | 80 | Loading Group | Loading Group A grouping of products that share the same loading requirements. The system uses the loading group as well as the ' Shipping conditions' and 'Delivering plant' to automatically determine the shipping point for the item in sales and transfer documents (for example Sales Order, outbound delivery). | |
| MARA | WBWSP | Number | 6 | Valuation Margin | Valuation Margin The valuation margin is the difference in percent between the retail value and the cost value of a product in relation to the retail value: Valuation margin = (total retail - total cost) / total retail x 100 | |
| MARA | PSTATQ | Text | 1 | Indicator: Quality | Indicator: Quality You can use this indicator to set the quality view on client level active. For further information please refer to the migration object documentation. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | |
| MARA | PSTATV | Text | 1 | Indicator: Sales | Indicator: Sales You can use this indicator to set the sales view on client level active. For further information please refer to the migration object documentation. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | |
| MARA | PSTATL | Text | 1 | Indicator: Storage | Indicator: Storage You can use this indicator to set the storage view on client level active. For further information please refer to the migration object documentation. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | |
| MARA | PSTATE | Text | 1 | Indicator: Purchasing | Indicator: Purchasing You can use this indicator to set the purchasing view on client level active. For further information please refer to the migration object documentation. This is an indicator field. If the criterion is met, enter X. If not, leave the field empty. | |
| SAP Structure | SAP Field | Type | Length | Field Description | Importance | |
| MAKT - Material Descriptions (short/long material text per language) | ||||||
| MAKT | MATERIAL | Text | 80 | Material Number | mandatory for sheet | Product Number* A key that uniquely identifies the product. |
| MAKT | SPRAS | Text | 80 | Language Key | mandatory for sheet | Language Key* The language key indicates - the language in which texts are displayed, - the language in which you enter texts, - the language in which the system prints texts. |
| MAKT | MAKTX | Text | 40 | Product Description | mandatory for sheet | Product Description* Text that describes the product in more detail. Note: You can maintain additional descriptions (for languages other than those provided on the 'Basic Data' sheet). |
Extraction Dependencies
| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Data cleansing of legacy Material data must be completed. | Business |
Transformation
The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow to make the data Target ready:
- 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 Run Sheet
| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Verify that Material data is extracted from both source systems. | Syniti / S2P Data Team |
2 | Verify that Services data is extracted from the DCT. | Syniti / S2P Data Team |
3 | Verify that the Material Number XREF has been updated for both material and service data. | Syniti |
5 | Transformation jobs are ready for execution. | Syniti |
| 6 | Generate Load Files. | Syniti |
Transformation Rules
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PF2/WQ2 | S_MARA | MATNR | Material Number | S/4HANA | S_MARA | MATNR | Material Number | Generate new Material number in Target System and maintain mapping in reference table |
| 2 | PF2/WQ2 | S_MARA | MBRSH | Industry Sector | S/4HANA | S_MARA | MBRSH | Industry Sector | Copy from source to target system |
| 3 | PF2/WQ2 | S_MARA | MTART | Material Type | S/4HANA | S_MARA | MTART | Material Type | Map from source to target using Material Type mapping table |
| 4 | PF2/WQ2 | S_MARA | MAKTX | Description | S/4HANA | S_MARA | MAKTX | Description | Copy from source to target system in adherence to S4H Data Standard (ie. descriptions to be cleansed so that non standard special characters are excluded) |
| 5 | PF2/WQ2 | S_MARA | SPRAS | Language Key | S/4HANA | S_MARA | SPRAS | Language Key | EN description to be created if not available. Copy local descriptions from source if required. |
| 6 | PF2/WQ2 | S_MARA | MEINS | Base Unit of Measure (ISO Format) | S/4HANA | S_MARA | MEINS | Base Unit of Measure (ISO Format) | Map from source to target in adherence to S4H Data Standard |
| 7 | PF2/WQ2 | S_MARA | MATKL | Material Group | S/4HANA | S_MARA | MATKL | Material Group | Map from source to target using Material Group mapping table |
| 8 | PF2/WQ2 | S_MARA | SPART | Division | S/4HANA | S_MARA | SPART | Division | Map from source to target in adherence to S4H Data Standard |
| 9 | PF2/WQ2 | S_MARA | PRDHA | Product Hierarchy | S/4HANA | S_MARA | PRDHA | Product Hierarchy | Map from source to target using Product Hierarchy mapping table |
| 10 | PF2/WQ2 | S_MARA | MTPOS_MARA | General Item Category Group | S/4HANA | S_MARA | MTPOS_MARA | General Item Category Group | Copy from source to target system |
| 11 | PF2/WQ2 | S_MARA | BRGEW | Gross Weight | S/4HANA | S_MARA | BRGEW | Gross Weight | Copy from source to target system |
| 12 | PF2/WQ2 | S_MARA | NTGEW | Net Weight | S/4HANA | S_MARA | NTGEW | Net Weight | Copy from source to target system |
| 13 | PF2/WQ2 | S_MARA | GEWEI | Unit of Weight (ISO Format) | S/4HANA | S_MARA | GEWEI | Unit of Weight (ISO Format) | Copy from source to target system in adherence to S4H Data Standard |
| 14 | PF2/WQ2 | S_MARA | PROFL | DG Indicator Profile | S/4HANA | S_MARA | Compliance Relevant Indicator | If DG Ind Profile or Environmentally Rel is populated/ticked then set Compliance Relevant Indicator to X in S4H | |
| 15 | PF2/WQ2 | S_MARA | KZUMW | Environmentally Relevant | S/4HANA | S_MARA | Compliance Relevant Indicator | If DG Ind Profile or Environmentally Rel is populated/ticked then set Compliance Relevant Indicator to X in S4H |
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
Material Type | Mapping of legacy Material Types to target system value |
Material Group | Mapping of legacy Material Groups to target system value |
| Product Hierarchy | Mapping of legacy Product Hierarchies to target system value |
| Lab/Office | Mapping of legacy Lab/Office values to target system value |
| Division | Mapping of legacy Division values to target system value |
| Authorization Group | Mapping of legacy Authorization Group values to target system value |
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Data has been extracted from sources systems | Syniti |
2 | Deduplication is completed | Syniti & S2P Data Team |
3 | Configuration should be completed - (Config documents should be complete) | S2P Functional Team |
4 | Ensure DCT completeness | S2P Data Team |
| 5 | Value mapping and XREF tables are ready | Syniti & S2P Data Team |
Pre-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Verify Record Count | The number of records presented after relevancy checks and validation, as well as the number of records in the DCT, needs to be correct compared to the staged data in Syniti ADMM. |
Completeness check | All fields required as per mapping template rules must be completed. Syniti ADMM standard validity reports checking each field in Syniti must be built. |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Verify that the data staged in the preload tables are correct in terms of the mapping rules. This will be done via Syniti ADMM standard reports.. |
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. |
Business
Completeness
| Task | Action |
|---|---|
Completeness Check | Business should compare legacy record counts, taking into account the reduction from the relevancy and deduplication processes, against the record count in the preload table. |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Business team to verify that the data staged in the preload tables are correct in terms of the mapping rules. This will be done via Syniti ADMM reports/SAP reports. |
Load
The load process includes:
- Execute the automated data load into target system using load tool or product the load file if the load must be done manually
- Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation
Load Run Sheet
| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Verify data extracted | Data Specialist/Functional - S2P |
2 | Verify data combined from both source systems and DCT | Data Specialist/Functional - S2P |
3 | Verify Material, Plant and Purchasing Group XREFs are ready | Data Specialist/Functional - S2P |
4 | Stage data for transformations | Syniti |
5 | Run transforms | Syniti |
6 | Execute pre-load report | Syniti |
7 | Validate preload report - release | Data Specialist/Functional - S2P |
8 | Prepare and simulate | Syniti |
9 | Pre-load verification and approval to load | Functional/Data Owner - S2P |
10 | Load to S4 | Syniti |
11 | Complete Jira steps, Volumes and Timings | All - where applicable |
12 | Execute post-load report | Syniti |
13 | Post-load report verification/validation | Data Specialist/Functional/Data Owner - S2P |
14 | Object load completion approval | Data Owner - S2P |
Loading Method
Load Phase and Dependencies
Configuration
| Item # | Configuration Item |
|---|---|
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram) | |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
Post-Load Validation
Project Team
Post-Load Steps
Step Description | Team Responsible |
Execute post-load report | Syniti |
Post-load report verification/validation | Data Specialist/Functional/Data Owner - S2P |
Object load completion approval | Data Owner - S2P |
Completeness
| Task | Action |
|---|---|
Verify Count | The number of records presented in the post-load needs to be compared to the preload – Syniti report |
Field by field check | Compare source data staged in the preload tables to target data in the load tables. |
Accuracy
| Task | Action |
|---|---|
Verify Logs | Check if there is data that failed to load and perform the necessary actions (e.g. register as post load issue or attempt to load the record again, etc.). |
Business
Completeness
| Task | Action |
|---|---|
Verify Count | The number of records presented in the preload needs to be compared to the post-load Syniti report. |
Missing data | Check missing data which was supposed to be loaded. |
Reconciliation | Participate in Post-load walkthroughs. |
Field by field check | Perform random Field by Field checks by comparing source data staged in the preload tables to target data in the load tables. |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Verify that the data in S/4 HANA was loaded correctly via Syniti post-load reports. |
Key Assumptions
- Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
- Materials - Basic Data is in scope based on data design and any exception requested by business.
See also
Change log
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||