1. Home
  2. Resources
  3. SAP Tables
  4. MCUSEG - Sales Price Change: Item Data

SAP Table MCUSEG

Sales Price Change: Item Data

MCUSEG (Sales Price Change: Item Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MCUSEG to other SAP tables.

Source: MCUSEG (Sales Price Change: Item Data)

MCUSEG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
UBLNR Retail revaluation document number UBLNR CHAR 10 0
UBJAHR Retail revaluation: document year UBJAHR NUMC 4 0
UZEIL Item number in retail revaluation document UZEIL NUMC 4 0
UPSTA Item status of retail revaluation document UPSTA CHAR 1 0
A Count still to be carried out
B Count complete, revaluation not yet taken place
C Revaluation carried out
D Items with errors, marked for deletion
BUKRS Company Code BUKRS T001 CHAR 4 0
BWKEY Valuation Area BWKEY T001K CHAR 4 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
MATNR Material Number MATNR MARA CHAR 18 0
MATBF Material in Respect of Which Stock is Managed MATBF MARA CHAR 18 0
PV_GRUND Reason for retail price change PV_GRUND TWBN CHAR 4 0
BWTAR Valuation Type BWTAR_D MBEW CHAR 10 0
VPDAT Date of retail price change VPDAT_D DATS 8 0
ENDPR Final price ENDPR CURR 11 2
VPNEU New retail price VPNEU CURR 11 2
VPALT Old retail price VPALT CURR 11 2
VRKPE Sales price unit VRKPE DEC 5 0
VRKME Sales unit VRKME T006 UNIT 3 0
VWAER Sales currency VWAER TCURC CUKY 5 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
VKLAB_OLD Stock value of a value-only material at sales price VKLAB CURR 13 2
VKLABN_OLD Stock value of a value-only material at retail w/o tax VKLAB_NET CURR 13 2
VKSAL_OLD Value of Total Valuated Stock at Sales Price VKSAL CURR 13 2
VKSALN_OLD Total inventory value at retail without tax VKSAL_NET CURR 13 2
VKSAD Difference Between New and Previous Stock Value VKSALD CURR 13 2
VKSADN Difference in retail value without tax VKSALD_NET CURR 13 2
HWAER Local Currency HWAER TCURC CUKY 5 0
ERFMG Quantity in unit of entry for revaluation at retail VKUMG QUAN 13 3
MENGE Quantity with +/- sign in base unit of measure MENGV QUAN 13 3
LBKUM Total Valuated Stock LBKUM QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 0
UMVKN Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 0
SPANN Flag: not affecting margins SPANN CHAR 1 0
X Yes
NULL No
EKPA Old cost price EKPA_D CURR 11 2
EKPN New price NPREI CURR 11 2
WRBTR Amount in document currency WRBTR CURR 13 2
SALK3_OLD Value of Total Valuated Stock SALK3 CURR 13 2
XIVNE Indicates that change in retail value does not affect stock XIVNE CHAR 1 0
X Yes
NULL No
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
UAKT Change Category of Sales Price Origin from Old to New Price UAKT CHAR 2 0
NULL Undefined (Not Determined)
11 From Regular Price to Regular Price
12 From Regular Price to Promotion Price
13 From Regular Price to Manual Price
14 From Regular Price to Unknown
21 From Promotion Price to Regular Price
22 From Promotion Price to Promotion Price
23 From Promotion Price to Manual Price
24 From Promotion Price to Unknown
31 From Manual Price to Regular Price
32 From Manual Price to Promotion Price
33 From Manual Price to Manual Price
34 From Manual Price to Unknown
41 From Unknown to Regular Price
42 From Unknown to Promotion Price
43 From Unknown to Manual Price
44 From Unknown to Unknown
SALES_VAL_SIGN Sign of Sales Value Change VALUE_CHANGE_SIGN CHAR 1 0
+ Increase in Sales Value
- Decrease in Sales Value
0 No Change to Sales Value
AFFECT_COST_VAL Adjust Cost Value (Result) AFFECT_COST_VAL_RESULT CHAR 1 0
NULL Undefined
1 Purchase Value Change (Profile)
2 Purchase Value Change (Partial Revaluation)
3 Purchase Value Change (No Profile)
4 Purchase Value Change (No Activation of Value-Only Material)
5 No Purchase Value Change (Affecting Margins)
6 No Purchase Value Change (Profile)
7 No Purchase Value Change (Zero Count)
8 No Purchase Value Change (BAdI)
9 Purchase Value Change (BAdI)
VORGA_CREATE Indicates the transaction triggering revaluation at retail VKPU_VORGA CHAR 1 0
1 Call revaluation at retail from report RWVKU001
2 Call revaluation at retail from dialog transaction
3 Call revaluation at retail via POS inbound
4 Call revaluation at retail via SAP Retail Store
5 Call revaluation at retail for status changes from B to C
MOD_CREATE Cost Value Changed By MODIFIER_COST_VAL CHAR 1 0
NULL Undefined
1 Automatic Total Revaluation
2 Total Revaluation Screen
3 Partial Revaluation Screen
4 Initialization/Correction of Sales Price Valuation
5 Stock Counting
6 Automatic Total Revaluation (No Stock)
7 Total Revaluation (Price Origin Change)
TIME_CREATE UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
VORGA_CHANGE Indicates the transaction triggering revaluation at retail VKPU_VORGA CHAR 1 0
1 Call revaluation at retail from report RWVKU001
2 Call revaluation at retail from dialog transaction
3 Call revaluation at retail via POS inbound
4 Call revaluation at retail via SAP Retail Store
5 Call revaluation at retail for status changes from B to C
MOD_CHANGE Cost Value Changed By MODIFIER_COST_VAL CHAR 1 0
NULL Undefined
1 Automatic Total Revaluation
2 Total Revaluation Screen
3 Partial Revaluation Screen
4 Initialization/Correction of Sales Price Valuation
5 Stock Counting
6 Automatic Total Revaluation (No Stock)
7 Total Revaluation (Price Origin Change)
TIME_CHANGE UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
BZIRK Sales district BZIRK T171 CHAR 6 0
EKSGB Purchasing area EKSGB T026 CHAR 4 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
LTSNR Vendor Subrange LTSNR WYT1 CHAR 6 0
BTRKZ Plant category VLFKZ CHAR 1 0
A Store
B Distribution Center
ABTNR Department number ABTNR TSAB CHAR 4 0
WGRU2 Material group hierarchy 2 MCW_WGRU2 CHAR 18 0
WGRU1 Material group hierarchy 1 MCW_WGRU1 CHAR 18 0
MATKL Material Group MATKL T023 CHAR 9 0
PRDHA Product hierarchy PRODH_D T179 CHAR 18 0
SATNR Cross-Plant Configurable Material SATNR MARA CHAR 18 0
MERK1 Characteristic 1 MCW_MERK1 CHAR 30 0
MERK2 Characteristic 2 MCW_MERK2 CHAR 30 0
MERK3 Characteristic 3 MCW_MERK3 CHAR 30 0
AKTYP Promotion Category W_AKTYP TWTY CHAR 4 0
AKTHE Promotion theme W_AKTHE TWAT CHAR 4 0
PLGTP Price Band Category PLGTP TWPT CHAR 2 0
SAISO Season Category SAISO T6WSP CHAR 4 0
SAISJ Season Year SAISJ CHAR 4 0
BWVOR Procurement rule BWVOR T6WP1 CHAR 1 0
BWSCL Source of Supply BWSCL T6WP2 CHAR 1 0
SERVG IS-R service level W_SERVGRD TWSG CHAR 1 0
BRGEW Gross Weight BRGEW QUAN 13 3
NTGEW Net Weight NTGEW QUAN 13 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume VOLUM QUAN 13 3
VOLEH Volume unit VOLEH T006 UNIT 3 0
LIFNR Account number of regular vendor MCW_RLIFN LFA1 CHAR 10 0
LAND1 Country of regular vendor MCW_LANDRL T005 CHAR 3 0
MTART Material Type MTART T134 CHAR 4 0
WMAKG Material type ID WMAK CHAR 1 0
NULL General material type
1 Material type for value-only materials
2 Material type for empties
3 Material type for catalog variants
4 Material type for perishables
5 Material type for additionals
6 Material type for coupons
WRKGR2 Plant group hierarchy 2 MCW_WRKGR2 CHAR 18 0
WRKGR1 Plant group hierarchy 1 MCW_WRKGR1 CHAR 18 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
IDNLF Material Number Used by Vendor IDNLF CHAR 35 0
KOLIF Prior Vendor KOLIF LFA1 CHAR 10 0
ATINM1 Internal characteristic number, characteristic 1 MCW_ATINM1 NUMC 10 0
ATINM2 Internal characteristic number, characteristic 2 MCW_ATINM2 NUMC 10 0
ATINM3 Internal characteristic number, characteristic 3 MCW_ATINM3 NUMC 10 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
STRNR Structured material STRNR MARA CHAR 18 0
UBPEPM Revaluation at cost, plus, quantity MCW_UBPEPM QUAN 15 3
UBPGEO Revaluation at cost, plus MCW_UBPGEO CURR 19 2
UBMEPM Revaluation at cost minus, quantity MCW_UBMEPM QUAN 15 3
UBMGEO Revaluation at cost, minus MCW_UBMGEO CURR 19 2
UBPVPM Revaluation at retail, plus, quantity MCW_UBPVPM QUAN 15 3
UBPGVO Revaluation at retail, plus MCW_UBPGVO CURR 19 2
UBPGVP Revaluation at retail, plus, at retail with tax MCW_UBPGVP CURR 19 2
UBMVPM Revaluation at retail, minus, quantity MCW_UBMVPM QUAN 15 3
UBMGVO Revaluation at retail, minus MCW_UBMGVO CURR 19 2
UBMGVP Revaluation at retail, minus, at retail with tax MCW_UBMGVP CURR 19 2
ABGGEO Issues at cost MCW_ABGGEO CURR 19 2
ABGGVO Issues at retail MCW_ABGGVO CURR 19 2
ABGGVP Issues at retail with tax MCW_ABGGVP CURR 19 2
ZUGGEO Receipts at cost MCW_ZUGGEO CURR 19 2
ZUGGVO Receipts at retail MCW_ZUGGVO CURR 19 2
ZUGGVP Receipts at retail with tax MCW_ZUGGVP CURR 19 2
DPFLG Indicator: duplicated record MCW_DPFLAG CHAR 1 0
X Yes
NULL No
ERFME Unit of Entry ERFME T006 UNIT 3 0
WKUNNR Customer number of plant KUNNR_WK KNA1 CHAR 10 0
BIWMNG RIS/Reporting Server - Transfer base quantity MCW_BIWMNG QUAN 15 3
BIWMVE RIS/Reporting Server - Transfer quantity sold MCW_BIWMVE QUAN 15 3
BIWGEO RIS/Reporting Server - Transfer cost price MCW_BIWGEO CURR 19 2
BIWGVO RIS/Reporting Server - Transfer retail price MCW_BIWGVO CURR 19 2
BIWGVP RIS/Reporting Server - Transfer retail price with tax MCW_BIWGVP CURR 19 2
BRELEV RIS/Reporting Server - stock relevance MCW_BRELEV CHAR 1 0
1 Yes
2 No
NEUAUF_BEW Indicator: Statistical setup - Inventory Controlling NEUAUF_BEW CHAR 1 0
BWVORG SAP BW transaction key MCW_BWVORG NUMC 3 0
FILGRP Store Group WISP_FILGRP TWISPC_FILGRP NUMC 2 0
PSWAE Database Currency for Planning Data in a Planning Scenario WISP_PSWAE TCURC CUKY 5 0
PLMHT Planned Unit of Measure WISP_PLMHT T006 UNIT 3 0
ASORT Assortment ASORT WRS1 CHAR 10 0
AVGW1 Memory Currency 1 in Currency Fields for Average Retail WISP_AVGW1 TCURC CUKY 5 0
AVGW2 Memory Currency 2 for Currency Fields for Average Retail WISP_AVGW2 TCURC CUKY 5 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
BWMNG BW: Quantity in Base Unit of Measure MCBW_MNG QUAN 15 3
BWMVE BW: Quantity in Sales Unit MCBW_MVE QUAN 15 3
BWGEO BW: Cost Value in Local Currency MCBW_GEO CURR 19 2
BWGVO BW: Retail Value in Local Currency MCBW_GVO CURR 19 2
BWGVP BW: Retail Value with Tax in Local Currency MCBW_GVP CURR 19 2
BWBREL BW: Stock Relevance MCBW_BREL CHAR 1 0
BWAPPLNM Application Component RSAPPLNM CHAR 30 0
BWEXT_REL Relevant Valuation Method WRMA_BWEXT_REL CHAR 1 0
NULL All Valuation Methods
R Traditional Retail Valuation Method
C Valuation at Cost Price

MCUSEG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCUSEG ABTNR MCMSEG MANDT TSAB Contact persons: standard departments MANDT
MCUSEG ABTNR MCUSEG ABTNR TSAB Contact persons: standard departments ABTNR
MCUSEG AKTHE MCUSEG AKTHE TWAT Promotion themes, IS-R AKTHE
MCUSEG AKTHE MCMSEG MANDT TWAT Promotion themes, IS-R MANDT
MCUSEG AKTNR MCUSEG MANDT WAKH Promotion Header Data, IS-R MANDT
MCUSEG AKTNR MCUSEG AKTNR WAKH Promotion Header Data, IS-R AKTNR
MCUSEG AKTYP MCUSEG AKTYP TWTY Promotion category, IS-R AKTYP
MCUSEG AKTYP MCMSEG MANDT TWTY Promotion category, IS-R MANDT
MCUSEG ASORT MCUSEG ASORT WRS1 Assortment ASORT
MCUSEG ASORT SYST MANDT WRS1 Assortment MANDT
MCUSEG AVGW1 MCUSEG AVGW1 TCURC Currency Codes WAERS
MCUSEG AVGW1 SYST MANDT TCURC Currency Codes MANDT
MCUSEG AVGW2 MCUSEG AVGW2 TCURC Currency Codes WAERS
MCUSEG AVGW2 SYST MANDT TCURC Currency Codes MANDT
MCUSEG BUKRS MCUSEG MANDT T001 Company Codes MANDT
MCUSEG BUKRS MCUSEG BUKRS T001 Company Codes BUKRS
MCUSEG BWKEY MCUSEG BWKEY T001K Valuation area BWKEY
MCUSEG BWKEY MCUSEG MANDT T001K Valuation area MANDT
MCUSEG BWSCL MCUSEG BWSCL T6WP2 Check table, supply source keys (no longer used) BWSCL
MCUSEG BWSCL MCMSEG MANDT T6WP2 Check table, supply source keys (no longer used) MANDT
MCUSEG BWTAR MCUSEG MANDT MBEW Material Valuation MANDT
MCUSEG BWTAR MCUSEG MATNR MBEW Material Valuation MATNR
MCUSEG BWTAR MCUSEG BWKEY MBEW Material Valuation BWKEY
MCUSEG BWTAR MCUSEG BWTAR MBEW Material Valuation BWTAR
MCUSEG BWVOR MCUSEG BWVOR T6WP1 Check table, supply source entry BWVOR
MCUSEG BWVOR MCMSEG MANDT T6WP1 Check table, supply source entry MANDT
MCUSEG BZIRK MCUSEG BZIRK T171 Customers: Sales Districts BZIRK
MCUSEG BZIRK MCMSEG MANDT T171 Customers: Sales Districts MANDT
MCUSEG DISPO MCUSEG DISPO T024D MRP controllers DISPO
MCUSEG DISPO MCMSEG WERKS T024D MRP controllers WERKS
MCUSEG DISPO MCMSEG MANDT T024D MRP controllers MANDT
MCUSEG EKGRP MCUSEG EKGRP T024 Purchasing Groups EKGRP
MCUSEG EKGRP MCMSEG MANDT T024 Purchasing Groups MANDT
MCUSEG EKORG MCMSEG MANDT T024E Purchasing Organizations MANDT
MCUSEG EKORG MCUSEG EKORG T024E Purchasing Organizations EKORG
MCUSEG EKSGB MCUSEG EKSGB T026 Purchasing Area EKSGB
MCUSEG EKSGB MCMSEG MANDT T026 Purchasing Area MANDT
MCUSEG ERFME MCMSEG MANDT T006 Units of Measurement MANDT
MCUSEG ERFME MCUSEG ERFME T006 Units of Measurement MSEHI
MCUSEG FILGRP MCUSEG FILGRP TWISPC_FILGRP Store Groups FILGRP
MCUSEG FILGRP SYST MANDT TWISPC_FILGRP Store Groups MANDT
MCUSEG GEWEI MCUSEG GEWEI T006 Units of Measurement MSEHI
MCUSEG GEWEI MCMSEG MANDT T006 Units of Measurement MANDT
MCUSEG HWAER MCUSEG MANDT TCURC Currency Codes MANDT
MCUSEG HWAER MCUSEG HWAER TCURC Currency Codes WAERS
MCUSEG KOLIF MCUSEG KOLIF LFA1 Vendor Master (General Section) LIFNR
MCUSEG KOLIF MCUSEG MANDT LFA1 Vendor Master (General Section) MANDT
MCUSEG LAND1 MCUSEG MANDT T005 Countries MANDT
MCUSEG LAND1 MCUSEG LAND1 T005 Countries LAND1
MCUSEG LGORT MCUSEG MANDT T001L Storage Locations MANDT
MCUSEG LGORT MCUSEG WERKS T001L Storage Locations WERKS
MCUSEG LGORT MCUSEG LGORT T001L Storage Locations LGORT
MCUSEG LIFNR MCUSEG LIFNR LFA1 Vendor Master (General Section) LIFNR
MCUSEG LIFNR MCUSEG MANDT LFA1 Vendor Master (General Section) MANDT
MCUSEG LTSNR MCUSEG LTSNR WYT1 Vendor Subrange LTSNR
MCUSEG LTSNR MCMSEG LIFNR WYT1 Vendor Subrange LIFNR
MCUSEG LTSNR MCMSEG MANDT WYT1 Vendor Subrange MANDT
MCUSEG MANDT MCUSEG MANDT T000 Clients MANDT
MCUSEG MATBF MCUSEG MATBF MARA General Material Data MATNR
MCUSEG MATBF MCUSEG MANDT MARA General Material Data MANDT
MCUSEG MATKL MCMSEG MANDT T023 Material Groups MANDT
MCUSEG MATKL MCUSEG MATKL T023 Material Groups MATKL
MCUSEG MATNR MCUSEG MATNR MARA General Material Data MATNR
MCUSEG MATNR MCUSEG MANDT MARA General Material Data MANDT
MCUSEG MEINS MCUSEG MANDT T006 Units of Measurement MANDT
MCUSEG MEINS MCUSEG MEINS T006 Units of Measurement MSEHI
MCUSEG MTART MCUSEG MTART T134 Material Types MTART
MCUSEG MTART MCMSEG MANDT T134 Material Types MANDT
MCUSEG PLGTP MCMSEG MANDT TWPT Price band categories MANDT
MCUSEG PLGTP MCUSEG PLGTP TWPT Price band categories PLGTP
MCUSEG PLMHT SYST MANDT T006 Units of Measurement MANDT
MCUSEG PLMHT MCUSEG PLMHT T006 Units of Measurement MSEHI
MCUSEG PRDHA MCMSEG MANDT T179 Materials: Product Hierarchies MANDT
MCUSEG PRDHA MCUSEG PRDHA T179 Materials: Product Hierarchies PRODH
MCUSEG PSWAE SYST MANDT TCURC Currency Codes MANDT
MCUSEG PSWAE MCUSEG PSWAE TCURC Currency Codes WAERS
MCUSEG PV_GRUND MCUSEG PV_GRUND TWBN Reason for Price Change PV_GRUND
MCUSEG PV_GRUND MCUSEG MANDT TWBN Reason for Price Change MANDT
MCUSEG SAISO MCUSEG SAISO T6WSP Check Table for Season Indicator SAISO
MCUSEG SAISO MCMSEG MANDT T6WSP Check Table for Season Indicator MANDT
MCUSEG SATNR MCMSEG MANDT MARA General Material Data MANDT
MCUSEG SATNR MCUSEG SATNR MARA General Material Data MATNR
MCUSEG SERVG MCUSEG SERVG TWSG Service level IS-R (Info for assortment list) SERVG
MCUSEG SERVG MCMSEG MANDT TWSG Service level IS-R (Info for assortment list) MANDT
MCUSEG STRNR MCUSEG MANDT MARA General Material Data MANDT
MCUSEG STRNR MCUSEG STRNR MARA General Material Data MATNR
MCUSEG VKORG MCUSEG VKORG TVKO Organizational Unit: Sales Organizations VKORG
MCUSEG VKORG MCMSEG MANDT TVKO Organizational Unit: Sales Organizations MANDT
MCUSEG VOLEH MCMSEG MANDT T006 Units of Measurement MANDT
MCUSEG VOLEH MCUSEG VOLEH T006 Units of Measurement MSEHI
MCUSEG VRKME MCUSEG MANDT T006 Units of Measurement MANDT
MCUSEG VRKME MCUSEG VRKME T006 Units of Measurement MSEHI
MCUSEG VTWEG MCUSEG VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
MCUSEG VTWEG MCMSEG MANDT TVTW Organizational Unit: Distribution Channels MANDT
MCUSEG VWAER MCUSEG VWAER TCURC Currency Codes WAERS
MCUSEG VWAER MCUSEG MANDT TCURC Currency Codes MANDT
MCUSEG WERKS MCUSEG WERKS T001W Plants/Branches WERKS
MCUSEG WERKS MCUSEG MANDT T001W Plants/Branches MANDT
MCUSEG WKUNNR MCUSEG MANDT KNA1 General Data in Customer Master MANDT
MCUSEG WKUNNR MCUSEG WKUNNR KNA1 General Data in Customer Master KUNNR