You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 122 Next »

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)
  • 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.
  • 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

  1. All materials created in the previous 6 months will be included unless flagged for deletion
  2. 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).
  3. 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):
    1. Company Codes in scope
    2. Plants in scope
    3. Purchasing Orgs in scope
    4. Sales Orgs in scope
  4. 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:
    1. 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
    2. For sales data use VBAK/VBAP tables 
    3. 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.
    4. 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.
  5. 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.
  6. We will include for migration all materials that have open documents including the following:
    1. Open PO and STO. (EKPO-ELIKZ ≠ 'X') (EKKO.BSTYP = F)
    2. Open contracts and scheduling agreements. (EKPO-ELIKZ ≠ 'X') (EKKO.BSTYP = K)
    3. Open SO. VBUK.GBSTK = ('A','B') 
    4. 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'.
  7. Have current stock/open inventory
    1. For Open Inventory use the following tables:

      MARD

      MKOL (Consignment stock)

      MSKA (Sales Order stock)

      MSLB (Special stock)

      MSPR (Project stock)

  8. We will include all Production BOM data for materials in scope using tables: MAST/STKO/STPO. We will also include all Plant Maintenance BOMs and their related components. MAST data will include BOM Usage (STLAN) 1 (Production) & 4 (Plant Maintenance). STKO data will include BOM Category (STLTY) E (Equipment) & M (Material).
  9. Materials with Deletion Flags will be excluded unless appearing in the following open transactions:
    1. Open PO/STO
    2. Open contracts and scheduling agreements
    3. Open SO
    4. Open WO
  10. Deletion Flags (Table/Field) are as follows: MARA/LVORM = 'X' MARA/MSTAE = Z3, Z4, ZZ (PF2 system) Z0 (WP2 system)
  11. 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***'
  12. 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
  13. 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
  14. 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.


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget 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,000S4H260,000

Additional Information

MDS Documents

20251028

MDS pending

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.

202511XX

Extraction Pending


Material Master: Source ECC Material (all material types in scope) → Target S4H Material Master

Source Field InformationTransformation/Business RulesTarget Field Information
SequenceTechnical Source TableField DescriptionTechnical Source FieldField FormatField LengthCommentsMapping TypeTransform Rule or Default ValueValidation RuleCommentsDataload TemplateSheet NameGroupField DescriptionBusiness DescriptionCheck TableBusiness Mandatory
Y/N/C
System Mandatory
Y/N/C
TypeLengthDecimalSap Table NameSap Field Name
001MARAMaterial NumberMATNRText (CHAR)40
Default Value<EMPTY>
- Mandatory for Migration Cockpit


Material Number

YESYESText (CHAR)18
S_MARAMATNR
002MARAMaterial TypeMTARTText (CHAR)4



- Mandatory for Migration Cockpit


Material Type

YESYESText (CHAR)4
S_MARAMTART
003MARAMaterial GroupMATKLText (CHAR)9







Material Group



Text (CHAR)9
S_MARAMATKL
004MARAIndustry SectorMBRSHText (CHAR)1
Update Target Field using the Source field as-is





Industry Sector



Text (CHAR)1
S_MARAMBRSH
005MARADescriptionMAKTXText (CHAR)40



- Mandatory for Migration Cockpit


Description

YESYESText (CHAR)40
S_MARAMAKTX
006MARALanguage KeySPRASText (CHAR)1



- Mandatory for Migration Cockpit


Language Key

YESYESText (CHAR)1
S_MARASPRAS
007MARABase Unit of Measure (ISO Format)MEINSText (CHAR)3



- Mandatory for Migration Cockpit


Base Unit of Measure (ISO Format)

YESYESText (CHAR)3
S_MARAMEINS
008MARAChange NumberAENNRText (CHAR)6







Change Number



Text (CHAR)6
S_MARAAENNR
009MARARevision LevelREVLVText (CHAR)2







Revision Level



Text (CHAR)2
S_MARAREVLV
010MARAGTINEAN11Text (CHAR)18







GTIN



Text (CHAR)18
S_MARAEAN11
011MARAGTIN CategoryNUMTPText (CHAR)1







GTIN Category



Text (CHAR)1
S_MARANUMTP
012MARADivisionSPARTText (CHAR)2







Division



Text (CHAR)2
S_MARASPART
013MARAOld Material NumberBISMTText (CHAR)40







Old Material Number



Text (CHAR)40
S_MARABISMT
014MARAProduct HierarchyPRDHAText (CHAR)18







Product Hierarchy



Text (CHAR)18
S_MARAPRDHA
015MARABatch Management Required Ind.XCHPFText (CHAR)1







Batch Management Required Ind.



Text (CHAR)1
S_MARAXCHPF
016MARAHas EmptiesMLGUTText (CHAR)1







Has Empties



Text (CHAR)1
S_MARAMLGUT
017MARAValid FromDATABDate








Valid From



Date

S_MARADATAB
018MARADeletion DateLIQDTDate








Deletion Date



Date

S_MARALIQDT
019MARAIndustry Standard DescriptionNORMTText (CHAR)18







Industry Standard Description



Text (CHAR)18
S_MARANORMT
020MARASize/DimensionsGROESText (CHAR)32







Size/Dimensions



Text (CHAR)32
S_MARAGROES
021MARALaboratory / Design OfficeLABORText (CHAR)4







Laboratory / Design Office



Text (CHAR)4
S_MARALABOR
022MARAExternal Product GroupEXTWGText (CHAR)18







External Product Group



Text (CHAR)18
S_MARAEXTWG
022MARAGeneral Item Category GroupMTPOS_MARAText (CHAR)4







General Item Category Group



Text (CHAR)4
S_MARAMTPOS_MARA
023MARAAuthorization GroupBEGRUText (CHAR)4







Authorization Group



Text (CHAR)4
S_MARABEGRU
024MARACross-Plant Product StatusMSTAEText (CHAR)2







Cross-Plant Product Status



Text (CHAR)2
S_MARAMSTAE
025MARAValid-From DateMSTDEDate








Valid-From Date



Date

S_MARAMSTDE
026MARAQuality Manag. in Procurement Is ActiveQMPURText (CHAR)1







Quality Manag. in Procurement Is Active



Text (CHAR)1
S_MARAQMPUR
027MARAANP CodeANPNumber (NUMC)9







ANP Code



Number (NUMC)9
S_MARAANP
028MARAGross WeightBRGEWNumber (NUMC)13,3







Gross Weight



Number (NUMC)13,33S_MARABRGEW
029MARANet WeightNTGEWNumber (NUMC)13,3







Net Weight



Number (NUMC)13,33S_MARANTGEW
030MARAUnit of Weight (ISO Format)GEWEIText (CHAR)3







Unit of Weight (ISO Format)



Text (CHAR)3
S_MARAGEWEI
031MARALengthLAENGNumber (NUMC)13,3







Length



Number (NUMC)13,33S_MARALAENG
032MARAWidthBREITNumber (NUMC)13,3







Width



Number (NUMC)13,33S_MARABREIT
033MARAHeightHOEHENumber (NUMC)13,3







Height



Number (NUMC)13,33S_MARAHOEHE
034MARAUnit for Length/Width/Height(ISO Format)MEABMText (CHAR)3







Unit for Length/Width/Height(ISO Format)



Text (CHAR)3
S_MARAMEABM
035MARAVolumeVOLUMNumber (NUMC)13,3







Volume



Number (NUMC)13,33S_MARAVOLUM
036MARAVolume UnitVOLEHText (CHAR)3







Volume Unit



Text (CHAR)3
S_MARAVOLEH
037MARACapacity UsageCAPAUSENumber15







Capacity Usage



Number15
S_MARACAPAUSE
038MARACompliance RelevantCHML_CMPLNC_RLVNCE_INDText (CHAR)1







Compliance Relevant



Text (CHAR)1
S_MARACHML_CMPLNC_RLVNCE_IND
039MARAProduct Is ConfigurableKZKFGText (CHAR)1







Product Is Configurable



Text (CHAR)1
S_MARAKZKFG
040MARAOrder Unit of Measure (ISO Format)BSTMEText (CHAR)3







Order Unit of Measure (ISO Format)



Text (CHAR)3
S_MARABSTME
041MARAPurchasing Value KeyEKWSLText (CHAR)2







Purchasing Value Key



Text (CHAR)2
S_MARAEKWSL
042MARAState of Variable Purchase Order UnitVABMEText (CHAR)1







State of Variable Purchase Order Unit



Text (CHAR)1
S_MARAVABME
043MARAInternal Product NumberBMATNText (CHAR)18







Internal Product Number



Text (CHAR)18
S_MARABMATN
044MARAManufacturer Part NumberMFRPNText (CHAR)40







Manufacturer Part Number



Text (CHAR)40
S_MARAMFRPN
045MARAManufacturer NumberMFRNRText (CHAR)10







Manufacturer Number



Text (CHAR)10
S_MARAMFRNR
046MARAManufacturer Part ProfileMPROFText (CHAR)4







Manufacturer Part Profile



Text (CHAR)4
S_MARAMPROF
047MARATransportation GroupTRAGRText (CHAR)4







Transportation Group



Text (CHAR)4
S_MARATRAGR
048MARACross-Distribution Chain Product StatusMSTAVText (CHAR)2







Cross-Distribution Chain Product Status



Text (CHAR)2
S_MARAMSTAV
049MARADG Indicator ProfilePROFLText (CHAR)3







DG Indicator Profile



Text (CHAR)3
S_MARAPROFL
050MARAEnvironmentally RelevantKZUMWText (CHAR)1







Environmentally Relevant



Text (CHAR)1
S_MARAKZUMW
051MARAIn Bulk/LiquidILOOSText (CHAR)1







In Bulk/Liquid



Text (CHAR)1
S_MARAILOOS
052MARAHighly ViscousIHIVIText (CHAR)1







Highly Viscous



Text (CHAR)1
S_MARAIHIVI
053MARAValid From Date for StatusMSTDVDate








Valid From Date for Status



Date

S_MARAMSTDV
054MARAMaterial CategoryATTYPText (CHAR)2







Material Category



Text (CHAR)2
S_MARAATTYP
055MARAProduct Group: Packaging MaterialsMAGRVText (CHAR)80







Product Group: Packaging Materials



Text (CHAR)80
S_MARAMAGRV
056MARAPackaging Product TypeVHIARTText (CHAR)80







Packaging Product Type



Text (CHAR)80
S_MARAVHIART
057MARAAllowed Packaging WeightERGEWText (CHAR)13







Allowed Packaging Weight



Text (CHAR)13
S_MARAERGEW
058MARAUnit of Allowed Packaging WeightERGEIText (CHAR)80







Unit of Allowed Packaging Weight



Text (CHAR)80
S_MARAERGEI
059MARAAllowed Packaging VolumeERVOLText (CHAR)13







Allowed Packaging Volume



Text (CHAR)13
S_MARAERVOL
060MARAUnit of Allowed Packaging VolumeERVOEText (CHAR)80







Unit of Allowed Packaging Volume



Text (CHAR)80
S_MARAERVOE
061MARAPackaging Product Is Closed PackagingKZGVHText (CHAR)1







Packaging Product Is Closed Packaging



Text (CHAR)1
S_MARAKZGVH
062MARAExcess Volume Tolerance for HUVOLTONumber3







Excess Volume Tolerance for HU



Number3
S_MARAVOLTO
063MARAPeriod Indicator for Shelf LifeIPRKZText (CHAR)80







Period Indicator for Shelf Life



Text (CHAR)80
S_MARAIPRKZ
064MARAStorage ConditionsRAUBEText (CHAR)80







Storage Conditions



Text (CHAR)80
S_MARARAUBE
065MARATemperature Conditions IndicatorTEMPBText (CHAR)2







Temperature Conditions Indicator



Text (CHAR)2
S_MARATEMPB
066MARAHazardous Product NumberSTOFFText (CHAR)40







Hazardous Product Number



Text (CHAR)40
S_MARASTOFF
067MARANumber of Goods Receipt/Issue SlipsWESCHNumber13







Number of Goods Receipt/Issue Slips



Number13
S_MARAWESCH
068MARAIndicator: Approved Batch Rec. RequiredXGCHPText (CHAR)1







Indicator: Approved Batch Rec. Required



Text (CHAR)1
S_MARAXGCHP
069MARATotal Shelf LifeMHDHBNumber4







Total Shelf Life



Number4
S_MARAMHDHB
070MARAMinimum Remaining Shelf LifeMHDRZNumber4







Minimum Remaining Shelf Life



Number4
S_MARAMHDRZ
071MARAIndi. for the Shelf Life Expiration DateSLED_BBDText (CHAR)80







Indi. for the Shelf Life Expiration Date



Text (CHAR)80
S_MARASLED_BBD
072MARAStorage PercentageMHDLPNumber3







Storage Percentage



Number3
S_MARAMHDLP
073MARARounding Rule for Calculation of SLEDRDMHDText (CHAR)80







Rounding Rule for Calculation of SLED



Text (CHAR)80
S_MARARDMHD
074MARASerial Number ProfileSERIALText (CHAR)80







Serial Number Profile



Text (CHAR)80
S_MARASERIAL
075MARARelevant for Hazardous SubstancesHAZMATText (CHAR)1







Relevant for Hazardous Substances



Text (CHAR)1
S_MARAHAZMAT
076MARAABC IndicatorMAABCText (CHAR)1







ABC Indicator



Text (CHAR)1
S_MARAMAABC
077MARACountry/Region of OriginHERKLText (CHAR)3







Country/Region of Origin



Text (CHAR)3
S_MARAHERKL
078MARAPurchasing GroupEKGRPText (CHAR)3







Purchasing Group



Text (CHAR)3
S_MARAEKGRP
079MARATax ClassificationTAKLVText (CHAR)1







Tax Classification



Text (CHAR)1
S_MARATAKLV
80MARALoading GroupLADGRText (CHAR)4







Loading Group



Text (CHAR)4
S_MARALADGR
081MARAIndicator: QualityPSTATQText (CHAR)1







Indicator: Quality



Text (CHAR)1
S_MARAPSTATQ
082MARAIndicator: SalesPSTATVText (CHAR)1







Indicator: Sales



Text (CHAR)1
S_MARAPSTATV
083MARAIndicator: StoragePSTATLText (CHAR)1







Indicator: Storage



Text (CHAR)1
S_MARAPSTATL
084MARAIndicator: PurchasingPSTATEText (CHAR)1







Indicator: Purchasing



Text (CHAR)1
S_MARAPSTATE



Material Master: Source ECC Service Master → Target S4H Material Master

Source Field InformationTransformation/Business RulesTarget Field Information
SequenceTechnical Source TableField DescriptionTechnical Source FieldField FormatField LengthCommentsMapping TypeTransform Rule or Default ValueValidation RuleCommentsDataload TemplateSheet NameGroupField DescriptionBusiness DescriptionCheck TableBusiness Mandatory
Y/N/C
System Mandatory
Y/N/C
TypeLengthDecimalSap Table NameSap Field Name
001ASMDActivity NumberASNUMText (CHAR)18
Default Value<EMPTY>
- Mandatory for Migration Cockpit


Material Number

YESYESText (CHAR)18
S_MARAMATNR
002ASMDMaterial GroupMATKLText (CHAR)9
Mapping RuleIf Source Field is empty do not send the data,

ElseApply data conversion based on the MAPPING_FILE

- Mandatory for Migration Cockpit


Material Group

YESYESText (CHAR)9
S_MARAMATKL
003ASMDBase Unit of MeasureMEINSUNIT3
Mapping Rule

If the source field exists in the MAPPING_FILE, apply the corresponding data conversion and update the target field accordingly.
If the source field is not found in the Mapping File, populate the target field with the source field value as is.


- Mandatory for Migration Cockpit


Base Unit of Measure (ISO Format)

YESYESText (CHAR)3
S_MARAMEINS
004ASMDService CategoryASTYPText (CHAR)4

















005ASMDPackage NumberPAKNRNUMC10

















006ASMDInternational Article Number (EAN/UPC)EAN11Text (CHAR)18
Copy AS-ISUpdate target field using the source field AS-IS




GTIN



Text (CHAR)18
S_MARAEAN11
007ASMDCategory of International Article Number (EAN)NUMTPText (CHAR)2
Copy AS-ISUpdate target field using the source field AS-IS




GTIN Category



Text (CHAR)1
S_MARANUMTP
008ASMDGeneral Purchasing Status for ServiceMSTAEText (CHAR)2
Mapping Rule

If the source field exists in the MAPPING_FILE, apply the corresponding data conversion and update the target field accordingly.
If the source field is not found in the Mapping File, populate the target field with the source field value as is.






Cross-Plant Product Status



Text (CHAR)2
S_MARAMSTAE
009ASMDValidity Date for “Purchasing” StatusMSTDEDATS8
Update 1:1Copy from source AS-IS




Valid-From Date



Date

S_MARAMSTDE
010ASMDValuation ClassBKLASText (CHAR)4















S_MARA
011ASMDHierarchy Service NumberLSTHIText (CHAR)18















S_MARA
012ASMDPrimary Language for Object TextsMLANGLANG1















S_MARA
013ASMDNumerator for Conversion of MEINS into IWEINIWUMZDEC5















S_MARA
014ASMDDenominator for Conversion (MEINS ↔ IWEIN)IWUMNDEC5















S_MARA
015ASMDUnit for WorkIWEINUNIT3















S_MARA
016ASMDFormula NumberFORMELNRText (CHAR)10















S_MARA
017ASMDShort Text Change AllowedCHGTEXTText (CHAR)1















S_MARA
018ASMDTax Tariff CodeTAXTARIFFCODEText (CHAR)16















S_MARA
019ASMDTLanguageSPRASText (CHAR)2










YESYES


S_MAKTSPRAS
020ASMDTDescriptionASKTXText (CHAR)40










YESYES


S_MAKTMAKTX





Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource 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 standardization. Confirmation regarding EA/PC format.


PF2/WP2

2019-004

C1

Check Gross and Net Weights

Check for missing weights and that Gross Weight >= Net


PF2/WP2

2019-005

C1

Country of Origin

Check Country of Origin exists for procured materials


PF2/WP2

2019-006

C1

Duplicate materials excluded

Check for materials with same Long/Short Description

Check Old Material Number field

Check Materials with same EAN

Check Materials with same Manufacturer Part Number

Check Source List/PIR for identical set ups

Check BOMs for identical components

Where duplicates found, check if either has no activity


PF2/WP2



Conversion Process

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


Data Privacy and Sensitivity


Extraction

Extract data from a source into . There are 2 possibilities:

  1. The data exists. connects to the source and loads the data into . There are 3 methods:
    1. Perform full data extraction from relevant tables in the source system(s).
    2. Perform extraction through the application layer.
    3. Only if ; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
  2. The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in . This is to be conducted using DCT (Data Collection Template) in

The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible
1Extract 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
2Validate 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
3Apply exclusion criteria (e.g., deletion flags, obsolete status, test materials, invalid UoM, invalid descriptions).SyWay Data Team
4Include recent transactional linkage (e.g., materials used in open PO, SO, or movements within last 3 years).SyWay Data Team
5Validate UoM conversions and ensure all Base Units (MEINS) exist in T006 (UoM ISO mapping).SyWay Data Team
6Generate Google Sheet report pre-populated with PF2 and WP2 extracted data for Business validation (showing only relevant fields from MDS_2019).SyWay Data Team
7Submit 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 ScreenParameter NameSelection TypeRequirementValue to be entered/set





















Data Collection Template (DCT)


Service Master


SAP StructureSAP FieldTypeLengthField DescriptionImportance
MARA - General Material Master Data (client-level basic material data)
S_MARAMATERIALText80Material Numbermandatory for sheetProduct Number*

A key that uniquely identifies the product.
S_MARAMTARTText80    Product Typemandatory for sheetProduct Type*

Key that assigns the product to a group of products such as raw product, finished product or trading goods.
S_MARAATTYPText80    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.
S_MARASATNRText80    Configuration Product for Retail Variant
Configuration Product for Retail Variant

Key uniquely identifying a generic product to which the variant is linked.
S_MARAMATKLText80    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.
S_MARAMBRSHText80    Industry Sector
Industry Sector

Key that specifies the branch of industry to which the product is assigned.
S_MARAMAKTXText40    Descriptionmandatory for sheetDescription*

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).
S_MARASPRASText80    Language Keymandatory for sheetLanguage Key*

Please provide the language for the product description.
S_MARAMEINSText80    Base Unit of Measure (ISO Format)mandatory for sheetBase 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'.
S_MARAAENNRText80    Change Number
Change Number

Number used to uniquely identify a change master record.
S_MARAREVLVText80    Revision Level
Revision Level

Indicates a product or document's change status in addition to the change number.
S_MARAEAN11Text18    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.
S_MARANUMTPText80    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.
S_MARASPARTText80    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.
S_MARABISMTText40    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.
S_MARAPRDHAText80    Product Hierarchy
Product Hierarchy

Alphanumeric character string for grouping together products by combining different characteristics. It is used for analyses and price determination.
S_MARABRAND_IDText80    Brand
Brand

Where applicable specify the manufacturer brand or private label of the product.
S_MARAXCHPFText1     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'.
S_MARAMLGUTText1     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.
S_MARADATABDate
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.\
S_MARALIQDTDate
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.)
S_MARAKUNNRText80    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.
S_MARANORMTText18    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.
S_MARAGROESText32    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.
S_MARALABORText80    Laboratory / Design Office
Laboratory / Design Office

Key for the design office, laboratory, or laboratory worker responsible.
S_MARAINHALNumber13    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.
S_MARAINHMEText80    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.
S_MARAINHBRNumber13    Gross Contens
Gross Contens

Specify the gross contents for the base unit of measure for the product.
S_MARAVPREHNumber5     Comparison Price Unit
Comparison Price Unit

Number of units of measure in the content unit to which the comparison price relates.
S_MARAEXTWGText80    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.
S_MARAMTPOS_MARAText80    General Item Category Group
General Item Category Group

Products grouping that helps the system to determine item categories during sales document processing.
S_MARABEGRUText4     Authorization Group
Authorization Group

The authorization group enables you protect access to certain objects.
S_MARAMSTAEText80    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.
S_MARAMSTDEDate
Valid-From Date
Valid-From Date

Date from which the cross-plant product status is valid.
S_MARASERLVText80    Level of Explicitness for Serial Number
Level of Explicitness for Serial Number

Level on which the serial number must be unique.
S_MARAQMPURText1     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.
S_MARAANIMAL_ORIGINText1     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.
S_MARAANPText80    ANP Code
ANP Code

For Brazil only !
Identifies the products that are controlled by the Brazilian Oil Agency.
S_MARABRGEWNumber13    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.
S_MARANTGEWNumber13    Net Weight
Net Weight

Net weight expressed in the unit of weight specified by you in the Unit of weight field.
S_MARAGEWEIText80    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.
S_MARALAENGNumber13    Length
Length

Length of the product or its packaging, measured in the unit of dimension.
S_MARABREITNumber13    Width
Width

Width of the product or its packaging, measured in the unit of dimension.
S_MARAHOEHENumber13    Height
Height

Height of the product or its packaging, measured in the unit of dimension.
S_MARAMEABMText80    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.
S_MARAVOLUMNumber13    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.
S_MARAVOLEHText80    Volume Unit
Volume Unit

If you specify a volume, you have to enter the corresponding volume unit here.
S_MARACAPAUSENumber15    Capacity Usage
Capacity Usage
S_MARACHML_CMPLNC_RLVNCE_INDText80    Compliance Relevant
Compliance Relevant

Indicates whether the product needs to be assessed for Compliance.
S_MARAKZKFGText1     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.
S_MARABSTMEText80    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.
S_MARAEKWSLText80    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.
S_MARAVABMEText80    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.
S_MARABMATNText80    Internal Product Number
Internal Product Number

Number of firm's own (internal) inventory-managed product.
S_MARAMFRPNText40    Manufacturer Part Number
Manufacturer Part Number

Specifies the number used by the manufacturer, or also by the supplier, to manage a product.
S_MARAMFRNRText80    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.
S_MARAMPROFText80    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.
S_MARATRAGRText80    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.
S_MARAMSTAVText80    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.
S_MARAMSTDVDate
Valid From Date for Status
Valid From Date for Status

Date from which the cross-distribution-chain product status is valid.\
S_MARAPMATAText80    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.
S_MARASPROFText80    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.
S_MARAALLOW_PMAT_IGNOText1     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.
S_MARASOM_CYCLEText80    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
S_MARASOM_CYCLE_RULEText80    Billing Cycle Determination Rule
Billing Cycle Determination Rule
S_MARASOM_TC_SCHEMAText80    Assignment Schema
Assignment Schema
S_MARABBTYPText80    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.
S_MARASERVVText80    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.
S_MARAMAGRVText80    Product Group: Packaging Materials
Product Group: Packaging Materials

Groups together products that require similar packaging products.
S_MARAVHIARTText80    Packaging Product Type
Packaging Product Type

Enter a code for a grouping of similar products, such as crates, trucks or pallets.
S_MARAERGEWNumber13    Allowed Packaging Weight
Allowed Packaging Weight

Maximum weight of other products that are packed in this packaging product.
S_MARAERGEIText80    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.
S_MARAGEWTONumber3     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.
S_MARAERVOLNumber13    Allowed Packaging Volume
Allowed Packaging Volume

Maximum volume of other products that are packed in this packaging product.
S_MARAERVOEText80    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.
S_MARAKZGVHText1     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.
S_MARAVOLTONumber3     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.
S_MARAIPRKZText80    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.
S_MARARAUBEText80    Storage Conditions
Storage Conditions

Indicates what storage conditions are required for the product.
S_MARATEMPBText80    Temperature Conditions Indicator
Temperature Conditions Indicator

Indicates the temperature conditions in which the product should be stored.
S_MARABEHVOText80    Container Requirements
Container Requirements

Key for the regulation that governs which type of container the product must be stored and shipped in.
S_MARASTOFFText40    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.
S_MARAETIARText80    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.
S_MARAETIFOText80    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.
S_MARAWESCHNumber13    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.
S_MARAXGCHPText1     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.
S_MARAMHDHBNumber4     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.
S_MARAMHDRZNumber4     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.
S_MARASLED_BBDText80    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.
S_MARAMHDLPNumber3     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).
S_MARARDMHDText80    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).
S_MARAHNDLCODEText80    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.
S_MARAWHMATGRText80    Warehouse Product Group
Warehouse Product Group

Groups products by warehousing points of view.
S_MARAWHSTCText80    Warehouse Storage Condition
Warehouse Storage Condition

Describes the storage condition that should be used to store the product.
S_MARAHUTYP_DFLTText80    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.
S_MARASERIALText80    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.
S_MARAPILFERABLEText1     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.
S_MARAHAZMATText1     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.
S_MARAQQTIMENumber3     Quarantine Period
Quarantine Period
S_MARAQQTIMEUOMText80    Time Unit for Quarantine Period
Time Unit for Quarantine Period
S_MARAQGRPText80    Quality Inspection Group
Quality Inspection Group
S_MARAHUTYPText80    Handling Unit Type
Handling Unit Type

Specifies the HU type of the packaging product used for creating handling units.
S_MARAMAXCNumber15    Maximum Capacity
Maximum Capacity

Maximum allowed capacity of packaging product.
S_MARAMAXC_TOLNumber3     Overcapacity Tolerance
Overcapacity Tolerance

Defines the tolerance limit for the maximum packaging capacity of a packaging product.
S_MARATARE_VARText1     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.
S_MARAMAXLNumber15    Max. Pack. Length
Max. Pack. Length

Maximum packing length of packaging product.
S_MARAMAXDIM_UOMText80    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
S_MARAMAXBNumber15    Max. Pack. Width
Max. Pack. Width

Maximum packing width of packaging product.
S_MARAMAXHNumber15    Max. Pack. Height
Max. Pack. Height

Maximum packing height of packaging product.
S_MARARBNRMText80    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.
S_MARASSTUFText80    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.
S_MARALSTVZText80    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.
S_MARALDVZLDate
Listing Period Start Date
Listing Period Start Date

Date from which the product is listed in the distribution center.
S_MARALDBZLDate
Listing Period End Date
Listing Period End Date

Date to which the product is listed in the distribution center.
S_MARALSTFLText80    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.
S_MARALDVFLDate
Listing Period Start Date
Listing Period Start Date

Date from which the product is listed in the stores.
S_MARALDBFLDate
Listing Period End Date
Listing Period End Date

Date to which the product is listed in the stores.
S_MARAVDVZLDate
Sales Period Start Date
Sales Period Start Date

Date from which the product is sold in the distribution center.
S_MARAVDBZLDate
Sales Period End Date
Sales Period End Date

Date to which the product is sold in the distribution center.
S_MARAVDVFLDate
Sales Period Start Date
Sales Period Start Date

Date from which the product is sold in the stores.
S_MARAVDBFLDate
Sales Period End Date
Sales Period End Date

Date to which the product is sold in the stores.
S_MARAWAUSMText80    Delivery Unit of Measure (ISO Format)
Delivery Unit of Measure (ISO Format)

Unit in which the product is issued from the warehouse.
S_MARAWVRKMText80    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.
S_MARAWMAABText80    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.
S_MARAWBKLAText80    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.
S_MARAWHERLText80    Country/Region of Origin
Country/Region of Origin

Country/Region in which the product has been produced.
S_MARAWHERRText80    Region of Origin
Region of Origin

Region of Origin of the product.
S_MARAWEKGRText80    Purchasing Group
Purchasing Group

Key for a buyer or a group of buyers responsible for the procurement of the product.
S_MARABWSCLText80    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.
S_MARATAKLVText80    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).
S_MARAWLADGText80    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).
S_MARAWBWSPNumber6     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
S_MARAPSTATQText1     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.
S_MARAPSTATVText1     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.
S_MARAPSTATLText1     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.
S_MARAPSTATEText1     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 StructureSAP FieldTypeLengthField DescriptionImportance
MAKT - Material Descriptions (short/long material text per language)
S_MAKTMATERIALText80Material Numbermandatory for sheetProduct Number*

A key that uniquely identifies the product.
S_MAKTSPRASText80    Language Keymandatory for sheetLanguage 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.
S_MAKTMAKTXText40    Product Descriptionmandatory for sheetProduct 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).


SAP StructureSAP FieldTypeLengthField DescriptionImportance
MARM - Material Units of Measure (UoM and conversion factors)
S_MARMMATERIALText80Material Numbermandatory for sheetProduct Number*

A key that uniquely identifies the product.
S_MARMMEINHText80    Alternative Unit of Measure (ISO Format)mandatory for sheetAlternative Unit of Measure (ISO Format)*

Provide only Alternative Unit of Measures (please provide the Base Unit of Measure only on sheet 'Basic Data').
S_MARMUMRENNumber5     Denominator for Conversion to Base Unitmandatory for sheetDenominator for Conversion to Base Unit*

Enter the number of units of the alternative unit of measure (denominator) that corresponds to the number of units of the base unit of measure (numerator).
The alternative unit of measure is kilogram (kg). The base unit of measure is piece (PC). 5 kg correspond to 3 pieces.
5 kg = 3 PC => 1 kg = 3/5 PC
In this case, the quotient is therefore 3/5 (the numerator being 3 and the denominator 5).
S_MARMUMREZNumber5     Numerator for Conversion to Base Unitmandatory for sheetNumerator for Conversion to Base Unit*

Enter the number of units of the alternative unit of measure (denominator) that corresponds to the number of units of the base unit of measure (numerator).
The alternative unit of measure is kilogram (kg). The base unit of measure is piece (PC). 5 kg correspond to 3 pieces.
5 kg = 3 PC => 1 kg = 3/5 PC
In this case, the quotient is therefore 3/5 (the numerator being 3 and the denominator 5).
S_MARMEAN11Text18    GTIN
GTIN

Note: if you have additional EAN's for this unit please enter them on the Additional EAN sheet. The EAN entered here is always the Main EAN for this unit.
S_MARMNUMTPText80    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.
S_MARMLAENGNumber13    Length
Length

Length of the product or its packaging, measured in the unit of dimension for the alternative unit of measure.
S_MARMBREITNumber13    Width
Width

Width of the product or its packaging, measured in the unit of dimension for the alternative unit of measure.
S_MARMHOEHENumber13    Height
Height

Height of the product or its packaging, measured in the unit of dimension for the alternative unit of measure.
S_MARMMEABMText80    Unit for Length/Width/Height(ISO Format)
Unit for Length/Width/Height(ISO Format)

Unit in which the dimensions of length, width, and height of a product or its packaging for the alternative unit of measure are measured.
S_MARMBRGEWNumber13    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.
S_MARMGEWEIText80    Unit of Weight (ISO Format)
Unit of Weight (ISO Format)

Unit referring to the gross weight of the alternative unit of measure.
S_MARMVOLUMNumber13    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 alternative unit of measure.
S_MARMVOLEHText80    Volume Unit (ISO Format)
Volume Unit (ISO Format)

If you specify a volume, you have to enter the corresponding volume unit here.
S_MARMCAPAUSENumber15    Capacity Usage
Capacity Usage

The capacity usage of a product refers to the product quantity and is therefore specified as a variable in the system. It represents the consumption of a product in relation to the capacity.


SAP StructureSAP FieldTypeLengthField DescriptionImportance
MEAN - International Article Numbers (EAN/UPC) for Materials
S_MEANMATERIALText80Material Numbermandatory for sheetProduct Number*

A key that uniquely identifies the product.
S_MEANMEINHText80    Alternative Unit of Measure (ISO Format)mandatory for sheetAlternative Unit of Measure (ISO Format)*

Provide the Alternative Unit of Measures for the additional GTIN.
S_MEANEAN11Text18    GTIN
GTIN

Note: the GTIN for the additional units is always not flagged as main GTIN. The main GTIN has to be filled on basic data sheet for the Base unit of measure and on sheet Alternative unit of measure for the alternative unit of measure.
With internal number assignment, you enter the GTIN category but not a GTIN.
S_MEANEANTPText80    GTIN Category
GTIN Category

Defines how the system determines an International Article Number (EAN) to be assigned internally, and which check criteria (check digit, prefix, and so on) an EAN of this category must fulfil.



Extraction Dependencies

Item #Step DescriptionTeam Responsible

1

Data cleansing of legacy Material data must be completed.
If standardization within the DCT begins using relevant data from PF2 and WP2 before the cleansing is finalized, it is understood that the business will take due diligence to ensure any subsequent delta cleansing is verified and aligned within the DCT.

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:

  1. Perform value mapping and data transformation rules.
    1. Legacy values are mapped to the to-be values (this could include a default value)
    2. Values are transformed according to the rules defined in
  2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

Transformation Run Sheet

Item #Step DescriptionTeam Responsible

1

Obtain DCT Sign-off from Business

SyWay S2P Data Team

2

<Add steps from Syniti Migrate here>

SyWay S2P Data Team

3

Review and Validate Error and Preload Reports

SyWay S2P Data Team

4

Generate Load Files

SyWay S2P Data Team


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2/WQ2S_MARAMATNRMaterial NumberS/4HANAS_MARAMATNRMaterial NumberGenerate new Material number in Target System and maintain mapping in reference table
2PF2/WQ2S_MARAMBRSHIndustry SectorS/4HANAS_MARAMBRSHIndustry SectorCopy from source to target system
3PF2/WQ2S_MARAMTARTMaterial TypeS/4HANAS_MARAMTARTMaterial TypeMap from source to target using Material Type mapping table
4PF2/WQ2S_MARAMAKTXDescriptionS/4HANAS_MARAMAKTXDescriptionCopy from source to target system in adherence to S4H Data Standard (ie. descriptions to be cleansed so that non standard special characters are excluded)
5PF2/WQ2S_MARASPRASLanguage KeyS/4HANAS_MARASPRASLanguage KeyEN description to be created if not available. Copy local descriptions from source if required.
6PF2/WQ2S_MARAMEINSBase Unit of Measure (ISO Format)S/4HANAS_MARAMEINSBase Unit of Measure (ISO Format)Map from source to target in adherence to S4H Data Standard
7PF2/WQ2S_MARAMATKLMaterial GroupS/4HANAS_MARAMATKLMaterial GroupMap from source to target using Material Group mapping table
8PF2/WQ2S_MARASPARTDivisionS/4HANAS_MARASPARTDivisionMap from source to target in adherence to S4H Data Standard
9PF2/WQ2S_MARAPRDHAProduct HierarchyS/4HANAS_MARAPRDHAProduct HierarchyMap from source to target using Product Hierarchy mapping table
10PF2/WQ2S_MARAMTPOS_MARAGeneral Item Category GroupS/4HANAS_MARAMTPOS_MARAGeneral Item Category GroupCopy from source to target system
11PF2/WQ2S_MARABRGEWGross WeightS/4HANAS_MARABRGEWGross WeightCopy from source to target system
12PF2/WQ2S_MARANTGEWNet WeightS/4HANAS_MARANTGEWNet WeightCopy from source to target system
13PF2/WQ2S_MARAGEWEIUnit of Weight (ISO Format)S/4HANAS_MARAGEWEIUnit of Weight (ISO Format)Copy from source to target system in adherence to S4H Data Standard
14PF2/WQ2S_MARAPROFLDG Indicator ProfileS/4HANAS_MARA
Compliance Relevant IndicatorIf DG Ind Profile or Environmentally Rel is populated/ticked then set Compliance Relevant Indicator to X in S4H
15PF2/WQ2S_MARAKZUMWEnvironmentally RelevantS/4HANAS_MARA
Compliance Relevant IndicatorIf DG Ind Profile or Environmentally Rel is populated/ticked then set Compliance Relevant Indicator to X in S4H


Transformation Mapping

Mapping Table NameMapping 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 HierarchyMapping of legacy Product Hierarchies to target system value
Lab/OfficeMapping of legacy Lab/Office values to target system value
DivisionMapping of legacy Division values to target system value
Authorization GroupMapping of legacy Authorization Group values to target system value

Transformation Dependencies

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

1

Ensure DCT tables completeness

SyWay S2P Data Team

2

Value Mappings are according to the latest design - <List of Value Mappings>

SyWay S2P Data Team








Pre-Load Validation

Project Team

Completeness

TaskAction

Verify Record Count

SyWay S2P Data Team to verify that the total number of relevant records from the  DCT is equal to the total number of records in the Preload and Load Sheets.






Accuracy

TaskAction

Conversion Accuracy

SyWay S2P Data Team to verify that all fields below meet pass the checks:

  1. Mandatory Fields
  2. Field and Value Mapping Correctness
  3. Null Checks
  4. Text Length 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.




Business

Completeness

TaskAction

Verify Record Count

Business Data Owner/s to verify that the total number of relevant records from the the DCT is equal to the total number of records in the Preload and Load Sheets.






Accuracy

TaskAction

Conversion Accuracy

Business Data Owner/s to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules (and signed-off DCT data).






Load

The load process includes:

  1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
  2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation


The load process encompasses all activities required to transfer transformed data into the target SAP S/4HANA system.

The process includes the following steps:

  • Data Load Execution: Execute the automated data load into the target system using the approved load tool (e.g., Migration Cockpiti). If automation is not possible, perform a controlled manual upload using the provided load file,
  • Loading Method and Sequence: Define and document the loading method (e.g., Direct Input, BAPI, IDoc, Web Service, or OData API) and ensure that the load sequence or dependency between related objects is clearly established,
  • Error Handling: Include error-handling requirements, specifying alerting mechanisms and the expected corrective actions in case of load failures or inconsistencies.


Extraction/Transformation Methods and File Types

Data is extracted and transformed using Syniti ADM, and the staging area of Migration Cockpit staging area will be updated accordingly.

Load Run Sheet

Item #Step DescriptionTeam Responsible

1

Go to <Load Tool>

SyWay S2P Data Team

2

Load 3 records for < > to validate if data is loaded successfully without errors

SyWay S2P Data Team

3

Load 3 records for < > to validate if data is loaded successfully without errors

SyWay S2P Data Team

4

Proceed with full load if steps 2 and 3 are validated

SyWay S2P Data Team

5

Validate few records loaded by accessing standard transactions from S/4HNA eg. MM03

SyWay S2P Data Team

6

Generate post load report if step 5 is validated

SyWay S2P Data Team


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 TypeError DescriptionAction Taken










Post-Load Validation

Project Team

Completeness

TaskAction

Verify Count

SyWay S2P Data Team to verify the record count created in target S/4 HANA by accessing post load reports in dspMigrate or standard reports from S/4 HANA.






Accuracy

TaskAction

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

TaskAction

Verify Count

Download Post Load Reports from dspMigrate and verify that the record count loaded in the target S/4 HANA is the same count as of the endorsed load file.






Accuracy

TaskAction

Conversion Accuracy

Verify that the Material data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA.






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

Version Published Changed By Comment
CURRENT (v. 122) Apr 29, 2026 14:44 HANCOCK-ext, John
v. 313 Apr 28, 2026 13:55 HANCOCK-ext, John
v. 312 Apr 27, 2026 07:42 HANCOCK-ext, John
v. 311 Apr 21, 2026 08:04 HANCOCK-ext, John
v. 310 Apr 21, 2026 08:01 HANCOCK-ext, John
v. 309 Apr 21, 2026 07:51 HANCOCK-ext, John
v. 308 Apr 10, 2026 12:02 HANCOCK-ext, John
v. 307 Apr 09, 2026 14:07 HANCOCK-ext, John
v. 306 Mar 06, 2026 13:37 MADHOK-ext, Jasleen
v. 305 Mar 03, 2026 17:15 HANCOCK-ext, John

Go to Page History

Workflow history

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

  • No labels