/LIME/PI_IT_BIZ

-- ============================================================
-- Table  : /LIME/PI_IT_BIZ — Physical inventory item business keys — the readable stock identity behind a document item: product, batch, stock type, owner and entitled party, plus the location and handling unit the stock was counted in
-- Purpose: Column-selected read of /LIME/PI_IT_BIZ — auto-generated from field metadata
-- Grain  : One row per client + GUID_DOC + ITEM_NO + LINE_IDX + CHANGE_SEQ + ITEM_TYPE
-- 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_IT_BIZ; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as lime_pi_it_biz — 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",
  t.ITEM_TYPE AS "Line category of the item",
  t.MATNR AS "Product number of the counted stock, in readable form",
  t.MATID AS "Product GUID of the counted stock (RAW16 form)",
  lower(hex(t.MATID)) AS "Product GUID of the counted stock (RAW16 form) (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.CHARG AS "Batch number of the counted stock",
  t.BATCHID AS "Batch GUID of the counted stock",
  lower(hex(t.BATCHID)) AS "Batch GUID of the counted stock (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.CAT AS "Stock type of the counted stock, such as unrestricted against blocked",
  t.STOCK_USAGE AS "Stock usage classification",
  t.OWNER AS "Owner of the counted stock",
  t.ENTITLED AS "Party entitled to dispose of the counted stock",
  t.STOCK_DOCCAT AS "Special stock reference category, where the stock is document-related",
  t.STOCK_DOCNO AS "Readable number of that reference document",
  t.DOCCAT AS "Document category for document-related stock",
  t.LGNUM_STOCK AS "Warehouse number the stock is managed in",
  t.LGNUM AS "Warehouse number of the counted location",
  t.LGTYP AS "Storage type of the counted location",
  t.LGPLA AS "Storage bin the stock was counted in",
  t.LGNUM_HU AS "Warehouse number of the handling unit the stock was counted in",
  t.HUIDENT AS "External identification of that handling unit",
  t.HU_PMAT AS "Packaging material of that handling unit",
  t.HU_TYPE AS "Handling unit type",
  t.SSCC AS "Serial shipping container code of the handling unit",
  t.WERKS AS "Plant, where the count reaches stock outside the warehouse structure",
  t.LGORT AS "Storage location of that stock"
FROM <catalog>.<schema>.lime_pi_it_biz t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
ORDER BY t.GUID_DOC;