/SCWM/PVPAKC

-- ============================================================
-- Table  : /SCWM/PVPAKC — Packaging specification content — what is packed at a level: the product, the quantity and unit, and the mixing rules that say whether different products or batches may share the pack
-- Purpose: Column-selected read of /SCWM/PVPAKC — auto-generated from field metadata
-- Grain  : One row per client + PVGUID + PVCNT
-- Notes  : Auto-generated skeleton for SAP EWM data replicated into your lakehouse — it reads the replicated copy, not the SAP database. Source table /SCWM/PVPAKC; slashes aren't legal in unquoted Databricks identifiers, so replication targets conventionally land it as scwm_pvpakc — 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.PVGUID AS "GUID of the iPPE variant the content belongs to — the same variant the element row hangs on",
  lower(hex(t.PVGUID)) AS "GUID of the iPPE variant the content belongs to — the same variant the element row hangs on (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.PVCNT AS "Change counter of the variant",
  t.MATID AS "Product being packed, as a product GUID (RAW16 form)",
  lower(hex(t.MATID)) AS "Product being packed, as a product GUID (RAW16 form) (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.SUB_PS AS "Nested packaging specification packed at this level — typed as the packaging specification GUID, not the iPPE node GUID the header keys on",
  lower(hex(t.SUB_PS)) AS "Nested packaging specification packed at this level — typed as the packaging specification GUID, not the iPPE node GUID the header keys on (hex)",  -- display rendering of the RAW16 GUID — join on the raw column; see quirks guide #guid-keys
  t.UNIT AS "Unit of the packed quantity",
  t.QUAN AS "How much of the product the level holds",
  t.MEINS AS "Base unit of measure of the product",
  t.REFMIX AS "Whether products sharing a reference product may be mixed in the pack",
  t.BATCHMIX AS "Whether different batches may be packed together"
FROM <catalog>.<schema>.scwm_pvpakc t
WHERE
  t.MANDT = '<client>'  -- client filter — drop on single-client systems
ORDER BY t.PVGUID;