F4101

-- ============================================================
-- 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;