JDE Reference

P41026

Interactive

Item Branch/Plant — assign items to branch/plants and maintain branch-level item attributes and locations

Module: 41 · Inventory Management
Lineage hook

Rows written by P41026 carry …PID = 'P41026' 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: P41026 Item Branch/Plant — assign items to branch/plants and maintain branch-level item attributes and locations
-- Purpose: Item Branch/Plant — assign items to branch/plants and maintain branch-level item attributes and locations — auto-generated boilerplate from program-table-map
-- Grain  : F4102 × F41021, F4101, F41001 — 1:N joins yield one row per detail line
-- Tables : F4102, F41021, F4101, F41001
-- 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
  ib.IBITM AS "Short item number - the internal numeric item key",
  TRIM(ib.IBMCU) 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",
  f.CISY AS "System/product code the constants row belongs to (typically 41)."
FROM <catalog>.<schema_data>.f4102 ib
LEFT JOIN <catalog>.<schema_data>.f41021 loc
  ON loc.LIITM = ib.IBITM
 AND loc.LIMCU = ib.IBMCU
LEFT JOIN <catalog>.<schema_data>.f4101 im
  ON im.IMITM = ib.IBITM
LEFT JOIN <catalog>.<schema_data>.f41001 f
  ON f.CIMCU = ib.IBMCU
WHERE
  ib.IBITM = <ITM>
  AND ib.IBMCU = '<MCU>'
ORDER BY ib.IBITM;

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

Tables Used by This Program

How these tables connect. Nodes are clickable.

Join details

  • F4102F4101foreign key · N:1
    ON f4102.IBITM = f4101.IMITM
  • F41021F4101foreign key · N:1
    ON f41021.LIITM = f4101.IMITM