V_Mmim_Ddl_Om_Bypo

DDL: V_MMIM_DDL_OM_BYPO SQL: V_MMIM_OM_BYPO Type: view
5 Fields 1 Data Sources

Output Management group Items by PO

V_Mmim_Ddl_Om_Bypo is a CDS View that provides data about "Output Management group Items by PO" in SAP S/4HANA. It reads from 1 data source (ekko) and exposes 5 fields with key fields mblnr, mjahr, ebeln.

Data Sources (1)

SourceAliasJoin Type
ekko ekko inner

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName V_MMIM_OM_BYPO view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Output Management group Items by PO view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY mblnr matdoc mblnr Material Doc.
KEY mjahr matdoc mjahr Mat. Doc. Year
KEY ebeln matdoc ebeln Source PurchDoc
weakt ekko weakt GR Message
zeile

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 V_Mmim_Ddl_Om_Bypo.
-- 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: V_MMIM_OM_BYPO

CREATE VIEW V_Mmim_Ddl_Om_Bypo AS
SELECT
  matdoc.mblnr AS mblnr,
  matdoc.mjahr AS mjahr,
  matdoc.ebeln AS ebeln,
  ekko.weakt AS weakt,
  min(matdoc.zeile) AS zeile
INNER JOIN ekko ON /* join condition not captured in parsed metadata */
;

Learn More