EBAV SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
EBAV is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The EBAV table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include BANFN (Purchase Requisition Number), BNFPO (Item Number of Purchase Requisition), BSART (Purchase Requisition Document Type), BSTYP (Purchasing Document Category).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP EBAV table view fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
BNFPO | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | BNFPO | BAP | |||
BSART | Purchase Requisition Document Type | BBSRT | CHAR | 4 | T161 | BSART | BBA | ||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
BSAKZ | Control indicator for purchasing document type | BSAKZ | CHAR | 1 | BSAKZ | ||||
LOEKZ | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 1 | ELOEK | ||||
ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | ESTKZ | CHAR | 1 | ESTKZ | ||||
FRGKZ | Release Indicator | FRGKZ | CHAR | 1 | T161S | FRGKZ | |||
FRGZU | Release status | FRGZU | CHAR | 8 | FRGZU | ||||
FRGST | Release Strategy in Purchase Requisition | FRGST | CHAR | 2 | FRGST | ||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
TXZ01 | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | MARA | MATN1 | MATNR | HTN | |
WERKS | Plant | EWERK | CHAR | 4 | T001W | WERKS | WRK | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10 | CHAR10 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
RESWK | Supplying (Issuing) Plant in Stock Transport Order | RESWK | CHAR | 4 | WERKS | ||||
MENGE | Purchase Requisition Quantity | BAMNG | QUAN | 13(3) | MENG13 | ||||
MEINS | Purchase Requisition Unit of Measure | BAMEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
BUMNG | Shortage (stock undercoverage) quantity | BUMNG | QUAN | 13(3) | MENG13 | ||||
BADAT | Requisition (Request) Date | BADAT | DATS | 8 | DATUM | ||||
LPEIN | Category of Delivery Date | LPEIN | CHAR | 1 | TPRG | PRGBZ | |||
LFDAT | Item Delivery Date | EINDT | DATS | 8 | DATUM | ||||
FRGDT | Purchase Requisition Release Date | FRGDT | DATS | 8 | DATUM | ||||
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
PREIS | Price in Purchase Requisition | BAPRE | CURR | 11(2) | WERT11 | ||||
PEINH | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
KFLAG | Acct.asst.changeable | KFLAG | CHAR | 1 | XFELD | ||||
VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
TWRKZ | Partial Invoice Indicator | TWRKZ | CHAR | 1 | TWRKZ | ||||
WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | XFELD | ||||
REPOS | Invoice Receipt Indicator | REPOS | CHAR | 1 | XFELD | ||||
LIFNR | Desired Vendor | WLIEF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
FLIEF | Fixed Vendor | FLIEF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
VRTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | EKKO | ALPHA | EBELN | KTR | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | EKPO | EBELP | |||
INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
ZUGBA | Assigned Source of Supply | DZUGBA | CHAR | 1 | XFELD | ||||
QUNUM | Number of Quota Arrangement | QUNUM | CHAR | 10 | ALPHA | QUNUM | |||
QUPOS | Quota Arrangement Item | QUPOS | NUMC | 3 | NUM03 | ||||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | T024D | DISPO | DGR | HS_T024D | |
SERNR | BOM explosion number | SERNR | CHAR | 8 | SERNR | ||||
BATOL | Resubmission Interval of Purchase Requisition | BATOL | DEC | 3 | BATOL | ||||
LBLNI | Entry Sheet Number | LBLNI | CHAR | 10 | ESSR | ALPHA | LBLNI | LBL | ESSR |
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
XOBLR | Item affects commitments | XOBLR | CHAR | 1 | XFELD | ||||
EBAKZ | Purchase Requisition Closed | EBAKZ | CHAR | 1 | XFELD | ||||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | RSNUM | RES | |||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | MDNUM | ||||
ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | RSPOS | ||||
FIXKZ | Purchase Requisition is Fixed | BAFIX | CHAR | 1 | XFELD | ||||
BMEIN | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
VORAB | Advance procurement: project stock | VORAB | CHAR | 1 | XFELD | ||||
PACKNO | Package number | PACKNO | NUMC | 10 | ESLH | PACKNO | |||
KANBA | Kanban Indicator | KBNKZ | CHAR | 1 | KBNKZ | ||||
BPUEB | Adopt Requisition Price in Purchase Order | BPUEB | CHAR | 1 | BPUEB | ||||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
FRGGR | Release group | FRGGR | CHAR | 2 | T16FG | FRGGR | |||
FRGRL | Release Not Yet Completely Effected | FRGRL | CHAR | 1 | XFELD | ||||
AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | CHARG | CHA | |||
UMSOK | Special Stock Indicator for Physical Stock Transfer | UMSOK | CHAR | 1 | SOBKZ | ||||
VERID | Production Version | VERID | CHAR | 4 | VERID | VER | |||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | FIPOS | FIP | |||
FISTL | Funds Center | FISTL | CHAR | 16 | FISTL | FIS | |||
GEBER | Fund | BP_GEBER | CHAR | 10 | BP_GEBER | FIC | |||
KZKFG | Origin of Configuration | KZCUH | CHAR | 1 | KZCUH | ||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MATN1 | MATNR | |||
MNG02 | Committed Quantity | MNG06 | QUAN | 13(3) | MENGV13 | ||||
DAT01 | Committed Date | DAT05 | DATS | 8 | DATUM | ||||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
ADRNR | Manual address number in purchasing document item | ADRNR_MM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
ADRN2 | Number of delivery address | ADRN2 | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
KUNNR | Customer | EKUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
EMLIF | Vendor to be supplied/who is to receive delivery | EMLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
LBLKZ | Subcontracting vendor | LBLKZ | CHAR | 1 | XFELD | ||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
GSFRG | Overall release of purchase requisitions | GSFRG | CHAR | 1 | XFELD | ||||
MPROF | Manufacturer Part Profile | MPROF | CHAR | 4 | MPROF | ||||
KZFME | Units of measure usage | KZWSO | CHAR | 1 | KZWSO | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
MFRNR | Number of a Manufacturer | MFRNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
EMNFR | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
FORDN | Framework Order | SFORDN | CHAR | 10 | ALPHA | EBELN | |||
FORDP | Item of framework order | FORDP | NUMC | 5 | EBELP | ||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
BERID | MRP Area | BERID | CHAR | 10 | BERID | BERID | |||
UZEIT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | UZEIT | ||||
FKBER | Functional Area | FKBER | CHAR | 16 | FKBER | FBE | |||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
MEMORY | Purchase Requisition not yet Complete | MEMBF | CHAR | 1 | XFELD | ||||
BANPR | Requisition Processing State | BANPR | CHAR | 2 | BANPR | ||||
RLWRT | Total value at time of release | RLWRT | CURR | 15(2) | WERT15 | ||||
BLCKD | Purchase Requisition Blocked | BLCKD | CHAR | 1 | BLCKD | ||||
REVNO | Version number in Purchasing | REVNO | CHAR | 8 | ALPHA | REVNO | |||
BLCKT | Reason for Item Block | BLCKT | CHAR | 60 | CHAR60K | ||||
BESWK | Procuring Plant | BESWK | CHAR | 4 | T001W | WERKS | BESW | ||
EPROFILE | External Procurement Profile | MEPROFILE | CHAR | 2 | EPROFILE | ||||
EPREFDOC | External Procurement Reference Document | EPREFDOC | CHAR | 10 | EPREFDOC | ||||
EPREFITM | External Procurement Reference Item | EPREFITM | NUMC | 5 | EPREFITM | ||||
WRTKZ | Value-Based Commitment Reduction for Service Purchase Reqs | WRTKZ | CHAR | 1 | XFELD | ||||
RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR | 4 | LGORT | ||||
KBLNR | Document Number for Earmarked Funds | KBLNR | CHAR | 10 | ALPHA | KBLNR | KBL | ||
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | KBLPOS | KBP | |||
PRIO_URG | Requirement Urgency | PRIO_URG | NUMC | 2 | PURG | PRIO_URG | |||
PRIO_REQ | Requirement Priority | PRIO_REQ | NUMC | 3 | PREQ | PRIO_REQ | |||
MEMORYTYPE | Category of Incompleteness | MEMORYTYPE | CHAR | 1 | MM_MEMORYTYPE | ||||
ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | INT4 | ||||
MHDRZ | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | DEC4 | ||||
IPRKZ | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | PERKZ | DATTP | H_PERDKZ | ||
NODISP | Ind: Reserv. not applicable to MRP;Purc. req. not created | NODISP | CHAR | 1 | XFELD | ||||
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10 | ALPHA | BBP_BAPI_EBELN | MMBSI_MEKK_CC | ||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10 | BBP_ITEMNO | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | FM_BUDGET_PERIOD | BUDPER | |||
ADVCODE | Advice Code | /ISDFPS/ADVCODE | CHAR | 2 | /ISDFPS/ADVCODE2 | /ISDFPS/ADVCODE | |||
STACODE | Status Code | /ISDFPS/STACODE | CHAR | 2 | /ISDFPS/CSTACODE | /ISDFPS/STACODE | |||
BANFN_CS | Cross-System PReq Number | /ISDFPS/BANFN_CS | CHAR | 10 | ALPHA | BANFN | |||
BNFPO_CS | Cross-System PReq Item | /ISDFPS/BNFPO_CS | NUMC | 5 | BNFPO | ||||
ITEM_CS | Cross-System Item Category | /ISDFPS/ITEM_CS | CHAR | 1 | /ISDFPS/ITEM_CS | ||||
BSMNG_SND | PO Quantity Sender | /ISDFPS/BSMNG_SND | QUAN | 13(3) | MENG13 | ||||
NO_MARD_DATA | No Storage Location Data Exists for Material | /ISDFPS/NO_MARD_DATA | CHAR | 1 | XFELD | ||||
ADMOI | Model ID code | ADMOI | CHAR | 4 | CSPCMOI | ADMOI | |||
ADPRI | Order priority | ADPRI | CHAR | 3 | CSPCPRI | ADPRI | |||
LPRIO | Delivery Priority | LPRIO | NUMC | 2 | TPRIO | LPRIO | |||
ADACN | Aircraft registration number | ADACN | CHAR | 5 | ADACN | ||||
SERRU | Type of subcontracting | SERRU | CHAR | 1 | SERRU | SERRU | |||
DISUB_SOBKZ | Special stock indicator Subcontracting | DISUB_SOBKZ_LB | CHAR | 1 | DISUB_SOBKZ_LB | ||||
DISUB_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | KONPR | PS_POSNR | |||
DISUB_KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
DISUB_VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | ALPHA | VBELN | AUN | ||
DISUB_POSNR | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
DISUB_OWNER | Owner of stock | OWNER_D | CHAR | 10 | ALPHA | LIFNR | |||
IUID_RELEVANT | IUID-Relevant | IUID_RELEVANT | CHAR | 1 | UID_RELEVANT |
Key field | Non-key field |
How do I retrieve data from SAP table EBAV using ABAP code
The following ABAP code Example will allow you to do a basic selection on EBAV to SELECT all data from the tableDATA: WA_EBAV TYPE EBAV.
SELECT SINGLE *
FROM EBAV
INTO CORRESPONDING FIELDS OF WA_EBAV
WHERE...
How to access SAP table EBAV
Within an ECC or HANA version of SAP you can also view further information about EBAV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects