JDE Reference
F4101
masterAlso in JDE WorldItem master — one row per item with descriptions, units of measure, and category codes shared across branches
Module: 41 · Inventory ManagementColumn prefix: IM
What the badges mean
- Superseded
- Superseded — a newer table has replaced it, but older scripts still read this one.
- Also in JDE World
- Also present in JDE World A9.x on the same table name.
- master
- Data class: what the table holds — master data, transaction documents, control/setup values, history, or a workfile.
- Read/write access
- Access mode: how the paired program reads or writes this table — R (read), W (write), or R/W (both).
No lifecycle badge means the table is current and not documented in JDE World. In field listings, K marks a primary-key field.
Used in the library
Dashboard patterns
D-01Inventory Health
Cross-ERP guides
Fields
32 fields · 1 key
32 fields.
| Key | Field | Alias | Description | Type | Length | Flags |
|---|---|---|---|---|---|---|
| Primary key | IMITM | ITM | Short item number - the internal numeric item key | Numeric | 8 | |
| IMLITM | LITM | Second item number - the primary user-facing item code | String | 25 | ||
| IMAITM | AITM | Third item number - catalog or cross-reference item code | String | 25 | ||
| IMDSC1 | DSC1 | Description line 1 | String | 30 | ||
| IMDSC2 | DSC2 | Description line 2 | String | 30 | ||
| IMSRTX | SRTX | Search text used by item lookup | String | 30 | ||
| IMSTKT | STKT | Stocking type - how the item is stocked/made/purchased | Character | 1 | ||
| IMGLPT | GLPT | G/L class code driving inventory account derivation through AAIs | String | 4 | ||
| IMLNTY | LNTY | Default line type used when the item is ordered | String | 2 | ||
| IMPDGR | PDGR | Product group for pricing | String | 3 | ||
| IMUOM1 | UOM1 | Primary unit of measure | String | 2 | ||
| IMUOM2 | UOM2 | Secondary unit of measure | String | 2 | ||
| IMUOM3 | UOM3 | Purchasing unit of measure | String | 2 | ||
| IMUOM4 | UOM4 | Pricing unit of measure | String | 2 | ||
| IMUOM6 | UOM6 | Shipping unit of measure | String | 2 | ||
| IMSLD | SLD | Shelf life in days | Numeric | 6 | ||
| IMBBDD | BBDD | Default days used to compute the best-before date | Numeric | 6 | ||
| IMCDCD | CDCD | Commodity code | String | 15 | ||
| IMABCS | ABCS | ABC ranking by sales | Character | 1 | ||
| IMLOTS | LOTS | Default lot status code | Character | 1 | ||
| IMSRP0 | SRP0 | Sales category code 10 (6-char) | String | 6 | ||
| IMSRP1 | SRP1 | Sales category code 1 - catalog section | String | 3 | ||
| IMSRP2 | SRP2 | Sales category code 2 - sub section | String | 3 | ||
| IMSRP3 | SRP3 | Sales category code 3 | String | 3 | ||
| IMSRP4 | SRP4 | Sales category code 4 | String | 3 | ||
| IMSRP5 | SRP5 | Sales category code 5 | String | 3 | ||
| IMPRP0 | PRP0 | Purchasing category code - item pool (6-char) | String | 6 | ||
| IMPRP1 | PRP1 | Purchasing category code 1 - commodity class | String | 3 | ||
| IMPRP2 | PRP2 | Purchasing category code 2 - commodity sub class | String | 3 | ||
| IMPRP3 | PRP3 | Purchasing category code 3 - supplier rebate code | String | 3 | ||
| IMPRP4 | PRP4 | Purchasing category code 4 - master planning family | String | 3 | ||
| IMPRP5 | PRP5 | Purchasing category code 5 | String | 3 |
Field provenance: hand-curated.
Boilerplate SQL
Starting point for reading F4101 on Databricks — Julian dates, implied decimals, and padded strings are already converted. Set your Unity Catalog location and filter values below; they’re substituted into the SQL and the copy button.
Query parameters
3 parameters not filled: <catalog>, <schema_data>, <ITM>
-- ============================================================
-- Table : F4101 Item master — one row per item with descriptions, units of measure, and category codes shared across branches
-- Purpose: Column-selected read of F4101 — auto-generated from field metadata
-- Grain : One row per IMITM
-- Notes : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. 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
im.IMITM AS "Short item number - the internal numeric item key",
im.IMLITM AS "Second item number - the primary user-facing item code",
im.IMAITM AS "Third item number - catalog or cross-reference item code",
im.IMDSC1 AS "Description line 1",
im.IMDSC2 AS "Description line 2",
im.IMSRTX AS "Search text used by item lookup",
im.IMSTKT AS "Stocking type - how the item is stocked/made/purchased",
im.IMGLPT AS "G/L class code driving inventory account derivation through AAIs",
im.IMLNTY AS "Default line type used when the item is ordered",
im.IMPDGR AS "Product group for pricing",
im.IMUOM1 AS "Primary unit of measure",
im.IMUOM2 AS "Secondary unit of measure",
im.IMUOM3 AS "Purchasing unit of measure",
im.IMUOM4 AS "Pricing unit of measure",
im.IMUOM6 AS "Shipping unit of measure",
im.IMSLD AS "Shelf life in days",
im.IMBBDD AS "Default days used to compute the best-before date",
im.IMCDCD AS "Commodity code",
im.IMABCS AS "ABC ranking by sales",
im.IMLOTS AS "Default lot status code",
im.IMSRP0 AS "Sales category code 10 (6-char)",
im.IMSRP1 AS "Sales category code 1 - catalog section",
im.IMSRP2 AS "Sales category code 2 - sub section",
im.IMSRP3 AS "Sales category code 3",
im.IMSRP4 AS "Sales category code 4",
im.IMSRP5 AS "Sales category code 5",
im.IMPRP0 AS "Purchasing category code - item pool (6-char)",
im.IMPRP1 AS "Purchasing category code 1 - commodity class",
im.IMPRP2 AS "Purchasing category code 2 - commodity sub class",
im.IMPRP3 AS "Purchasing category code 3 - supplier rebate code",
im.IMPRP4 AS "Purchasing category code 4 - master planning family",
im.IMPRP5 AS "Purchasing category code 5"
FROM <catalog>.<schema_data>.f4101 im
WHERE
im.IMITM = <ITM>
ORDER BY im.IMITM;Verified September 2026
Relationships
Diagram of 1-hop neighbors — join details below. UDC decode edges point coded fields at their F0005 lookup.
Join details
ON f4211.SDITM = f4101.IMITMON f4102.IBITM = f4101.IMITMON f41021.LIITM = f4101.IMITMON f4111.ILITM = f4101.IMITMON f0005.DRSY = '41' AND f0005.DRRT = '9' AND TRIM(f0005.DRKY) = TRIM(f4101.IMGLPT)ON f4311.PDITM = f4101.IMITMON f41061.CBITM = f4101.IMITMON f4106.BPITM = f4101.IMITMON f4104.IVITM = f4101.IMITMON f4108.IOITM = f4101.IMITMON f41002.UMITM = f4101.IMITMON f3002.IXITM = f4101.IMITMON f3002.IXKIT = f4101.IMITMON f3003.IRKIT = f4101.IMITMON f3111.WMCPIT = f4101.IMITMON f3460.MFITM = f4101.IMITMON f3412.MWITM = f4101.IMITMON f3412.MWKIT = f4101.IMITMON f4602.IFITM = f4101.IMITMON f46010.IPITM = f4101.IMITMON f46011.IQITM = f4101.IMITM
Programs That Use This Table
R read · W write · R/W read + write
Primary programs
Secondary programs
- P3002Bill of Material Revisions — the screen where engineering builds and maintains bills of material: components, quantities per, effectivity dates, and substitutes.Read accessInteractive
- P3460Forecast Revisions — the screen where planners review and manually adjust detail forecast quantities and amounts by item, branch, and forecast type.Read accessInteractive
- P41026Item Branch/Plant — assign items to branch/plants and maintain branch-level item attributes and locationsRead accessInteractive
- P4105Cost Revisions — maintain item costs by cost method and branch/plant, generating variance journal entries on changeRead accessInteractive
- P4106Base Price Revisions — maintain base sales prices by item, branch, customer, or customer group with effective datesRead accessInteractive
- P41061Supplier Catalog Maintenance — maintain supplier price catalogs used for purchase price retrieval at PO entryRead accessInteractive
- P41202Item Availability — inquire on on-hand, committed, and available quantities by item, branch, location, and lotRead accessInteractive
- P4310Purchase Order Entry — create and revise purchase orders, requisitions, and quotes (header and detail lines)Read accessInteractive
- P46010Item Profile Revisions — the setup application that defines each item's warehouse behavior: default pick/replenishment zones, process groups for movement instructions, and overflow handlingRead accessInteractive
- P46011Item Unit of Measure Definition — the setup application that defines the UOM structure (pallet, case, each) the warehouse uses for an item, including capacity, weight, and breakdown rules per unit of measureRead accessInteractive
- R34650Forecast Generation — the batch job that builds statistical demand forecasts from sales history, testing up to twelve forecasting methods and keeping the best fit per item.Read accessBatch UBE
- R49115Transportation Bill of Lading — the batch print job that produces bill of lading documents for confirmed shipments, with options for delivery instructions and shipment attachmentsRead accessBatch UBE
More Inventory Management tables
- F4102Item branch — branch/plant-level item attributes, planning parameters, and sourcing responsibility
- F41021Item location — on-hand, committed, and inbound quantities by item, branch, location, and lot
- F4104Item cross-reference: links internal item numbers to external identifiers such as customer or supplier part numbers, substitutes, and replacements, keyed by cross-reference type.
- F4105Item cost table: one row per item, branch, location, lot, and cost method carrying the unit cost used to value inventory and purchasing transactions.
- F4108Lot master: one row per lot or serial number by item and branch, holding lot status, grade, potency, supplier lot linkage, and the full set of lot control dates.
- F4111Item ledger (Cardex) — every inventory movement with quantity, cost, and links back to source documents