P_Mpekbetype5

DDL: P_MPEKBETYPE5 SQL: PMPEKBETYPE5 Type: view COMPOSITE
5 Fields 1 Data Sources 1 Associations

P_Mpekbetype5 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_Purdocmp) and exposes 5 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_Purdocmp MPPurDoc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurDocHistory _PurDocHistory _PurDocHistory.PurchasingDocument = MPPurDoc.PurchaseDocument and _PurDocHistory.PurchasingDocumentItem = MPPurDoc.PurchaseItem and _PurDocHistory.PurchaseOrderCategory = '5'

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMPEKBETYPE5 view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
MasterprojectUUID P_Purdocmp MasterProjectUUID NodeID
MasterProject P_Purdocmp MasterProject Project ID
PurchaseDocument _PurDocHistory PurchasingDocument Purchasing Document
PurchaseItem _PurDocHistory PurchasingDocumentItem Purchasing Doc. Item
DocumentDate _PurDocHistory DocumentDate Journal Entry Date

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 P_Mpekbetype5.
-- 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: PMPEKBETYPE5

CREATE VIEW P_Mpekbetype5 AS
SELECT
  MPPurDoc.MasterProjectUUID AS MasterprojectUUID,
  MPPurDoc.MasterProject AS MasterProject,
  _PurDocHistory.PurchasingDocument AS PurchaseDocument,
  _PurDocHistory.PurchasingDocumentItem AS PurchaseItem,
  _PurDocHistory.DocumentDate AS DocumentDate
FROM P_Purdocmp AS MPPurDoc
LEFT OUTER JOIN I_PurDocHistory AS _PurDocHistory ON _PurDocHistory.PurchasingDocument = MPPurDoc.PurchaseDocument AND _PurDocHistory.PurchasingDocumentItem = MPPurDoc.PurchaseItem AND _PurDocHistory.PurchaseOrderCategory = '5'  -- association [0..1]
;

Learn More