AFPO

-- ============================================================
-- Table  : AFPO Order Item
-- Purpose: Column-selected read of AFPO — auto-generated from field metadata
-- Grain  : One row per AUFNR + POSNR
-- 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
  l.MANDT AS "Client",
  l.AUFNR AS "Order Number",
  l.POSNR AS "Order Item Number",
  l.MATNR AS "Material Number",
  l.DWERK AS "Plant",
  l.LGORT AS "Storage Location",
  l.PSMNG AS "Order Item Quantity",
  l.WEMNG AS "Delivered Quantity",
  l.PAMNG AS "Scrap Quantity",
  l.WEBAZ AS "Goods Receipt Processing Time in Days",
  l.CHARG AS "Batch Number",
  l.LTRMI AS "Actual Delivery / Finish Date",
  l.STRMP AS "Start Date from Planned Order",
  l.KDAUF AS "Sales Order Number",
  l.KDPOS AS "Sales Order Item",
  l.LTRMP AS "Delivery Date from Planned Order",
  l.KRSNR AS "Number of Reservation/Dependent Requirements",
  l.PLNUM AS "Planned Order Number",
  l.PROJN AS "Work Breakdown Structure Element (WBS Element)"
FROM <catalog>.<schema>.afpo l
WHERE
  l.MANDT = '<MANDT>'
  -- AND l.AUFNR = '<AUFNR>'
ORDER BY l.AUFNR;