/LIME/PI_DOC_IT

-- ============================================================
-- Table  : /LIME/PI_DOC_IT — Physical inventory document item — the countable line: its type and status, when it was created, counted, and posted, who counted it, the physical inventory area it belongs to, and the completeness flags that say whether a bin or handling unit was counted whole
-- Purpose: Column-selected read of /LIME/PI_DOC_IT — auto-generated from field metadata
-- Grain  : One row per client + GUID_DOC + ITEM_NO + LINE_IDX + CHANGE_SEQ + ITEM_TYPE
-- Caution: The key carries a change version (CHANGE_SEQ) — take the latest per item or a recount is counted twice
-- 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_IT; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as lime_pi_doc_it — 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 the item belongs to",
  lower(hex(t.GUID_DOC)) AS "GUID of the physical inventory document the item belongs to (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 — part of the key, so one item number can carry several rows",
  t.CHANGE_SEQ AS "Change version — a recount writes a new version rather than overwriting the previous count",
  t.ITEM_TYPE AS "Line category of the item — what kind of object is being counted",
  t.ITEM_GROUP AS "Item group tying related counting lines together",
  t.DOC_TYPE AS "Physical inventory procedure the item is counted under",
  t.DOC_STATUS AS "Status of the counting item (created, counted, posted, and so on)",
  t.COUNT_DATE AS "Time the count was entered — a long-form timestamp, not the short yyyymmddhhmmss form used elsewhere in this reference",
  t.COUNT_USER AS "User who entered the count",
  t.COUNT_REFERENCE AS "Free reference captured with the count, such as a count sheet number",
  t.CREATE_DATE AS "Time the counting item was created — long-form timestamp",
  t.POST_DATE AS "Time the difference was posted — long-form timestamp; the gap from the count time is the count-to-posting lag",
  t.DIF_DIRECTION AS "Direction of the difference posting (stock in or stock out)",
  t.POST_ITEM AS "Whether the item is to be posted",
  t.GUID_ITEM AS "GUID of the counted object itself — resolved to readable keys on the item business-key table",
  lower(hex(t.GUID_ITEM)) AS "GUID of the counted object itself — resolved to readable keys on the item business-key table (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.GUID_PARENT AS "GUID of the parent object the counted stock sits in — resolved to readable keys on the parent business-key table",
  lower(hex(t.GUID_PARENT)) AS "GUID of the parent object the counted stock sits in — resolved to readable keys on the parent business-key table (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PI_AREA AS "Physical inventory area, as a bare GUID — no browsable area configuration table renders publicly, so area names cannot be resolved from this catalog",
  lower(hex(t.PI_AREA)) AS "Physical inventory area, as a bare GUID — no browsable area configuration table renders publicly, so area names cannot be resolved from this catalog (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.BLOCK_IND AS "Inventory blocking indicator set on the counted stock",
  t.FREEZE_IND AS "Whether the book quantity is frozen for the count",
  t.PRIORITY AS "Priority of the counting item",
  t.ITEM_NEW_IND AS "Flag: stock was found that the document did not expect",
  t.IND_LOC_PAR_COMP AS "Flag: the parent location was counted completely — the completeness signal that stands in for a countable-area report",
  t.IND_LOC_PAR_EMPT AS "Flag: the parent location was counted as empty — distinct from never counted",
  t.IND_HU_ITEM_COMP AS "Flag: the handling unit was counted completely",
  t.REASON AS "Reason code for the count or the difference",
  t.EXCCODE AS "Exception code raised during counting",
  t.WDATU AS "Goods receipt time of the counted stock",  -- UTC
  t.VFDAT AS "Shelf-life expiration date of the counted stock"
FROM <catalog>.<schema>.lime_pi_doc_it t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
ORDER BY t.GUID_DOC;