e_mrp_purchase_docs

DDL: PPH_MRP_PURCHASE_DOCS SQL: V_MRP_PURCH_DOC Type: view Package: PPH_AMDP_SDM

Fiori MRP App Purchase Documents CDS View

e_mrp_purchase_docs is a CDS View that provides data about "Fiori MRP App Purchase Documents CDS View" in SAP S/4HANA. It reads from 5 data sources (ebkn, eket, ekkn, ekpo, ekpv). Part of development package PPH_AMDP_SDM.

Data Sources (5)

SourceAliasJoin Type
ebkn ebkn left_outer
eket eket left_outer
ekkn ekkn left_outer
ekpo ekpo inner
ekpv ekpv left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName V_MRP_PURCH_DOC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #P view

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 e_mrp_purchase_docs.
-- 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_MRP_PURCH_DOC

CREATE VIEW e_mrp_purchase_docs AS
SELECT *  -- field list not available in parsed metadata
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN eket ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekpv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekkn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ebkn ON /* join condition not captured in parsed metadata */
;