/SCWM/AQUA

-- ============================================================
-- Table  : /SCWM/AQUA — Available quants — the stock that warehouse task creation can actually consume, with the bin, handling unit, product, stock type, batch, owner, and entitled party all resolved onto one row
-- Purpose: Column-selected read of /SCWM/AQUA — auto-generated from field metadata
-- Grain  : One row per client + GUID_PARENT + GUID_STOCK
-- Caution: Available quantity, not on-hand: stock already committed to open warehouse tasks is excluded, so AQUA and the LIME quantities do not tie out row for row
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/AQUA; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_aqua — 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 (a bin or a handling unit) the available quant sits under",
  lower(hex(t.GUID_PARENT)) AS "GUID of the parent node (a bin or a handling unit) the available quant sits under (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.GUID_STOCK AS "Stock GUID — joins to the quant attribute rows",
  lower(hex(t.GUID_STOCK)) AS "Stock GUID — joins to the quant attribute rows (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.LGNUM AS "EWM warehouse number",
  t.LGTYP AS "Storage type of the quant's location",
  t.LGPLA AS "Storage bin the quant sits in",
  t.HUIDENT AS "External handling-unit identification the stock sits in — the readable join to the HU header",
  t.MATID AS "Product GUID (RAW16 form)",
  lower(hex(t.MATID)) AS "Product GUID (RAW16 form) (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.CAT AS "Stock type or category, such as unrestricted versus blocked",
  t.DOCCAT AS "Document category for document-related stock",
  t.STOCK_USAGE AS "Stock usage classification",
  t.OWNER AS "Stock owner (business partner)",
  t.ENTITLED AS "Party entitled to dispose of the stock",
  t.CHARG AS "Batch number in its readable form",
  t.QUAN AS "Available quantity usable for warehouse task creation",
  t.UNIT AS "Base unit of the available quantity",
  t.VFDAT AS "Shelf-life expiration or best-before date",
  t.WDATU AS "Goods receipt date and time"  -- UTC
FROM <catalog>.<schema>.scwm_aqua 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;