SAP ABAP View V_PUR_PO_ITM (View For PUR PO ITEM Datasource)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷
MM (Application Component) Materials Management
⤷
MMDA (Package) Data Provisioning for Real Time Reporting in MM

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | V_PUR_PO_ITM | |
Short Description | View For PUR PO ITEM Datasource | |
Root table | EKKO | Purchasing Document Header |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
EKKO | ||
2 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
EBELN | JL | EQ | 0 | 0 | ||||
4 | ![]() |
EBELN | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
MANDT | MANDT | Client | |||
2 | ![]() |
![]() |
EBELN | EBELN | Purchasing Document Number | |||
3 | ![]() |
![]() |
EBELP | EBELP | Item Number of Purchasing Document | |||
4 | ![]() |
![]() |
BEDAT | EBDAT | Purchasing Document Date | |||
5 | ![]() |
![]() |
BSART | ESART | Purchasing Document Type | |||
6 | ![]() |
![]() |
BSTYP | EBSTYP | Purchasing Document Category | |||
7 | ![]() |
![]() |
EKGRP | BKGRP | Purchasing Group | |||
8 | ![]() |
![]() |
EKORG | EKORG | Purchasing organization | |||
9 | ![]() |
![]() |
KDATB | KDATB | Start of Validity Period | |||
10 | ![]() |
![]() |
KDATE | KDATE | End of Validity Period | |||
11 | ![]() |
![]() |
LBLIF | LBLIF | Field not used | |||
12 | ![]() |
![]() |
LIFNR | ELIFN | Vendor's account number | |||
13 | ![]() |
![]() |
LIFRE | LIFRE | Different Invoicing Party | |||
14 | ![]() |
![]() |
LLIEF | LLIEF | Supplying Vendor | |||
15 | ![]() |
![]() |
ADRNR | AD_ADDRNUM | Address number | |||
16 | ![]() |
![]() |
LOGSY | LOGSYSTEM | Logical System | |||
17 | ![]() |
![]() |
RESWK | RESWK | Supplying (issuing) plant in case of stock transport order | |||
18 | ![]() |
![]() |
STATU | ESTAK | Status of Purchasing Document | |||
19 | ![]() |
![]() |
BEDAT | EBDAT | Purchasing Document Date | |||
20 | ![]() |
![]() |
WAERS | WAERS | Currency Key | |||
21 | ![]() |
![]() |
WKURS | WKURS | Exchange Rate | |||
22 | ![]() |
![]() |
BSAKZ | BSAKZ | Control indicator for purchasing document type | |||
23 | ![]() |
![]() |
BUKRS | BUKRS | Company Code | |||
24 | ![]() |
![]() |
FRGRL | FRGRL | Release Not Yet Completely Effected | |||
25 | ![]() |
![]() |
KALSM | KALSM_D | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | |||
26 | ![]() |
![]() |
KNUMV | KNUMV | Number of the document condition | |||
27 | ![]() |
![]() |
KORNR | KORNR | Correction of miscellaneous provisions | |||
28 | ![]() |
![]() |
KTWRT | KTWRT | Target Value for Header Area per Distribution | |||
29 | ![]() |
![]() |
KUFIX | KUFIX | Indicator: Fixing of Exchange Rate | |||
30 | ![]() |
![]() |
KUNNR | KUNNR | Customer Number | |||
31 | ![]() |
![]() |
LOEKZ | ELOEK | Deletion indicator in purchasing document | |||
32 | ![]() |
![]() |
MEMORY | MEMER | Purchase order not yet complete | |||
33 | ![]() |
![]() |
REVNO | REVNO | Version number in Purchasing | |||
34 | ![]() |
![]() |
STAFO | STAFO | Update group for statistics update | |||
35 | ![]() |
![]() |
STAKO | STAKO | Document with time-dependent conditions | |||
36 | ![]() |
![]() |
SUBMI | SUBMI | Collective Number | |||
37 | ![]() |
![]() |
AFNAM | AFNAM | Name of requisitioner/requester | |||
38 | ![]() |
![]() |
AKTNR | WAKTION | Promotion | |||
39 | ![]() |
![]() |
BSGRU | BSGRU | Reason for Ordering | |||
40 | ![]() |
![]() |
ELIKZ | ELIKZ | "Delivery Completed" Indicator | |||
41 | ![]() |
![]() |
EMATN | EMATNR | Material number | |||
42 | ![]() |
![]() |
EREKZ | EREKZ | Final Invoice Indicator | |||
43 | ![]() |
![]() |
KONNR | KONNR | Number of principal purchase agreement | |||
44 | ![]() |
![]() |
KTMNG | KTMNG | Target Quantity | |||
45 | ![]() |
![]() |
KTPNR | KTPNR | Item number of principal purchase agreement | |||
46 | ![]() |
![]() |
LGORT | LGORT_D | Storage location | |||
47 | ![]() |
![]() |
LMEIN | LAGME | Base Unit of Measure | |||
48 | ![]() |
![]() |
MATKL | MATKL | Material Group | |||
49 | ![]() |
![]() |
MATNR | MATNR | Material Number | |||
50 | ![]() |
![]() |
MEINS | BSTME | Order unit | |||
51 | ![]() |
![]() |
MENGE | BSTMG | Purchase Order Quantity | |||
52 | ![]() |
![]() |
NETPR | BPREI | Net Price in Purchasing Document (in Document Currency) | |||
53 | ![]() |
![]() |
NETWR | BWERT | Net Order Value in PO Currency | |||
54 | ![]() |
![]() |
PEINH | EPEIN | Price unit | |||
55 | ![]() |
![]() |
PSTYP | PSTYP | Item category in purchasing document | |||
56 | ![]() |
![]() |
REPOS | REPOS | Invoice receipt indicator | |||
57 | ![]() |
![]() |
TXZ01 | TXZ01 | Short Text | |||
58 | ![]() |
![]() |
UMREN | UMBSN | Denominator for Conversion of Order Unit to Base Unit | |||
59 | ![]() |
![]() |
UMREZ | UMBSZ | Numerator for Conversion of Order Unit to Base Unit | |||
60 | ![]() |
![]() |
WEBRE | WEBRE | Indicator: GR-Based Invoice Verification | |||
61 | ![]() |
![]() |
WEPOS | WEPOS | Goods Receipt Indicator | |||
62 | ![]() |
![]() |
WERKS | EWERK | Plant | |||
63 | ![]() |
![]() |
XERSY | XERSY | Evaluated Receipt Settlement (ERS) | |||
64 | ![]() |
![]() |
ZWERT | DZWERT | Target value for outline agreement in document currency | |||
65 | ![]() |
![]() |
ANZPU | ANZPU | Number of Points | |||
66 | ![]() |
![]() |
BPRME | BBPRM | Order Price Unit (purchasing) | |||
67 | ![]() |
![]() |
BPUMN | BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | |||
68 | ![]() |
![]() |
BPUMZ | BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | |||
69 | ![]() |
![]() |
BRGEW | BRGEW | Gross weight | |||
70 | ![]() |
![]() |
BRTWR | BBWERT | Gross order value in PO currency | |||
71 | ![]() |
![]() |
BSTAE | BSTAE | Confirmation Control Key | |||
72 | ![]() |
![]() |
BSTYP | BSTYP | Purchasing document category | |||
73 | ![]() |
![]() |
BUKRS | BUKRS | Company Code | |||
74 | ![]() |
![]() |
BWTAR | BWTAR_D | Valuation type | |||
75 | ![]() |
![]() |
EBONF | EBONY | Item Relevant to Subsequent (Period-End Rebate) Settlement | |||
76 | ![]() |
![]() |
EFFWR | EFFWR | Effective value of item | |||
77 | ![]() |
![]() |
EGLKZ | EGLKZ | "Outward Delivery Completed" Indicator | |||
78 | ![]() |
![]() |
EMNFR | EMNFR | External manufacturer code name or number | |||
79 | ![]() |
![]() |
FPLNR | IPLNR | Invoicing plan number | |||
80 | ![]() |
![]() |
GEWEI | EGEWE | Unit of Weight | |||
81 | ![]() |
![]() |
IDNLF | IDNLF | Material Number Used by Vendor | |||
82 | ![]() |
![]() |
INFNR | INFNR | Number of purchasing info record | |||
83 | ![]() |
![]() |
KNTTP | KNTTP | Account assignment category | |||
84 | ![]() |
![]() |
KZWI1 | KZWI1 | Subtotal 1 from pricing procedure for condition | |||
85 | ![]() |
![]() |
KZWI2 | KZWI2 | Subtotal 2 from pricing procedure for condition | |||
86 | ![]() |
![]() |
KZWI3 | KZWI3 | Subtotal 3 from pricing procedure for condition | |||
87 | ![]() |
![]() |
KZWI4 | KZWI4 | Subtotal 4 from pricing procedure for condition | |||
88 | ![]() |
![]() |
KZWI5 | KZWI5 | Subtotal 5 from pricing procedure for condition | |||
89 | ![]() |
![]() |
KZWI6 | KZWI6 | Subtotal 6 from pricing procedure for condition | |||
90 | ![]() |
![]() |
LOEKZ | ELOEK | Deletion indicator in purchasing document | |||
91 | ![]() |
![]() |
LTSNR | LTSNR | Vendor Subrange | |||
92 | ![]() |
![]() |
MEPRF | MEPRF | Price Determination (Pricing) Date Control | |||
93 | ![]() |
![]() |
MFRNR | MFRNR | Manufacturer number | |||
94 | ![]() |
![]() |
MFRPN | MFRPN | Manufacturer Part Number | |||
95 | ![]() |
![]() |
MPROF | MPROF | Mfr part profile | |||
96 | ![]() |
![]() |
MWSKZ | MWSKZ | Tax on sales/purchases code | |||
97 | ![]() |
![]() |
NAVNW | NAVNW | Non-deductible input tax | |||
98 | ![]() |
![]() |
NTGEW | ENTGE | Net Weight | |||
99 | ![]() |
![]() |
PRDAT | PREDT | Date of Price Determination | |||
100 | ![]() |
![]() |
PUNEI | PUNEI | Points unit | |||
101 | ![]() |
![]() |
RESLO | RESLO | Issuing Storage Location for Stock Transport Order | |||
102 | ![]() |
![]() |
RETPO | RETPO | Returns Item | |||
103 | ![]() |
![]() |
SATNR | SATNR | Cross-Plant Configurable Material | |||
104 | ![]() |
![]() |
STAFO | STAFO | Update group for statistics update | |||
105 | ![]() |
![]() |
STAPO | STAPO | Item is statistical | |||
106 | ![]() |
![]() |
STATU | ASTAT | RFQ status | |||
107 | ![]() |
![]() |
TWRKZ | TWRKZ | Partial invoice indicator | |||
108 | ![]() |
![]() |
VOLEH | VOLEH | Volume unit | |||
109 | ![]() |
![]() |
VOLUM | VOLUM | Volume | |||
110 | ![]() |
![]() |
VRTKZ | VRTKZ | Distribution indicator for multiple account assignment | |||
111 | ![]() |
![]() |
WEBAZ | WEBAZ | Goods receipt processing time in days | |||
112 | ![]() |
![]() |
WEUNB | WEUNB | Goods Receipt, Non-Valuated | |||
113 | ![]() |
![]() |
BANFN | BANFN | Purchase requisition number | |||
114 | ![]() |
![]() |
BNFPO | BNFPO | Item number of purchase requisition | |||
115 | ![]() |
![]() |
UEBTO | UEBTO | Overdelivery Tolerance Limit | |||
116 | ![]() |
![]() |
UEBTK | UEBTK | Indicator: Unlimited Overdelivery Allowed | |||
117 | ![]() |
![]() |
UNTTO | UNTTO | Underdelivery Tolerance Limit | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 606 |