SHSM_M_MEKKC

DDL: SHSM_M_MEKKC SQL: SHSMMMEKKC Type: view
7 Fields 2 Data Sources

CDS View replacing M_MEKKC in search help MEKKC

SHSM_M_MEKKC is a CDS View that provides data about "CDS View replacing M_MEKKC in search help MEKKC" in SAP S/4HANA. It reads from 2 data sources (ekko, m_mekkc) and exposes 7 fields.

Data Sources (2)

SourceAliasJoin Type
ekko ekko left_outer
m_mekkc m_mekkc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMEKKC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK 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
EndUserText.label CDS View replacing M_MEKKC in search help MEKKC view

Fields (7)

KeyFieldSource TableSource FieldDescription
bstyp m_mekkc bstyp Source doc.cat.
bedat m_mekkc bedat Start date
ebeln m_mekkc ebeln Source PurchDoc
iseopblocked m_mekkc iseopblocked Business Usage Comp.
ekorg ekko ekorg Purchasing Org.
ekgrp ekko ekgrp Sub. purchasing grp
bsart ekko bsart Stnd purch.ord.

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_MEKKC.
-- 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: SHSMMMEKKC

CREATE VIEW SHSM_M_MEKKC AS
SELECT
  m_mekkc.bstyp AS bstyp,
  m_mekkc.bedat AS bedat,
  m_mekkc.ebeln AS ebeln,
  m_mekkc.iseopblocked AS iseopblocked,
  ekko.ekorg AS ekorg,
  ekko.ekgrp AS ekgrp,
  ekko.bsart AS bsart
FROM m_mekkc
LEFT OUTER JOIN ekko ON /* join condition not captured in parsed metadata */
;

Learn More