Status

Owner
StakeholdersThe business stakeholders involved in making, reviewing, and endorsing this decision. Type @ to mention people by name

Purpose

The purpose of this conversion is to migrate and create Extended Warehouse Management (EWM) Product Master data in the S/4HANA EWM environment.

The EWM Product Master is an extension of the Material Master, providing warehouse-specific attributes that enable and control warehouse functionality and processes such as putaway, stock removal, replenishment, and physical inventory.

This conversion ensures that each product (material) within the warehouse has a corresponding EWM product master record, containing all relevant attributes aligned with the warehouse organization structure.

MDS DD-FUN-050 Master Data Standard_1060-EWM Product Master - Google Sheets



Conversion Scope

The scope of this conversion includes the creation of EWM Product Master data in S/4HANA, derived from existing Material Master and WM-related configuration and data in the legacy ECC system.

Because legacy EWM Product Master data does not exist, the conversion is not a one-to-one migration but rather a data derivation and enrichment process. The data will be constructed based on material master attributes and warehouse-specific logic defined during EWM design.

In Scope

  • Creation of EWM Product Master records for all materials that are in scope for warehouse operations in S/4HANA.

  • Population of key EWM product attributes including:

    • Warehouse Number

    • Putaway and Stock Removal Control Indicators

    • Storage Type Indicators

    • Handling Unit Type Assignments (where relevant)

    • Consolidation Group and Availability Group

    • Packaging Data and Unit of Measure Information

    • Product Grouping for Replenishment or Slotting (if applicable)

  • Alignment of EWM Product Master data with S/4HANA Material Master and EWM design configurations.

  • Upload of EWM Product Master data via standard EWM transaction /SCWM/MIG_PRODUCT 

Out of Scope

  • Non-warehouse relevant materials.


Additional Information

Multi-language Requirement

N/A

Document Management

N/A

Legal Requirement

N/A

Special Requirements

N/A




Target Design

The technical design of the target for this conversion approach.

IndexTechnical Table-FieldField LabelDescriptionField FormatAllowed Values / ReferenceConditional LogicMulti-language Field RequirementsComments / Special Handling NotesRequirement (R/O/C/S/NU)Data Type & Length
1/SAPAPO/MATLWH-MATIDProduct IDProduct identifier within EWMCHAR(22)NoneNoneNoneDerived from MARA-MATNRRData type : CHAR
Length : 22
2/SAPAPO/MATLWH-ENTITLED_IDParty Entitled to DisposeParty responsible for stock ownershipRAW(16)NoneNoneNoneLinked to business partner dataRData type : RAW
Length : 16
4/SAPAPO/MATLWH-PTDETINDProcess Type Determination IndicatorControls process type determination for productCHAR(2)/SCWM/TPTDETIND-PTDETINDNoneNoneDrives task creation behaviorCData type : CHAR
Length : 2
5/SAPAPO/MATLWH-CCINDCycle Counting IndicatorDefines product classification for inventory countingCHAR(1)MARC-ABCINNoneNoneMaps ABC indicator to EWMCData type : CHAR
Length : 1
6/SAPAPO/MATLWH-PUT_STRAPutaway Control IndicatorControls product putaway strategyCHAR(4)/SCWM/T305Q-PUT_STRANoneNoneRequired for inbound processingRData type : CHAR
Length : 4
7/SAPAPO/MATLWH-LGBKZStorage Section IndicatorDefines section search strategyCHAR(4)/SCWM/T304-LGBKZNoneNoneUsed for bin search logicCData type : CHAR
Length : 4
8/SAPAPO/MATLWH-LPTYPStorage Bin TypeDefines type/classification of storage binCHAR(4)/SCWM/T303-LPTYPNoneNoneImpacts putaway and removal rulesCData type : CHAR
Length : 4
9/SAPAPO/MATLWH-BLOCKBulk Storage IndicatorControls bulk storage putawayCHAR(2)/SCWM/T338-BLOCKNoneNoneUsed for bulk materialsCData type : CHAR
Length : 2
10/SAPAPO/MATLWH-REM_STRAStock Removal ControlControls stock removal strategyCHAR(4)/SCWM/T305R-REM_STRANoneNoneRequired for picking logicRData type : CHAR
Length : 4
11/SAPAPO/MATLWH-STCKDETGRStock Determination GroupDetermines stock group for pickingCHAR(2)/SCWM/V_STCKDTGR-STCKDETGRNoneNoneUsed for batch-managed materialsCData type : CHAR
Length : 2
12/SAPAPO/MATLWH-DRDETGRStaging Area Determination GroupDefines staging area determinationCHAR(4)/SCWM/TDRDETGR-DRDETGRNoneNoneUsed for outbound stagingCData type : CHAR
Length : 4
13/SAPAPO/MATLWHST-LGTYTPStorage TypeStorage space within warehouseCHAR(4)/SCWM/T331-LGTYPNoneNoneLevel-specific configurationCData type : CHAR
Length : 4
14/SAPAPO/MATLWHST-SECTINDSection IndicatorSection indicator at storage type levelCHAR(4)/SCWM/T304-LGBKZNoneNoneUsed for fine-tuning putawayCData type : CHAR
Length : 4
15/SAPAPO/MATLWHST-BINTYPEBin TypeBin type assignment for productCHAR(4)/SCWM/T303-LPTYPNoneNoneImpacts replenishment logicCData type : CHAR
Length : 4
16/SAPAPO/MATLWHST-REPQTY_DSPMinimum Replenishment QtyMinimum quantity for replenishment triggerQUAN(15)NoneNoneNoneMaintained based on planning dataCData type : QUAN
Length : 15
17/SAPAPO/MATLWHST-REPQTY_UOM_DSPDisplay UoM for Replenishment QtyUnit of measure for replenishment quantityUNIT(3)MEINSNoneNoneUoM from material masterCData type : UNIT
Length : 3
18/SAPAPO/MATLWHST-MINQTY_DSPMinimum QtyMinimum stock level in storage typeQUAN(15)NoneNoneNoneUsed for replenishment logicCData type : QUAN
Length : 15
19/SAPAPO/MATLWHST-MINQTY_UOM_DSPDisplay UoM for Minimum QtyUoM for minimum stockUNIT(3)MEINSNoneNoneDerived from base UoMCData type : UNIT
Length : 3
20/SAPAPO/MATLWHST-MAXQTY_DSPMaximum QtyMaximum allowed stock in storage typeQUAN(15)NoneNoneNoneUsed for replenishment ceilingCData type : QUAN
Length : 15
21/SAPAPO/MATLWHST-MAXQTY_UOM_DSPDisplay UoM for Maximum QtyUoM for maximum stockUNIT(3)MEINSNoneNoneDerived from base UoMCData type : UNIT
Length : 3
22/SAPAPO/MATLWHST-QUANCLAQuantity ClassificationClassification for stock quantityCHAR(1)/SCWM/TQUANCLA-QUANCLANoneNoneUsed for volume optimizationCData type : CHAR
Length : 1
23/SAPAPO/MATLWHST-QUANCLAPUTQuantity Classification (Putaway)Classification for putaway quantityCHAR(1)/SCWM/TQUANCLA-QUANCLANoneNoneImpacts putaway bin searchCData type : CHAR
Length : 1


Data Cleansing

The EWM Product Master data is being newly created as part of the S/4HANA EWM deployment. Since the legacy system (WM) does not contain equivalent warehouse-level product data, there is no direct source data to cleanse.



Conversion Process

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



The EWM Product Master will be created through a Data Collection Template (DCT)–based approach. Since no equivalent data exists in the legacy WM system, all records will be newly derived using material master data, EWM configuration, and approved mapping logic.

Process Steps

  1. Data Collection (DCT Preparation)

    • Populate the DCT with all fields defined in the target design.

    • Each record represents a combination of Product, Warehouse, and Party Entitled to Dispose.

  2. Transformation & Value Mapping

    • Apply transformation logic to derive warehouse-specific attributes

  3. Load to Target System

    • Load the validated DCT using standard transaction /SCWM/MIG_PRODUCT.

    • The load will create EWM product master records for each product–warehouse–party combination.

    • Post-load validation will be performed using transaction /SCWM/MAT1 to confirm completeness and accuracy.

Data Privacy and Sensitivity

N/A


Extraction

N/A


Data Collection Template (DCT)

Target Ready Data Collection Template will be created for Data Object data with exception of some fields which require transformation as mentioned in the transformation rule.

The Data Collection Template (DCT) for the Product Master conversion applies to the standard migration object MIG-PRODUCT.
This object supports the upload of product master data into SAP EWM through the standard load process.

The MIG-PRODUCT DCT contains all fields required by the standard transaction. While the full set of columns must be maintained in the file for technical compatibility, only the fields identified in the target design are required to be populated with business data.

The table below maps these mandatory target design fields to their respective DCT column identifiers and provides the corresponding technical field descriptions. All other columns within the DCT are considered optional or out of scope and should remain blank unless explicitly required for load completeness or validation.

DCT Load File : DCT Product Master.csv


ColumnDCT Field NameField DescriptionTarget Design FieldMandatory (Y/N)
AEWM_LGNUMWarehouse numberWarehouse numberY
BEWM_PRODNOProduct numberProduct IDY
CEWM_ENTITLEDParty entitled to disposeParty Entitled to DisposeY
DPROCPRFL--N
EPTDETINDProcess type determination indicatorProcess Type Determination IndicatorY
FWRKLDGRN
GDRDETGRStaging area determination groupStaging Area Determination GroupY
HVASVCPN
ISLRQ_MINN
JPUT_STRAPut away control indicatorPutaway Control IndicatorY
KPUT_STRA_FIXN
LPUT_STRA_PLANN
MLGBKZStorage section indicatorStorage section indicatorY
NLPTYPStorage Bin TypeStorage TypeY
OBLOCKN
PREM_STRAStock removal control indicatorStock Removal ControlY
QREM_STRA_FIXN
RREM_STRA_PLANN
SSTCKDETGRStock determination groupStock Determination GroupY
TL2SKRN
UDEMQTYN
VDEMQTY_FIXN
WNOSOIN
XNOSOI_FIXN
YRSQTYN
ZRSQTY_FIXN
AADEMTYPN
ABCONCSTATN
ACLASTSLOTN
ADWGHTINDN
AEWGHTIND_FIXN
AFVOLINDN
AGVOLIND_FIXN
AHLGTHINDN
AILGTHIND_FIXN
AJWDTHINDN
AKWDTHIND_FIXN
ALHGHTINDN
AMHGHTIND_FIXN
ANCCINDCycle counting indicatorCycle Counting IndicatorY
AOCCIND_FIXN
APDOCBATCHN
AQBACKFLUSH_PRODN
ARKIT_FIXED_QUANN
ASMEDI_APROF_WHN
ATQUANCLA_MERCHN
AUPUOM_WHN
AVKZZULN
AWRATIODIMN
AXQGRP_WHN
AYEWM_LGTYPStorage typeStorage TypeY
AZFIXBINN
BASECTINDStorage section indicatorStorage Section IndicatorY
BBSECTIND_FIXN
BCSECTIND_PLANSection indicator (planned)Section IndicatorY
BDBINTYPEBin typeBin TypeY
BEBINTYPE_FIXN
BFBINTYPE_PLANBin type (planned)Bin TypeY
BGMAXFIXBINN
BHMAXFIXBIN_FIXN
BIMAXFIXBIN_PLANN
BJMAXQTYMaximum quantityMaximum QtyY
BKMAXQTY_PLANN
BLMAXQTY_UOM_DSPDisplay UoM for maximum quantityDisplay Unit of Measure for Maximum QtyY
BMMINQTYMinimum replenishment quantityMinimum Replenishment QtyY
BNMINQTY_PLANMinimum quantityMinimum QtyY
BOMINQTY_UOM_DSPDisplay UoM for minimum quantityDisplay Unit of Measure for Minimum QtyY
BPREPQTYReplenishment quantityMinimum Replenishment QtyY
BQREPQTY_PLANN
BRREPQTY_UOM_DSPDisplay UoM for replenishment quantityDisplay Unit of Measure for Replenishment QtyY
BSRMMQTY_FIXN
BTPERMXQTYN
BUSPLITTHN
BVSPLITPUTN
BWNORPLNN
BXBINSRCHN
BYQUANCLAQuantity classificationQuantity ClassificationY
BZQUANCLAPUTQuantity classification for putawayQuantity Classification for PutawayY
CASEQPUTN
CBSEQPUT_FIXN
CCSEQPUT_PLANN
CDSKIPPTWN
CESKIPPTW_FIXN
CFSKIPPTW_PLANN

Extraction Dependencies

N/A


Transformation

The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow Syniti Migrate to make the data Target ready:

  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 Syniti Migrate
  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


All EWM Product Master fields are directly mapped from the Data Collection Template (DCT) to the target EWM tables.
No transformation, enrichment, or lookup logic is applied.
Each field below is a direct copy from the corresponding column in the DCT.


Transformation Rules


Source (DCT Field)Target Field (Technical Name)Field Label / DescriptionTransformation Logic
EWM_PRODNO/SAPAPO/MATLWH-MATIDProduct IDCopy
EWM_ENTITLED/SAPAPO/MATLWH-ENTITLED_IDParty Entitled to DisposeCopy
WRKLDGR/SAPAPO/MATLWH-SCUGUIDSupply Chain UnitCopy
PTDETIND/SAPAPO/MATLWH-PTDETINDProcess Type Determination IndicatorN/A
CCIND/SAPAPO/MATLWH-CCINDCycle Counting IndicatorCopy
PUT_STRA/SAPAPO/MATLWH-PUT_STRAPutaway Control IndicatorCopy
LGBKZ/SAPAPO/MATLWH-LGBKZStorage Section IndicatorCopy
LPTYP/SAPAPO/MATLWH-LPTYPStorage Bin TypeCopy
BLOCK/SAPAPO/MATLWH-BLOCKBulk Storage IndicatorCopy
REM_STRA/SAPAPO/MATLWH-REM_STRAStock Removal ControlCopy
STCKDETGR/SAPAPO/MATLWH-STCKDETGRStock Determination GroupCopy
DRDETGR/SAPAPO/MATLWH-DRDETGRStaging Area Determination GroupCopy
EWM_LGTYP/SAPAPO/MATLWHST-LGTYTPStorage TypeCopy
SECTIND/SAPAPO/MATLWHST-SECTINDSection IndicatorCopy
BINTYPE/SAPAPO/MATLWHST-BINTYPEBin TypeCopy
REPQTY/SAPAPO/MATLWHST-REPQTY_DSPMinimum Replenishment QuantityCopy
REPQTY_UOM_DSP/SAPAPO/MATLWHST-REPQTY_UOM_DSPDisplay Unit of Measure for Replenishment QtyCopy
MINQTY/SAPAPO/MATLWHST-MINQTY_DSPMinimum QuantityCopy
MINQTY_UOM_DSP/SAPAPO/MATLWHST-MINQTY_UOM_DSPDisplay Unit of Measure for Minimum QtyCopy
MAXQTY/SAPAPO/MATLWHST-MAXQTY_DSPMaximum QuantityCopy
MAXQTY_UOM_DSP/SAPAPO/MATLWHST-MAXQTY_UOM_DSPDisplay Unit of Measure for Maximum QtyCopy
QUANCLA/SAPAPO/MATLWHST-QUANCLAQuantity ClassificationCopy
QUANCLAPUT/SAPAPO/MATLWHST-QUANCLAPUTQuantity Classification for PutawayCopy

Transformation Dependencies

List the steps that need to occur before transformation can commence


Item #Step DescriptionTeam Responsible
1Capture the data for packaging specifications in DCT. Review and correct any errors if bulk uploading data via downloaded excel DCT template.Business team
2Ensure the mapping tables which are needed during transformation have been reviewed and signed off by business.Business team, Data Team (SCM)
3Obtain DCT Sign-off from BusinessData Team (SCM)
4Generate Pre-Load reports Data Team (Syniti)
5Review and Validate Error and Preload ReportsData Team (SCM)
6Log errors as defects, if any and address resolutions. Data Team (SCM)
7Re-transform and re-validate the Pre-load reports if necessary.Data Team (SCM), Data Team (Syniti)
8Obtain preload validation sign-off from BusinessBusiness + Functional (SCM) + Data Team (SCM)
9Generate Load FilesData Team (Syniti)




Pre-Load Validation

Project Team

The following pre-load validations will be performed by the Project Team.

Completeness

TaskAction
Check ValuesValidate the pre-load data confirming the values are aligned with target system format
Validate template structure and required field populationEnsure mandatory fields are filled
Verify Record CountSCM 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

SCM 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
Perform format validation (date, currency, decimal separators)Standardize format to match SAP accepted input (e.g., YYYYMMDD for dates), cubic volume, weight etc
Review Error ReportsReview 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.
Conduct dry runs using LTMC or BAPIs and review logsAnalyze load results and correct format or conversion errors


Business

The following pre-load validations will be performed by the business.

Completeness


TaskAction
Verify Record CountBusiness 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 validation file.






Accuracy


TaskAction
Conversion Accuracy

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

Review error reports in tool for any mismatch or missing transformed values.


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

Load Run Sheet


StepActivityResponsible Team
1Ensure the load tools (e.g., conversion templates, migration objects) are transported into the correct system/instance.Data Team (SCM)
2Ensure Pre-load sign-offs are obtained from relevant stakeholders.Data Team (SCM)
3Execute upload of the DCT directly using standard transaction /SCWM/MIG_ProductData Team (SCM)
4Validate a few records by accessing standard S/4HANA transactions to ensure data accuracy.Data Team (SCM)
5Generate post-load reports from the tool to confirm successful uploads.Data Team (SCM), Data Team (Syniti)
6Log any errors as defects; address and resolve issues. Close defects after resolution.Data Team (SCM)
7If defects were corrected, re-upload the affected data and regenerate post-load reports as required.Data Team (SCM), Data Team (Syniti)
8Business team to validate post-load files, raise data defects if any, or provide post-load sign-off.Business Team
9Repeat post-load report generation and defect resolution (Steps 5–7) if necessary.Data Team (SCM), Data Team (Syniti)


Load Phase and Dependencies

Identify the phase as to “when” the load for this object will occur. <Pre-Cutover, Cutover, Post Cutover> and list the steps that need to occur before the load can commence

Configuration

Conversion Objects


Error Handling

The table below depicts some possible system errors for this data object during data load. All data load error is to be logged as defect and managed within the Defect Management


Error TypeDescriptionProbable CauseSuggested Resolution
Configuration ErrorInvalid or missing EWM configuration required for product master uploadRequired configuration (e.g., Supply Chain Unit, Storage Type, Bin Type, Stock Determination Groups) missing or inactive in target systemEnsure all prerequisite configuration exists and is active in the target system
Formatting ErrorKey fields such as Product ID, Party Entitled to Dispose, Supply Chain Unit incorrectly formattedData in DCT does not match SAP field specifications (length, numeric vs. alphanumeric, UoM mismatch)Correct DCT formatting; verify units of measure, numeric fields, and field lengths against SAP master data
Authorization ErrorLack of access to execute MIG-PRODUCT load or modify product masterExecuting user lacks roles/authorizations in target clientAssign required SAP roles to executing user; validate access in target client
Transformation MissMandatory transformation logic not applied before loadAny required transformation missing (though for Product Master, mostly direct copy)Ensure all mandatory fields per target design are populated correctly; verify DCT field-to-field mapping
Technical Load FailureDCT file not processed due to syntax error or system issueSystem downtime, incorrect file encoding, missing headers, or temporary SAP errorVerify DCT integrity (CSV or Excel format), correct syntax issues, and re-execute upload; check logs of MIG-PRODUCT execution
Data InconsistencyMissing or invalid references in the DCTProduct IDs, PACI, Storage Types, SRCI etc., do not exist in target EWM/S/4HANAValidate that all master data exists in target system; correct DCT references
Duplicate EntryProduct ID already exists in target systemSame product uploaded previously or duplicate records in DCTRemove duplicates from DCT or adjust product entries before re-upload
Missing Mandatory FieldRequired DCT field not populatedMandatory fields such as Product ID, Party Entitled to Dispose, Supply Chain Unit, Putaway Control Indicator, Min/Max/Rep Qty, Quantity Classification are blankPopulate all mandatory fields per mapping table; validate before upload
Unit / Quantity ErrorsMin/Max quantities, replenishment qty, or unit of measure inconsistentIncorrect numeric values, inconsistent quantity/UoM, or invalid classificationVerify all quantity fields, units of measure, and classification codes; ensure consistency with target system


Post-Load Validation

Project Team

The following post-load validations will be performed by the Project Team.

Completeness


Run Fiori app/tcode to check loaded data in SAPRun /scwm/mat1 transaction to check if data has been loaded 
Compare uploaded data against source file valuesUse Custom reconciliation tools e.g. SQL Server or Excel based comparison tools to validate the number of records loaded against the load file record volume


Accuracy


TaskAction
Compare uploaded data against source file valuesUse automated postload validation report or standard reports from S/4 HANA to validate field by field value match across all loaded records

Business

The following post-load validations will be performed by the business.

Completeness


TaskAction
Verify CountDownload Postload validation reports from Syniti and verify that the record count loaded in the target S/4 HANA is the same count as of the endorsed load file
Review loaded Transportation lanesAccess the S/4HANA system to view loaded packaging specification

Accuracy


TaskAction
Compare Against Approved Load FileCross-check data in S/4HANA against the final business-approved load file used for migration
Validate Accuracy of Converted/Transformed DataReview any transformed fields (e.g., business partner number) for correctness
Log and Report DiscrepanciesUse provided discrepancy log format or defect management tool to report any findings


Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • EWM Product Master is in scope based on data design and any exception requested by business.
  • Data entries in DCT are target-ready data unless a specific transformation rule is stated for that field in the transformation rules.
  • The list of validation checks in transformation section is not exhaustive and may change over time as the design and configuration of the system evolves.

Any additional key assumptions.


See also

Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.

Change log

Workflow history