P4101

-- ============================================================
-- Program: P4101 Item Master — the interactive application that creates and maintains F4101 items
-- Purpose: Item Master — the interactive application that creates and maintains F4101 items — auto-generated boilerplate from program-table-map
-- Grain  : F4101 × F4102, F41021 — 1:N joins yield one row per detail line
-- Tables : F4101, F4102, 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
  im.IMITM AS "Short item number - the internal numeric item key",
  im.IMDSC1 AS "Description line 1",
  im.IMDSC2 AS "Description line 2",
  TRIM(ib.IBMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)",
  TRIM(loc.LIMCU) AS "Business unit / branch plant (right-justified, space-padded to 12)",
  loc.LILOCN AS "Storage location within the branch plant",
  loc.LILOTN AS "Lot or serial number"
FROM <catalog>.<schema_data>.f4101 im
LEFT JOIN <catalog>.<schema_data>.f4102 ib
  ON ib.IBITM = im.IMITM
LEFT JOIN <catalog>.<schema_data>.f41021 loc
  ON loc.LIITM = im.IMITM
WHERE
  im.IMITM = <ITM>
ORDER BY im.IMITM;