USEG - Retail Revaluation Document: Revaluation Segment
Retail Revaluation Document: Revaluation Segment information is stored in SAP table USEG.
It is part of development package WBEF in software component LO-RFM-LG-SPV. This development package consists of objects that can be grouped under "IS-R: Inventory Management".
It is part of development package WBEF in software component LO-RFM-LG-SPV. This development package consists of objects that can be grouped under "IS-R: Inventory Management".
Fields for table USEG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| UBLNR | Retail revaluation document number | X | UBLNR | CHAR | 20 | |
| UBJAHR | Retail revaluation: document year | X | UBJAHR | NUMC | 8 | |
| UZEIL | Item number in retail revaluation document | X | UZEIL | NUMC | 8 | |
| UPSTA | Item status of retail revaluation document | UPSTA | CHAR | 2 | ||
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| BWKEY | Valuation area | BWKEY | CHAR | 8 | T001K | |
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| LGORT | Storage location | LGORT_D | CHAR | 8 | T001L | |
| MATNR | Material Number | MATNR | CHAR | 80 | MARA | |
| MATBF | Material in Respect of Which Stock is Managed | MATBF | CHAR | 80 | MARA | |
| PV_GRUND | Reason for retail price change | PV_GRUND | CHAR | 8 | TWBN | |
| BWTAR | Valuation Type | BWTAR_D | CHAR | 20 | MBEW | |
| VPDAT | Date of retail price change | VPDAT_D | DATS | 16 | ||
| ENDPR | Final price | ENDPR | CURR | 6 | ||
| VPNEU | New retail price | VPNEU | CURR | 6 | ||
| VPALT | Old retail price | VPALT | CURR | 6 | ||
| VRKPE | Sales price unit | VRKPE | DEC | 3 | ||
| VRKME | Sales unit | VRKME | UNIT | 6 | T006 | |
| VWAER | Sales currency | VWAER | CUKY | 10 | TCURC | |
| AKTNR | Promotion | WAKTION | CHAR | 20 | WAKH | |
| VKLAB_OLD | Stock value of a value-only material at sales price | VKLAB | CURR | 7 | ||
| VKLABN_OLD | Stock value of a value-only material at retail w/o tax | VKLAB_NET | CURR | 7 | ||
| VKSAL_OLD | Value of Total Valuated Stock at Sales Price | VKSAL | CURR | 7 | ||
| VKSALN_OLD | Total inventory value at retail without tax | VKSAL_NET | CURR | 7 | ||
| VKSAD | Difference Between New and Previous Stock Value | VKSALD | CURR | 7 | ||
| VKSADN | Difference in retail value without tax | VKSALD_NET | CURR | 7 | ||
| HWAER | Local Currency | HWAER | CUKY | 10 | TCURC | |
| ERFMG | Quantity in unit of entry for revaluation at retail | VKUMG | QUAN | 7 | ||
| MENGE | Quantity with +/- sign in base unit of measure | MENGV | QUAN | 7 | ||
| LBKUM | Total Valuated Stock | LBKUM | QUAN | 7 | ||
| MEINS | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 3 | ||
| UMVKN | Denominator (divisor) for conversion of sales Qty into SKU | UMVKN | DEC | 3 | ||
| SPANN | Flag: not affecting margins | SPANN | CHAR | 2 | ||
| EKPA | Old cost price | EKPA_D | CURR | 6 | ||
| EKPN | New Price | NPREI | CURR | 6 | ||
| WRBTR | Amount in Document Currency | WRBTR_CS | CURR | 7 | ||
| SALK3_OLD | Value of Total Valuated Stock | SALK3 | CURR | 7 | ||
| XIVNE | Indicates that change in retail value does not affect stock | XIVNE | CHAR | 2 | ||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
| .INCLU--AP | HYBRID_DATA_APPEND | 0 | ||||
| .INCLUDE | HYBRID_DATA | HYBRID_METHOD_DATA_APPEND_STY | 0 | |||
| .INCLUDE | RESULT_COST_VAL | RESULT_DATA_COST_VAL_STY | 0 | |||
| UAKT | Change Category of Sales Price Origin from Old to New Price | UAKT | CHAR | 4 | ||
| SALES_VAL_SIGN | Sign of Sales Value Change | VALUE_CHANGE_SIGN | CHAR | 2 | ||
| AFFECT_COST_VAL | Adjust Cost Value (Result) | AFFECT_COST_VAL_RESULT | CHAR | 2 | ||
| .INCLUDE | HISTORY_DATA | DOC_HISTORY_DATA_STY | 0 | |||
| VORGA_CREATE | Indicates the transaction triggering revaluation at retail | VKPU_VORGA | CHAR | 2 | ||
| MOD_CREATE | Cost Value Changed By | MODIFIER_COST_VAL | CHAR | 2 | ||
| TIME_CREATE | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| VORGA_CHANGE | Indicates the transaction triggering revaluation at retail | VKPU_VORGA | CHAR | 2 | ||
| MOD_CHANGE | Cost Value Changed By | MODIFIER_COST_VAL | CHAR | 2 | ||
| TIME_CHANGE | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 |