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

Compare with Current View Page History

« Previous Version 9 Current »

Status

  Approved

Owner
Stakeholders

Purpose

The purpose of this specification is to define the 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).


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.


Field NameTechnical FieldDescriptionData 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



Conversion Process

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

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/A


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

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

  • Mapping tables must be reviewed and approved by Functional and Business owners.

  • Warehouse customizing must match mapping values.

  • Legacy cleansing 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


Pre-Load Validation

Project Team


Check TypeActivityResponsible
CompletenessVerify bin counts per warehouseProject Team
AccuracyCheck mappings vs customizingProject Team
Business ValidationConfirm bins and attributes align with warehouse designBusiness Team


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 :


Load Run Sheet

StepDescriptionResponsibility
1Upload 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

  • 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


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

Version Published Changed By Comment
CURRENT (v. 9) Oct 14, 2025 14:31 HASSAN-ext, Shamir
v. 9 Oct 14, 2025 14:29 HASSAN-ext, Shamir
v. 8 Oct 14, 2025 14:18 HASSAN-ext, Shamir
v. 7 Oct 14, 2025 14:06 HASSAN-ext, Shamir
v. 6 Sept 16, 2025 13:11 HASSAN-ext, Shamir
v. 5 Sept 11, 2025 17:58 HASSAN-ext, Shamir
v. 4 Jul 30, 2025 20:03 RAYUDU-ext, Narasimha Kumar
v. 3 Jun 16, 2025 14:35 RAYUDU-ext, Narasimha Kumar
v. 2 Jun 16, 2025 14:35 RAYUDU-ext, Narasimha Kumar
v. 1 Jun 16, 2025 14:27 RAYUDU-ext, Narasimha Kumar

Workflow history

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

  • No labels