AFKO

-- ============================================================
-- Table  : AFKO Order Header Data PP Orders
-- Purpose: Column-selected read of AFKO — auto-generated from field metadata
-- Grain  : One row per AUFNR
-- Notes  : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  h.MANDT      AS "Client",
  h.AUFNR      AS "Order Number",
  h.AUFPL      AS "Routing Number of Operations in the Order",
  h.STLNR      AS "Bill of Material",
  h.STLBEZ     AS "BOM Material Number",
  h.PLNTY      AS "Task List Type",
  h.PLNNR      AS "Key for Task List Group",
  h.PLNAL      AS "Group Counter",
  h.PLNME      AS "Task List Unit of Measure",
  h.STLAL      AS "Alternative BOM",
  h.STLAN      AS "BOM Usage",
  h.RSNUM      AS "Number of Reservation/Dependent Requirements",
  h.GLTRP      AS "Scheduled Finish (Basic)",
  h.GSTRP      AS "Scheduled Start (Basic)",
  h.GLTRS      AS "Scheduled Finish (Scheduled)",
  h.GSTRS      AS "Scheduled Start (Scheduled)",
  h.GLTRI      AS "Actual Finish (Confirmed)",
  h.GSTRI      AS "Actual Start (Confirmed)",
  h.FHORI      AS "Scheduling Margin Key",
  h.GAMNG      AS "Total Order Quantity",
  h.GMEIN      AS "Unit of Measure for Total Order Quantity",
  h.IGMNG      AS "Confirmed Yield",
  h.PLSVB      AS "To Lot Size",
  h.PLNBEZ     AS "Material Number",
  h.CY_SEQNR   AS "Sequence Number Counter for Repetitive Manufacturing",
  h.LEAD_AUFNR AS "Lead Order Number",
  h.FEVOR      AS "Production Supervisor"
FROM <catalog>.<schema>.afko h
WHERE
  h.MANDT = '<MANDT>'
  -- AND h.AUFNR = '<AUFNR>'
ORDER BY h.AUFNR;