SAP ABAP Table QBEW (Project Stock Valuation)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MGA (Package) Application development R/3 material master from 3.0
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MGA (Package) Application development R/3 material master from 3.0
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | QBEW | Table Relationship Diagram |
Short Description | Project Stock Valuation |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
3 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | * | |
4 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
5 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | * | |
6 | PSPNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
7 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 1 | |||||
8 | LBKUM | LBKUM | MENG13V | QUAN | 13 | 3 | Total Valuated Stock | ||
9 | SALK3 | SALK3 | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock | ||
10 | VPRSV | VPRSV | VPRSV | CHAR | 1 | 0 | Price control indicator | ||
11 | VERPR | VERPR | WERT11V | CURR | 11 | 2 | Moving Average Price/Periodic Unit Price | ||
12 | STPRS | STPRS | WERT11V | CURR | 11 | 2 | Standard price | ||
13 | PEINH | PEINH | PACK3 | DEC | 5 | 0 | Price unit | ||
14 | BKLAS | BKLAS | BKLAS | CHAR | 4 | 0 | Valuation Class | T025 | |
15 | SALKV | SALKV | WERT13N | CURR | 13 | 2 | Value based on moving average price (only with price ctrl S) | ||
16 | VMKUM | VMKUM | MENG13V | QUAN | 13 | 3 | Total valuated stock in previous period | ||
17 | VMSAL | VMSAL | WERT13N | CURR | 13 | 2 | Value of total valuated stock in previous period | ||
18 | VMVPR | VMVPR | VPRSV | CHAR | 1 | 0 | Price control indicator for previous period | ||
19 | VMVER | VMVER | WERT11V | CURR | 11 | 2 | Moving Average Price/Periodic Unit Price in Previous Period | ||
20 | VMSTP | VMSTP | WERT11V | CURR | 11 | 2 | Standard price in the previous period | ||
21 | VMPEI | VMPEI | PACK3 | DEC | 5 | 0 | Price unit of previous period | ||
22 | VMBKL | VMBKL | BKLAS | CHAR | 4 | 0 | Valuation class of previous period | T025 | |
23 | VMSAV | VMSAV | WERT13N | CURR | 13 | 2 | Value based on moving average price (previous period) | ||
24 | VJKUM | VJKUM | MENG13V | QUAN | 13 | 3 | Total valuated stock in previous year | ||
25 | VJSAL | VJSAL | WERT13N | CURR | 13 | 2 | Value of total valuated stock in previous year | ||
26 | VJVPR | VJVPR | VPRSV | CHAR | 1 | 0 | Price control indicator for previous year | ||
27 | VJVER | VJVER | WERT11V | CURR | 11 | 2 | Moving Average Price/Periodic Unit Price in Previous Year | ||
28 | VJSTP | VJSTP | WERT11V | CURR | 11 | 2 | Standard price in previous year | ||
29 | VJPEI | VJPEI | PACK3 | DEC | 5 | 0 | Price unit of previous year | ||
30 | VJBKL | VJBKL | BKLAS | CHAR | 4 | 0 | Valuation class from previous year | T025 | |
31 | VJSAV | VJSAV | WERT13N | CURR | 13 | 2 | Value based on moving average price (previous year) | ||
32 | LFGJA | LFGJA | GJAHR | NUMC | 4 | 0 | Fiscal Year of Current Period | ||
33 | LFMON | LFMON | MONAT | NUMC | 2 | 0 | Current period (posting period) | ||
34 | BWTTY | BWTTY_D | BWTTY | CHAR | 1 | 0 | Valuation Category | T149C | |
35 | STPRV | STPRV | WERT11V | CURR | 11 | 2 | Previous price | ||
36 | LAEPR | LAEPR | DATUM | DATS | 8 | 0 | Date of the last price change | ||
37 | ZKPRS | DZKPRS | WERT11 | CURR | 11 | 2 | Future price | ||
38 | ZKDAT | DZKDAT | DATUM | DATS | 8 | 0 | Date as of which the price is valid | ||
39 | TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
40 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 2 | |||||
41 | ZPLPR | DZPLPR | WERT11 | CURR | 11 | 2 | Future planned price | ||
42 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 3 | |||||
43 | KALKZ | KAXKZ | XFELD | CHAR | 1 | 0 | Indicator: standard cost estimate for future period | ||
44 | KALKL | KALKL | XFELD | CHAR | 1 | 0 | Indicator: standard cost estimate for current period | ||
45 | KALKV | KALKV | XFELD | CHAR | 1 | 0 | Indicator: standard cost estimate for previous period | ||
46 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 4 | |||||
47 | KALN1 | CK_KALNR1 | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number - Product Costing | * | |
48 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 5 | |||||
49 | BWVA1 | CK_BWVA1 | CK_BWVAR | CHAR | 3 | 0 | Valuation variant for the future standard cost estimate | TCK05 | |
50 | BWVA2 | CK_BWVA2 | CK_BWVAR | CHAR | 3 | 0 | Valuation variant for the current standard cost estimate | TCK05 | |
51 | BWVA3 | CK_BWVA3 | CK_BWVAR | CHAR | 3 | 0 | Valuation variant for past standard cost estimate | TCK05 | |
52 | VERS1 | CK_TVERS1 | CK_VERSION | NUMC | 2 | 0 | Costing version of the future standard cost estimate | ||
53 | VERS2 | CK_TVERS2 | CK_VERSION | NUMC | 2 | 0 | Costing version of the current standard cost estimate | ||
54 | VERS3 | CK_TVERS3 | CK_VERSION | NUMC | 2 | 0 | Costing version of the previous standard cost estimate | ||
55 | HRKFT | HRKFT | HRKFT | CHAR | 4 | 0 | Origin Group as Subdivision of Cost Element | TKKH1 | |
56 | KOSGR | CK_KOSGR | CK_KOSGR | CHAR | 10 | 0 | Costing overhead group | TCK14 | |
57 | PPRDZ | CK_PPRDZ | POPER | NUMC | 3 | 0 | Period of future cost estimate | ||
58 | PPRDL | CK_PPRDL | POPER | NUMC | 3 | 0 | Period of the current cost estimate | ||
59 | PPRDV | CK_PPRDV | POPER | NUMC | 3 | 0 | Period of the previous cost estimate | ||
60 | PDATZ | CK_PDATZ | GJAHR | NUMC | 4 | 0 | Future fiscal year | ||
61 | PDATL | CK_PDATL | GJAHR | NUMC | 4 | 0 | Fiscal year for current cost estimate | ||
62 | PDATV | CK_PDATV | GJAHR | NUMC | 4 | 0 | Fiscal year of previous cost estimate | ||
63 | EKALR | CK_EKALREL | XFELD | CHAR | 1 | 0 | Material Is Costed with Quantity Structure | ||
64 | VPLPR | VPLPR | WERT11 | CURR | 11 | 2 | Previous planned price | ||
65 | MLMAA | CK_ML_MAAC | XFELD | CHAR | 1 | 0 | Material ledger activated at material level | ||
66 | MLAST | CK_ML_ABST | CK_ML_ABST | CHAR | 1 | 0 | Material Price Determination: Control | ||
67 | LPLPR | CK_LPLPR | WERT11 | CURR | 11 | 2 | Current Planned Price | ||
68 | VKSAL | VKSAL | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock at Sales Price | ||
69 | HKMAT | HKMAT | HKMAT | CHAR | 1 | 0 | Material-related origin | ||
70 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 6 | |||||
71 | BWSPA | BWSPA | PRZ32V | DEC | 6 | 2 | Valuation margin | ||
72 | LPLPX | CK_LPLPX | WERT11V | CURR | 11 | 2 | Fixed Portion of Current Planned Price | ||
73 | VPLPX | CK_VPLPX | WERT11V | CURR | 11 | 2 | Fixed Portion of Previous Planned Price | ||
74 | FPLPX | CK_ZPLPX | WERT11V | CURR | 11 | 2 | Fixed Portion of Future Planned Price | ||
75 | LBWST | CK_LBWST | CK_BWST | CHAR | 1 | 0 | Val. strat. for current plan price, sales order/proj. stock | ||
76 | VBWST | CK_VBWST | CK_BWST | CHAR | 1 | 0 | Valn. strategy for prev. planned price, restricted use stock | ||
77 | FBWST | CK_ZBWST | CK_BWST | CHAR | 1 | 0 | Valn strategy for future planned price, restr. use stock | ||
78 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 7 | |||||
79 | MBRUE | MBRUE | XFELD | CHAR | 1 | 0 | MBEWH rec. already exists for per. before last of MBEW per. | ||
80 | OKLAS | OKLAS | BKLAS | CHAR | 4 | 0 | Valuation Class for Special Stock at the Vendor | T025 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | QBEW | BKLAS | T025 | BKLAS | |||
2 | QBEW | BWTTY | T149C | BWTTY | |||
3 | QBEW | BWVA1 | TCK05 | BWVAR | |||
4 | QBEW | BWVA2 | TCK05 | BWVAR | |||
5 | QBEW | BWVA3 | TCK05 | BWVAR | |||
6 | QBEW | HRKFT | TKKH1 | HRKFT | |||
7 | QBEW | KOSGR | TCK14 | KOSGR | |||
8 | QBEW | OKLAS | T025 | BKLAS | |||
9 | QBEW | VJBKL | T025 | BKLAS | |||
10 | QBEW | VMBKL | T025 | BKLAS |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in |