SAP ABAP Table USEG (Retail Revaluation Document: Revaluation Segment)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ WBEF (Package) IS-R: Inventory Management
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ WBEF (Package) IS-R: Inventory Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | USEG | Table Relationship Diagram |
Short Description | Retail Revaluation Document: Revaluation Segment |
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 | T000 | |
2 | UBLNR | UBLNR | UBLNR | CHAR | 10 | 0 | Retail revaluation document number | * | |
3 | UBJAHR | UBJAHR | GJAHR | NUMC | 4 | 0 | Retail revaluation: document year | ||
4 | UZEIL | UZEIL | UZEIL | NUMC | 4 | 0 | Item number in retail revaluation document | ||
5 | UPSTA | UPSTA | UPSTA | CHAR | 1 | 0 | Item status of retail revaluation document | ||
6 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
7 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | T001K | |
8 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
9 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
10 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
11 | MATBF | MATBF | MATNR | CHAR | 18 | 0 | Material in Respect of Which Stock is Managed | MARA | |
12 | PV_GRUND | PV_GRUND | PV_GRUND | CHAR | 4 | 0 | Reason for retail price change | TWBN | |
13 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | MBEW | |
14 | VPDAT | VPDAT_D | DATUM | DATS | 8 | 0 | Date of retail price change | ||
15 | ENDPR | ENDPR | WERTV6 | CURR | 11 | 2 | Final price | ||
16 | VPNEU | VPNEU | WERTV6 | CURR | 11 | 2 | New retail price | ||
17 | VPALT | VPALT | WERTV6 | CURR | 11 | 2 | Old retail price | ||
18 | VRKPE | VRKPE | DEC5 | DEC | 5 | 0 | Sales price unit | ||
19 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
20 | VWAER | VWAER | WAERS | CUKY | 5 | 0 | Sales currency | TCURC | |
21 | AKTNR | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | WAKH | |
22 | VKLAB_OLD | VKLAB | WERT13N | CURR | 13 | 2 | Stock value of a value-only material at sales price | ||
23 | VKLABN_OLD | VKLAB_NET | WERT13N | CURR | 13 | 2 | Stock value of a value-only material at retail w/o tax | ||
24 | VKSAL_OLD | VKSAL | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock at Sales Price | ||
25 | VKSALN_OLD | VKSAL_NET | WERT13N | CURR | 13 | 2 | Total inventory value at retail without tax | ||
26 | VKSAD | VKSALD | WERT13N | CURR | 13 | 2 | Difference Between New and Previous Stock Value | ||
27 | VKSADN | VKSALD_NET | WERT13N | CURR | 13 | 2 | Difference in retail value without tax | ||
28 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
29 | ERFMG | VKUMG | MENG13V | QUAN | 13 | 3 | Quantity in unit of entry for revaluation at retail | ||
30 | MENGE | MENGV | MENG13V | QUAN | 13 | 3 | Quantity with +/- sign in base unit of measure | ||
31 | LBKUM | LBKUM | MENG13V | QUAN | 13 | 3 | Total Valuated Stock | ||
32 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
33 | UMVKZ | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
34 | UMVKN | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
35 | SPANN | SPANN | XFELD | CHAR | 1 | 0 | Flag: not affecting margins | ||
36 | EKPA | EKPA_D | WERT11 | CURR | 11 | 2 | Old cost price | ||
37 | EKPN | NPREI | WERT11 | CURR | 11 | 2 | New Price | ||
38 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
39 | SALK3_OLD | SALK3 | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock | ||
40 | XIVNE | XIVNE | XFELD | CHAR | 1 | 0 | Indicates that change in retail value does not affect stock | ||
41 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
42 | .INCLU--AP | 0 | 0 | Data for Hybrid Method | |||||
43 | .INCLUDE | 0 | 0 | Data for Hybrid Method for Table USEG (Append) | |||||
44 | .INCLUDE | 0 | 0 | Result & Valuation Parameters for Purchase Val. Chg Profile | |||||
45 | UAKT | UAKT | PRICE_ORIG_CHG_TYPE | CHAR | 2 | 0 | Change Category of Sales Price Origin from Old to New Price | ||
46 | SALES_VAL_SIGN | VALUE_CHANGE_SIGN | VALUE_CHANGE_SIGN | CHAR | 1 | 0 | Sign of Sales Value Change | ||
47 | AFFECT_COST_VAL | AFFECT_COST_VAL_RESULT | AFFECT_COST_VAL_RESULT | CHAR | 1 | 0 | Adjust Cost Value (Result) | ||
48 | .INCLUDE | 0 | 0 | History of Revaluation Document | |||||
49 | VORGA_CREATE | VKPU_VORGA | VKPU_VORGA | CHAR | 1 | 0 | Indicates the transaction triggering revaluation at retail | ||
50 | MOD_CREATE | MODIFIER_COST_VAL | MODIFIER_COST_VAL | CHAR | 1 | 0 | Cost Value Changed By | ||
51 | TIME_CREATE | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
52 | VORGA_CHANGE | VKPU_VORGA | VKPU_VORGA | CHAR | 1 | 0 | Indicates the transaction triggering revaluation at retail | ||
53 | MOD_CHANGE | MODIFIER_COST_VAL | MODIFIER_COST_VAL | CHAR | 1 | 0 | Cost Value Changed By | ||
54 | TIME_CHANGE | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | USEG | AKTNR | WAKH | AKTNR | |||
2 | USEG | BUKRS | T001 | BUKRS | |||
3 | USEG | BWKEY | T001K | BWKEY | |||
4 | USEG | BWTAR | MBEW | BWTAR | KEY | 1 | CN |
5 | USEG | HWAER | TCURC | WAERS | |||
6 | USEG | LGORT | T001L | LGORT | |||
7 | USEG | MANDT | T000 | MANDT | |||
8 | USEG | MATBF | MARA | MATNR | |||
9 | USEG | MATNR | MARA | MATNR | |||
10 | USEG | MEINS | T006 | MSEHI | |||
11 | USEG | PV_GRUND | TWBN | PV_GRUND | |||
12 | USEG | VRKME | T006 | MSEHI | |||
13 | USEG | VWAER | TCURC | WAERS | REF | 1 | CN |
14 | USEG | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in |