/SAPAPO/MATLWH

-- ============================================================
-- Table  : /SAPAPO/MATLWH — Warehouse product — the warehouse-level settings for a product: putaway and stock-removal control, storage section and bin type indicators, stock determination, two-step picking relevance, and the slotting demand quantity
-- Purpose: Column-selected read of /SAPAPO/MATLWH — auto-generated from field metadata
-- Grain  : One row per client + MATID + SCUGUID + ENTITLED_ID
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SAPAPO/MATLWH; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as sapapo_matlwh — 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 — there is no LGNUM column on this table",
  lower(hex(t.SCUGUID)) AS "Supply chain unit GUID of the warehouse — there is no LGNUM column on this table (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.LVORM AS "Deletion flag",
  t.PROCPRFL AS "Process block profile for the product in this warehouse",
  t.PTDETIND AS "Control indicator for warehouse process type determination",
  t.PUT_STRA AS "Putaway control (strategy) indicator",
  t.LGBKZ AS "Storage section indicator for putaway",
  t.LPTYP AS "Preferred storage bin type",
  t.KZZUL AS "Flag: addition to existing stock is not allowed",
  t.REM_STRA AS "Stock removal control (strategy) indicator",
  t.STCKDETGR AS "Stock determination group",
  t.L2SKR AS "Relevance for two-step picking",
  t.DEMQTY AS "Demand quantity used by slotting",
  t.CONCSTAT AS "Slotting status of the product in this warehouse"
FROM <catalog>.<schema>.sapapo_matlwh 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
ORDER BY t.MATID;