V_PUR_PO_ITM 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
V_PUR_PO_ITM 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 V_PUR_PO_ITM table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), BEDAT (Purchasing Document Date), BSART (Purchasing Document Type).. 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 V_PUR_PO_ITM 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 | |||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | ALPHA | EBELN | BES | MEKK_C | |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EBELP | BSP | |||
| BEDAT | Purchasing Document Date | EBDAT | DATS | 8 | DATUM | ||||
| BSART | Purchasing Document Type | ESART | CHAR | 4 | T161 | BSART | BSA | ||
| BSTYP | Purchasing Document Category | EBSTYP | CHAR | 1 | EBSTYP | ||||
| EKGRP | Purchasing Group | BKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
| EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
| KDATB | Start of Validity Period | KDATB | DATS | 8 | DATUM | ||||
| KDATE | End of Validity Period | KDATE | DATS | 8 | DATUM | ||||
| LBLIF | Field not used | LBLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
| LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| LIFRE | Different Invoicing Party | LIFRE | CHAR | 10 | LFA1 | ALPHA | LIFNR | LRE | |
| LLIEF | Supplying Vendor | LLIEF | CHAR | 10 | LFA1 | ALPHA | LIFNR | LLI | |
| ADRNR | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
| LOGSY | Logical System | LOGSYSTEM | CHAR | 10 | ALPHA | LOGSYS | |||
| RESWK | Supplying (Issuing) Plant in Stock Transport Order | RESWK | CHAR | 4 | T001W | WERKS | |||
| STATU | Status of Purchasing Document | ESTAK | CHAR | 1 | ESTAK | ||||
| SYDAT | Purchasing Document Date | EBDAT | DATS | 8 | DATUM | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| WKURS | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | |||
| BSAKZ | Control indicator for purchasing document type | BSAKZ | CHAR | 1 | BSAKZ | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| FRGRL | Release Not Yet Completely Effected | FRGRL | CHAR | 1 | XFELD | ||||
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | T683 | KALSM | |||
| KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
| KORNR | Correction of miscellaneous provisions | KORNR | CHAR | 1 | KORNR | ||||
| KTWRT | Target Value for Header Area per Distribution | KTWRT | CURR | 15(2) | WERT15 | ||||
| KUFIX | Indicator: Fixing of Exchange Rate | KUFIX | CHAR | 1 | XFELD | ||||
| KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
| LOEKZ | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 1 | ELOEK | ||||
| MEMORY | Purchase order not yet complete | MEMER | CHAR | 1 | XFELD | ||||
| REVNO | Version number in Purchasing | REVNO | CHAR | 8 | ALPHA | REVNO | |||
| STAFO | Update group for statistics update | STAFO | CHAR | 6 | ALPHA | STAFO | MCF | ||
| STAKO | Document with time-dependent conditions | STAKO | CHAR | 1 | XFELD | ||||
| SUBMI | Collective Number | SUBMI | CHAR | 10 | CHAR10 | ||||
| AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
| AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
| BSGRU | Reason for Ordering | BSGRU | CHAR | 3 | TBSG | BSGRU | |||
| ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
| EMATN | Material Number | EMATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
| EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | XFELD | ||||
| KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | EKKO | ALPHA | EBELN | KTR | |
| KTMNG | Target Quantity | KTMNG | QUAN | 13(3) | MENGE | ||||
| KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | EKPO | EBELP | |||
| LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
| LMEIN | Base Unit of Measure | LAGME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| MENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
| NETPR | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR | 11(2) | WERT11 | ||||
| NETWR | Net Order Value in PO Currency | BWERT | CURR | 13(2) | WERT7 | ||||
| PEINH | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
| PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
| REPOS | Invoice Receipt Indicator | REPOS | CHAR | 1 | XFELD | ||||
| TXZ01 | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
| UMREN | Denominator for Conversion of Order Unit to Base Unit | UMBSN | DEC | 5 | UMBSN | ||||
| UMREZ | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5 | UMBSZ | ||||
| WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | XFELD | ||||
| WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
| WERKS | Plant | EWERK | CHAR | 4 | T001W | WERKS | WRK | ||
| XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | XFELD | ||||
| ZWERT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR | 13(2) | WERT7 | ||||
| ANZPU | Number of Points | ANZPU | QUAN | 13(3) | MENG13 | ||||
| BPRME | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | T006 | CUNIT | MEINS | ||
| BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | UMBSN | ||||
| BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | UMBSZ | ||||
| BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
| BRTWR | Gross order value in PO currency | BBWERT | CURR | 13(2) | WERT7 | ||||
| BSTAE | Confirmation Control Key | BSTAE | CHAR | 4 | T163L | BSTAE | |||
| BSTYP_ITM | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
| BUKRS_ITM | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
| EBONF | Item Relevant to Subsequent (Period-End Rebate) Settlement | EBONY | CHAR | 1 | XFELD | ||||
| EFFWR | Effective value of item | EFFWR | CURR | 13(2) | WERT7 | ||||
| EGLKZ | 'Outward Delivery Completed' Indicator | EGLKZ | CHAR | 1 | XFELD | ||||
| EMNFR | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
| FPLNR | Invoicing plan number | IPLNR | CHAR | 10 | CHAR10 | ||||
| GEWEI | Unit of Weight | EGEWE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
| INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
| KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
| KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
| KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
| KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
| KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
| KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
| KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
| LOEKZ_ITM | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 1 | ELOEK | ||||
| LTSNR | Vendor Subrange | LTSNR | CHAR | 6 | LTSNR | ||||
| MEPRF | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1 | MEPRF | ||||
| MFRNR | Number of a Manufacturer | MFRNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
| MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
| MPROF | Manufacturer Part Profile | MPROF | CHAR | 4 | MPROF | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
| NAVNW | Non-deductible input tax | NAVNW | CURR | 13(2) | WERT7 | ||||
| NTGEW | Net Weight | ENTGE | QUAN | 13(3) | MENG13 | ||||
| PRDAT | Date of Price Determination | PREDT | DATS | 8 | DATUM | ||||
| PUNEI | Points unit | PUNEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
| RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR | 4 | T001L | LGORT | |||
| RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
| STAFO_ITM | Update group for statistics update | STAFO | CHAR | 6 | ALPHA | STAFO | MCF | ||
| STAPO_ITM | Item is statistical | STAPO | CHAR | 1 | XFELD | ||||
| STATU_ITM | RFQ status | ASTAT | CHAR | 1 | ASTAT | ||||
| TWRKZ | Partial Invoice Indicator | TWRKZ | CHAR | 1 | TWRKZ | ||||
| VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
| VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
| WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
| WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | XFELD | ||||
| BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
| BNFPO | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | EBAN | BNFPO | BAP | ||
| MCEX_UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
| MCEX_UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
| MCEX_UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 |
| Key field | Non-key field |
How do I retrieve data from SAP table V_PUR_PO_ITM using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_PUR_PO_ITM to SELECT all data from the tableDATA: WA_V_PUR_PO_ITM TYPE V_PUR_PO_ITM.
SELECT SINGLE *
FROM V_PUR_PO_ITM
INTO CORRESPONDING FIELDS OF WA_V_PUR_PO_ITM
WHERE...
How to access SAP table V_PUR_PO_ITM
Within an ECC or HANA version of SAP you can also view further information about V_PUR_PO_ITM 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