SAP ABAP Table MDG_BS_MAT_S_MBEW_PDF (MDG BS MAT: Material Master Valuation Data Structure)
Hierarchy
☛
MDG_APPL (Software Component) MDG Applications
⤷ CA-MDG-APP-MM (Application Component) MDG Material
⤷ MDG_BS_MAT_PDF (Package) MDG: Printing
⤷ CA-MDG-APP-MM (Application Component) MDG Material
⤷ MDG_BS_MAT_PDF (Package) MDG: Printing
Basic Data
Table Category | INTTAB | Structure |
Structure | MDG_BS_MAT_S_MBEW_PDF | Table Relationship Diagram |
Short Description | MDG BS MAT: Material Master Valuation Data Structure |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | MDG BS MAT: Material Master Valuation Data Structure | |||||
2 | .INCLUDE | 0 | 0 | Material Valuation | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
5 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | T001K | |
6 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
7 | .INCLUDE | 0 | 0 | Data Division MBEW | |||||
8 | LVORM | LVOBA | XFELD | CHAR | 1 | 0 | Deletion flag for all material data of a valuation type | ||
9 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 1 | |||||
10 | LBKUM | LBKUM | MENG13V | QUAN | 13 | 3 | Total Valuated Stock | ||
11 | SALK3 | SALK3 | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock | ||
12 | VPRSV | VPRSV | VPRSV | CHAR | 1 | 0 | Price control indicator | ||
13 | VERPR | VERPR | WERT11V | CURR | 11 | 2 | Moving Average Price/Periodic Unit Price | ||
14 | STPRS | STPRS | WERT11V | CURR | 11 | 2 | Standard price | ||
15 | PEINH | PEINH | PACK3 | DEC | 5 | 0 | Price unit | ||
16 | BKLAS | BKLAS | BKLAS | CHAR | 4 | 0 | Valuation Class | T025 | |
17 | SALKV | SALKV | WERT13N | CURR | 13 | 2 | Value based on moving average price (only with price ctrl S) | ||
18 | VMKUM | VMKUM | MENG13V | QUAN | 13 | 3 | Total valuated stock in previous period | ||
19 | VMSAL | VMSAL | WERT13N | CURR | 13 | 2 | Value of total valuated stock in previous period | ||
20 | VMVPR | VMVPR | VPRSV | CHAR | 1 | 0 | Price control indicator for previous period | ||
21 | VMVER | VMVER | WERT11V | CURR | 11 | 2 | Moving Average Price/Periodic Unit Price in Previous Period | ||
22 | VMSTP | VMSTP | WERT11V | CURR | 11 | 2 | Standard price in the previous period | ||
23 | VMPEI | VMPEI | PACK3 | DEC | 5 | 0 | Price unit of previous period | ||
24 | VMBKL | VMBKL | BKLAS | CHAR | 4 | 0 | Valuation class of previous period | T025 | |
25 | VMSAV | VMSAV | WERT13N | CURR | 13 | 2 | Value based on moving average price (previous period) | ||
26 | VJKUM | VJKUM | MENG13V | QUAN | 13 | 3 | Total valuated stock in previous year | ||
27 | VJSAL | VJSAL | WERT13N | CURR | 13 | 2 | Value of total valuated stock in previous year | ||
28 | VJVPR | VJVPR | VPRSV | CHAR | 1 | 0 | Price control indicator for previous year | ||
29 | VJVER | VJVER | WERT11V | CURR | 11 | 2 | Moving Average Price/Periodic Unit Price in Previous Year | ||
30 | VJSTP | VJSTP | WERT11V | CURR | 11 | 2 | Standard price in previous year | ||
31 | VJPEI | VJPEI | PACK3 | DEC | 5 | 0 | Price unit of previous year | ||
32 | VJBKL | VJBKL | BKLAS | CHAR | 4 | 0 | Valuation class from previous year | T025 | |
33 | VJSAV | VJSAV | WERT13N | CURR | 13 | 2 | Value based on moving average price (previous year) | ||
34 | LFGJA | LFGJA | GJAHR | NUMC | 4 | 0 | Fiscal Year of Current Period | ||
35 | LFMON | LFMON | MONAT | NUMC | 2 | 0 | Current period (posting period) | ||
36 | BWTTY | BWTTY_D | BWTTY | CHAR | 1 | 0 | Valuation Category | T149 | |
37 | STPRV | STPRV | WERT11V | CURR | 11 | 2 | Previous price | ||
38 | LAEPR | LAEPR | DATUM | DATS | 8 | 0 | Date of the last price change | ||
39 | ZKPRS | DZKPRS | WERT11 | CURR | 11 | 2 | Future price | ||
40 | ZKDAT | DZKDAT | DATUM | DATS | 8 | 0 | Date as of which the price is valid | ||
41 | TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
42 | BWPRS | BWPRS | WERT11 | CURR | 11 | 2 | Valuation price based on tax law: level 1 | ||
43 | BWPRH | BWPRH | WERT11 | CURR | 11 | 2 | Valuation price based on commercial law: level 1 | ||
44 | VJBWS | VJBWS | WERT11 | CURR | 11 | 2 | Valuation price based on tax law: level 3 | ||
45 | VJBWH | VJBWH | WERT11 | CURR | 11 | 2 | Valuation price based on commercial law: level 3 | ||
46 | VVJSL | VVJSL | WERT13N | CURR | 13 | 2 | Value of total valuated stock in year before last | ||
47 | VVJLB | VVJLB | MENG13V | QUAN | 13 | 3 | Total valuated stock in year before last | ||
48 | VVMLB | VVMLB | MENG13V | QUAN | 13 | 3 | Total valuated stock in period before last | ||
49 | VVSAL | VVSAL | WERT13N | CURR | 13 | 2 | Value of total valuated stock in period before last | ||
50 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 2 | |||||
51 | ZPLPR | DZPLPR | WERT11 | CURR | 11 | 2 | Future planned price | ||
52 | ZPLP1 | DZPLP1 | WERT11 | CURR | 11 | 2 | Future Planned Price 1 | ||
53 | ZPLP2 | DZPLP2 | WERT11 | CURR | 11 | 2 | Future Planned Price 2 | ||
54 | ZPLP3 | DZPLP3 | WERT11 | CURR | 11 | 2 | Future Planned Price 3 | ||
55 | ZPLD1 | DZPLD1 | DATUM | DATS | 8 | 0 | Date from Which Future Planned Price 1 Is Valid | ||
56 | ZPLD2 | DZPLD2 | DATUM | DATS | 8 | 0 | Date from Which Future Planned Price 2 Is Valid | ||
57 | ZPLD3 | DZPLD3 | DATUM | DATS | 8 | 0 | Date from Which Future Planned Price 3 Is Valid | ||
58 | PPERZ | PPERZ | BUPER | ACCP | 6 | 0 | Period for future standard cost estimate (deactivated) | ||
59 | PPERL | PPERL | BUPER | ACCP | 6 | 0 | Period for current standard cost estimate (deactivated) | ||
60 | PPERV | PPERV | BUPER | ACCP | 6 | 0 | Period for previous standard cost estimate (deactivated) | ||
61 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 3 | |||||
62 | KALKZ | KAXKZ | XFELD | CHAR | 1 | 0 | Indicator: standard cost estimate for future period | ||
63 | KALKL | KALKL | XFELD | CHAR | 1 | 0 | Indicator: standard cost estimate for current period | ||
64 | KALKV | KALKV | XFELD | CHAR | 1 | 0 | Indicator: standard cost estimate for previous period | ||
65 | KALSC | KALSC | KALSC | CHAR | 6 | 0 | Overhead key (deactivated) | ||
66 | XLIFO | XLIFO | LIFO_FIFO | CHAR | 1 | 0 | LIFO/FIFO-relevant | ||
67 | MYPOL | MYPOOL | LIFO_POOL | CHAR | 4 | 0 | Pool number for LIFO valuation | TPOOL | |
68 | BWPH1 | BWPH1 | WERT11 | CURR | 11 | 2 | Valuation price based on commercial law: level 2 | ||
69 | BWPS1 | BWPS1 | WERT11 | CURR | 11 | 2 | Valuation price based on tax law: level 2 | ||
70 | ABWKZ | ABWKZ | NUMC2 | NUMC | 2 | 0 | Lowest value: devaluation indicator | ||
71 | PSTAT | PSTAT_D | PSTAT | CHAR | 15 | 0 | Maintenance status | ||
72 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 4 | |||||
73 | KALN1 | CK_KALNR1 | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number - Product Costing | * | |
74 | KALNR | CK_KALNR | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number for Cost Est. w/o Qty Structure | * | |
75 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 5 | |||||
76 | BWVA1 | CK_BWVA1 | CK_BWVAR | CHAR | 3 | 0 | Valuation variant for the future standard cost estimate | TCK05 | |
77 | BWVA2 | CK_BWVA2 | CK_BWVAR | CHAR | 3 | 0 | Valuation variant for the current standard cost estimate | TCK05 | |
78 | BWVA3 | CK_BWVA3 | CK_BWVAR | CHAR | 3 | 0 | Valuation variant for past standard cost estimate | TCK05 | |
79 | VERS1 | CK_TVERS1 | CK_VERSION | NUMC | 2 | 0 | Costing version of the future standard cost estimate | ||
80 | VERS2 | CK_TVERS2 | CK_VERSION | NUMC | 2 | 0 | Costing version of the current standard cost estimate | ||
81 | VERS3 | CK_TVERS3 | CK_VERSION | NUMC | 2 | 0 | Costing version of the previous standard cost estimate | ||
82 | HRKFT | HRKFT | HRKFT | CHAR | 4 | 0 | Origin Group as Subdivision of Cost Element | TKKH1 | |
83 | KOSGR | CK_KOSGR | CK_KOSGR | CHAR | 10 | 0 | Costing overhead group | TCK14 | |
84 | PPRDZ | CK_PPRDZ | POPER | NUMC | 3 | 0 | Period of future cost estimate | ||
85 | PPRDL | CK_PPRDL | POPER | NUMC | 3 | 0 | Period of the current cost estimate | ||
86 | PPRDV | CK_PPRDV | POPER | NUMC | 3 | 0 | Period of the previous cost estimate | ||
87 | PDATZ | CK_PDATZ | GJAHR | NUMC | 4 | 0 | Future fiscal year | ||
88 | PDATL | CK_PDATL | GJAHR | NUMC | 4 | 0 | Fiscal year for current cost estimate | ||
89 | PDATV | CK_PDATV | GJAHR | NUMC | 4 | 0 | Fiscal year of previous cost estimate | ||
90 | EKALR | CK_EKALREL | XFELD | CHAR | 1 | 0 | Material Is Costed with Quantity Structure | ||
91 | VPLPR | VPLPR | WERT11 | CURR | 11 | 2 | Previous planned price | ||
92 | MLMAA | CK_ML_MAAC | XFELD | CHAR | 1 | 0 | Material ledger activated at material level | ||
93 | MLAST | CK_ML_ABST | CK_ML_ABST | CHAR | 1 | 0 | Material Price Determination: Control | ||
94 | LPLPR | CK_LPLPR | WERT11 | CURR | 11 | 2 | Current Planned Price | ||
95 | VKSAL | VKSAL | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock at Sales Price | ||
96 | HKMAT | HKMAT | HKMAT | CHAR | 1 | 0 | Material-related origin | ||
97 | SPERW | SPERR | SPERR | CHAR | 1 | 0 | Physical inventory blocking indicator | ||
98 | KZIWL | KZIWL | INVKZ | CHAR | 3 | 0 | Phys. inventory indicator for value-only material | ||
99 | WLINL | DLINL | DATS | DATS | 8 | 0 | Date of last physical inventory for unrestricted-use stock | ||
100 | ABCIW | ABCIN | ABCIN | CHAR | 1 | 0 | Physical inventory indicator for cycle counting | * | |
101 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 6 | |||||
102 | BWSPA | BWSPA | PRZ32V | DEC | 6 | 2 | Valuation margin | ||
103 | LPLPX | CK_LPLPX | WERT11V | CURR | 11 | 2 | Fixed Portion of Current Planned Price | ||
104 | VPLPX | CK_VPLPX | WERT11V | CURR | 11 | 2 | Fixed Portion of Previous Planned Price | ||
105 | FPLPX | CK_ZPLPX | WERT11V | CURR | 11 | 2 | Fixed Portion of Future Planned Price | ||
106 | LBWST | CK_LBWST | CK_BWST | CHAR | 1 | 0 | Val. strat. for current plan price, sales order/proj. stock | ||
107 | VBWST | CK_VBWST | CK_BWST | CHAR | 1 | 0 | Valn. strategy for prev. planned price, restricted use stock | ||
108 | FBWST | CK_ZBWST | CK_BWST | CHAR | 1 | 0 | Valn strategy for future planned price, restr. use stock | ||
109 | EKLAS | EKLAS | BKLAS | CHAR | 4 | 0 | Valuation Class for Sales Order Stock | T025 | |
110 | QKLAS | QKLAS | BKLAS | CHAR | 4 | 0 | Valuation Class for Project Stock | T025 | |
111 | MTUSE | J_1BMATUSE | J_1BMATUSE | CHAR | 1 | 0 | Usage of the material | ||
112 | MTORG | J_1BMATORG | J_1BMATORG | CHAR | 1 | 0 | Origin of the material | ||
113 | OWNPR | J_1BOWNPRO | XFELD | CHAR | 1 | 0 | Produced in-house | ||
114 | XBEWM | XBEWW | XFELD | CHAR | 1 | 0 | Valuation based on the batch-specific unit of measure | ||
115 | BWPEI | BWPEI | PACK3 | DEC | 5 | 0 | Price unit for valuation prices based on tax/commercial law | ||
116 | .INCLUDE | 0 | 0 | Joint Data Part MBEW/EBEW/QBEW: Part 7 | |||||
117 | MBRUE | MBRUE | XFELD | CHAR | 1 | 0 | MBEWH rec. already exists for per. before last of MBEW per. | ||
118 | OKLAS | OKLAS | BKLAS | CHAR | 4 | 0 | Valuation Class for Special Stock at the Vendor | T025 | |
119 | .INCLU--AP | 0 | 0 | Joint Venture Extension to MBEW | |||||
120 | OIPPINV | JV_PPINV | JV_PPINV | CHAR | 1 | 0 | Prepaid Inventory Flag for Material Valuation Type Segment | ||
121 | MTART | MTART | MTART | CHAR | 4 | 0 | Material type | * | |
122 | USMD_DESCRIPTION | MDG_BS_MAT_S_PDF_MBEW_DESC | STRU | 0 | 0 | ||||
123 | BKLAS | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
124 | HKMAT | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
125 | HRKFT | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
126 | KOSGR | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
127 | EKALR | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
128 | MLAST | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
129 | MLMAA | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
130 | ABWKZ | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
131 | MYPOL | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
132 | XLIFO | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
133 | BWTTY | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
134 | QKLAS | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
135 | EKLAS | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
136 | MTORG | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
137 | MTUSE | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
138 | OWNPR | USMD_TXTLG | TEXT60 | CHAR | 60 | 0 | Description (long text) | ||
139 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MDG_BS_MAT_S_MBEW_PDF | BKLAS | T025 | BKLAS | REF | C | CN |
2 | MDG_BS_MAT_S_MBEW_PDF | BWKEY | T001K | BWKEY | KEY | 1 | CN |
3 | MDG_BS_MAT_S_MBEW_PDF | BWTTY | T149 | BWTTY | REF | C | CN |
4 | MDG_BS_MAT_S_MBEW_PDF | BWVA1 | TCK05 | BWVAR | REF | C | CN |
5 | MDG_BS_MAT_S_MBEW_PDF | BWVA2 | TCK05 | BWVAR | REF | C | CN |
6 | MDG_BS_MAT_S_MBEW_PDF | BWVA3 | TCK05 | BWVAR | REF | C | CN |
7 | MDG_BS_MAT_S_MBEW_PDF | EKLAS | T025 | BKLAS | |||
8 | MDG_BS_MAT_S_MBEW_PDF | HRKFT | TKKH1 | HRKFT | REF | C | CN |
9 | MDG_BS_MAT_S_MBEW_PDF | KOSGR | TCK14 | KOSGR | REF | C | CN |
10 | MDG_BS_MAT_S_MBEW_PDF | MANDT | T000 | MANDT | KEY | 1 | CN |
11 | MDG_BS_MAT_S_MBEW_PDF | MATNR | MARA | MATNR | KEY | 1 | CN |
12 | MDG_BS_MAT_S_MBEW_PDF | MYPOL | TPOOL | MYPOOL | REF | C | CN |
13 | MDG_BS_MAT_S_MBEW_PDF | OKLAS | T025 | BKLAS | |||
14 | MDG_BS_MAT_S_MBEW_PDF | QKLAS | T025 | BKLAS | |||
15 | MDG_BS_MAT_S_MBEW_PDF | VJBKL | T025 | BKLAS | REF | C | CN |
16 | MDG_BS_MAT_S_MBEW_PDF | VMBKL | T025 | BKLAS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 607 |