P49002

-- ============================================================
-- Program: P49002 Transportation Constants — the setup application that defines per-depot transportation defaults: shipment and load status flows, consolidation modes, weight/volume UOMs, and distance-calculation settings
-- Purpose: Transportation Constants — the setup application that defines per-depot transportation defaults: shipment and load status flows, consolidation modes, weight/volume UOMs, and distance-calculation settings — auto-generated boilerplate from program-table-map
-- Grain  : F0006 × F0006 — 1:N joins yield one row per detail line
-- Tables : F0006, 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.
-- Omitted: F0004, F0005 are cataloged for this program, but no verified join condition connects them to F0006, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  TRIM(f.MCMCU) AS "Business unit number - the key (right-justified, space-padded to 12)",
  f.MCDL01 AS "Business unit description",
  f.MCDL02 AS "Description line 2"
FROM <catalog>.<schema_data>.f0006 f
LEFT JOIN <catalog>.<schema_data>.f0006 f
  ON f.MCMCU = f.MCMCU
WHERE
  f.MCMCU = '<MCU>'
ORDER BY f.MCMCU;