P_PurcContractLeakagePC2

DDL: P_PURCCONTRACTLEAKAGEPC2 SQL: PMMCONTRLEAKGPC2 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
15 Fields 2 Data Sources

P_PurcContractLeakagePC2

P_PurcContractLeakagePC2 is a Consumption CDS View that provides data about "P_PurcContractLeakagePC2" in SAP S/4HANA. It reads from 2 data sources (P_PurcContractLeakagePC, P_PurcContractLeakagePC1) and exposes 15 fields with key fields PurchaseOrder, PurchaseOrderItem, identifier. Part of development package ODATA_MM_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
P_PurcContractLeakagePC P_PurcContractLeakagePC inner
P_PurcContractLeakagePC1 P_PurcContractLeakagePC1 from

Parameters (1)

NameTypeDefault
P_PurchaseContract ebeln

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMMCONTRLEAKGPC2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label P_PurcContractLeakagePC2 view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY identifier
Material PurchaseOrderItem Material Vehicle Model
MaterialGroup PurchaseOrderItem MaterialGroup Product Group
Supplier PurchaseOrderItem Supplier Supplier
PurchasingOrganization PurchaseOrderItem PurchasingOrganization Purchasing Organization
PurchasingGroup PurchaseOrderItem PurchasingGroup Purchasing Group
PurchaseOrderDate PurchaseOrderItem PurchaseOrderDate PO Date
Plant PurchaseOrderItem Plant Valuation Area
CompanyCode PurchaseOrderItem CompanyCode Receiver Company Code
IsReturnsItem PurchaseOrderItem IsReturnsItem Returns Item
DocumentCurrency PurchaseOrderItem DocumentCurrency Document Currency
PurchaseOrderNetAmount NetAmountInDisplayCurrency
MaxContractAmount PurchaseOrderItem MaxContractAmount

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_PurcContractLeakagePC2.
-- 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: PMMCONTRLEAKGPC2
-- Parameters: P_PurchaseContract : ebeln

CREATE VIEW P_PurcContractLeakagePC2 AS
SELECT
  PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  min( ContractItemDetails.identifier) AS identifier,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Supplier AS Supplier,
  PurchaseOrderItem.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderItem.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderItem.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.CompanyCode AS CompanyCode,
  PurchaseOrderItem.IsReturnsItem AS IsReturnsItem,
  PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  NetAmountInDisplayCurrency AS PurchaseOrderNetAmount,
  PurchaseOrderItem.MaxContractAmount AS MaxContractAmount
FROM P_PurcContractLeakagePC1
INNER JOIN P_PurcContractLeakagePC ON /* join condition not captured in parsed metadata */
;

Learn More