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

Compare with Current View Page History

« Previous Version 6 Next »

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:
    /SCWM/LAGP-LGNUM, LGPLA, LGTYP, LGBER, BIN_AT, BRAND, LPTYP, LGBER_LGST, MAX_WEIGHT, MAX_VOLUME, MAX_CAPA, AISLE, STACK, LVL_V, BINSC, ANGLE, X_CORD, Y_CORD, Z_CORD, DEPTH, VERIF, SKZUA, SKZUE.

  • 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 Number/SCWM/LAGP-LGNUMWarehouse NumberCHAR4RequiredLegacy 3 → 4 char
Storage Bin/SCWM/LAGP-LGPLAStorage BinCHAR18Required1:1 copy
Storage Type/SCWM/LAGP-LGTYPStorage TypeCHAR4RequiredLegacy 3 → 4 char
Storage Section/SCWM/LAGP-LGBERStorage SectionCHAR4OptionalLegacy 3 → 4 char
Bin Access Type/SCWM/LAGP-BIN_ATBin Access TypeCHAR2OptionalCopy if available
Fire Containment Section/SCWM/LAGP-BRANDFire Containment SectionCHAR2OptionalCopy if available
Storage Bin Type/SCWM/LAGP-LPTYPBin TypeCHAR2OptionalCopy/default
Storage Group/SCWM/LAGP-LGBER_LGSTStorage GroupCHAR4OptionalCopy if available
Maximum Weight/SCWM/LAGP-MAX_WEIGHTMaximum WeightQUAN13OptionalCopy/default
Maximum Volume/SCWM/LAGP-MAX_VOLUMEMaximum VolumeQUAN13OptionalCopy/default
Total Capacity/SCWM/LAGP-MAX_CAPATotal CapacityQUAN13OptionalCopy/default
Bin Aisle/SCWM/LAGP-AISLEBin AisleCHAR3OptionalCopy
Stack/SCWM/LAGP-STACKStackCHAR3OptionalCopy
Level/SCWM/LAGP-LVL_VLevelCHAR3OptionalCopy
Bin Section/SCWM/LAGP-BINSCBin SectionCHAR3OptionalCopy
Bin Angle/SCWM/LAGP-ANGLEBin AngleCHAR3OptionalCopy
X Coordinate/SCWM/LAGP-X_CORDX CoordinateNUMC6OptionalCopy
Y Coordinate/SCWM/LAGP-Y_CORDY CoordinateNUMC6OptionalCopy
Z Coordinate/SCWM/LAGP-Z_CORDZ CoordinateNUMC6OptionalCopy
Bin Depth/SCWM/LAGP-DEPTHBin DepthNUMC3OptionalCopy
Verification/SCWM/LAGP-VERIFVerification IndicatorCHAR1OptionalCopy
Removal Block/SCWM/LAGP-SKZUARemoval BlockCHAR1OptionalCopy
Putaway Block/SCWM/LAGP-SKZUEPutaway 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/putaway blocksWarehouse Operations



Conversion Process

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

The process is divided into the following stages:

  1. Extraction – Pull relevant fields from legacy LAGP.

  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.

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

Example DCT Structure:

LGNUMLGTYPLGBERLGPLABIN_ATBRANDLPTYPLGBER_LGSTMAX_WEIGHTMAX_VOLUMEMAX_CAPAAISLESTACKLVL_VBINSCANGLEX_CORDY_CORDZ_CORDDEPTHVERIFSKZUASKZUE


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

StepDescriptionResponsibility
1Apply org field mapping (LGNUM, LGTYP, LGSEC)Project Team
2Populate defaults for missing capacity valuesProject Team
3Validate block indicators with BusinessBusiness / Project Team
4Generate transformed DCTProject Team


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




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

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 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 mappingsProject 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. 6) 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