/SCWM/LAGP

-- ============================================================
-- Table  : /SCWM/LAGP — The storage bin master — one row per bin in a warehouse, with its storage type and section, the three block indicators, capacity limits, empty/full flags, and the layout coordinates the pick path is built from
-- Purpose: Column-selected read of /SCWM/LAGP — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + LGPLA
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/LAGP; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_lagp — 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 — unique within the warehouse, with storage type NOT part of the key",
  t.LGTYP AS "Storage type the bin belongs to (an attribute here, not a key column)",
  t.LGBER AS "Storage section the bin belongs to",
  t.LPTYP AS "Storage bin type — the capacity profile the bin follows",
  t.SKZUA AS "Block indicator for stock removals from the bin",
  t.SKZUE AS "Block indicator for putaways into the bin",
  t.SKZSI AS "Block indicator set by an ongoing physical inventory",
  t.MAX_WEIGHT AS "Maximum weight the bin can hold",
  t.UNIT_W AS "Unit of the weight figures",
  t.MAX_VOLUME AS "Maximum volume the bin can hold",
  t.UNIT_V AS "Unit of the volume figures",
  t.FCAPA AS "Remaining available capacity in the bin, as used by the capacity check",
  t.KZLER AS "Flag: the bin is currently empty",
  t.KZVOL AS "Flag: the bin is currently full",
  t.AISLE AS "Aisle coordinate of the bin — layout data the pick path is built from",
  t.MOVED_AT AS "Time of the last movement into the bin"  -- UTC
FROM <catalog>.<schema>.scwm_lagp t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.LGPLA = '<LGPLA>'
  -- AND t.MOVED_AT >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.MOVED_AT <= <TS_TO>
ORDER BY t.LGNUM;