P46011

-- ============================================================
-- Program: P46011 Item Unit of Measure Definition — the setup application that defines the UOM structure (pallet, case, each) the warehouse uses for an item, including capacity, weight, and breakdown rules per unit of measure
-- Purpose: Item Unit of Measure Definition — the setup application that defines the UOM structure (pallet, case, each) the warehouse uses for an item, including capacity, weight, and breakdown rules per unit of measure — auto-generated boilerplate from program-table-map
-- Grain  : F46011 × F4101, F41002 — 1:N joins yield one row per detail line
-- Tables : F46011, F4101, F41002
-- Notes  : Auto-generated skeleton. Julian dates are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210). Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  TRIM(h.IQMCU) AS "Branch/plant the definition applies to.",
  h.IQPRP6 AS "Item dimension group the row defines; blank when the row is for a specific item instead.",
  h.IQITM AS "Short item number the row defines; zero when the row is for a dimension group.",
  h.IQUOM AS "Unit of measure this definition row describes (e.g., EA, CA, PL).",
  f.UMUM AS "From unit of measure of the conversion.",
  f.UMRUM AS "To (related) unit of measure of the conversion."
FROM <catalog>.<schema_data>.f46011 h
LEFT JOIN <catalog>.<schema_data>.f4101 im
  ON im.IMITM = h.IQITM
LEFT JOIN <catalog>.<schema_data>.f41002 f
  ON f.UMMCU = h.IQMCU
 AND f.UMITM = h.IQITM
WHERE
  h.IQMCU = '<MCU>'
  AND h.IQITM = <ITM>
ORDER BY h.IQMCU;