Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Status

Page Status

Owner

RAYUDUHASSAN-ext, Narasimha KumarShamir 

Stakeholders

Purpose

The purpose of this

document

specification is to define the

conversion approach to create EWM Storage Bin in S/4HANA.

The purpose of this document is to define the conversion approach to create EWM Storage Bins

Storage Bin in EWM is the smallest addressable unit within a warehouse where goods can be stored. Each storage bin is uniquely identified within the warehouse and can hold a specific quantity of materials.

end-to-end approach for migrating Storage Bin Master Data from the legacy SAP WM environment into S/4HANA Extended Warehouse Management (EWM).

Storage bins are critical to warehouse operations as they represent the smallest managed physical units in a warehouse. They determine where stock is stored, how it is accessed, and which restrictions or capacities apply. Accurate migration ensures operational continuity post-cutover.

This document covers:

  • Scope of bins to be converted.

  • Extraction, transformation, cleansing, and loading approach.

  • Detailed field-level mappings.

  • Dependencies, error handling, validations, and governance rules.

Bins will be created via Data Collection Template (DCT) and uploaded using transaction /SCWM/SBUP.

.


Conversion Scope

In Scope

  • Active, operational bins from the legacy WM system.

  • Migration of all mandatory and optional fields required for EWM bin creation:

  • Transformation of 3-character warehouse objects (warehouse number, storage type, storage section) to 4-character objects in S/4HANA.

  • Upload through transaction /SCWM/SBUP using a Data Collection Template (DCT).

Out of Scope

  • Deleted, obsolete, or test bins.

  • Warehouses not part of deployment scope.

  • Bin sorting rules, process type assignments, or fixed bin assignments (handled as separate conversion objects).

Conversion Scope

The scope of this document covers the approach for converting active Storage Bin from Legacy Source Systems into S/4HANA following the Master Data Standard - DD-FUN-050 Master Data  Standard - Bins

All the records (identified based on the relevancy rules and criteria provided in the Master data standard) need to be converted from legacy to S/4HANA system.

Where possible, Bins which do not exist physically / Logical Bins will be cleansed to conform to Master Data Standards. Cleansing activity is performed by Data cleansers in the legacy system before conversion. 

 The data from legacy system includes:

The data from legacy system excludes:

List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget ApproxNo. of Records

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.


TableField
Field NameTechnical Field
Data Element
DescriptionData TypeLengthRequirementTransformation Rule
Warehouse NumberLGNUMWarehouse NumberCHAR4RequiredLegacy 3 → 4 char
Storage BinLGPLAStorage BinCHAR18Required1:1 copy
Storage TypeLGTYPStorage TypeCHAR4RequiredLegacy 3 → 4 char
Storage SectionLGBERStorage SectionCHAR4OptionalLegacy 3 → 4 char
Bin Access TypeBIN_ATBin Access TypeCHAR2OptionalCopy if available
Fire Containment SectionBRANDFire Containment SectionCHAR2OptionalCopy if available
Storage Bin TypeLPTYPBin TypeCHAR2OptionalCopy/default
Storage GroupLGBER_LGSTStorage GroupCHAR4OptionalCopy if available
Maximum WeightMAX_WEIGHTMaximum WeightQUAN13OptionalCopy/default
Maximum VolumeMAX_VOLUMEMaximum VolumeQUAN13OptionalCopy/default
Total CapacityMAX_CAPATotal CapacityQUAN13OptionalCopy/default
Bin AisleAISLEBin AisleCHAR3OptionalCopy
StackSTACKStackCHAR3OptionalCopy
LevelLVL_VLevelCHAR3OptionalCopy
Bin SectionBINSCBin SectionCHAR3OptionalCopy
Bin AngleANGLEBin AngleCHAR3OptionalCopy
X CoordinateX_CORDX CoordinateNUMC6OptionalCopy
Y CoordinateY_CORDY CoordinateNUMC6OptionalCopy
Z CoordinateZ_CORDZ CoordinateNUMC6OptionalCopy
Bin DepthDEPTHBin DepthNUMC3OptionalCopy
VerificationVERIFVerification IndicatorCHAR1OptionalCopy
Removal BlockSKZUARemoval BlockCHAR1OptionalCopy
Putaway BlockSKZUEPut away BlockCHAR1OptionalCopy



Data Cleansing


Data cleansing is essential to avoid loading irrelevant or invalid bins into EWM.

Cleansing
RuleDescriptionResponsibility
Obsolete binsExclude bins marked for deletion in LAGPData Team
Non-operational binsExclude bins not tied to operational storage typesBusiness Team
Invalid capacitiesCorrect or default any negative or missing MAXWE/MAXVO/CAPA valuesBusiness / Project Team
DuplicatesEliminate duplicate bin recordsData Team
Coordinate integrityEnsure X/Y/Z coordinates are consistent with warehouse layoutBusiness Team
Block indicatorsValidate correctness of removal/put away blocksWarehouse Operations
IDCriticalityError Message/Report DescriptionRuleOutputSource System



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

Selection Screen

Image Added

The process is divided into the following stages: Steps 2&3 are part of the DCT file generation 

  1. Extraction – Pull relevant fields from legacy system.

  2. Cleansing – Apply rules to remove duplicates, obsolete bins, invalid values.

  3. Transformation – Apply mapping (3 → 4 char), defaults, and adjustments.

  4. Pre-Load Validation – Confirm counts and mapping accuracy.

  5. Load – Upload DCT file via /SCWM/SBUP.

  6. Post-Load Validation – Confirm successful bin creation in target.

Data Privacy and Sensitivity

N/A


Extraction


Source System/Table:

  • LAGP (WM Storage Bin Master) in legacy SAP WM.

Extraction Run Sheet


Legacy FieldTarget FieldNotes
LAGP-LGNUM/SCWM/LAGP-LGNUM3 → 4 char
LAGP-LGTYP/SCWM/LAGP-LGTYP3 → 4 char
LAGP-LGPLA/SCWM/LAGP-LGPLA1:1
LAGP-LGSAE/SCWM/LAGP-LGBER3 → 4 char
Remaining fieldsAs per mappingDirect copy/default



Selection Screen


N/ASelection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set


Data Collection Template (DCT)

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

DCT Rules

Field NameField DescriptionRule


The DCT serves as the upload file for /SCWM/SBUP.

  • Mandatory columns: LGNUM, LGTYP, LGPLA.

  • Optional columns included if available and relevant.

  • Populated from transformed extract. Will occur as users are constructing data in DCT

  • Used both for load and as record of migration scope.



Extraction Dependencies


  • Target warehouse org structure (LGNUM, LGTYP, LGSEC) must exist.

  • Mapping of 3 → 4 char codes finalized and signed off.

  • Legacy data must be cleansed prior to staging.

  • Notes:

    • Mandatory: LGNUM, LGTYP, LGPLA.

    • All other fields are optional depending on warehouse design.

    • Validation will check presence of mandatory fields before load.



Transformation

Transformation covers:

  • Org fields: 3 → 4 char conversion for LGNUM, LGTYP, LGSEC.

  • Bin numbers: Migrated 1:1 (LGPLA).

  • Capacities: Defaults applied if missing.

  • Blocks and verification: Carried forward only if maintained.

  • Coordinates: Loaded if consistent with warehouse design.

Transformation Rules



Rule #Legacy FieldTarget FieldLogic
1LGNUM/SCWM/LAGP-LGNUMMap 3 → 4 char
2LGTYP/SCWM/LAGP-LGTYPMap 3 → 4 char
3LGSAE/SCWM/LAGP-LGBERMap 3 → 4 char
4LGPLA/SCWM/LAGP-LGPLA1:1
5MAX_WEIGHT/SCWM/LAGP-MAX_WEIGHTCopy or default
6MAX_VOLUME/SCWM/LAGP-MAX_VOLUMECopy or default
7MAX_CAPA/SCWM/LAGP-MAX_CAPACopy or default
8SKZUA/SCWM/LAGP-SKZUACopy if set
9SKZUE/SCWM/LAGP-SKZUECopy if set


Transformation Mapping

Mapping tables will be maintained for:

  • Warehouse Number (legacy 3-char → EWM 4-char)

  • Storage Type (legacy 3-char → EWM 4-char)

  • Storage Section (legacy 3-char → EWM 4-char)

Legacy source table : LAGP - storage bin Masterdata


Legacy ValueTarget ValueDescription
101WH01Warehouse 101 → WH01
0010001Storage Type 001 → 0001
A01SA01Section A01 → SA01

Transformation Dependencies

  • Warehouse customizing must match mapping values.

  • Master data creation must be completed before transformation.



Field NameTechnical FieldLegacy Source TableDescriptionData TypeLengthRequirementTransformation RuleMapping Notes 
Warehouse NumberLGNUMLAGP-LGNUMWarehouse NumberCHAR4RequiredLegacy 3 → 4 charLegacy value is 3 character. New value will be 4 character as agreed upon by business / functional team. New transformed value will be included as part of DCT
Storage BinLGPLALAGP-LGPLAStorage BinCHAR18Required1:1 copyCopy from legacy
Storage TypeLGTYPLAGP-LGTYPStorage TypeCHAR4RequiredLegacy 3 → 4 charLegacy value is 3 character. New value will be 4 character as agreed upon by business / functional team. New transformed value will be included as part of DCT
Storage SectionLGBERLAGP-LGBERStorage SectionCHAR4OptionalLegacy 3 → 4 charLegacy value is 3 character. New value will be 4 character as agreed upon by business / functional team. New transformed value will be included as part of DCT
Bin Access TypeBIN_ATLAGP-BIN_ATBin Access TypeCHAR2OptionalCopy if availableCopy from legacy
Fire Containment SectionBRANDLAGP-BRANDFire Containment SectionCHAR2OptionalCopy if availableCopy from legacy
Storage Bin TypeLPTYPLAGP-LPTYPBin TypeCHAR2OptionalCopy/defaultCopy from legacy
Storage GroupLGBER_LGSTLAGP-LGBER_LGSTStorage GroupCHAR4OptionalCopy if availableCopy from legacy
Maximum WeightMAX_WEIGHTLAGP-MAX_WEIGHTMaximum WeightQUAN13OptionalCopy/defaultCopy from legacy
Maximum VolumeMAX_VOLUMELAGP-MAX_VOLUMEMaximum VolumeQUAN13OptionalCopy/defaultCopy from legacy
Total CapacityMAX_CAPALAGP-MAX_CAPATotal CapacityQUAN13OptionalCopy/defaultCopy from legacy
Bin AisleAISLELAGP-AISLEBin AisleCHAR3OptionalCopyCopy from legacy
StackSTACKLAGP-STACKStackCHAR3OptionalCopyCopy from legacy
LevelLVL_VLAGP-LVL_VLevelCHAR3OptionalCopyCopy from legacy
Bin SectionBINSCLAGP-BINSCBin SectionCHAR3OptionalCopyCopy from legacy
Bin AngleANGLELAGP-ANGLEBin AngleCHAR3OptionalCopyCopy from legacy
X CoordinateX_CORDLAGP-X_CORDX CoordinateNUMC6OptionalCopyCopy from legacy
Y CoordinateY_CORDLAGP-Y_CORDY CoordinateNUMC6OptionalCopyCopy from legacy
Z CoordinateZ_CORDLAGP-Z_CORDZ CoordinateNUMC6OptionalCopyCopy from legacy
Bin DepthDEPTHLAGP-DEPTHBin DepthNUMC3OptionalCopyCopy from legacy
VerificationVERIFLAGP-VERIFVerification IndicatorCHAR1OptionalCopyCopy from legacy
Removal BlockSKZUALAGP-SKZUARemoval BlockCHAR1OptionalCopyCopy from legacy. Subjected to change as per business requirement. Will be included in DCT
Putaway BlockSKZUELAGP-SKZUEPut away BlockCHAR1OptionalCopyCopy from legacy. Subjected to change as per business requirement. Will be included in DCT

Extraction Dependencies

Item #Step DescriptionTeam Responsible

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

Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

Transformation Mapping

Mapping Table NameMapping Table Description

Transformation Dependencies

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


Pre-Load Validation

Project Team


Check TypeActivityResponsible
Completeness
TaskAction
Verify bin counts per warehouseProject Team
Accuracy
TaskAction
Check mappings vs customizingProject Team
Business
ValidationConfirm bins and attributes align with warehouse designBusiness Team

Completeness

TaskAction

Accuracy

TaskAction


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

Sample Load File :

Google Drive Live Link
urlhttps://docs.google.com/spreadsheets/d/1AWl59lSCCme5AZp3dsixvzedFJX6Ib3a/edit?rtpof=true


Load Run Sheet

Item #
Step
Step
DescriptionResponsibility
1
Team Responsible
Upload DCT into /SCWM/SBUPProject Team
2Monitor error logProject Team
3Correct and reload failed binsProject Team
4Validate created bins in /SCWM/LAGPBusiness / Project Team


Load Phase and Dependencies

Configuration

Item #Configuration Item

Conversion Objects

Object #Preceding Object Conversion Approachlist the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)
  • Predecessor: Warehouse org structure migration.

  • Successor: Bin sorting, warehouse process type assignment.

Configuration

N/A

Error Handling

Error handling is critical because /SCWM/SBUP rejects invalid or incomplete bins.

Error Categories


  • Error TypeExampleResolution
    Missing mandatory fieldLGNUM not providedCorrect DCT and reload
    Invalid mappingLegacy 101 not mapped to WH01Update mapping table
    Incorrect capacity valuesMAX_WEIGHT = negativeCorrect or default value
    Org mismatchLGTYP not configured in target warehouseValidate customizing
    Bin already existsDuplicate LGPLARemove duplicate before reload



  • Error Handling Process

    1. Run /SCWM/SBUP and review error log.

    2. Categorize errors (mapping, cleansing, config, duplication).

    3. Correct DCT file.

    4. Reload corrected bins.

    5. Track and report error resolution status to Project Governance.



Post-Load Validation


Check TypeActivityResponsibility
CompletenessCompare loaded vs extracted countsProject Team
AccuracySpot check field mappingsSyniti Team
Business ProcessTest putaway/removal to verify bin usabilityBusiness Team


Error Handling

Error TypeError DescriptionAction Taken

Post-Load Validation

Project Team

Completeness

TaskAction

Accuracy

TaskAction

Business

Completeness

TaskAction

Accuracy

TaskAction

Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.

  • All target org structures (LGNUM, LGTYP, LGSEC) configured and available before load.

  • 3 → 4 character mappings signed off prior to conversion.

  • Bin numbers migrate 1:1.

  • /SCWM/SBUP is

  • in scope based on data design and any exception requested by business.
  • the only upload method.

  • Governance applies:

    • Change of Bin Data: Allowed under strict approval.

    • Deletion of Bins: Only if empty and not in use, requires business approval


See also

Change log

Change History
limit10

Workflow history

Workflow Report
parent@self
hideheadertrue
typeapprovals