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