/SAPAPO/MATLWHST

-- ============================================================
-- Table  : /SAPAPO/MATLWHST — Warehouse product at storage-type level — the same product's parameters narrowed to one storage type: preferred section and bin type, maximum fixed bins, and the min/max/replenishment quantity set
-- Purpose: Column-selected read of /SAPAPO/MATLWHST — auto-generated from field metadata
-- Grain  : One row per client + MATID + SCUGUID + ENTITLED_ID + LGTYP
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SAPAPO/MATLWHST; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as sapapo_matlwhst — 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.MATID AS "Product GUID in its 22-character compressed form",
  t.SCUGUID AS "Supply chain unit GUID of the warehouse",
  lower(hex(t.SCUGUID)) AS "Supply chain unit GUID of the warehouse (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ENTITLED_ID AS "Party entitled to dispose, as a GUID",
  lower(hex(t.ENTITLED_ID)) AS "Party entitled to dispose, as a GUID (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.LGTYP AS "Storage type the row's parameters apply to",
  t.LVORM AS "Deletion flag",
  t.SECTIND AS "Preferred storage section indicator",
  t.BINTYPE AS "Preferred storage bin type",
  t.MAXFIXBIN AS "Maximum number of fixed bins for the product in this storage type",
  t.MAXQTY AS "Maximum quantity in the storage type",
  t.MAXQTY_UOM_DSP AS "Display unit for the maximum quantity",
  t.MINQTY AS "Minimum quantity in the storage type",
  t.REPQTY AS "Minimum replenishment quantity",
  t.RMMQTY_FIX AS "Flag: the minimum, maximum, and replenishment quantities are fixed against slotting",
  t.NORPLN AS "Flag: no replenishment for the product in this storage type",
  t.CHANGEUTC AS "Time of the last change"  -- UTC
FROM <catalog>.<schema>.sapapo_matlwhst t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.MATID = '<MATID>'
  -- AND t.SCUGUID = unhex('<SCUGUID>')  -- pass the 32-character hex form
  -- AND t.ENTITLED_ID = unhex('<ENTITLED_ID>')  -- pass the 32-character hex form
  -- AND t.LGTYP = '<LGTYP>'
  -- AND t.CHANGEUTC >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.CHANGEUTC <= <TS_TO>
ORDER BY t.MATID;