/SCWM/QUAN

-- ============================================================
-- Table  : /SCWM/QUAN — Quant attributes — the descriptive side of a stock item (units, weight, volume, goods-receipt time, shelf life, country of origin, and the document reference for special stock), keyed by the stock GUID
-- Purpose: Column-selected read of /SCWM/QUAN — auto-generated from field metadata
-- Grain  : One row per client + GUID_PARENT + GUID_STOCK
-- Caution: Attributes only — quantities live in /LIME/NQUAN and product, stock type, owner, and entitled party live on /SCWM/AQUA; key stock-identity analytics off AQUA, not this table
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/QUAN; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_quan — 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.GUID_PARENT AS "GUID of the parent node in the LIME location/handling-unit tree — a legacy column that remains part of the key",
  lower(hex(t.GUID_PARENT)) AS "GUID of the parent node in the LIME location/handling-unit tree — a legacy column that remains part of the key (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.GUID_STOCK AS "GUID of the stock item — the join handle to the LIME quantities and to available quants",
  lower(hex(t.GUID_STOCK)) AS "GUID of the stock item — the join handle to the LIME quantities and to available quants (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.MEINS AS "Base unit of measure of the quant",
  t.ALTME AS "Alternative stockkeeping unit of measure",
  t.WEIGHT AS "Net or loading weight of the quant",
  t.UNIT_W AS "Unit for the weight value",
  t.VOLUM AS "Net or loading volume of the quant",
  t.UNIT_V AS "Unit for the volume value",
  t.WDATU AS "Goods receipt date and time of the stock",  -- UTC
  t.VFDAT AS "Shelf-life expiration or best-before date",
  t.COO AS "Country or region of origin of the stock",
  t.BRESTR AS "Flag: the batch is in restricted-use stock",
  t.IDPLATE AS "Stock identification number (ID plate)",
  t.QDOCCAT AS "Document category for document-related (special) stock references",
  t.QDOCID AS "Document GUID for document-related stock, such as sales-order stock",
  lower(hex(t.QDOCID)) AS "Document GUID for document-related stock, such as sales-order stock (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.QITMID AS "Document item GUID for document-related stock",
  lower(hex(t.QITMID)) AS "Document item GUID for document-related stock (hex)"  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
FROM <catalog>.<schema>.scwm_quan t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.GUID_PARENT = unhex('<GUID_PARENT>')  -- pass the 32-character hex form
  -- AND t.GUID_STOCK = unhex('<GUID_STOCK>')  -- pass the 32-character hex form
  -- AND t.WDATU >= <TS_FROM>  -- UTC yyyymmddhhmmss — convert warehouse-local dates first (#utc-timestamps)
  -- AND t.WDATU <= <TS_TO>
ORDER BY t.GUID_PARENT;