P_CntrlPurContrItemMonitor

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_CntrlPurContrItemMonitor.
-- 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: PCCTRITEMMNTR
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW P_CntrlPurContrItemMonitor AS
SELECT
  CentralContractItem.CentralPurchaseContract AS CentralPurchaseContract,
  CentralContractItem.CentralPurchaseContractItem AS CentralPurchaseContractItem,
  CentralContractItem.DistributionKey AS DistributionKey,
  FormattedPurchasingDocItem,
  CntrlPurContrDistributionLevel,
  PurchaseContractType,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  CentralContractItem.CompanyCode AS CompanyCode,
  PurchasingDocumentCategory,
  ValidityStartDate,
  ValidityEndDate,
  cast(case when CentralContractItem.ValidityEndDate < $session.system_date then '03' when CentralContractItem.ValidityEndDate >= $session.system_date and PurchaseContractValidityStatus > 0.900 then '01' else '02' end as abap.char( 2 ) ) as PurchaseContractValidityStatus AS char2asPurchaseContractValidityStatus,
  CreationDate,
  ItemDistributionStatus,
  Material,
  MaterialGroup,
  ProductType,
  PurchasingDocumentItemCategory,
  CentralContractItem.Plant AS Plant,
  PurchasingCentralMaterial,
  PurchaseContractItemText,
  ProcmtHubPurchasingOrg,
  ProcmtHubPurchasingGroup,
  ProcmtHubPlant,
  ProcmtHubCompanyCode,
  LogicalSystem,
  CentralContractItem.ExtContractForPurg AS ExtContractForPurg,
  CentralContractItem.ExtContractItemForPurg AS ExtContractItemForPurg,
  ReleaseHistory.ExtContractForPurg AS PurchasingDocument,
  ReleaseHistory.ExtContractItemForPurg AS PurchasingDocumentItem,
  ReleaseOrderItemLastChgDate,
  ReleaseOrderItemOrderQuantity,
  TargetQuantity,
  OrderQuantityUnit,
  cast( $parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  ReleaseOrderItemNetAmount,
  count( distinct CentralContractItem.FormattedPurchasingDocItem ) AS NumberOfContractItems,
  PurgDocChangeRequestStatus,
  ProcmtHubCompanyCodeGroupingID
FROM P_CntrlPurContrItemMonitor1
LEFT OUTER JOIN P_CntrlPurContrReleaseHistory ON /* join condition not captured in parsed metadata */
;