P30006

-- ============================================================
-- Program: P30006 Work Center Revision — the screen for defining work centers and their rates, crew sizes, capacity, and dispatch details used by routings and costing.
-- Purpose: Work Center Revision — the screen for defining work centers and their rates, crew sizes, capacity, and dispatch details used by routings and costing. — auto-generated boilerplate from program-table-map
-- Grain  : F30006 × F0006 — 1:N joins yield one row per detail line
-- Tables : F30006, F0006
-- 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.IWMCU) AS "Work center identifier — itself a business unit in the F0006 sense.",
  TRIM(h.IWMMCU) AS "Branch/plant the work center belongs to."
FROM <catalog>.<schema_data>.f30006 h
LEFT JOIN <catalog>.<schema_ctl>.f0006 mc
  ON mc.MCMCU = h.IWMCU
WHERE
  h.IWMCU = '<MCU>'
ORDER BY h.IWMCU;