P_CntrlPurContrItemMonitor

DDL: P_CNTRLPURCONTRITEMMONITOR SQL: PCCTRITEMMNTR Type: view CONSUMPTION
39 Fields 2 Data Sources

Central Purchase Contract Items

P_CntrlPurContrItemMonitor is a Consumption CDS View that provides data about "Central Purchase Contract Items" in SAP S/4HANA. It reads from 2 data sources (P_CntrlPurContrItemMonitor1, P_CntrlPurContrReleaseHistory) and exposes 39 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey.

Data Sources (2)

SourceAliasJoin Type
P_CntrlPurContrItemMonitor1 P_CntrlPurContrItemMonitor1 from
P_CntrlPurContrReleaseHistory P_CntrlPurContrReleaseHistory left_outer

Parameters (1)

NameTypeDefault
P_DisplayCurrency displaycurrency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCCTRITEMMNTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central Purchase Contract Items view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralContractItem CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralContractItem CentralPurchaseContractItem Item in Central Purchase Contract
KEY DistributionKey CentralContractItem DistributionKey Distr. Number
FormattedPurchasingDocItem FormattedPurchasingDocItem
CntrlPurContrDistributionLevel CntrlPurContrDistributionLevel
PurchaseContractType PurchaseContractType Order Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Supplier Supplier Supplier
CompanyCode CentralContractItem CompanyCode Receiver Company Code
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
char2asPurchaseContractValidityStatus
CreationDate CreationDate Time Stamp
ItemDistributionStatus ItemDistributionStatus Distributn Status
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
ProductType ProductType Product Type Group
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
Plant CentralContractItem Plant Valuation Area
PurchasingCentralMaterial PurchasingCentralMaterial Material
PurchaseContractItemText PurchaseContractItemText Short Text
ProcmtHubPurchasingOrg ProcmtHubPurchasingOrg Purchasing Org.
ProcmtHubPurchasingGroup ProcmtHubPurchasingGroup Purch. Group
ProcmtHubPlant ProcmtHubPlant Plant
ProcmtHubCompanyCode ProcmtHubCompanyCode Company Code
LogicalSystem LogicalSystem Logical System
ExtContractForPurg ExtContractForPurg Contract
ExtContractItemForPurg ExtContractItemForPurg Item
ReleaseOrderItemLastChgDate ReleaseOrderItemLastChgDate Changed On
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity PO Quantity
TargetQuantity TargetQuantity Target Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
DisplayCurrency
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount Net Value
NumberOfContractItems
PurgDocChangeRequestStatus PurgDocChangeRequestStatus Change Request Stat.
ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping ID

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,
  ExtContractForPurg,
  ExtContractItemForPurg,
  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 */
;

Learn More