Follow us on LinkedIn for your next SAP project

SAP Table EBAN

Purchase Requisition

EBAN (Purchase Requisition) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EBAN to other SAP tables.

A purchase requisition is a request or instruction to Purchasing to procure a certain quantity of a material or a service so that it is available at a certain point in time. A purchase requisition is an internal document. It I not used outside the organization.

Purchase requisitions only have a line item table in SAP. There are no header details. A purchase requisition is usually followed by a purchase document (like a purchase order) in a typical MM flow.

EBAN table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
BANFN
Purchase Requisition Number
BANFN
CHAR
10 0
BNFPO
Item Number of Purchase Requisition
BNFPO
NUMC
5 0
BSART
Purchase Requisition Document Type
BBSRT T161
CHAR
4 0
BSTYP
Purchasing Document Category
BSTYP
CHAR
1 0
BSAKZ
Control indicator for purchasing document type
BSAKZ
CHAR
1 0
LOEKZ
Deletion Indicator in Purchasing Document
ELOEK
CHAR
1 0
STATU
Processing status of purchase requisition
BANST
CHAR
1 0
ESTKZ
Creation Indicator (Purchase Requisition/Schedule Lines)
ESTKZ
CHAR
1 0
FRGKZ
Release Indicator
FRGKZ T161S
CHAR
1 0
FRGZU
Release status
FRGZU
CHAR
8 0
FRGST
Release Strategy in Purchase Requisition
FRGST
CHAR
2 0
EKGRP
Purchasing Group
EKGRP T024
CHAR
3 0
ERNAM
Name of Person who Created the Object
ERNAM
CHAR
12 0
ERDAT
Changed On
AEDAT
DATS
8 0
AFNAM
Name of Requisitioner/Requester
AFNAM
CHAR
12 0
TXZ01
Short Text
TXZ01
CHAR
40 0
MATNR
Material Number
MATNR MARA
CHAR
18 0
EMATN
Material Number Corresponding to Manufacturer Part Number
EMATN MARA
CHAR
18 0
WERKS
Plant
EWERK T001W
CHAR
4 0
LGORT
Storage Location
LGORT_D T001L
CHAR
4 0
BEDNR
Requirement Tracking Number
BEDNR
CHAR
10 0
MATKL
Material Group
MATKL T023
CHAR
9 0
RESWK
Supplying (Issuing) Plant in Stock Transport Order
RESWK
CHAR
4 0
MENGE
Purchase Requisition Quantity
BAMNG
QUAN
13 3
MEINS
Purchase Requisition Unit of Measure
BAMEI T006
UNIT
3 0
BUMNG
Shortage (stock undercoverage) quantity
BUMNG
QUAN
13 3
BADAT
Requisition (Request) Date
BADAT
DATS
8 0
LPEIN
Category of Delivery Date
LPEIN TPRG
CHAR
1 0
LFDAT
Item Delivery Date
EINDT
DATS
8 0
FRGDT
Purchase Requisition Release Date
FRGDT
DATS
8 0
WEBAZ
Goods Receipt Processing Time in Days
WEBAZ
DEC
3 0
PREIS
Price in Purchase Requisition
BAPRE
CURR
11 2
PEINH
Price Unit
EPEIN
DEC
5 0
PSTYP
Item Category in Purchasing Document
PSTYP T163
CHAR
1 0
KNTTP
Account Assignment Category
KNTTP T163K
CHAR
1 0
KZVBR
Consumption Posting
KZVBR
CHAR
1 0
KFLAG
Acct.asst.changeable
KFLAG
CHAR
1 0
VRTKZ
Distribution indicator for multiple account assignment
VRTKZ
CHAR
1 0
TWRKZ
Partial Invoice Indicator
TWRKZ
CHAR
1 0
WEPOS
Goods Receipt Indicator
WEPOS
CHAR
1 0
WEUNB
Goods Receipt, Non-Valuated
WEUNB
CHAR
1 0
REPOS
Invoice Receipt Indicator
REPOS
CHAR
1 0
LIFNR
Desired Vendor
WLIEF LFA1
CHAR
10 0
FLIEF
Fixed Vendor
FLIEF LFA1
CHAR
10 0
EKORG
Purchasing Organization
EKORG T024E
CHAR
4 0
VRTYP
Purchasing Document Category
BSTYP
CHAR
1 0
KONNR
Number of Principal Purchase Agreement
KONNR EKKO
CHAR
10 0
KTPNR
Item Number of Principal Purchase Agreement
KTPNR EKPO
NUMC
5 0
INFNR
Number of Purchasing Info Record
INFNR EINA
CHAR
10 0
ZUGBA
Assigned Source of Supply
DZUGBA
CHAR
1 0
QUNUM
Number of Quota Arrangement
QUNUM
CHAR
10 0
QUPOS
Quota Arrangement Item
QUPOS
NUMC
3 0
DISPO
MRP Controller (Materials Planner)
DISPO T024D
CHAR
3 0
SERNR
BOM explosion number
SERNR
CHAR
8 0
BVDAT
Date of last resubmission
BVDAT
DATS
8 0
BATOL
Resubmission Interval of Purchase Requisition
BATOL
DEC
3 0
BVDRK
Number of resubmissions
BVDRK
DEC
7 0
EBELN
Purchase Order Number
BSTNR EKKO
CHAR
10 0
EBELP
Purchase Order Item Number
BSTPO EKPO
NUMC
5 0
BEDAT
Purchase Order Date
BEDAT
DATS
8 0
BSMNG
Quantity Ordered Against this Purchase Requisition
BSMNG
QUAN
13 3
LBLNI
Entry Sheet Number
LBLNI ESSR
CHAR
10 0
BWTAR
Valuation Type
BWTAR_D T149D
CHAR
10 0
XOBLR
Item affects commitments
XOBLR
CHAR
1 0
EBAKZ
Purchase Requisition Closed
EBAKZ
CHAR
1 0
RSNUM
Number of Reservation/Dependent Requirement
RSNUM
NUMC
10 0
SOBKZ
Special Stock Indicator
SOBKZ T148
CHAR
1 0
ARSNR
Settlement reservation number
ARSNR
NUMC
10 0
ARSPS
Item number of the settlement reservation
ARSPS
NUMC
4 0
FIXKZ
Purchase Requisition is Fixed
BAFIX
CHAR
1 0
BMEIN
Purchase Order Unit of Measure
BSTME T006
UNIT
3 0
REVLV
Revision Level
REVLV
CHAR
2 0
VORAB
Advance procurement: project stock
VORAB
CHAR
1 0
PACKNO
Package number
PACKNO ESLH
NUMC
10 0
KANBA
Kanban Indicator
KBNKZ
CHAR
1 0
BPUEB
Adopt Requisition Price in Purchase Order
BPUEB
CHAR
1 0
CUOBJ
Configuration (internal object number)
CUOBJ
NUMC
18 0
FRGGR
Release group
FRGGR T16FG
CHAR
2 0
FRGRL
Release Not Yet Completely Effected
FRGRL
CHAR
1 0
AKTNR
Promotion
WAKTION WAKH
CHAR
10 0
CHARG
Batch Number
CHARG_D
CHAR
10 0
UMSOK
Special Stock Indicator for Physical Stock Transfer
UMSOK
CHAR
1 0
VERID
Production Version
VERID
CHAR
4 0
FIPOS
Commitment Item
FIPOS
CHAR
14 0
FISTL
Funds Center
FISTL
CHAR
16 0
GEBER
Fund
BP_GEBER
CHAR
10 0
KZKFG
Origin of Configuration
KZCUH
CHAR
1 0
SATNR
Cross-Plant Configurable Material
SATNR
CHAR
18 0
MNG02
Committed Quantity
MNG06
QUAN
13 3
DAT01
Committed Date
DAT05
DATS
8 0
ATTYP
Material Category
ATTYP
CHAR
2 0
ADRNR
Manual address number in purchasing document item
ADRNR_MM ADRC
CHAR
10 0
ADRN2
Number of delivery address
ADRN2 ADRC
CHAR
10 0
KUNNR
Customer
EKUNNR KNA1
CHAR
10 0
EMLIF
Vendor to be supplied/who is to receive delivery
EMLIF LFA1
CHAR
10 0
LBLKZ
Subcontracting vendor
LBLKZ
CHAR
1 0
KZBWS
Valuation of Special Stock
KZBWS
CHAR
1 0
WAERS
Currency Key
WAERS TCURC
CUKY
5 0
IDNLF
Material Number Used by Vendor
IDNLF
CHAR
35 0
GSFRG
Overall release of purchase requisitions
GSFRG
CHAR
1 0
MPROF
Manufacturer Part Profile
MPROF
CHAR
4 0
KZFME
Units of measure usage
KZWSO
CHAR
1 0
SPRAS
Language Key
SPRAS T002
LANG
1 0
TECHS
Parameter Variant/Standard Variant
TECHS
CHAR
12 0
MFRPN
Manufacturer Part Number
MFRPN
CHAR
40 0
MFRNR
Number of a Manufacturer
MFRNR LFA1
CHAR
10 0
EMNFR
External manufacturer code name or number
EMNFR
CHAR
10 0
FORDN
Framework Order
SFORDN
CHAR
10 0
FORDP
Item of framework order
FORDP
NUMC
5 0
PLIFZ
Planned Delivery Time in Days
PLIFZ
DEC
3 0
BERID
MRP Area
BERID
CHAR
10 0
UZEIT
Delivery Date Time-Spot
LZEIT
TIMS
6 0
FKBER
Functional Area
FKBER
CHAR
16 0
GRANT_NBR
Grant
GM_GRANT_NBR
CHAR
20 0
MEMORY
Purchase Requisition not yet Complete
MEMBF
CHAR
1 0
BANPR
Requisition Processing State
BANPR
CHAR
2 0
RLWRT
Total value at time of release
RLWRT
CURR
15 2
BLCKD
Purchase Requisition Blocked
BLCKD
CHAR
1 0
REVNO
Version number in Purchasing
REVNO
CHAR
8 0
BLCKT
Reason for Item Block
BLCKT
CHAR
60 0
BESWK
Procuring Plant
BESWK T001W
CHAR
4 0
EPROFILE
External Procurement Profile
MEPROFILE
CHAR
2 0
EPREFDOC
External Procurement Reference Document
EPREFDOC
CHAR
10 0
EPREFITM
External Procurement Reference Item
EPREFITM
NUMC
5 0
GMMNG
PO Quantity of Purchase Requisition in POs on Hold
GMMNG
QUAN
13 3
WRTKZ
Value-Based Commitment Reduction for Service Purchase Reqs
WRTKZ
CHAR
1 0
RESLO
Issuing Storage Location for Stock Transport Order
RESLO
CHAR
4 0
KBLNR
Document Number for Earmarked Funds
KBLNR
CHAR
10 0
KBLPOS
Earmarked Funds: Document Item
KBLPOS
NUMC
3 0
PRIO_URG
Requirement Urgency
PRIO_URG PURG
NUMC
2 0
PRIO_REQ
Requirement Priority
PRIO_REQ PREQ
NUMC
3 0
MEMORYTYPE
Category of Incompleteness
MEMORYTYPE
CHAR
1 0
ANZSN
Number of serial numbers
ANZSN
INT4
10 0
MHDRZ
Minimum Remaining Shelf Life
MHDRZ
DEC
4 0
IPRKZ
Period Indicator for Shelf Life Expiration Date
DATTP
CHAR
1 0
NODISP
Ind: Reserv. not applicable to MRP;Purc. req. not created
NODISP
CHAR
1 0
SRM_CONTRACT_ID
Central Contract
SRM_CONTRACT_ID
CHAR
10 0
SRM_CONTRACT_ITM
Central Contract Item Number
SRM_CONTRACT_ITEM
NUMC
10 0
BUDGET_PD
FM: Budget Period
FM_BUDGET_PERIOD
CHAR
10 0
ADVCODE
Advice Code
/ISDFPS/ADVCODE /ISDFPS/ADVCODE2
CHAR
2 0
STACODE
Status Code
/ISDFPS/STACODE /ISDFPS/CSTACODE
CHAR
2 0
BANFN_CS
Cross-System PReq Number
/ISDFPS/BANFN_CS
CHAR
10 0
BNFPO_CS
Cross-System PReq Item
/ISDFPS/BNFPO_CS
NUMC
5 0
ITEM_CS
Cross-System Item Category
/ISDFPS/ITEM_CS
CHAR
1 0
BSMNG_SND
PO Quantity Sender
/ISDFPS/BSMNG_SND
QUAN
13 3
NO_MARD_DATA
No Storage Location Data Exists for Material
/ISDFPS/NO_MARD_DATA
CHAR
1 0
SERRU
Type of subcontracting
SERRU
CHAR
1 0
DISUB_SOBKZ
Special stock indicator Subcontracting
DISUB_SOBKZ_LB
CHAR
1 0
DISUB_PSPNR
Work Breakdown Structure Element (WBS Element)
PS_PSP_PNR
NUMC
8 0
DISUB_KUNNR
Customer Number
KUNNR
CHAR
10 0
DISUB_VBELN
Sales and Distribution Document Number
VBELN
CHAR
10 0
DISUB_POSNR
Item number of the SD document
POSNR
NUMC
6 0
DISUB_OWNER
Owner of stock
OWNER_D
CHAR
10 0
IUID_RELEVANT
IUID-Relevant
IUID_RELEVANT
CHAR
1 0
OITAXFROM
Excise duty tax key for 'from' location
OIH_TAXFRO OIH4
CHAR
2 0
OIHANTYP
Excise Duty Handling Type
OIH_HANTYP OIH5
CHAR
2 0
OITAXTO
Excise duty tax key for 'to' location
OIH_TAXTO OIH4
CHAR
2 0
OITAXGRP
Excise Duty Group
OIH_TAXGRP OIH2
CHAR
2 0
OIOILCON
Oil content in a material as a percentage
OIH_OILCON
DEC
5 2
OIINEX
Code for internal or external excise duty rate determination
OIH_INEX OIH16
CHAR
2 0
OIPRICIE
ED pricing: external (indicator)
OIH_PRICIE
CHAR
1 0
OIO_SPROC
Supply Process
OIO_SPROC
CHAR
4 0
OIO_STATUS
Supply chain status
OIO_SC_STATUS
CHAR
1 0
OIO_REF_BANFN
Reference requisition number
OIO_REF_BANFN
CHAR
10 0
OIO_REF_BNFPO
Reference requisition item
OIO_REF_BNFPO
NUMC
5 0
OIO_HOLD
Indicator: Hold Delivery Onshore
OIO_HOLD
CHAR
1 0

EBAN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EBAN ADRN2 EBAN ADRN2 ADRC
Addresses (Business Address Services)
ADDRNUMBER
EBAN ADRN2 * ADRC
Addresses (Business Address Services)
DATE_FROM
EBAN ADRN2 * ADRC
Addresses (Business Address Services)
NATION
EBAN ADRN2 EBAN MANDT ADRC
Addresses (Business Address Services)
CLIENT
EBAN ADRNR * ADRC
Addresses (Business Address Services)
DATE_FROM
EBAN ADRNR * ADRC
Addresses (Business Address Services)
NATION
EBAN ADRNR EBAN MANDT ADRC
Addresses (Business Address Services)
CLIENT
EBAN ADRNR EBAN ADRNR ADRC
Addresses (Business Address Services)
ADDRNUMBER
EBAN ADVCODE EBAN MANDT /ISDFPS/ADVCODE2
Advice Code with Document Type
MANDT
EBAN ADVCODE EBAN BSART /ISDFPS/ADVCODE2
Advice Code with Document Type
BSART
EBAN ADVCODE EBAN ADVCODE /ISDFPS/ADVCODE2
Advice Code with Document Type
ADVCODE
EBAN AKTNR EBAN MANDT WAKH
Promotion Header Data, IS-R
MANDT
EBAN AKTNR EBAN AKTNR WAKH
Promotion Header Data, IS-R
AKTNR
EBAN BESWK EBAN MANDT T001W
Plants/Branches
MANDT
EBAN BESWK EBAN BESWK T001W
Plants/Branches
WERKS
EBAN BMEIN EBAN MANDT T006
Units of Measurement
MANDT
EBAN BMEIN EBAN BMEIN T006
Units of Measurement
MSEHI
EBAN BSART EBAN MANDT T161
Purchasing Document Types
MANDT
EBAN BSART EBAN BSTYP T161
Purchasing Document Types
BSTYP
EBAN BSART EBAN BSART T161
Purchasing Document Types
BSART
EBAN BWTAR EBAN MANDT T149D
Global Valuation Types
MANDT
EBAN BWTAR EBAN BWTAR T149D
Global Valuation Types
BWTAR
EBAN DISPO EBAN WERKS T024D
MRP controllers
WERKS
EBAN DISPO EBAN DISPO T024D
MRP controllers
DISPO
EBAN DISPO EBAN MANDT T024D
MRP controllers
MANDT
EBAN EBELN EBAN EBELN EKKO
Purchasing Document Header
EBELN
EBAN EBELN EBAN MANDT EKKO
Purchasing Document Header
MANDT
EBAN EBELP EBAN MANDT EKPO
Purchasing Document Item
MANDT
EBAN EBELP EBAN EBELN EKPO
Purchasing Document Item
EBELN
EBAN EBELP EBAN EBELP EKPO
Purchasing Document Item
EBELP
EBAN EKGRP EBAN MANDT T024
Purchasing Groups
MANDT
EBAN EKGRP EBAN EKGRP T024
Purchasing Groups
EKGRP
EBAN EKORG EBAN MANDT T024E
Purchasing Organizations
MANDT
EBAN EKORG EBAN EKORG T024E
Purchasing Organizations
EKORG
EBAN EMATN EBAN MANDT MARA
General Material Data
MANDT
EBAN EMATN EBAN EMATN MARA
General Material Data
MATNR
EBAN EMLIF EBAN EMLIF LFA1
Vendor Master (General Section)
LIFNR
EBAN EMLIF EBAN MANDT LFA1
Vendor Master (General Section)
MANDT
EBAN FLIEF EBAN MANDT LFA1
Vendor Master (General Section)
MANDT
EBAN FLIEF EBAN FLIEF LFA1
Vendor Master (General Section)
LIFNR
EBAN FRGGR EBAN MANDT T16FG
Release Groups
MANDT
EBAN FRGGR EBAN FRGGR T16FG
Release Groups
FRGGR
EBAN FRGKZ EBAN MANDT T161S
Release Indicator, Purchase Requisition
MANDT
EBAN FRGKZ EBAN FRGKZ T161S
Release Indicator, Purchase Requisition
FRGKZ
EBAN INFNR EBAN MANDT EINA
Purchasing Info Record: General Data
MANDT
EBAN INFNR EBAN INFNR EINA
Purchasing Info Record: General Data
INFNR
EBAN KNTTP EBAN KNTTP T163K
Account Assignment Categories in Purchasing Document
KNTTP
EBAN KNTTP EBAN MANDT T163K
Account Assignment Categories in Purchasing Document
MANDT
EBAN KONNR EBAN MANDT EKKO
Purchasing Document Header
MANDT
EBAN KONNR EBAN KONNR EKKO
Purchasing Document Header
EBELN
EBAN KTPNR EBAN MANDT EKPO
Purchasing Document Item
MANDT
EBAN KTPNR EBAN KONNR EKPO
Purchasing Document Item
EBELN
EBAN KTPNR EBAN KTPNR EKPO
Purchasing Document Item
EBELP
EBAN KUNNR EBAN MANDT KNA1
General Data in Customer Master
MANDT
EBAN KUNNR EBAN KUNNR KNA1
General Data in Customer Master
KUNNR
EBAN LBLNI EBAN MANDT ESSR
Service Entry Sheet Header Data
MANDT
EBAN LBLNI EBAN LBLNI ESSR
Service Entry Sheet Header Data
LBLNI
EBAN LGORT EBAN WERKS T001L
Storage Locations
WERKS
EBAN LGORT EBAN LGORT T001L
Storage Locations
LGORT
EBAN LGORT EBAN MANDT T001L
Storage Locations
MANDT
EBAN LIFNR EBAN MANDT LFA1
Vendor Master (General Section)
MANDT
EBAN LIFNR EBAN LIFNR LFA1
Vendor Master (General Section)
LIFNR
EBAN LPEIN EBAN MANDT TPRG
Date display format
MANDT
EBAN LPEIN SYST LANGU TPRG
Date display format
SPRAS
EBAN LPEIN EBAN LPEIN TPRG
Date display format
PRGBZ
EBAN MANDT EBAN MANDT T000
Clients
MANDT
EBAN MATKL EBAN MANDT T023
Material Groups
MANDT
EBAN MATKL EBAN MATKL T023
Material Groups
MATKL
EBAN MATNR EBAN MANDT MARA
General Material Data
MANDT
EBAN MATNR EBAN MATNR MARA
General Material Data
MATNR
EBAN MEINS EBAN MANDT T006
Units of Measurement
MANDT
EBAN MEINS EBAN MEINS T006
Units of Measurement
MSEHI
EBAN MFRNR EBAN MFRNR LFA1
Vendor Master (General Section)
LIFNR
EBAN MFRNR EBAN MANDT LFA1
Vendor Master (General Section)
MANDT
EBAN OIHANTYP EBAN MANDT OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
MANDT
EBAN OIHANTYP EBAN OIHANTYP OIH5
Definition of Excise Duty Handling Type (IS-OIL-TDP)
HANTYP
EBAN OIINEX EBAN MANDT OIH16
Internal/external price conditions
MANDT
EBAN OIINEX EBAN OIINEX OIH16
Internal/external price conditions
INEX
EBAN OITAXFROM EBAN OITAXFROM OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
TAXKEY
EBAN OITAXFROM EBAN MANDT OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
MANDT
EBAN OITAXGRP EBAN MANDT OIH2
Excise duty tax group (IS-Oil TDP standard/core object)
MANDT
EBAN OITAXGRP EBAN OITAXGRP OIH2
Excise duty tax group (IS-Oil TDP standard/core object)
TAXGRP
EBAN OITAXTO EBAN MANDT OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
MANDT
EBAN OITAXTO EBAN OITAXTO OIH4
Excise duty tax status (IS-Oil TDP standard/core object)
TAXKEY
EBAN PACKNO EBAN MANDT ESLH
Service Package Header Data
MANDT
EBAN PACKNO EBAN PACKNO ESLH
Service Package Header Data
PACKNO
EBAN PRIO_REQ EBAN PRIO_REQ PREQ
Requirement Priorities
PRIO_REQ
EBAN PRIO_REQ EBAN MANDT PREQ
Requirement Priorities
MANDT
EBAN PRIO_URG EBAN MANDT PURG
Requirement Urgencies
MANDT
EBAN PRIO_URG EBAN PRIO_URG PURG
Requirement Urgencies
PRIO_URG
EBAN PSTYP EBAN MANDT T163
Item Categories in Purchasing Document
MANDT
EBAN PSTYP EBAN PSTYP T163
Item Categories in Purchasing Document
PSTYP
EBAN SOBKZ EBAN SOBKZ T148
Special Stock Indicator
SOBKZ
EBAN SOBKZ EBAN MANDT T148
Special Stock Indicator
MANDT
EBAN SPRAS EBAN SPRAS T002
Language Keys (Component BC-I18)
SPRAS
EBAN STACODE EBAN MANDT /ISDFPS/CSTACODE
Status Code
MANDT
EBAN STACODE EBAN STACODE /ISDFPS/CSTACODE
Status Code
STACODE
EBAN WAERS EBAN MANDT TCURC
Currency Codes
MANDT
EBAN WAERS EBAN WAERS TCURC
Currency Codes
WAERS
EBAN WERKS EBAN WERKS T001W
Plants/Branches
WERKS
EBAN WERKS EBAN MANDT T001W
Plants/Branches
MANDT