/SCWM/BINMAT

-- ============================================================
-- Table  : /SCWM/BINMAT — Fixed bin assignment — the products that live in a named bin for a given entitled party, with the minimum, maximum, and replenishment quantities slotting maintains
-- Purpose: Column-selected read of /SCWM/BINMAT — auto-generated from field metadata
-- Grain  : One row per client + LGNUM + MATID + ENTITLED + 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/BINMAT; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_binmat — adjust to your landing convention (see quirks #namespace-slashes). RAW16 GUID columns are joined raw; the hex aliases are for display only (#guid-keys). 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.MATID AS "Product GUID — the RAW16 form; resolve to a material number through the product master bridge",
  lower(hex(t.MATID)) AS "Product GUID — the RAW16 form; resolve to a material number through the product master bridge (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ENTITLED AS "Party entitled to dispose the assignment applies to",
  t.LGPLA AS "Fixed storage bin for the product",
  t.LGTYP AS "Storage type of the fixed bin",
  t.OUTCON AS "Flag set by slotting: the bin assignment is considered improvable",
  t.MAXQTY AS "Maximum replenishment-planning quantity for the product in the bin",
  t.MAXQTY_UOM_DSP AS "Display unit for the maximum quantity",
  t.MINQTY AS "Minimum quantity that triggers planned replenishment",
  t.MINQTY_UOM_DSP AS "Display unit for the minimum quantity",
  t.MATNR AS "Material number carried denormalized alongside the product GUID",
  t.RMMQTY_FIX AS "Flag: the minimum, maximum, and replenishment quantities are fixed against slotting",
  t.CREATED_AT AS "Time the assignment was created",  -- UTC
  t.CREATED_BY AS "User who created the assignment"
FROM <catalog>.<schema>.scwm_binmat t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.LGNUM = '<LGNUM>'
  -- AND t.MATID = unhex('<MATID>')  -- pass the 32-character hex form
  -- AND t.LGPLA = '<LGPLA>'
  -- AND t.CREATED_AT >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CREATED_AT <= <TS_TO>
ORDER BY t.LGNUM;