EKPO

-- ============================================================
-- Table  : EKPO Purchasing Document Item
-- Purpose: Column-selected read of EKPO — auto-generated from field metadata
-- Grain  : One row per EBELN + EBELP
-- 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.EBELN AS "Purchasing Document Number",
  l.EBELP AS "Item Number of Purchasing Document",
  l.LOEKZ AS "Deletion Indicator in Purchasing Document",
  l.STATU AS "RFQ Status",
  l.AEDAT AS "Change Date of the Item",
  l.TXZ01 AS "Short Text",
  l.MATNR AS "Material Number",
  l.EMATN AS "Material Number for MPN Material",
  l.BUKRS AS "Company Code",
  l.WERKS AS "Plant",
  l.LGORT AS "Storage Location",
  l.BEDNR AS "Requirement Tracking Number",
  l.MATKL AS "Material Group",
  l.INFNR AS "Number of Purchasing Info Record",
  l.IDNLF AS "Material Number Used by Vendor",
  l.KTMNG AS "Target Quantity in Purchasing Document Item",
  l.MENGE AS "Purchase Order Quantity",
  l.MEINS AS "Purchase Order Unit of Measure",
  l.BPRME AS "Order Price Unit (Purchasing)",
  l.BPUMZ AS "Numerator for Conversion of Order Price Unit into Order Unit",
  l.BPUMN AS "Denominator for Conversion of Order Price Unit into Order Unit",
  l.UMREZ AS "Numerator for Conversion of Order Unit to Base Unit",
  l.UMREN AS "Denominator for Conversion of Order Unit to Base Unit",
  l.NETPR AS "Net Price in Purchasing Document (in Document Currency)",
  l.PEINH AS "Price Unit",
  l.NETWR AS "Net Order Value in PO Currency",
  l.BRTWR AS "Gross Order Value in PO Currency",
  l.AGDAT AS "Deadline for Submission of Bid/Quotation",
  l.WEBAZ AS "Goods Receipt Processing Time in Days",
  l.MWSKZ AS "Tax on Sales/Purchases Code",
  l.BONUS AS "Settlement Group 1 (Purchasing)",
  l.INSMK AS "Stock Type",
  l.SPINF AS "Update Info Record",
  l.PRSDR AS "Price Printout",
  l.SCHPR AS "Estimated Price Indicator",
  l.MAHNZ AS "Number of Reminders/Expeditors",
  l.BSTYP AS "Purchasing Document Category",
  l.XOBLR AS "Item Affects Commitments",
  l.KONNR AS "Number of Principal Purchase Agreement"
  -- … plus 32 more columns — full list in the Fields section above
FROM <catalog>.<schema>.ekpo l
WHERE
  l.MANDT = '<MANDT>'
ORDER BY l.EBELN;