MVKE is a standard Material Master Transparent Table in SAP Logistics application, which stores Sales Data for Material data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for MVKE. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

MVKE — Meta Data

Description: Sales Data for Material
Main Category: Logistics
Sub Category: Material Master
Table type: Transparent Table (TRANSP)

MVKE — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 MATNR Material X CHAR 40 MARA
    3 VKORG Sales Org. X CHAR 4 TVKO
    4 VTWEG Distr. Channel X CHAR 2 TVTW
    5 .INCLUDE 0
    6 LVORM Deletion Flag for 1-Level Deletion Logic CHAR 1
    7 VERSG Updated information in related user data field CHAR 1 TVSM
    8 BONUS Vol. rebate grp CHAR 2 TVBO
    9 PROVG Commission grp CHAR 2 TVPR
    10 SKTOF Cash discount indicator CHAR 1
    11 VMSTA Checkbox CHAR 2 TVMS
    12 VMSTD Checkbox DATS 8
    13 AUMNG Checkbox QUAN 13
    14 LFMNG Min. dely qty QUAN 13
    15 EFMNG Checkbox QUAN 13
    16 SCMNG Checkbox QUAN 13
    17 SCHME Checkbox UNIT 3 T006
    18 VRKME Sales unit UNIT 3 T006
    19 MTPOS General item category group CHAR 4 TPTM
    20 DWERK Delivering Plant CHAR 4 TVKWZ
    21 PRODH Prod.hierarchy CHAR 18 T179
    22 PMATN Pricing Reference Material CHAR 40 MARA
    23 KONDM Material Pricing Group CHAR 2 T178
    24 KTGRM Account assignment group for this material CHAR 2 TVKM
    25 MVGR1 MaterialGroup 1 CHAR 3 TVM1
    26 MVGR2 MaterialGroup 2 CHAR 3 TVM2
    27 MVGR3 MaterialGroup 3 CHAR 3 TVM3
    28 MVGR4 MaterialGroup 4 CHAR 3 TVM4
    29 MVGR5 MaterialGroup 5 CHAR 3 TVM5
    30 .INCLUDE 0
    31 SSTUF Checkbox CHAR 2 TWSS
    32 PFLKS Checkbox CHAR 1 TWSP
    33 LSTFL Checkbox CHAR 2 TWLV
    34 LSTVZ Checkbox CHAR 2 TWLV
    35 LSTAK Checkbox CHAR 1
    36 LDVFL Checkbox DATS 8
    37 LDBFL Checkbox DATS 8
    38 LDVZL Checkbox DATS 8
    39 LDBZL Checkbox DATS 8
    40 VDVFL Checkbox DATS 8
    41 VDBFL Checkbox DATS 8
    42 VDVZL Checkbox DATS 8
    43 VDBZL Checkbox DATS 8
    44 PRAT1 Updated information in related user data field CHAR 1
    45 PRAT2 Updated information in related user data field CHAR 1
    46 PRAT3 Updated information in related user data field CHAR 1
    47 PRAT4 Updated information in related user data field CHAR 1
    48 PRAT5 Updated information in related user data field CHAR 1
    49 PRAT6 Updated information in related user data field CHAR 1
    50 PRAT7 Updated information in related user data field CHAR 1
    51 PRAT8 Updated information in related user data field CHAR 1
    52 PRAT9 Updated information in related user data field CHAR 1
    53 PRATA Updated information in related user data field CHAR 1
    54 RDPRF Rounding Profile CHAR 4 RDPR
    55 MEGRU Updated information in related user data field CHAR 4 TWMEG
    56 LFMAX Checkbox QUAN 13
    57 RJART Checkbox CHAR 1
    58 PBIND Checkbox CHAR 1
    59 VAVME Checkbox CHAR 1
    60 MATKC Checkbox CHAR 1
    61 PVMSO Checkbox NUMC 8 *
    62 .INCLUDE 0
    63 DUMMY_SALD_INCL_EEW_PS CHAR 1
    64 .INCLU--AP 0
    65 .INCLUDE 0
    66 /BEV1/EMLGRP Empties Group CHAR 4 /BEV1/EMGRP
    67 /BEV1/EMDRCKSPL Print Column Empties Returns Block NUMC 1
    68 .INCLU--AP 0
    69 .INCLUDE 0
    70 /BEV1/RPBEZME Base Unit of Measure for Statistics Totals List/Planning UNIT 3 *
    71 /BEV1/RPSNS No Allocation to Totals Field (Do not Total) CHAR 1
    72 /BEV1/RPSFA Assignment to Totals Field Category 1 CHAR 1
    73 /BEV1/RPSKI Assignment to Totals Field Category 2 CHAR 1
    74 /BEV1/RPSCO Assignment to Totals Field Category 3 CHAR 1
    75 /BEV1/RPSSO Assignment to Totals Field Category 4 CHAR 1
    76 .INCLU--AP 0
    77 .INCLUDE 0
    78 NF_FLAG Indicator: Material Contains NF Metals CHAR 1
    79 .INCLU--AP 0
    80 .INCLUDE 0
    81 PLGTP Checkbox CHAR 2 TWPT

SAP Help, Wiki Resources, and Forum Discussions on MVKE

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
MARA General Material Data Logistics - Material Master
MAKT Material Descriptions Logistics - Material Master
MBEW Material Valuation Logistics - Material Master
MARD Storage Location Data for Material Logistics - Material Master
EKPO Purchasing Document Item MM - Purchasing
VBAK Sales Document: Header Data SD - Sales
MKPF Header: Material Document MM - Inventory Management

Transaction Codes for SAP Table MVKE

TCODE Description Functional Area
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
MM01 Create Material & Logistics - Material Master
MIGO Goods Movement MM - Inventory Management
MM03 Display Material & Logistics - Material Master
MM02 Change Material & Logistics - Material Master
ME21N Create Purchase Order MM - Purchasing
MIRO Enter Incoming Invoice MM - Invoice Verification
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance

FMs for SAP Table MVKE

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
READ_TEXT SAPscript: Read text BC - SAPscript
BAPI_MATERIAL_SAVEDATA Create and Change Material Master Data Logistics - Material Master
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
BAPI_TRANSACTION_COMMIT Execute external Commit when using BAPIs Basis - ALE Integration Technology
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
WS_DOWNLOAD OBSOLETE: File Transfer from Internal Table to Presentation Server File Basis - Graphic

ABAP Reports for SAP Table MVKE

ABAP REPORT Description Functional Area
SAPLMGMM Material Master: Central Main Program
SAPLSPO1 ?...
SAPMV45A Sales Order Processing SD - Sales
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SAPMV13A Condition Maintenance SD - Conditions
RMDATIND Transfer Material Master Data by Direct Input Logistics - Material Master
SAPMM06E Module Pool: PO History MM - Purchasing
SELECTION Include SELECTION SD - POS Interface

BW Datasources for SAP Table MVKE

BW DATASOURCE Description Functional Area
0MAT_SALES_ATTR Material number with sales Logistics - Logistics - General
0MATERIAL_ATTR Material Number Logistics - Logistics - General
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
0MATERIAL_LPRH_HIER Material number Logistics - Logistics - General
2LIS_02_SCL Purchasing Data (Schedule Line Level) MM - Materials Management
0MAT_PLANT_ATTR Material Number with Plant Logistics - Logistics - General
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
0MATERIAL_TEXT Material Number Logistics - Logistics - General

Authorization Objects for SAP Table MVKE

AUTHORIZATION OBJECT Description Functional Area
C_VKORG Transfer of Sales Organization Data
V_VBAK_VKO Sales Document: Authorization for Sales Areas
E_GRID Authorization Object for Grid
M_MATE_VKO Material Master: Sales Organization/Distribution Channel
P_APPL HR: Applicants
R_AREA Planning - Planning Area
C_SIGN Authorization for Digital Signature