F4009

-- ============================================================
-- Table  : F4009 Distribution/inventory constants - system-level configuration flags stored one row per system code
-- Purpose: Column-selected read of F4009 — auto-generated from field metadata
-- Grain  : One row per CPSY
-- 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
  f.CPSY AS "System code the constants row belongs to (distribution constants live under one row per system)",
  f.CPBUMC AS "Flag: unit-of-measure conversions are defined per branch/plant",
  f.CPBSDB AS "Flag: supplemental database is kept by branch/plant",
  f.CPULOT AS "Whether duplicate lot numbers are allowed",
  f.CPAVGC AS "Flag: average cost is updated online instead of by batch job",
  f.CPADVP AS "Advanced sales pricing enabled",
  f.CPUMB1 AS "Unit of measure used when retrieving sales prices",
  f.CPCP01 AS "Which date drives sales price selection",
  f.CPCP02 AS "Symbol that identifies a variable table in pricing",
  f.CPCP03 AS "Symbol that identifies a unit of measure in pricing",
  f.CPCP04 AS "Symbol that identifies a currency code in pricing",
  f.CPCP05 AS "Symbol that identifies a database field in pricing",
  f.CPCP06 AS "Unit of measure used when retrieving purchase prices",
  f.CPCP07 AS "Category code used for purchase rebates",
  f.CPCP08 AS "Pricing audit history enabled",
  f.CPCP09 AS "Internal PPAT message flag for pricing",
  f.CPCP10 AS "Non-coexisting lot processing flag",
  f.CPCCTL AS "ECS (energy/chemical) control flag",
  f.CPSADR AS "Ship-ascending-date rule enabled",
  f.CPCP11 AS "Advanced procurement pricing enabled",
  f.CPCP12 AS "Scientific rounding option",
  f.CPCP13 AS "Price changes require approval",
  f.CPCP14 AS "Which date drives procurement cost selection",
  f.CPCP15 AS "Reserved constants flag 15",
  f.CPCP16 AS "Audit log used for sales order changes",
  f.CPCP17 AS "Reason code required on order changes",
  f.CPCP18 AS "Approval process required for order changes",
  f.CPCP19 AS "Customer set functionality enabled",
  f.CPCP20 AS "Prepayment processing enabled",
  f.CPCHDC AS "Critical hold decoupling flag",
  f.CPELOT AS "Enhanced lot processing enabled",
  f.CPAJRM AS "Adjustment retrieval method for pricing",
  f.CPOSTP AS "Organization structure type used by pricing",
  f.CPPRAD AS "Pricing address selection flag",
  f.CPCP22 AS "Unit of measure used for preference retrieval",
  f.CPPRSN AS "Default preference schedule",
  f.CPPMRF AS "How overlapping promotions are resolved",
  f.CPPRSF AS "Promotions system enabled",
  f.CPCP23 AS "Reserved future-use flag 23",
  f.CPCP24 AS "Reserved future-use flag 24"
  -- … plus 10 more columns — full list in the Fields section above
FROM <catalog>.<schema_data>.f4009 f
ORDER BY f.CPSY;