JDE Reference

P49002

Interactive

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

Module: 49 · Transportation Management
Lineage hook

Rows written by P49002 carry …PID = 'P49002' in their audit columns — a ready-made marker for isolating the records this program produced. See the audit-columns guide →

Notes

Its primary storage table (F49002) is not in the current catalog, so the map shows only supporting reads (branch/plant and UDC status values such as 49/SL).

Boilerplate SQL

Databricks SQL

Starting point for querying the tables behind this program. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters
-- ============================================================
-- 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, F0004, F0005 — 1:N joins yield one row per detail line
-- Tables : F0006, F0006, F0004, F0005
-- 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(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",
  dt.DTSY AS "System code the UDC type belongs to",
  dt.DTRT AS "User defined code type (the two-character table id)",
  udc.DRSY AS "System code of the UDC table",
  udc.DRRT AS "User defined code type within the system",
  TRIM(udc.DRKY) AS "The code value itself; short/numeric codes are stored right-justified with leading blanks - TRIM before joining"
FROM <catalog>.<schema_ctl>.f0006 f
LEFT JOIN <catalog>.<schema_ctl>.f0006 f
  ON f.MCMCU = f.MCMCU
LEFT JOIN <catalog>.<schema_ctl>.f0004 dt
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
LEFT JOIN <catalog>.<schema_ctl>.f0005 udc
  ON 1 = 1  -- TODO: define join condition (no shared aliases detected)
WHERE
  f.MCMCU = '<MCU>'
ORDER BY f.MCMCU;

3 parameters not filled: <catalog>, <schema_ctl>, <MCU>

Tables Used by This Program