MVKE

Transparent Table Application Table
4 Fields 5 CDS Views

Sales Data for Material

MVKE is an SAP database table in S/4HANA. Sales Data for Material. It contains 4 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 (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY vkorg vkorg Sales Org.
KEY vtweg vtweg Distr. Channel

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]
    PRIMARY KEY (MANDT, MATNR, VKORG, VTWEG)
);

Learn More