The EBAN table in SAP ERP or S/4HANA stores Purchase Requisition data. There are total 218 fields in EBAN table. The Purchase Requisition table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of EBAN table. It is in Purchasing (ME) ABAP package and is part of the Purchasing (MM-PUR) module.
SAP EBAN Table Fields
Following is the list of fields that are available in SAP EBAN table. The primary key fields of the table are MANDT (Client), BANFN (Purchase Requisition Number), BNFPO (Item number of purchase requisition).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| BANFN | Purchase Requisition Number | BANFN | CHAR (10) | |
| BNFPO | Item number of purchase requisition | BNFPO | NUMC (5) | |
| BSART | Purchase Requisition Document Type | BBSRT | T161 | CHAR (4) |
| BSTYP | Purchasing Document Category | BSTYP | CHAR (1) | |
| BSAKZ | Control indicator for purchasing document type | BSAKZ | CHAR (1) | |
| LOEKZ | Deletion indicator in purchasing document | ELOEK | CHAR (1) | |
| STATU | Processing status of purchase requisition | BANST | CHAR (1) | |
| ESTKZ | Creation indicator (purchase requisition/schedule lines) | ESTKZ | CHAR (1) | |
| FRGKZ | Release Indicator | FRGKZ | T161S | CHAR (1) |
| FRGZU | Release State | FRGZU | CHAR (8) | |
| FRGST | Release strategy in the purchase requisition | FRGST | CHAR (2) | |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR (3) |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| ERDAT | Date of Last Change | AEDAT | DATS (8) | |
| AFNAM | Name of requisitioner/requester | AFNAM | CHAR (12) | |
| TXZ01 | Short Text | TXZ01 | CHAR (40) | |
| MATNR | Material Number | MATNR | MARA | CHAR (40) |
| EMATN | Material number corresponding to manufacturer part number | EMATN | MARA | CHAR (40) |
| WERKS | Plant | EWERK | T001W | CHAR (4) |
| LGORT | Storage location | LGORT_D | T001L | CHAR (4) |
| BEDNR | Requirement Tracking Number | BEDNR | CHAR (10) | |
| MATKL | Material Group | MATKL | T023 | CHAR (9) |
| RESWK | Supplying (issuing) plant in case of stock transport order | RESWK | CHAR (4) | |
| MENGE | Purchase requisition quantity | BAMNG | QUAN (13) | |
| MEINS | Purchase requisition unit of measure | BAMEI | T006 | UNIT (3) |
| BUMNG | Shortage (stock undercoverage) quantity | BUMNG | QUAN (13) | |
| BADAT | Requisition (request) date | BADAT | DATS (8) | |
| LPEIN | Category of delivery date | LPEIN | TPRG | CHAR (1) |
| LFDAT | Item delivery date | EINDT | DATS (8) | |
| FRGDT | Purchase Requisition Release Date | FRGDT | DATS (8) | |
| WEBAZ | Goods receipt processing time in days | WEBAZ | DEC (3) | |
| PREIS | Price in Purchase Requisition | BAPRE | CURR (11) | |
| PEINH | Price unit | EPEIN | DEC (5) | |
| PSTYP | Item category in purchasing document | PSTYP | T163 | CHAR (1) |
| KNTTP | Account Assignment Category | KNTTP | T163K | CHAR (1) |
| KZVBR | Consumption posting | KZVBR | CHAR (1) | |
| KFLAG | Acct.asst.modifiable | KFLAG | CHAR (1) | |
| VRTKZ | Distribution Indicator for Multiple Account Assignment | VRTKZ | CHAR (1) | |
| TWRKZ | Partial invoice indicator | TWRKZ | CHAR (1) | |
| WEPOS | Goods Receipt Indicator | WEPOS | CHAR (1) | |
| WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR (1) | |
| REPOS | Invoice receipt indicator | REPOS | CHAR (1) | |
| LIFNR | Desired Vendor | WLIEF | LFA1 | CHAR (10) |
| FLIEF | Fixed vendor | FLIEF | LFA1 | CHAR (10) |
| EKORG | Purchasing organization | EKORG | T024E | CHAR (4) |
| VRTYP | Purchasing Document Category | BSTYP | CHAR (1) | |
| KONNR | Number of principal purchase agreement | KONNR | EKKO | CHAR (10) |
| KTPNR | Item number of principal purchase agreement | KTPNR | EKPO | NUMC (5) |
| INFNR | Number of purchasing info record | INFNR | EINA | CHAR (10) |
| ZUGBA | Assigned Source of Supply | DZUGBA | CHAR (1) | |
| QUNUM | Number of quota arrangement | QUNUM | CHAR (10) | |
| QUPOS | Quota arrangement item | QUPOS | NUMC (3) | |
| DISPO | MRP Controller | DISPO | T024D | CHAR (3) |
| SERNR | BOM explosion number | SERNR | CHAR (8) | |
| BVDAT | Date of last resubmission | BVDAT | DATS (8) | |
| BATOL | Resubmission interval of purchase requisition | BATOL | DEC (3) | |
| BVDRK | Number of resubmissions | BVDRK | DEC (7) | |
| EBELN | Purchase order number | BSTNR | EKKO | CHAR (10) |
| EBELP | Purchase order item number | BSTPO | EKPO | NUMC (5) |
| BEDAT | Purchase Order Date | BEDAT | DATS (8) | |
| BSMNG | Quantity ordered against this purchase requisition | BSMNG | QUAN (13) | |
| LBLNI | Entry Sheet Number | LBLNI | ESSR | CHAR (10) |
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR (10) |
| XOBLR | Item affects commitments | XOBLR | CHAR (1) | |
| EBAKZ | Purchase requisition closed | EBAKZ | CHAR (1) | |
| RSNUM | Number of reservation/dependent requirements | RSNUM | NUMC (10) | |
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR (1) |
| ARSNR | Settlement reservation number | ARSNR | NUMC (10) | |
| ARSPS | Item number of the settlement reservation | ARSPS | NUMC (4) | |
| FIXKZ | Purchase requisition is fixed | BAFIX | CHAR (1) | |
| BMEIN | Purchase Order Unit of Measure | BSTME | T006 | UNIT (3) |
| REVLV | Revision Level | REVLV | CHAR (2) | |
| VORAB | Advance procurement: project stock | VORAB | CHAR (1) | |
| PACKNO | Package number | PACKNO | ESLH | NUMC (10) |
| KANBA | Kanban Indicator | KBNKZ | CHAR (1) | |
| BPUEB | Use Requisition Price in Purchase Order | BPUEB | CHAR (1) | |
| CUOBJ | Configuration (internal object number) | CUOBJ | NUMC (18) | |
| FRGGR | Release group | FRGGR | T16FG | CHAR (2) |
| FRGRL | Release Not Yet Completely Effected | FRGRL | CHAR (1) | |
| AKTNR | Promotion | WAKTION | WAKH | CHAR (10) |
| CHARG | Batch Number | CHARG_D | CHAR (10) | |
| UMSOK | Special stock indicator for physical stock transfer | UMSOK | CHAR (1) | |
| VERID | Production Version | VERID | CHAR (4) | |
| FIPOS | Commitment Item | FIPOS | CHAR (14) | |
| FISTL | Funds Center | FISTL | CHAR (16) | |
| GEBER | Fund | BP_GEBER | CHAR (10) | |
| KZKFG | Origin of Configuration | KZCUH | CHAR (1) | |
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR (40) | |
| MNG02 | Committed Quantity | MNG06 | QUAN (13) | |
| DAT01 | Committed date | DAT05 | DATS (8) | |
| ATTYP | Material Category | ATTYP | CHAR (2) | |
| ADRNR | Manual address number in purchasing document item | ADRNR_MM | ADRC | CHAR (10) |
| ADRN2 | Number of delivery address | ADRN2 | ADRC | CHAR (10) |
| KUNNR | Customer | EKUNNR | KNA1 | CHAR (10) |
| EMLIF | Supplier to be Supplied/Who is to Receive Delivery | EMLIF | LFA1 | CHAR (10) |
| LBLKZ | Subcontracting Supplier | LBLKZ | CHAR (1) | |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR (1) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| IDNLF | Material Number Used by Supplier | IDNLF | CHAR (35) | |
| GSFRG | Overall release of purchase requisitions | GSFRG | CHAR (1) | |
| MPROF | Mfr part profile | MPROF | CHAR (4) | |
| KZFME | Units of measure usage | KZWSO | CHAR (1) | |
| SPRAS | Language Key | SPRAS | T002 | LANG (1) |
| TECHS | Parameter Variant/Standard Variant | TECHS | CHAR (12) | |
| MFRPN | Manufacturer Part Number | MFRPN | CHAR (40) | |
| MFRNR | Manufacturer number | MFRNR | LFA1 | CHAR (10) |
| EMNFR | External manufacturer code name or number | EMNFR | CHAR (10) | |
| FORDN | Framework Order | SFORDN | CHAR (10) | |
| FORDP | Item of framework order | FORDP | NUMC (5) | |
| PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC (3) | |
| BERID | MRP Area | BERID | CHAR (10) | |
| UZEIT | Delivery Date Time-Spot | LZEIT | TIMS (6) | |
| FKBER | Functional Area | FKBER | CHAR (16) | |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR (20) | |
| MEMORY | Purchase Requisition not yet Complete | MEMBF | CHAR (1) | |
| BANPR | Requisition Processing State | BANPR | CHAR (2) | |
| RLWRT | Total value at time of release | RLWRT | CURR (15) | |
| BLCKD | Purchase Requisition Blocked | BLCKD | CHAR (1) | |
| REVNO | Version number in Purchasing | REVNO | CHAR (8) | |
| BLCKT | Reason for Item Block | BLCKT | CHAR (60) | |
| BESWK | Procuring Plant | BESWK | T001W | CHAR (4) |
| EPROFILE | External Procurement Profile | MEPROFILE | CHAR (2) | |
| EPREFDOC | External Procurement Reference Document | EPREFDOC | CHAR (10) | |
| EPREFITM | External Procurement Reference Item | EPREFITM | NUMC (5) | |
| GMMNG | PO Quantity of Purchase Requisition in POs on Hold | GMMNG | QUAN (13) | |
| WRTKZ | Value-Based Commitment Reduction for Service Purchase Reqs | WRTKZ | CHAR (1) | |
| RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR (4) | |
| KBLNR | Document Number for Earmarked Funds | KBLNR | CHAR (10) | |
| KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC (3) | |
| PRIO_URG | Requirement Urgency | PRIO_URG | PURG | NUMC (2) |
| PRIO_REQ | Requirement Priority | PRIO_REQ | PREQ | NUMC (3) |
| MEMORYTYPE | Category of Incompleteness | MEMORYTYPE | CHAR (1) | |
| ANZSN | Number of serial numbers | ANZSN | INT4 (10) | |
| MHDRZ | Minimum Remaining Shelf Life | MHDRZ | DEC (4) | |
| IPRKZ | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR (1) | |
| NODISP | Ind: Reserv. not applicable to MRP | NODISP | CHAR (1) | |
| SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR (10) | |
| SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC (10) | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | CHAR (10) | |
| ELDAT | Receipt/Requirements date | DAT00 | DATS (8) | |
| EXPERT_MODE | PR Created in Expert Mode | MMPUR_PR_SSP_EXPERT_MODE | CHAR (1) | |
| CENTRAL_PURREQN_PROC | Is PR relevant for Central PR Processing | MMPUR_PR_CEN_PURREQN_PROC_MODE | CHAR (1) | |
| SPE_CRM_REF_SO | CRM Reference Order Number for TPOP Process | /SPE/REF_VBELN_CRM | CHAR (35) | |
| SPE_CRM_REF_ITEM | CRM Reference Sales Order Item Number in TPOP Process | /SPE/REF_POSNR_CRM | CHAR (6) | |
| DUMMY_EBAN_INCL_EEW_PS | Data element for purchase requisition extensibility | EBAN_INCL_EEW | CHAR (1) | |
| STORENETWORKID | 128 character | CHAR128 | CHAR (128) | |
| STORESUPPLIERID | Character field, length 64 | CHAR64 | CHAR (64) | |
| CREATIONDATE | Purchasing Document Creation Date | ME_PDI_CREATIONDATE | DATS (8) | |
| CREATIONTIME | Purchasing Document Creation Time | ME_PDI_CREATIONTIME | TIMS (6) | |
| PRODUCTTYPE | Product Type Group | PRODUCT_TYPE | CHAR (2) | |
| SERVICEPERFORMER | Service Performer | SERVICEPERFORMER | CHAR (10) | |
| ISEOPBLOCKED | Business Purpose Completed | EOPBLOCKED | CHAR (1) | |
| EXT_REV_TMSTMP | Timestamp for Revision of External Calls | MM_EXT_REV_TMSTMP | DEC (21) | |
| FMFGUS_KEY | United States Federal Government Fields | FMFG_US_KEY | CHAR (22) | |
| STARTDATE | Start Date for Period of Performance | MMPUR_SERVPROC_PERIOD_START | DATS (8) | |
| ENDDATE | End Date for Period of Performance | MMPUR_SERVPROC_PERIOD_END | DATS (8) | |
| EXTMATERIALFORPURG | Material of External System | MM_PUR_HUB_MATNR | * | CHAR (40) |
| EXTFIXEDSUPPLIERFORPURG | Fixed Supplier of External System | MM_PUR_HUB_FLIEF | * | CHAR (10) |
| EXTDESIREDSUPPLIERFORPURG | Desired Supplier of External System | MM_PUR_HUB_WLIEF | * | CHAR (10) |
| EXTCONTRACTFORPURG | Contract of External System | MM_PUR_HUB_KONNR | * | CHAR (10) |
| EXTCONTRACTITEMFORPURG | Contract Item of External System | MM_PUR_HUB_KTPNR | * | NUMC (5) |
| EXTINFORECORDFORPURG | Info Record of External System | MM_PUR_HUB_INFNR | * | CHAR (10) |
| EXTPLANTFORPURG | Plant of External System | MM_PUR_HUB_WERKS | * | CHAR (4) |
| EXTCOMPANYCODEFORPURG | Company Code of External System | MM_PUR_HUB_BUKRS | * | CHAR (4) |
| EXTPURGORGFORPURG | Purchasing Organization | MM_PUR_HUB_EKORG | * | CHAR (4) |
| EXT_BE_PRCHANGEINDICATOR | Change Indicator for PR in Central Procurement | MM_PUR_HUB_CHGIND | CHAR (1) | |
| EXTDOCTYPEFORPURG | PR Document Type of Connected System | MM_PUR_HUB_REQ_DOC_TYPE | * | CHAR (4) |
| EXTAPPROVALSTATUS | External Processing Status | MMPUR_REQ_EXTAPPRVLSTS | CHAR (1) | |
| PURCHASEREQNITEMUNIQUEID | Key to identify purchase requisition item | MM_PUR_PR_ITEM_KEY | CHAR (15) | |
| LASTCHANGEDATETIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC (21) | |
| ISONBEHALFCART | Shop on behalf indicator | MMPUR_REQ_D_SOB | CHAR (1) | |
| SDM_VERSION | Version of Silent Data Migration | MMPUR_SDM_VERSION | CHAR (2) | |
| SAKTO | G/L Account Number | SAKNR | CHAR (10) | |
| KOSTL | Cost Center | KOSTL | CHAR (10) | |
| EXPECTED_VALUE | Expected Value of Overall Limit | COMMITMENT | CURR (13) | |
| LIMIT_AMOUNT | Overall Limit | SUMLIMIT | CURR (13) | |
| ISOUTLINE | Is Outline | MMPUR_REQ_IS_OUTLINE | CHAR (1) | |
| PARENT_ITEM_NO | Parent Item No | MMPUR_REQ_PARENT_ITEM_NO | NUMC (5) | |
| OUTLINE_TYPE | Outline Type | MMPUR_REQ_OUTLINE_TYPE | CHAR (1) | |
| ADVCODE | Advice Code | /ISDFPS/ADVCODE | /ISDFPS/ADVCODE2 | CHAR (2) |
| STACODE | Status Code | /ISDFPS/STACODE | /ISDFPS/CSTACODE | CHAR (2) |
| BANFN_CS | Cross-System PReq Number | /ISDFPS/BANFN_CS | CHAR (10) | |
| BNFPO_CS | Cross-System PReq Item | /ISDFPS/BNFPO_CS | NUMC (5) | |
| ITEM_CS | Cross-System Item Category | /ISDFPS/ITEM_CS | CHAR (1) | |
| BSMNG_SND | PO Quantity Sender | /ISDFPS/BSMNG_SND | QUAN (13) | |
| NO_MARD_DATA | No Storage Location Data Exists for Material | /ISDFPS/NO_MARD_DATA | CHAR (1) | |
| ADMOI | Model ID Code | ADMOI | CSPCMOI | CHAR (4) |
| ADPRI | Order Priority | ADPRI | CSPCPRI | CHAR (3) |
| LPRIO | Delivery Priority | LPRIO | TPRIO | NUMC (2) |
| ADACN | Aircraft registration number | ADACN | CHAR (10) | |
| ADDNS | Do Not Substitute | ADDNS | CHAR (1) | |
| SERRU | Type of subcontracting | SERRU | CHAR (1) | |
| DISUB_SOBKZ | Special stock indicator Subcontracting | DISUB_SOBKZ_LB | CHAR (1) | |
| DISUB_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | * | NUMC (8) |
| DISUB_KUNNR | Customer Number | KUNNR | CHAR (10) | |
| DISUB_VBELN | Sales and Distribution Document Number | VBELN | CHAR (10) | |
| DISUB_POSNR | Item number of the SD document | POSNR | NUMC (6) | |
| DISUB_OWNER | Owner of stock | OWNER_D | * | CHAR (10) |
| FLDLOGSSUPPLYPROCESS | Supply Process | FLOG_SPROC | CHAR (4) | |
| FLDLOGSDELIVISHELDONSHORE | Hold On-Shore | FLOG_HOLD | CHAR (1) | |
| FSH_SEASON_YEAR | Season Year | FSH_SAISJ | FSH_SEASONS | CHAR (4) |
| FSH_SEASON | Season | FSH_SAISO | FSH_SEASONS | CHAR (10) |
| FSH_COLLECTION | Fashion Collection | FSH_COLLECTION | FSH_COLLECTIONS | CHAR (10) |
| FSH_THEME | Fashion Theme | FSH_THEME | FSH_THEMES | CHAR (10) |
| FSH_VAS_REL | VAS Relevant | FSH_VAS_REL | CHAR (1) | |
| FSH_VAS_PRNT_ID | Item Number of Purchasing Document | EBELP | * | NUMC (5) |
| FSH_TRANSACTION | Transaction Number | FSH_TRANSACTION | CHAR (10) | |
| FSH_ITEM_GROUP | Item Group | FSH_ITEM_GROUP | NUMC (5) | |
| FSH_ITEM | Item Number | FSH_ITEM | NUMC (5) | |
| IUID_RELEVANT | IUID-Relevant | IUID_RELEVANT | CHAR (1) | |
| SC_CATALOGID | Technical Key of a Web Service (for Example – a Catalog) | BBP_WS_SERVICE_ID | CHAR (20) | |
| SC_AUTHOR | Author of Requisition | MMPUR_REQ_D_AUTHOR | CHAR (12) | |
| SGT_SCAT | Stock Segment | SGT_SCAT | CHAR (40) | |
| SGT_RCAT | Requirement Segment | SGT_RCAT | CHAR (40) | |
| WRF_CHARSTC1 | Characteristic Value 1 | WRF_CHARSTC1 | CHAR (18) | |
| WRF_CHARSTC2 | Characteristic Value 2 | WRF_CHARSTC2 | CHAR (18) | |
| WRF_CHARSTC3 | Characteristic Value 3 | WRF_CHARSTC3 | CHAR (18) |
