/LIME/PI_LOGHEAD

-- ============================================================
-- Table  : /LIME/PI_LOGHEAD — Physical inventory document header — the log header that resolves a counting document's GUID to its readable year and number, its process type, and the warehouse it was raised for
-- Purpose: Column-selected read of /LIME/PI_LOGHEAD — auto-generated from field metadata
-- Grain  : One row per client + GUID_DOC
-- 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_LOGHEAD; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as lime_pi_loghead — 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 key every counting table hangs on",
  lower(hex(t.GUID_DOC)) AS "GUID of the physical inventory document — the key every counting table hangs on (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.DOC_YEAR AS "Document year of the counting document — with the number, the readable identity of the count",
  t.DOC_NUMBER AS "Physical inventory document number",
  t.IPO_YEAR AS "Document year of the planning object the count was generated from",
  t.IPO_NUMBER AS "Number of the physical inventory planning document — empty on ad-hoc counts",
  t.PROCESS_TYPE AS "Counting process type",
  t.LGNUM AS "Warehouse number the count was raised for"
FROM <catalog>.<schema>.lime_pi_loghead t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
ORDER BY t.GUID_DOC;