SHSM_M_MEKKV

DDL: SHSM_M_MEKKV SQL: SHSMMMEKKV Type: view
14 Fields 1 Data Sources

SHSM_M_MEKKV is a CDS View in SAP S/4HANA. It reads from 1 data source (m_mekkv) and exposes 14 fields.

Data Sources (1)

SourceAliasJoin Type
m_mekkv m_mekkv from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMEKKV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
vbeln vbeln SD Sched. Agmt
vbelp vbelp Schd. Agmt Item
veten veten Schedule Line
bstyp bstyp Source doc.cat.
ekorg ekorg Purchasing Org.
ebeln ebeln Source PurchDoc
ebelp ebelp Item pur. doc.
zekkn zekkn Account Assgmt No.
exlin exlin Hierarchy Number
iseopblocked iseopblocked Business Usage Comp.
ekgrp ekgrp Sub. purchasing grp
bsart bsart Stnd purch.ord.
statu statu Vehicle Status
werks werks Receiving Plant

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SHSM_M_MEKKV.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SHSMMMEKKV

CREATE VIEW SHSM_M_MEKKV AS
SELECT
  vbeln,
  vbelp,
  veten,
  bstyp,
  ekorg,
  ebeln,
  ebelp,
  zekkn,
  exlin,
  iseopblocked,
  ekgrp,
  bsart,
  statu,
  werks
FROM m_mekkv
;

Learn More