EBAN

-- ============================================================
-- Table  : EBAN Purchase Requisition
-- Purpose: Column-selected read of EBAN — auto-generated from field metadata
-- Grain  : One row per BANFN + BNFPO
-- 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.BANFN AS "Purchase Requisition Number",
  h.BNFPO AS "Item Number of Purchase Requisition",
  h.BSART AS "Purchasing Document Type",
  h.BSTYP AS "Purchasing Document Category",
  h.LOEKZ AS "Deletion Indicator",
  h.STATU AS "Processing status of purchase requisition",
  h.ESTKZ AS "Creation Indicator (Purchase Requisition/Schedule Lines)",
  h.FRGKZ AS "Release Indicator",
  h.FRGST AS "Release Strategy in the Purchase Requisition",
  h.FRGZU AS "Release Status",
  h.ERNAM AS "Name of Person Who Created the Object",
  h.ERDAT AS "Last Changed On",
  h.TXZ01 AS "Short Text",
  h.MATNR AS "Material Number",
  h.EMATN AS "Material Number for MPN Material",
  h.WERKS AS "Plant",
  h.LGORT AS "Storage Location",
  h.BEDNR AS "Requirement Tracking Number",
  h.MATKL AS "Material Group",
  h.BADAT AS "Requisition (Request) Date",
  h.MENGE AS "Requested Quantity",
  h.MEINS AS "Unit of Measure",
  h.LFDAT AS "Delivery Date",
  h.EKGRP AS "Purchasing Group",
  h.EKORG AS "Purchasing Organization",
  h.LIFNR AS "Desired Vendor",
  h.FLIEF AS "Fixed Vendor",
  h.AFNAM AS "Name of Requisitioner/Requester",
  h.KNTTP AS "Account Assignment Category",
  h.KZVBR AS "Consumption Posting",
  h.PSTYP AS "Item Category in Purchasing Document",
  h.EBELN AS "Purchase Order Number (Assigned)",
  h.EBELP AS "Item Number of Purchase Order",
  h.PREIS AS "Price in Purchase Requisition",
  h.PEINH AS "Price Unit",
  h.WAERS AS "Currency Key",
  h.LPEIN AS "Category of Delivery Date",
  h.INFNR AS "Number of Purchasing Info Record"
FROM <catalog>.<schema>.eban h
WHERE
  h.MANDT = '<MANDT>'
ORDER BY h.BANFN;