/LIME/PI_DOC_TB

-- ============================================================
-- Table  : /LIME/PI_DOC_TB — Physical inventory quantities — the book and counted quantities behind a document item, one row per quantity parameter per unit of measure
-- Purpose: Column-selected read of /LIME/PI_DOC_TB — auto-generated from field metadata
-- Grain  : One row per client + GUID_DOC + ITEM_NO + LINE_IDX + CHANGE_SEQ + ITEM_TYPE + QAN_DOC_STATUS + QUAN_SEQ + UNIT
-- Caution: Not one row per item: the quantity status (QAN_DOC_STATUS), sequence, and unit are all in the key — pick the status you mean (book against counted) before comparing, or the difference is computed against itself
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /LIME/PI_DOC_TB; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as lime_pi_doc_tb — 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_DOC AS "GUID of the physical inventory document",
  lower(hex(t.GUID_DOC)) AS "GUID of the physical inventory document (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.ITEM_NO AS "Item number within the counting document",
  t.LINE_IDX AS "Row index within the item",
  t.CHANGE_SEQ AS "Change version of the item the quantity belongs to",
  t.ITEM_TYPE AS "Line category of the item",
  t.QAN_DOC_STATUS AS "Which quantity the row holds — the status that separates the book quantity from the counted one",
  t.QUAN_SEQ AS "Sequence number of the quantity row",
  t.UNIT AS "Inventory-managed unit of measure — part of the key, so one item carries a row per unit",
  t.QUANTITY AS "Quantity in the inventory-managed unit",
  t.ENTERED_QUANTITY AS "Quantity as the counter entered it, before conversion",
  t.ENTERED_UNIT AS "Unit the counter entered the quantity in",
  t.IND_ZERO_COUNT AS "Flag: counted and found empty",
  t.IND_NOT_COUNT AS "Flag: not counted — the row that must never be read as a zero",
  t.PARAM_NAME AS "Name of the document parameter the row carries, where the row is a parameter rather than a quantity",
  t.PARAM_VALUE AS "Value of that parameter",
  t.PARAM_GROUP AS "Grouping of document parameters"
FROM <catalog>.<schema>.lime_pi_doc_tb t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
  -- AND t.UNIT = '<UNIT>'
ORDER BY t.GUID_DOC;