JDE Reference

P41001

Interactive

Branch/Plant Constants — define per-branch inventory rules: availability calculation, location format, and lot processing

Module: 41 · Inventory Management
Lineage hook

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

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: P41001 Branch/Plant Constants — define per-branch inventory rules: availability calculation, location format, and lot processing
-- Purpose: Branch/Plant Constants — define per-branch inventory rules: availability calculation, location format, and lot processing — auto-generated boilerplate from program-table-map
-- Grain  : F41001 × F0006 — 1:N joins yield one row per detail line
-- Tables : F41001, 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
  h.CISY AS "System/product code the constants row belongs to (typically 41).",
  TRIM(h.CIMCU) AS "Branch/plant (business unit); stored right-justified with leading blanks."
FROM <catalog>.<schema_data>.f41001 h
LEFT JOIN <catalog>.<schema_ctl>.f0006 mc
  ON mc.MCMCU = h.CIMCU
WHERE
  h.CIMCU = '<MCU>'
ORDER BY h.CIMCU;

4 parameters not filled: <catalog>, <schema_data>, <schema_ctl>, <MCU>

Tables Used by This Program