M_V_EKKO_EOP

DDL: M_V_EKKO_EOP SQL: M_VEKKO_EOP Type: view
12 Fields 1 Data Sources 3 Associations

Relevant fields with for setting the EOP-Flag in POs

M_V_EKKO_EOP is a CDS View that provides data about "Relevant fields with for setting the EOP-Flag in POs" in SAP S/4HANA. It reads from 1 data source (ekko) and exposes 12 fields. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ekko ekko from

Associations (3)

CardinalityTargetAliasCondition
[1..*] ekpo _ekpo ekko.ebeln = _ekpo.ebeln
[0..*] ekpa _ekpa ekko.ebeln = _ekpa.ebeln
[0..*] ekbz _ekbz ekko.ebeln = _ekbz.ebeln

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName M_VEKKO_EOP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Relevant fields with for setting the EOP-Flag in POs view

Fields (12)

KeyFieldSource TableSource FieldDescription
ebeln ekko ebeln Source PurchDoc
bukrs ekko bukrs Value
lifnr ekko lifnr Vendor no.
llief ekko llief Goods Supplier
lifre ekko lifre Location Alias
iseopblocked ekko iseopblocked Business Usage Comp.
lifn2 _ekpa lifn2 Ref. to suplr
emlif _ekpo emlif Supplier
kolif _ekpo kolif Prior Supplier
mfrnr _ekpo mfrnr Manufacturer
kunnr _ekpo kunnr Stock customer
ekbz_lifnr _ekbz lifnr Vendor no.

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 M_V_EKKO_EOP.
-- 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: M_VEKKO_EOP

CREATE VIEW M_V_EKKO_EOP AS
SELECT
  ekko.ebeln AS ebeln,
  ekko.bukrs AS bukrs,
  ekko.lifnr AS lifnr,
  ekko.llief AS llief,
  ekko.lifre AS lifre,
  ekko.iseopblocked AS iseopblocked,
  _ekpa.lifn2 AS lifn2,
  _ekpo.emlif AS emlif,
  _ekpo.kolif AS kolif,
  _ekpo.mfrnr AS mfrnr,
  _ekpo.kunnr AS kunnr,
  _ekbz.lifnr AS ekbz_lifnr
FROM ekko
LEFT OUTER JOIN ekpo AS _ekpo ON ekko.ebeln = _ekpo.ebeln  -- association [1..*]
LEFT OUTER JOIN ekpa AS _ekpa ON ekko.ebeln = _ekpa.ebeln  -- association [0..*]
LEFT OUTER JOIN ekbz AS _ekbz ON ekko.ebeln = _ekbz.ebeln  -- association [0..*]
;

Learn More