P_ContrItmMonitoringCastAmt

DDL: P_CONTRITMMONITORINGCASTAMT SQL: PPURCONTRITMMNTR Type: view CONSUMPTION
41 Fields 1 Data Sources 2 Associations

Purchase Contract Items Cast Amounts

P_ContrItmMonitoringCastAmt is a Consumption CDS View that provides data about "Purchase Contract Items Cast Amounts" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 41 fields with key fields PurchaseContract, PurchaseContractItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem I_PurchaseContractItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PurchasingDocumentItem _PurchasingDocumentItem $projection.PurchaseContract = _PurchasingDocumentItem.PurchasingDocument and $projection.PurchaseContractItem = _PurchasingDocumentItem.PurchasingDocumentItem
[1..1] I_ProcmtBlockedSupplierTxt _DomainText _DomainText.PurchasingIsBlockedForSupplier = 'X' and _DomainText.Language = $session.system_language and _DomainText.DomainValue = 'X'

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPURCONTRITMMNTR view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Contract Items Cast Amounts view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
AcctAssignmentCategoryName
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
PurgDocItemCategoryName
PurgDocExternalItemCategory
Supplier _PurchaseContract Supplier Supplier
SupplierName
PurchasingGroup _PurchaseContract PurchasingGroup Purchasing Group
PurchasingGroupName
PurchasingOrganization _PurchaseContract PurchasingOrganization Purchasing Organization
PurchasingOrganizationName
CompanyCode _PurchaseContract CompanyCode Receiver Company Code
CompanyCodeName
PurchaseContractType _PurchaseContract PurchaseContractType Order Type
PurchasingDocumentTypeName
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
MaterialGroupName
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
CreationDate _PurchaseContract CreationDate Time Stamp
CreatedByUser _PurchaseContract CreatedByUser User Name
ValidityStartDate _PurchaseContract ValidityStartDate Validity Start Date
ValidityEndDate _PurchaseContract ValidityEndDate ValidTo
TargetQuantity TargetQuantity Target Quantity
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
NetPriceQuantity NetPriceQuantity Price Unit
StorageLocation StorageLocation StorageLocation
StorageLocationName _StorageLocation StorageLocationName Storage Loc. Name
TaxCode TaxCode Tax Code
OrderPriceUnit OrderPriceUnit Order Price Un.
OrderQuantityUnit OrderQuantityUnit Sales Unit
DocumentCurrency DocumentCurrency Document Currency
RequirementTracking RequirementTracking Tracking Number
TargetAmount Net Price
ContractNetPriceAmount Net Price
PurchaseContractTargetAmount
PurchasingInfoRecord _PurchasingDocumentItem PurchasingInfoRecord Info Record

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_ContrItmMonitoringCastAmt.
-- 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: PPURCONTRITMMNTR

CREATE VIEW P_ContrItmMonitoringCastAmt AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  AccountAssignmentCategory,
  _PurchasingDocumentItem._AccountAssignmentCategory._Text [1: Language = $session.system_language ].AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  PurchasingDocumentItemCategory,
  _PurchasingDocumentItem._PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  _PurchasingDocumentItem._PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  _PurchaseContract.Supplier AS Supplier,
  _PurchaseContract._Supplier.SupplierName AS SupplierName,
  _PurchaseContract.PurchasingGroup AS PurchasingGroup,
  _PurchaseContract._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseContract._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchaseContract.CompanyCode AS CompanyCode,
  _PurchaseContract._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchaseContract.PurchaseContractType AS PurchaseContractType,
  _PurchaseContract._PurchasingDocumentType._Text[1: Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  Material,
  MaterialGroup,
  _MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  Plant,
  _Plant.PlantName AS PlantName,
  _PurchaseContract.CreationDate AS CreationDate,
  _PurchaseContract.CreatedByUser AS CreatedByUser,
  _PurchaseContract.ValidityStartDate AS ValidityStartDate,
  _PurchaseContract.ValidityEndDate AS ValidityEndDate,
  TargetQuantity,
  OrdPriceUnitToOrderUnitDnmntr,
  OrderPriceUnitToOrderUnitNmrtr,
  NetPriceQuantity,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  TaxCode,
  OrderPriceUnit,
  OrderQuantityUnit,
  DocumentCurrency,
  RequirementTracking,
  cast(ContractNetPriceAmount as abap.curr(21, 5)) AS TargetAmount,
  cast(ContractNetPriceAmount as abap.curr(21, 5)) AS ContractNetPriceAmount,
  cast(_PurchaseContract.PurchaseContractTargetAmount as abap.curr(21, 5)) AS PurchaseContractTargetAmount,
  _PurchasingDocumentItem.PurchasingInfoRecord AS PurchasingInfoRecord
FROM I_PurchaseContractItem
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchaseContract = _PurchasingDocumentItem.PurchasingDocument AND PurchaseContractItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ProcmtBlockedSupplierTxt AS _DomainText ON _DomainText.PurchasingIsBlockedForSupplier = 'X' AND _DomainText.Language = $session.system_language AND _DomainText.DomainValue = 'X'  -- association [1..1]
;

Learn More