SAP tableObjectEBANModuleMM_P2P

EBAN table — EBAN Purchase Requisition Item Table

EBAN stores one line item of a purchase requisition per row, keyed by requisition number BANFN and item number BNFPO. It holds the requested material or service, quantity, plant, account assignment category, release status, and, once the requisition has been converted, the resulting purchase order number and item. It does not hold the PO itself.

EBAN is the header-and-item combined table for purchase requisitions in MM procurement, one row per requisition item. This page covers the fields that matter for tracing a requisition through release strategy and conversion into a purchase order, the joins into EKPO and EBKN, and the pitfalls that come from EBAN holding both open and long-since-converted requisitions in the same table.

Published 15 Sept 2026· 1,060 words

What it stores

Each row in EBAN represents a single item of a purchase requisition, identified by requisition number BANFN and item number BNFPO. There is no separate requisition header table beyond a header-like grouping implied by BANFN; header and item attributes live together on the item row. A requisition item captures what is being requested (material or free-text description), how much, for which plant and storage location, under which account assignment category, and by when it is needed. The row also tracks the requisition's own lifecycle: creation, release status, deletion indicator, and, if the requisition has been converted, the purchase order number and item that resulted from it. EBAN rows persist after conversion and after deletion; they are not purged, so the table accumulates the full history of every requisition ever raised in the system.

Key fields

  • MANDT - client
  • BANFN - purchase requisition number
  • BNFPO - requisition item number
  • BSTYP - document category, distinguishes requisition from other purchasing documents
  • BSART - requisition document type
  • MATNR - material number, blank for free-text or service items
  • TXZ01 - short text description of the item
  • WERKS - plant
  • LGORT - storage location
  • MATKL - material group
  • MENGE - quantity requested
  • MEINS - order unit
  • KNTTP - account assignment category
  • LFDAT - delivery date required
  • BADAT - date the requisition was created
  • ERNAM - user who created the requisition
  • EKGRP - purchasing group
  • EKORG - purchasing organization
  • LIFNR - fixed or desired vendor, if specified
  • EBAKZ - deletion indicator for the item
  • STATU - processing status of the item
  • EBELN - purchase order number, populated once converted
  • EBELP - purchase order item number, populated once converted

How it joins the data model

  • EBAN-BANFN = EBKN-BANFN and EBAN-BNFPO = EBKN-BNFPO, account assignment lines for the requisition item
  • EBAN-MATNR = MARA-MATNR, material master link where the item is material-based
  • EBAN-MATNR = MARC-MATNR and EBAN-WERKS = MARC-WERKS, plant-level material data
  • EBAN-EBELN = EKPO-EBELN and EBAN-EBELP = EKPO-EBELP, the purchase order item created from this requisition
  • EBAN-LIFNR = LFA1-LIFNR, vendor master for a fixed or desired vendor on the requisition

How to read it safely

Always restrict on MANDT and never select the full table by BANFN range alone in a production system; requisition numbers accumulate for years and the table can be very large. The most selective starting filters are EKGRP, EKORG, WERKS, and a BADAT date range, or a specific BANFN if it is already known from an EKPO lookup. Avoid selecting on MATNR or MATKL alone across the whole client, those are low-selectivity fields that scan enormous ranges. If searching for open, unconverted requisitions, filter on EBELN being blank and EBAKZ not set, then narrow by EKGRP or WERKS before pulling volume.

How to prove it in the data

To confirm a requisition item was actually converted into a purchase order, select EBAN by BANFN and BNFPO and read EBELN and EBELP directly off the row; both blank means it is still open, both populated means it converted. Cross-check by going the other direction from EKPO where EKPO-BANFN and EKPO-BNFPO match, confirming the PO item genuinely traces back to that requisition item and not a coincidentally reused number from an earlier era.

ECC vs S/4HANA

EBAN continues to exist as a transparent table on S/4HANA and is still written by requisition creation and the purchase requisition Fiori apps as well as the classic transactions. Some newer requisition-related reporting is built on CDS views layered on top of EBAN rather than direct table reads, but the underlying persistence and field structure are essentially unchanged from ECC for the core fields listed here. Custom code and interfaces reading EBAN directly generally continue to work without remapping.

Common pitfalls

  • Assuming a blank EBELN means the requisition was never actioned. It can also mean the requisition was deleted (check EBAKZ) or rejected in release strategy without ever reaching conversion, which is a different business situation from simply pending.
  • Reading EBAN in isolation to judge release status. The release indicators on the item only make sense alongside the release strategy and classification tables; EBAN alone does not explain why a requisition is stuck, only that it is.
  • Treating EBELN and EBELP on the requisition as a live pointer. If the PO item is later deleted or the requisition is reused for a different follow-on document in some non-standard process, the values on EBAN may not reflect current PO reality; EKPO is the authoritative source for the PO side.
  • Forgetting that EBAN never gets cleaned up. Reporting on 'open requisitions' by material or plant without filtering the deletion indicator and conversion fields pulls in years of dead history alongside genuinely open demand.
  • Assuming one BANFN equals one line of business demand. A single requisition can have many items under BNFPO with completely different materials, plants, and account assignments; aggregating at BANFN level without grouping by BNFPO misrepresents the requisition's actual content.
  • Mixing up requisition quantity MENGE with quantity still open. EBAN does not track how much of the requisitioned quantity has already been ordered against; that comparison requires joining to EKPO and summing ordered quantities against the requisition item.

Whose problem this is

Purchasing questions on EBAN sit with the MM/procurement functional consultant, particularly release strategy and account assignment issues, which usually involve the requester's purchasing group and the release approver setup. Volume or performance questions on the table belong with basis or the ABAP team building the report, since the fix is usually a better selection, not a data correction.

Related SAP objects

Reviewed pages this object connects to in the ERPClimb knowledge graph.

Source: ERPClimb — https://erpclimb.com/sap-tables/ebanERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.