P_CntrlPurContrItemMonitor1

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_CntrlPurContrItemMonitor1.
-- 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: PCCTRITEMMNTR1
-- Parameters: P_Date : sydatum

CREATE VIEW P_CntrlPurContrItemMonitor1 AS
SELECT
  CentralContractItem.CentralPurchaseContract AS CentralPurchaseContract,
  CentralContractItem.CentralPurchaseContractItem AS CentralPurchaseContractItem,
  DistributionKey,
  concat( CentralContractItem.CentralPurchaseContract, concat( '/', CentralContractItem.CentralPurchaseContractItem) ) AS FormattedPurchasingDocItem,
  concat( CentralContractItem.CentralPurchaseContract, concat( '/', concat( CentralContractItem.CentralPurchaseContractItem, concat( '/', DistributionKey) ) ) ) AS CntrlPurContrDistributionLevel,
  CentralContract.PurchaseContractType AS PurchaseContractType,
  cast( Distribution.PurchasingOrganization as mmpur_d_be_purchorg ) AS ProcmtHubPurchasingOrg,
  Distribution.ProcurementHubSourceSystem AS LogicalSystem,
  cast( Distribution.PurchasingGroup as ekgrp ) AS ProcmtHubPurchasingGroup,
  Supplier,
  cast( Distribution.CompanyCode as mmpur_d_be_cocode ) AS ProcmtHubCompanyCode,
  cast( Distribution.Plant as mmpur_d_plant ) AS ProcmtHubPlant,
  CentralContract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  ValidityStartDate,
  ValidityEndDate,
  CentralContract.PurchasingOrganization AS PurchasingOrganization,
  CentralContract.PurchasingGroup AS PurchasingGroup,
  CentralContractItem.Plant AS Plant,
  CentralContract.CompanyCode AS CompanyCode,
  PurgDocPriceDate,
  CreationDate,
  CentralContractItem.NetPriceQuantity AS NetPriceQuantity,
  CentralContractItem.Material AS Material,
  CentralContractItem.PurchaseContractItemText AS PurchaseContractItemText,
  CentralContractItem.MaterialGroup AS MaterialGroup,
  ProductType,
  PurchasingDocumentItemCategory,
  PurchasingCentralMaterial,
  Distribution.TargetQuantity AS TargetQuantity,
  CentralContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  ItemDistributionStatus,
  cast(CentralContractItem.ContractNetPriceAmount as abap.curr(21,2)) AS ContractNetPriceAmount,
  CentralContractItem.DocumentCurrency AS DocumentCurrency,
  CentralContract.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  CentralContract.ProcmtHubCompanyCodeGroupingID AS ProcmtHubCompanyCodeGroupingID,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  _VersionType.ChangeRequestNote AS ChangeRequestNote
FROM I_CntrlPurchaseContractItem AS CentralContractItem
INNER JOIN R_CentralPurchaseContract AS CentralContract ON /* join condition not captured in parsed metadata */
INNER JOIN I_CntrlPurContrDistribution AS Distribution ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CntrlPurContrVersionType AS _VersionType ON PurgDocChangeRequestStatus = _VersionType.PurgDocChangeRequestStatus  -- association [1..1]
;