MVKE

Transparent Table Application Table
73 Fields 5 CDS Views

Sales Data for Material

MVKE is an SAP database table in S/4HANA. Sales Data for Material. It contains 73 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_Productsalesdelivery view from EXTENSION Extension view-product sales delivery
F_Mmim_Mvke_Sales_Vh view from Help-View sales data for material
I_ProductSalesDelivery view from BASIC Product Sales Delivery
I_SubscrpnProdSlsDelivery view from BASIC Sales delivery data for subscription product
SHSM_H_MVKE view from CDS View for H_MVKE (search help)

Fields (73)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY vkorg VKORG Sales Org.
KEY vtweg VTWEG Distr. Channel
lvorm LVOVK DF DChain level
versg STGMA Matl stats grp
bonus BONUS Vol. Rebate Grp
provg PROVG Commission Grp
sktof SKTOF Cash Discount
vmsta VMSTA Status
vmstd VMSTD Valid from
aumng MINAU Min.order qty
lfmng MINLF Min. Dely Qty
efmng MINEF MakeToOrder qty
scmng SCHRT Delivery unit
schme SCHME Unit Of Measure
vrkme VRKME Sales Unit
mtpos MTPOS Item Cat. Group
dwerk DWERK_EXT Deliver.Plant
prodh PRODH_D Prod. Hierarchy
pmatn PMATN Pr. Ref. Matl
kondm KONDM Mat. Price Grp
ktgrm KTGRM AcctAssmtGrpMat
mvgr1 MVGR1 MaterialGroup 1
mvgr2 MVGR2 MaterialGroup 2
mvgr3 MVGR3 MaterialGroup 3
mvgr4 MVGR4 MaterialGroup 4
mvgr5 MVGR5 MaterialGroup 5
is_entlmnt_rlvt CMD_PRD_IS_ENTLMNT_RLVT Rel. Entitlement Gen
sstuf SSTUF Assortm. Grade
pflks PFLKS Ext. asst prio.
lstfl LSTFL LP for Stores
lstvz LSTVZ LP distr. ctrs
lstak LSTAK Listing active
ldvfl LDVFL Listed from
ldbfl LDBFL Listed to
ldvzl LDVZL Listed from
ldbzl LDBZL Listed to
vdvfl VDVFL For sale from
vdbfl VDBFL For sale till
vdvzl VDVZL For sale from
vdbzl VDBZL For sale till
prat1 PRAT1 Product attr.1
prat2 PRAT2 Product attr.2
prat3 PRAT3 Product attr.3
prat4 PRAT4 Product attr.4
prat5 PRAT5 Product attr.5
prat6 PRAT6 Prod.attribute6
prat7 PRAT7 Product attr.7
prat8 PRAT8 Prod.attribute8
prat9 PRAT9 Product attr.9
prata PRATA Prd.attribute10
rdprf RDPRF Rnding Profile
megru MEGRU UoM Group
lfmax MAXLF Max. dely qty
rjart RJART RackjobberFlag
pbind PBIND Price fixing
vavme VAVME SUn not var.
matkc MATKC Comp. charactn
pvmso PVMSO PP sorting
dummy_sald_incl_eew_ps SALD_INCL_EEW MD Product Sales Delivery
nf_flag /NFM/NFMAT NF Metals
ctr_term_def CRMS4_SOM_CTR_DUR_DEF Def Contract Term
ctr_term_alt1 CRMS4_SOM_CTR_DUR_1 Contract Term 1
ctr_term_alt2 CRMS4_SOM_CTR_DUR_2 Contract Term 2
ctr_term_unit CRMS4_SOM_CTR_TERM_UNIT Unit Contract Term
ext_period_def CRMS4_SOM_CTR_TRM_EXT_DEF Def Extension Period
ext_period_alt1 CRMS4_SOM_CTR_TRM_EXT_1 Extension Period 1
ext_period_alt2 CRMS4_SOM_CTR_TRM_EXT_2 Extension Period 2
ext_period_unit CRMS4_SOM_EXT_PERIOD_UNIT Unit for Extension
package_type LMD_MDE_PACKAGE_TYPE Package Type
package_size LMD_MDE_PACKAGE_SIZE Package Size
plgtp WRF_PLGTP Price band cat.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Data for Material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MVKE (
    MANDT,                   -- Client [MANDT]
    MATNR,                   -- Material [MATNR]
    VKORG,                   -- Sales Org. [VKORG]
    VTWEG,                   -- Distr. Channel [VTWEG]
    LVORM,                   -- DF DChain level [LVOVK]
    VERSG,                   -- Matl stats grp [STGMA]
    BONUS,                   -- Vol. Rebate Grp [BONUS]
    PROVG,                   -- Commission Grp [PROVG]
    SKTOF,                   -- Cash Discount [SKTOF]
    VMSTA,                   -- Status [VMSTA]
    VMSTD,                   -- Valid from [VMSTD]
    AUMNG,                   -- Min.order qty [MINAU]
    LFMNG,                   -- Min. Dely Qty [MINLF]
    EFMNG,                   -- MakeToOrder qty [MINEF]
    SCMNG,                   -- Delivery unit [SCHRT]
    SCHME,                   -- Unit Of Measure [SCHME]
    VRKME,                   -- Sales Unit [VRKME]
    MTPOS,                   -- Item Cat. Group [MTPOS]
    DWERK,                   -- Deliver.Plant [DWERK_EXT]
    PRODH,                   -- Prod. Hierarchy [PRODH_D]
    PMATN,                   -- Pr. Ref. Matl [PMATN]
    KONDM,                   -- Mat. Price Grp [KONDM]
    KTGRM,                   -- AcctAssmtGrpMat [KTGRM]
    MVGR1,                   -- MaterialGroup 1 [MVGR1]
    MVGR2,                   -- MaterialGroup 2 [MVGR2]
    MVGR3,                   -- MaterialGroup 3 [MVGR3]
    MVGR4,                   -- MaterialGroup 4 [MVGR4]
    MVGR5,                   -- MaterialGroup 5 [MVGR5]
    IS_ENTLMNT_RLVT,         -- Rel. Entitlement Gen [CMD_PRD_IS_ENTLMNT_RLVT]
    SSTUF,                   -- Assortm. Grade [SSTUF]
    PFLKS,                   -- Ext. asst prio. [PFLKS]
    LSTFL,                   -- LP for Stores [LSTFL]
    LSTVZ,                   -- LP distr. ctrs [LSTVZ]
    LSTAK,                   -- Listing active [LSTAK]
    LDVFL,                   -- Listed from [LDVFL]
    LDBFL,                   -- Listed to [LDBFL]
    LDVZL,                   -- Listed from [LDVZL]
    LDBZL,                   -- Listed to [LDBZL]
    VDVFL,                   -- For sale from [VDVFL]
    VDBFL,                   -- For sale till [VDBFL]
    VDVZL,                   -- For sale from [VDVZL]
    VDBZL,                   -- For sale till [VDBZL]
    PRAT1,                   -- Product attr.1 [PRAT1]
    PRAT2,                   -- Product attr.2 [PRAT2]
    PRAT3,                   -- Product attr.3 [PRAT3]
    PRAT4,                   -- Product attr.4 [PRAT4]
    PRAT5,                   -- Product attr.5 [PRAT5]
    PRAT6,                   -- Prod.attribute6 [PRAT6]
    PRAT7,                   -- Product attr.7 [PRAT7]
    PRAT8,                   -- Prod.attribute8 [PRAT8]
    PRAT9,                   -- Product attr.9 [PRAT9]
    PRATA,                   -- Prd.attribute10 [PRATA]
    RDPRF,                   -- Rnding Profile [RDPRF]
    MEGRU,                   -- UoM Group [MEGRU]
    LFMAX,                   -- Max. dely qty [MAXLF]
    RJART,                   -- RackjobberFlag [RJART]
    PBIND,                   -- Price fixing [PBIND]
    VAVME,                   -- SUn not var. [VAVME]
    MATKC,                   -- Comp. charactn [MATKC]
    PVMSO,                   -- PP sorting [PVMSO]
    DUMMY_SALD_INCL_EEW_PS,  -- MD Product Sales Delivery [SALD_INCL_EEW]
    NF_FLAG,                 -- NF Metals [/NFM/NFMAT]
    CTR_TERM_DEF,            -- Def Contract Term [CRMS4_SOM_CTR_DUR_DEF]
    CTR_TERM_ALT1,           -- Contract Term 1 [CRMS4_SOM_CTR_DUR_1]
    CTR_TERM_ALT2,           -- Contract Term 2 [CRMS4_SOM_CTR_DUR_2]
    CTR_TERM_UNIT,           -- Unit Contract Term [CRMS4_SOM_CTR_TERM_UNIT]
    EXT_PERIOD_DEF,          -- Def Extension Period [CRMS4_SOM_CTR_TRM_EXT_DEF]
    EXT_PERIOD_ALT1,         -- Extension Period 1 [CRMS4_SOM_CTR_TRM_EXT_1]
    EXT_PERIOD_ALT2,         -- Extension Period 2 [CRMS4_SOM_CTR_TRM_EXT_2]
    EXT_PERIOD_UNIT,         -- Unit for Extension [CRMS4_SOM_EXT_PERIOD_UNIT]
    PACKAGE_TYPE,            -- Package Type [LMD_MDE_PACKAGE_TYPE]
    PACKAGE_SIZE,            -- Package Size [LMD_MDE_PACKAGE_SIZE]
    PLGTP,                   -- Price band cat. [WRF_PLGTP]
    PRIMARY KEY (MANDT, MATNR, VKORG, VTWEG)
);

Learn More