SHSM_M_MEKKH

DDL: SHSM_M_MEKKH SQL: SHSMMMEKKH Type: view
8 Fields 1 Data Sources

SHSM_M_MEKKH is a CDS View in SAP S/4HANA. It reads from 1 data source (m_mekkh) and exposes 8 fields.

Data Sources (1)

SourceAliasJoin Type
m_mekkh m_mekkh from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMEKKH 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 (8)

KeyFieldSource TableSource FieldDescription
werks werks Receiving Plant
matkl matkl Product Sold Group
ekorg ekorg Purchasing Org.
ebeln ebeln Source PurchDoc
txz01 txz01 Text
ekgrp ekgrp Sub. purchasing grp
bsart bsart Stnd purch.ord.
iseopblocked iseopblocked Business Usage Comp.

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_MEKKH.
-- 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: SHSMMMEKKH

CREATE VIEW SHSM_M_MEKKH AS
SELECT
  werks,
  matkl,
  ekorg,
  ebeln,
  txz01,
  ekgrp,
  bsart,
  iseopblocked
FROM m_mekkh
;

Learn More