SAP ABAP Table VKUMB (Transfer Table for Revaluation at Retail by FM)
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 | INTTAB | Structure |
Structure | VKUMB | Table Relationship Diagram |
Short Description | Transfer Table for Revaluation at Retail by FM |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
3 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
4 | VKUDT | VKUDT | DATUM | DATS | 8 | 0 | Date of retail price change | ||
5 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | T001K | |
6 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
7 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
8 | ERFMG | ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry | ||
9 | VPALT | VPALT | WERTV6 | CURR | 11 | 2 | Old retail price | ||
10 | VPNEU | VPNEU | WERTV6 | CURR | 11 | 2 | New retail price | ||
11 | ENDPN | ENDPN | WERTV6 | CURR | 11 | 2 | Net final price | ||
12 | VWAER | VWAER | WAERS | CUKY | 5 | 0 | Sales currency | * | |
13 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
14 | VRKPE | VRKPE | DEC5 | DEC | 5 | 0 | Sales price unit | ||
15 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
16 | UWERT | UWERT | UWERT | CHAR | 1 | 0 | Value for revaluation at retail | ||
17 | GUMBE | GUMBE | XFELD | CHAR | 1 | 0 | Indicator for total revaluation | ||
18 | VKSALN | VKSAL | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock at Sales Price | ||
19 | VKSALNN | VKSALN | WERT13N | CURR | 13 | 2 | Total stock value at retail | ||
20 | USALDO | USALDO | WERT7 | CURR | 13 | 2 | Balance for revaluation of inventory at retail | ||
21 | USALDN | USALDN | WERT7 | CURR | 13 | 2 | Net balance for revaluation of inventory at retail | ||
22 | SELKZ_SOLL | XSELS | XRADI | CHAR | 1 | 0 | Indicator: debit posting | ||
23 | SELKZ_HABE | XSELH | XRADI | CHAR | 1 | 0 | Indicator: credit posting | ||
24 | PV_GRUND | PV_GRUND | PV_GRUND | CHAR | 4 | 0 | Reason for retail price change | * | |
25 | SPANN | SPANN | XFELD | CHAR | 1 | 0 | Flag: not affecting margins | ||
26 | SUBRC | SUBRC | EK08R_RC | NUMC | 2 | 0 | Subroutines for return code | ||
27 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
28 | XBKNG | XBKNG | XFELD | CHAR | 1 | 0 | Negative stocks in valuation area allowed | ||
29 | XLONG | XLONG | XFELD | CHAR | 1 | 0 | Negative stocks allowed in storage location | ||
30 | XMCNG | XMCNG | XFELD | CHAR | 1 | 0 | Negative stocks allowed in plant | ||
31 | XZERO_COUNT | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
32 | .INCLU--AP | 0 | 0 | Data for Hybrid Method | |||||
33 | .INCLUDE | 0 | 0 | All Data for Hybrid Method | |||||
34 | .INCLUDE | 0 | 0 | Result and Origin Data: Purchase Value Change Profile | |||||
35 | .INCLUDE | 0 | 0 | Price Origin and Purchase Value Change Profile | |||||
36 | PROF_COST_VAL | PROF_COST_VAL | PROF_COST_VAL | CHAR | 4 | 0 | Cost Value Change Profile | * | |
37 | PR_ORIG_VPNEU | PRICE_ORIGIN | PRICE_ORIGIN | CHAR | 1 | 0 | Origin and Type of Sales Price | ||
38 | PR_ORIG_VPALT | PRICE_ORIGIN | PRICE_ORIGIN | CHAR | 1 | 0 | Origin and Type of Sales Price | ||
39 | PR_ORIG_DET_NEW | PRICE_ORIGIN | PRICE_ORIGIN | CHAR | 1 | 0 | Origin and Type of Sales Price | ||
40 | PR_ORIG_DET_OLD | PRICE_ORIGIN | PRICE_ORIGIN | CHAR | 1 | 0 | Origin and Type of Sales Price | ||
41 | .INCLUDE | 0 | 0 | Result & Valuation Parameters for Purchase Val. Chg Profile | |||||
42 | UAKT | UAKT | PRICE_ORIG_CHG_TYPE | CHAR | 2 | 0 | Change Category of Sales Price Origin from Old to New Price | ||
43 | SALES_VAL_SIGN | VALUE_CHANGE_SIGN | VALUE_CHANGE_SIGN | CHAR | 1 | 0 | Sign of Sales Value Change | ||
44 | AFFECT_COST_VAL | AFFECT_COST_VAL_RESULT | AFFECT_COST_VAL_RESULT | CHAR | 1 | 0 | Adjust Cost Value (Result) | ||
45 | .INCLUDE | 0 | 0 | History of Revaluation Document | |||||
46 | VORGA_CREATE | VKPU_VORGA | VKPU_VORGA | CHAR | 1 | 0 | Indicates the transaction triggering revaluation at retail | ||
47 | MOD_CREATE | MODIFIER_COST_VAL | MODIFIER_COST_VAL | CHAR | 1 | 0 | Cost Value Changed By | ||
48 | TIME_CREATE | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
49 | VORGA_CHANGE | VKPU_VORGA | VKPU_VORGA | CHAR | 1 | 0 | Indicates the transaction triggering revaluation at retail | ||
50 | MOD_CHANGE | MODIFIER_COST_VAL | MODIFIER_COST_VAL | CHAR | 1 | 0 | Cost Value Changed By | ||
51 | 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 | VKUMB | BWKEY | T001K | BWKEY | |||
2 | VKUMB | BWTAR | T149D | BWTAR | |||
3 | VKUMB | HWAER | TCURC | WAERS | |||
4 | VKUMB | MATNR | MARA | MATNR | |||
5 | VKUMB | VRKME | T006 | MSEHI |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |