P4602

-- ============================================================
-- Program: P4602 Location Detail Maintenance — the interactive application for reviewing and correcting location detail records: what is stored in each warehouse location, in which units of measure, and how much capacity is committed
-- Purpose: Location Detail Maintenance — the interactive application for reviewing and correcting location detail records: what is stored in each warehouse location, in which units of measure, and how much capacity is committed — auto-generated boilerplate from program-table-map
-- Grain  : F4602 × F4100, F41021 — 1:N joins yield one row per detail line
-- Tables : F4602, F4100, F41021
-- 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
  h.IFITM AS "Short item number stored in the location.",
  TRIM(h.IFMCU) AS "Branch/plant (warehouse) the location belongs to.",
  h.IFLOCN AS "Warehouse location (bin) this row describes.",
  h.IFLOTN AS "Lot/serial number of the stock in the location.",
  h.IFLDSQ AS "Sequence distinguishing multiple detail rows for the same item/location/lot — the same key F4600/F4611 carry in their from/to sequence fields."
FROM <catalog>.<schema_data>.f4602 h
LEFT JOIN <catalog>.<schema_data>.f4100 f
  ON f.LMLOCN = h.IFLOCN
 AND f.LMMCU = h.IFMCU
LEFT JOIN <catalog>.<schema_data>.f41021 loc
  ON loc.LIITM = h.IFITM
 AND loc.LIMCU = h.IFMCU
 AND loc.LILOCN = h.IFLOCN
 AND loc.LILOTN = h.IFLOTN
WHERE
  h.IFITM = <ITM>
  AND h.IFMCU = '<MCU>'
ORDER BY h.IFITM;