/SCWM/LAGPS

-- ============================================================
-- Table  : /SCWM/LAGPS — Bin assignments to activity areas — one row per bin per activity, carrying the sort sequence that determines the order an operator walks the bins
-- Purpose: Column-selected read of /SCWM/LAGPS — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + LGPLA + ACT_TYPE
-- Caution: One bin appears once per ACT_TYPE — filter to the activity you mean (picking, putaway, counting) before joining to bins or bin counts multiply
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/LAGPS; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_lagps — adjust to your landing convention (see quirks #namespace-slashes). Timestamps flagged UTC are DEC(15) yyyymmddhhmmss values in UTC, not warehouse local time (#utc-timestamps).
-- ============================================================
SELECT
  t.MANDT AS "Client",
  t.LGNUM AS "EWM warehouse number",
  t.LGPLA AS "Storage bin the sort entry applies to",
  t.ACT_TYPE AS "Activity the sort entry applies to (picking, putaway, counting)",
  t.RANK AS "Rank of the bin within the activity-area sequence",
  t.AAREA AS "Activity area the bin is assigned to — an attribute of the assignment, not part of the key",
  t.LGTYP AS "Storage type of the bin, carried denormalized",
  t.LGBER AS "Storage section of the bin, carried denormalized",
  t.AISLE AS "Aisle of the bin, carried denormalized",
  t.SRT_NR AS "Bin sort sequence for the activity — the column that drives pick-path order",
  t.AISLE_S_DISTANCE AS "Distance from the bin to the start of its aisle",
  t.AISLE_LENGTH AS "Length of the aisle",
  t.AISLE_NEXT AS "Subsequent aisle in the path",
  t.AISLE_N_DISTANCE AS "Distance to the subsequent aisle",
  t.DSTGRP AS "Consolidation group used at this bin"
FROM <catalog>.<schema>.scwm_lagps t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.LGPLA = '<LGPLA>'
  -- AND t.ACT_TYPE = '<ACT_TYPE>'
ORDER BY t.LGNUM;