SAP ABAP View MGV_QBEW (Selection QBEW with material version, see: http://material)
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷
LO-MD-MM (Application Component) Material Master
⤷
MGV_MATNR (Package) Material number conversion (long mat. no.)

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | MGV_QBEW | |
Short Description | Selection QBEW with material version, see: http://material | |
Root table | QBEW | Project Stock Valuation |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
QBEW | ||
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 | ![]() |
MATNR | JL | EQ | 0 | 0 | ||||
4 | ![]() |
MATNR_INT | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
* | |||||
2 | ![]() |
![]() |
MANDT | MANDT | Client | |||
3 | ![]() |
![]() |
MATNR | MATNR | Material Number | |||
4 | ![]() |
![]() |
BWKEY | BWKEY | Valuation area | |||
5 | ![]() |
![]() |
BWTAR | BWTAR_D | Valuation type | |||
6 | ![]() |
![]() |
SOBKZ | SOBKZ | Special Stock Indicator | |||
7 | ![]() |
![]() |
PSPNR | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | |||
8 | ![]() |
![]() |
LBKUM | LBKUM | Total Valuated Stock | |||
9 | ![]() |
![]() |
SALK3 | SALK3 | Value of Total Valuated Stock | |||
10 | ![]() |
![]() |
VPRSV | VPRSV | Price control indicator | |||
11 | ![]() |
![]() |
VERPR | VERPR | Moving Average Price/Periodic Unit Price | |||
12 | ![]() |
![]() |
STPRS | STPRS | Standard price | |||
13 | ![]() |
![]() |
PEINH | PEINH | Price unit | |||
14 | ![]() |
![]() |
BKLAS | BKLAS | Valuation Class | |||
15 | ![]() |
![]() |
SALKV | SALKV | Value based on moving average price (only with price ctrl S) | |||
16 | ![]() |
![]() |
VMKUM | VMKUM | Total valuated stock in previous period | |||
17 | ![]() |
![]() |
VMSAL | VMSAL | Value of total valuated stock in previous period | |||
18 | ![]() |
![]() |
VMVPR | VMVPR | Price control indicator for previous period | |||
19 | ![]() |
![]() |
VMVER | VMVER | Moving Average Price/Periodic Unit Price in Previous Period | |||
20 | ![]() |
![]() |
VMSTP | VMSTP | Standard price in the previous period | |||
21 | ![]() |
![]() |
VMPEI | VMPEI | Price unit of previous period | |||
22 | ![]() |
![]() |
VMBKL | VMBKL | Valuation class of previous period | |||
23 | ![]() |
![]() |
VMSAV | VMSAV | Value based on moving average price (previous period) | |||
24 | ![]() |
![]() |
VJKUM | VJKUM | Total valuated stock in previous year | |||
25 | ![]() |
![]() |
VJSAL | VJSAL | Value of total valuated stock in previous year | |||
26 | ![]() |
![]() |
VJVPR | VJVPR | Price control indicator for previous year | |||
27 | ![]() |
![]() |
VJVER | VJVER | Moving Average Price/Periodic Unit Price in Previous Year | |||
28 | ![]() |
![]() |
VJSTP | VJSTP | Standard price in previous year | |||
29 | ![]() |
![]() |
VJPEI | VJPEI | Price unit of previous year | |||
30 | ![]() |
![]() |
VJBKL | VJBKL | Valuation class from previous year | |||
31 | ![]() |
![]() |
VJSAV | VJSAV | Value based on moving average price (previous year) | |||
32 | ![]() |
![]() |
LFGJA | LFGJA | Fiscal Year of Current Period | |||
33 | ![]() |
![]() |
LFMON | LFMON | Current period (posting period) | |||
34 | ![]() |
![]() |
BWTTY | BWTTY_D | Valuation Category | |||
35 | ![]() |
![]() |
STPRV | STPRV | Previous price | |||
36 | ![]() |
![]() |
LAEPR | LAEPR | Date of the last price change | |||
37 | ![]() |
![]() |
ZKPRS | DZKPRS | Future price | |||
38 | ![]() |
![]() |
ZKDAT | DZKDAT | Date as of which the price is valid | |||
39 | ![]() |
![]() |
TIMESTAMP | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
40 | ![]() |
![]() |
ZPLPR | DZPLPR | Future planned price | |||
41 | ![]() |
![]() |
KALKZ | KAXKZ | Indicator: standard cost estimate for future period | |||
42 | ![]() |
![]() |
KALKL | KALKL | Indicator: standard cost estimate for current period | |||
43 | ![]() |
![]() |
KALKV | KALKV | Indicator: standard cost estimate for previous period | |||
44 | ![]() |
![]() |
KALN1 | CK_KALNR1 | Cost Estimate Number - Product Costing | |||
45 | ![]() |
![]() |
BWVA1 | CK_BWVA1 | Valuation variant for the future standard cost estimate | |||
46 | ![]() |
![]() |
BWVA2 | CK_BWVA2 | Valuation variant for the current standard cost estimate | |||
47 | ![]() |
![]() |
BWVA3 | CK_BWVA3 | Valuation variant for past standard cost estimate | |||
48 | ![]() |
![]() |
VERS1 | CK_TVERS1 | Costing version of the future standard cost estimate | |||
49 | ![]() |
![]() |
VERS2 | CK_TVERS2 | Costing version of the current standard cost estimate | |||
50 | ![]() |
![]() |
VERS3 | CK_TVERS3 | Costing version of the previous standard cost estimate | |||
51 | ![]() |
![]() |
HRKFT | HRKFT | Origin Group as Subdivision of Cost Element | |||
52 | ![]() |
![]() |
KOSGR | CK_KOSGR | Costing overhead group | |||
53 | ![]() |
![]() |
PPRDZ | CK_PPRDZ | Period of future cost estimate | |||
54 | ![]() |
![]() |
PPRDL | CK_PPRDL | Period of the current cost estimate | |||
55 | ![]() |
![]() |
PPRDV | CK_PPRDV | Period of the previous cost estimate | |||
56 | ![]() |
![]() |
PDATZ | CK_PDATZ | Future fiscal year | |||
57 | ![]() |
![]() |
PDATL | CK_PDATL | Fiscal year for current cost estimate | |||
58 | ![]() |
![]() |
PDATV | CK_PDATV | Fiscal year of previous cost estimate | |||
59 | ![]() |
![]() |
EKALR | CK_EKALREL | Material Is Costed with Quantity Structure | |||
60 | ![]() |
![]() |
VPLPR | VPLPR | Previous planned price | |||
61 | ![]() |
![]() |
MLMAA | CK_ML_MAAC | Material ledger activated at material level | |||
62 | ![]() |
![]() |
MLAST | CK_ML_ABST | Material Price Determination: Control | |||
63 | ![]() |
![]() |
LPLPR | CK_LPLPR | Current Planned Price | |||
64 | ![]() |
![]() |
VKSAL | VKSAL | Value of Total Valuated Stock at Sales Price | |||
65 | ![]() |
![]() |
HKMAT | HKMAT | Material-related origin | |||
66 | ![]() |
![]() |
BWSPA | BWSPA | Valuation margin | |||
67 | ![]() |
![]() |
LPLPX | CK_LPLPX | Fixed Portion of Current Planned Price | |||
68 | ![]() |
![]() |
VPLPX | CK_VPLPX | Fixed Portion of Previous Planned Price | |||
69 | ![]() |
![]() |
FPLPX | CK_ZPLPX | Fixed Portion of Future Planned Price | |||
70 | ![]() |
![]() |
LBWST | CK_LBWST | Val. strat. for current plan price, sales order/proj. stock | |||
71 | ![]() |
![]() |
VBWST | CK_VBWST | Valn. strategy for prev. planned price, restricted use stock | |||
72 | ![]() |
![]() |
FBWST | CK_ZBWST | Valn strategy for future planned price, restr. use stock | |||
73 | ![]() |
![]() |
MBRUE | MBRUE | MBEWH rec. already exists for per. before last of MBEW per. | |||
74 | ![]() |
![]() |
OKLAS | OKLAS | Valuation Class for Special Stock at the Vendor | |||
75 | ![]() |
![]() |
MATNR_EXT | MATNR_EXT | External Long Material Number | |||
76 | ![]() |
![]() |
MATNR_VERS | MATNR_VERS | Material Version Number | |||
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 | 20060920 |
SAP Release Created in |