C_PurchaseContractItem

DDL: C_PURCHASECONTRACTITEM SQL: CMMPURITEM Type: view CONSUMPTION
30 Fields 1 Data Sources 5 Associations

Purchase Contract Item Consumption View

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

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem I_PurchaseContractItem from

Associations (5)

CardinalityTargetAliasCondition
[1..*] I_PurgDocAccountAssignment _PurgDoc $projection.PurchaseContract = _PurgDoc.PurchasingDocument and $projection.PurchaseContractItem = _PurgDoc.PurchasingDocumentItem
[1..*] C_PurCtrItemAdrs _ItemAdrs $projection.PurchaseContract = _ItemAdrs.PurchaseContract and $projection.PurchaseContractItem = _ItemAdrs.PurchaseContractItem
[1..*] I_PurCtrCondItem _ItemCond $projection.PurchaseContract = _ItemCond.PurchaseContract and $projection.PurchaseContractItem = _ItemCond.PurchaseContractItem
[1..1] C_PurchaseContractHdr _PurchaseContract $projection.PurchaseContract = _PurchaseContract.PurchaseContract
[0..1] C_ContractPrdTypeVH _ContractPrdTypeVH $projection.ProductTypeCode = _ContractPrdTypeVH.ProductType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMMPURITEM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Purchase Contract Item Consumption View view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
PurchasingDocumentItem PurchaseContractItem Item
PurchaseContractItemText PurchaseContractItemText Short Text
Material Material Vehicle Model
TargetQuantity TargetQuantity Target Quantity
OrderPriceUnit OrderPriceUnit Order Price Un.
TargetAmount TargetAmount Target Value
PurgDocReleaseOrderQuantity PurgDocReleaseOrderQuantity Rel. order qty.
SupplierMaterialNumber SupplierMaterialNumber Supp. Mat. No.
Plant Plant Valuation Area
MultipleAcctAssgmtDistribution
OrderQuantityUnit OrderQuantityUnit Sales Unit
NetPriceQuantity NetPriceQuantity Price Unit
DocumentCurrency DocumentCurrency Document Currency
GoodsRecipientName
NetPriceAmount ContractNetPriceAmount Net Price
ManufacturerMaterial ManufacturerMaterial MPN: Material
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
Manufacturer Manufacturer Manufacturer
PurgConfigurableItemNumber PurgConfigurableItemNumber Hierarchy Number
PurgExternalSortNumber PurgExternalSortNumber External Sort No.
PurchasingParentItem PurchasingParentItem Parent Item No
PurgDocAggrgdSubitemCategory PurgDocAggrgdSubitemCategory Sub-items
ProductTypeCode ProductType Product Type Group
ProductTypeName _ContractPrdTypeVH ProductTypeName Description
_PurgDoc _PurgDoc
_ItemAdrs _ItemAdrs
_ItemCond _ItemCond
_PurchaseContract _PurchaseContract

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 C_PurchaseContractItem.
-- 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: CMMPURITEM

CREATE VIEW C_PurchaseContractItem AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  PurchaseContractItem AS PurchasingDocumentItem,
  PurchaseContractItemText,
  Material,
  TargetQuantity,
  OrderPriceUnit,
  TargetAmount,
  PurgDocReleaseOrderQuantity,
  SupplierMaterialNumber,
  Plant,
  cast ('0' as abap.dec(3,1)) AS MultipleAcctAssgmtDistribution,
  OrderQuantityUnit,
  NetPriceQuantity,
  DocumentCurrency,
  cast ( '' as abap.char( 12 ) ) AS GoodsRecipientName,
  ContractNetPriceAmount AS NetPriceAmount,
  ManufacturerMaterial,
  ManufacturerPartNmbr,
  Manufacturer,
  PurgConfigurableItemNumber,
  PurgExternalSortNumber,
  PurchasingParentItem,
  PurgDocAggrgdSubitemCategory,
  ProductType AS ProductTypeCode,
  _ContractPrdTypeVH.ProductTypeName AS ProductTypeName
FROM I_PurchaseContractItem
LEFT OUTER JOIN I_PurgDocAccountAssignment AS _PurgDoc ON PurchaseContract = _PurgDoc.PurchasingDocument AND PurchaseContractItem = _PurgDoc.PurchasingDocumentItem  -- association [1..*]
LEFT OUTER JOIN C_PurCtrItemAdrs AS _ItemAdrs ON PurchaseContract = _ItemAdrs.PurchaseContract AND PurchaseContractItem = _ItemAdrs.PurchaseContractItem  -- association [1..*]
LEFT OUTER JOIN I_PurCtrCondItem AS _ItemCond ON PurchaseContract = _ItemCond.PurchaseContract AND PurchaseContractItem = _ItemCond.PurchaseContractItem  -- association [1..*]
LEFT OUTER JOIN C_PurchaseContractHdr AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_ContractPrdTypeVH AS _ContractPrdTypeVH ON ProductTypeCode = _ContractPrdTypeVH.ProductType  -- association [0..1]
;

Learn More