Material Valuation
Material Valuation Logical and Physical Data definitions
| AttributeName | ColName | DataType | ColLength | Precision | Scale | Nullable |
|---|---|---|---|---|---|---|
| Client | MANDT | N | 3 | 0 | 0 | Yes |
| Cost Estimate Number - Product Costing | KALN1 | N | 12 | 0 | 0 | Yes |
| Cost Estimate Number for Cost Est. w/o Qty Structure | KALNR | N | 12 | 0 | 0 | Yes |
| Costing Overhead Group | KOSGR | V | 10 | 0 | 0 | Yes |
| Costing Version of Current Standard Cost Estimate | VERS2 | N | 2 | 0 | 0 | Yes |
| Costing Version of Future Standard Cost Estimate | VERS1 | N | 2 | 0 | 0 | Yes |
| Costing Version of Previous Standard Cost Estimate | VERS3 | N | 2 | 0 | 0 | Yes |
| Current Planned Price | LPLPR | N | 11 | 11 | 2 | Yes |
| Current period (posting period) | LFMON | N | 2 | 0 | 0 | Yes |
| Date as of which the price is valid | ZKDAT | D | 8 | 0 | 0 | Yes |
| Date from Which Future Planned Price 1 Is Valid | ZPLD1 | D | 8 | 0 | 0 | Yes |
| Date from Which Future Planned Price 2 Is Valid | ZPLD2 | D | 8 | 0 | 0 | Yes |
| Date from Which Future Planned Price 3 Is Valid | ZPLD3 | D | 8 | 0 | 0 | Yes |
| Date of Last Posted Count | WLINL | D | 8 | 0 | 0 | Yes |
| Date of the last price change | LAEPR | D | 8 | 0 | 0 | Yes |
| Fiscal Year of Current Period | LFGJA | N | 4 | 0 | 0 | Yes |
| Fiscal Year of Current Standard Cost Estimate | PDATL | N | 4 | 0 | 0 | Yes |
| Fiscal Year of Future Standard Cost Estimate | PDATZ | N | 4 | 0 | 0 | Yes |
| Fiscal Year of Previous Standard Cost Estimate | PDATV | N | 4 | 0 | 0 | Yes |
| Fixed Portion of Current Planned Price | LPLPX | N | 11 | 11 | 2 | Yes |
| Fixed Portion of Future Planned Price | FPLPX | N | 11 | 11 | 2 | Yes |
| Fixed Portion of Previous Planned Price | VPLPX | N | 11 | 11 | 2 | Yes |
| Flag Material for Deletion | LVORM | V | 1 | 0 | 0 | Yes |
| Future Planned Price 1 | ZPLP1 | N | 11 | 11 | 2 | Yes |
| Future Planned Price 2 | ZPLP2 | N | 11 | 11 | 2 | Yes |
| Future Planned Price 3 | ZPLP3 | N | 11 | 11 | 2 | Yes |
| Future planned price | ZPLPR | N | 11 | 11 | 2 | Yes |
| Future price | ZKPRS | N | 11 | 11 | 2 | Yes |
| Indicator: standard cost estimate for future period | KALKZ | V | 1 | 0 | 0 | Yes |
| Indicator: standard cost estimate for previous period | KALKV | V | 1 | 0 | 0 | Yes |
| LIFO/FIFO-Relevant | XLIFO | V | 1 | 0 | 0 | Yes |
| Lowest value: devaluation indicator | ABWKZ | N | 2 | 0 | 0 | Yes |
| MBEWH rec. already exists for per. before last of MBEW per. | MBRUE | V | 1 | 0 | 0 | Yes |
| MD Product valuation extension field element | DUMMY_VAL_INCL_EEW_PS | V | 1 | 0 | 0 | Yes |
| Maintenance status | PSTAT | V | 15 | 0 | 0 | Yes |
| Material Is Costed with Quantity Structure | EKALR | V | 1 | 0 | 0 | Yes |
| Material Ledger Activated at Material Level | MLMAA | V | 1 | 0 | 0 | Yes |
| Material Number | MATNR | V | 40 | 0 | 0 | No |
| Material Price Determination: Control | MLAST | V | 1 | 0 | 0 | Yes |
| Material-related origin | HKMAT | V | 1 | 0 | 0 | Yes |
| Moving Average Price/Periodic Unit Price | VERPR | N | 11 | 11 | 2 | Yes |
| Moving Average Price/Periodic Unit Price in Previous Period | VMVER | N | 11 | 11 | 2 | Yes |
| Moving Average Price/Periodic Unit Price in Previous Year | VJVER | N | 11 | 11 | 2 | Yes |
| Origin Group as Subdivision of Cost Element | HRKFT | V | 4 | 0 | 0 | Yes |
| Origin of the material | MTORG | V | 1 | 0 | 0 | Yes |
| Overhead key (deactivated) | KALSC | V | 6 | 0 | 0 | Yes |
| Period for current standard cost estimate (deactivated) | PPERL | V | 6 | 0 | 0 | Yes |
| Period for future standard cost estimate (deactivated) | PPERZ | V | 6 | 0 | 0 | Yes |
| Period for previous standard cost estimate (deactivated) | PPERV | V | 6 | 0 | 0 | Yes |
| Period of Current Standard Cost Estimate | PPRDL | N | 3 | 0 | 0 | Yes |
| Period of Future Standard Cost Estimate | PPRDZ | N | 3 | 0 | 0 | Yes |
| Period of Previous Standard Cost Estimate | PPRDV | N | 3 | 0 | 0 | Yes |
| Phys. inventory indicator for value-only material | KZIWL | V | 3 | 0 | 0 | Yes |
| Physical Inventory Blocking Indicator | SPERW | V | 1 | 0 | 0 | Yes |
| Physical Inventory Indicator for Cycle Counting Plant Data | ABCIW | V | 1 | 0 | 0 | Yes |
| Pool number for LIFO valuation | MYPOL | V | 4 | 0 | 0 | Yes |
| Prepaid Inventory Flag for Material Valuation Type Segment | OIPPINV | V | 1 | 0 | 0 | Yes |
| Previous planned price | VPLPR | N | 11 | 11 | 2 | Yes |
| Previous price | STPRV | N | 11 | 11 | 2 | Yes |
| Price Control Indicator in Previous Period | VMVPR | V | 1 | 0 | 0 | Yes |
| Price Control Indicator in Previous Year | VJVPR | V | 1 | 0 | 0 | Yes |
| Price control indicator | VPRSV | V | 1 | 0 | 0 | Yes |
| Price unit | PEINH | N | 5 | 0 | 0 | Yes |
| Price unit for valuation prices based on tax/commercial law | BWPEI | N | 5 | 0 | 0 | Yes |
| Price unit of previous period | VMPEI | N | 5 | 0 | 0 | Yes |
| Price unit of previous year | VJPEI | N | 5 | 0 | 0 | Yes |
| Produced in-house | OWNPR | V | 1 | 0 | 0 | Yes |
| Standard Cost Estimate for Current Period | KALKL | V | 1 | 0 | 0 | Yes |
| Standard price | STPRS | N | 11 | 11 | 2 | Yes |
| Standard price in previous year | VJSTP | N | 11 | 11 | 2 | Yes |
| Standard price in the previous period | VMSTP | N | 11 | 11 | 2 | Yes |
| Total Valuated Stock | LBKUM | N | 13 | 13 | 3 | Yes |
| Total Valuated Stock in Previous Year | VJKUM | N | 13 | 13 | 3 | Yes |
| Total valuated stock in period before last | VVMLB | N | 13 | 13 | 3 | Yes |
| Total valuated stock in previous period | VMKUM | N | 13 | 13 | 3 | Yes |
| Total valuated stock in year before last | VVJLB | N | 13 | 13 | 3 | Yes |
| UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | N | 15 | 0 | 0 | Yes |
| Usage of the material | MTUSE | V | 1 | 0 | 0 | Yes |
| Val. Strat. for Current Plan Price, Sales Order/Proj. Stock | LBWST | V | 1 | 0 | 0 | Yes |
| Valuation Category | BWTTY | V | 1 | 0 | 0 | Yes |
| Valuation Class | BKLAS | V | 4 | 0 | 0 | Yes |
| Valuation Class for Project Stock | QKLAS | V | 4 | 0 | 0 | Yes |
| Valuation Class for Sales Order Stock | EKLAS | V | 4 | 0 | 0 | Yes |
| Valuation Class for Special Stock at the Vendor | OKLAS | V | 4 | 0 | 0 | Yes |
| Valuation Class in Previous Period | VMBKL | V | 4 | 0 | 0 | Yes |
| Valuation Class in Previous Year | VJBKL | V | 4 | 0 | 0 | Yes |
| Valuation Strategy for Future Planned Price, Special Stock | FBWST | V | 1 | 0 | 0 | Yes |
| Valuation Strategy for Previous Plan Price, Special Stock | VBWST | V | 1 | 0 | 0 | Yes |
| Valuation Type | BWTAR | V | 10 | 0 | 0 | No |
| Valuation Variant for Current Standard Cost Estimate | BWVA2 | V | 3 | 0 | 0 | Yes |
| Valuation Variant for Future Standard Cost Estimate | BWVA1 | V | 3 | 0 | 0 | Yes |
| Valuation Variant for Previous Standard Cost Estimate | BWVA3 | V | 3 | 0 | 0 | Yes |
| Valuation area | BWKEY | V | 4 | 0 | 0 | No |
| Valuation based on the batch-specific unit of measure | XBEWM | V | 1 | 0 | 0 | Yes |
| Valuation margin | BWSPA | N | 6 | 6 | 2 | Yes |
| Valuation price based on commercial law: level 1 | BWPRH | N | 11 | 11 | 2 | Yes |
| Valuation price based on commercial law: level 2 | BWPH1 | N | 11 | 11 | 2 | Yes |
| Valuation price based on commercial law: level 3 | VJBWH | N | 11 | 11 | 2 | Yes |
| Valuation price based on tax law: level 1 | BWPRS | N | 11 | 11 | 2 | Yes |
| Valuation price based on tax law: level 2 | BWPS1 | N | 11 | 11 | 2 | Yes |
| Valuation price based on tax law: level 3 | VJBWS | N | 11 | 11 | 2 | Yes |
| Value based on moving average price (only with price ctrl S) | SALKV | N | 13 | 13 | 2 | Yes |
| Value based on moving average price (previous period) | VMSAV | N | 13 | 13 | 2 | Yes |
| Value based on moving average price (previous year) | VJSAV | N | 13 | 13 | 2 | Yes |
| Value of Total Valuated Stock | SALK3 | N | 13 | 13 | 2 | Yes |
| Value of Total Valuated Stock at Sales Price | VKSAL | N | 13 | 13 | 2 | Yes |
| Value of total valuated stock in period before last | VVSAL | N | 13 | 13 | 2 | Yes |
| Value of total valuated stock in previous period | VMSAL | N | 13 | 13 | 2 | Yes |
| Value of total valuated stock in previous year | VJSAL | N | 13 | 13 | 2 | Yes |
| Value of total valuated stock in year before last | VVJSL | N | 13 | 13 | 2 | Yes |