What is P_AssocPurOrdItmPurConItm in SAP S/4HANA?

P_AssocPurOrdItmPurConItm is a consumption CDS view in SAP S/4HANA. Association PO Item / Contract Item It contains 75 fields.

Which tables does P_AssocPurOrdItmPurConItm read from?

P_AssocPurOrdItmPurConItm reads data from: C_ContractItemFs.

What VDM layer is P_AssocPurOrdItmPurConItm?

P_AssocPurOrdItmPurConItm is classified as a Consumption view optimized for specific business scenarios and reporting.

P_AssocPurOrdItmPurConItm

DDL: P_ASSOCPURORDITMPURCONITM SQL: PASCPOITMPCONITM Type: view CONSUMPTION

75 Fields 1 Data Sources

Association PO Item / Contract Item

P_AssocPurOrdItmPurConItm is a Consumption CDS View that provides data about "Association PO Item / Contract Item" in SAP S/4HANA. It reads from 1 data source (C_ContractItemFs) and exposes 75 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseContract, PurchaseContractItem.

Data Sources (1)

Source	Alias	Join Type
C_ContractItemFs	_C_ContractItemFs	inner

Annotations (5)

Name	Value	Level
EndUserText.label	Association PO Item / Contract Item	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AbapCatalog.sqlViewName	PASCPOITMPCONITM	view

Fields (75)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseOrder		PurchaseOrder	Purchasing Document
KEY	PurchaseOrderItem		PurchaseOrderItem	Purchasing Document Item
KEY	PurchaseContract	I_PurchaseOrderItem	PurchaseContract	Purchasing Doc.
KEY	PurchaseContractItem	I_PurchaseOrderItem	PurchaseContractItem	Item
	PurchasingDocumentCategory
	PurchaseContractType
	FormattedPurchaseContractItem	C_ContractItemFs	FormattedPurchaseContractItem	Char15
	SupplierName	C_ContractItemFs	SupplierName	Supplier Name
	CreatedByUser	C_ContractItemFs	CreatedByUser	User Name
	SupplierAddressID	C_ContractItemFs	SupplierAddressID	Address Number
	Supplier	C_ContractItemFs	Supplier	Supplier
	SupplyingSupplier	C_ContractItemFs	SupplyingSupplier	Goods Supplier
	InvoicingParty	C_ContractItemFs	InvoicingParty	Supplier
	DeliveryAddressID	C_ContractItemFs	DeliveryAddressID	Address
	IncotermsClassification	C_ContractItemFs	IncotermsClassification	Incoterms
	IncotermsTransferLocation	C_ContractItemFs	IncotermsTransferLocation	Incoterms 2
	Material	C_ContractItemFs	Material	Vehicle Model
	PurchaseContractItemText	C_ContractItemFs	PurchaseContractItemText	Short Text
	ContractNetPriceAmount	C_ContractItemFs	ContractNetPriceAmount	Net Price
	NetPriceQuantity	C_ContractItemFs	NetPriceQuantity	Price Unit
	OrderPriceUnit	C_ContractItemFs	OrderPriceUnit	Order Price Un.
	OrderQuantityUnit	C_ContractItemFs	OrderQuantityUnit	Sales Unit
	ReleasedQuantity	C_ContractItemFs	ReleasedQuantity
	MaterialGroup	C_ContractItemFs	MaterialGroup	Product Group
	Plant	C_ContractItemFs	Plant	Valuation Area
	PlantName	C_ContractItemFs	PlantName	Plant Name
	StorageLocation	C_ContractItemFs	StorageLocation	StorageLocation
	StorageLocationName	C_ContractItemFs	StorageLocationName	Storage Loc. Name
	GoodsReceiptIsExpected	C_ContractItemFs	GoodsReceiptIsExpected	Goods Receipt
	MultipleAcctAssgmtDistribution	C_ContractItemFs	MultipleAcctAssgmtDistribution	Distribution
	TargetQuantity	C_ContractItemFs	TargetQuantity	Target Quantity
	TargetAmount	C_ContractItemFs	TargetAmount	Target Value
	DocumentCurrency	C_ContractItemFs	DocumentCurrency	Document Currency
	ManualDeliveryAddressID	C_ContractItemFs	ManualDeliveryAddressID	Address Number
	PurchaseOrderCategory	I_PurchaseOrderItem	PurchaseOrderCategory	Doc. Category
	Currency	I_PurchaseOrderItem	DocumentCurrency	Document Currency
	PurchasingDocumentDeletionCode	I_PurchaseOrderItem	PurchasingDocumentDeletionCode	Del. Indicator
	SupplierMaterialNumber	I_PurchaseOrderItem	SupplierMaterialNumber	Supp. Mat. No.
	ManufacturerPartNmbr	I_PurchaseOrderItem	ManufacturerPartNmbr	Mfr Part Number
	ManufacturerMaterial	I_PurchaseOrderItem	ManufacturerMaterial	MPN: Material
	PurchaseOrderItemText	I_PurchaseOrderItem	PurchaseOrderItemText	Short Text
	CompanyCode	I_PurchaseOrderItem	CompanyCode	Receiver Company Code
	PurchaseOrderQuantityUnit	I_PurchaseOrderItem	PurchaseOrderQuantityUnit	Order Unit
	OrderItemQtyToBaseQtyNmrtr	I_PurchaseOrderItem	OrderItemQtyToBaseQtyNmrtr	Equal To
	OrderItemQtyToBaseQtyDnmntr	I_PurchaseOrderItem	OrderItemQtyToBaseQtyDnmntr	Denominator
	IsCompletelyDelivered	I_PurchaseOrderItem	IsCompletelyDelivered	Is completely delivered
	IsFinallyInvoiced	I_PurchaseOrderItem	IsFinallyInvoiced	Final Invoice
	InvoiceIsExpected	I_PurchaseOrderItem	InvoiceIsExpected	Invoice Receipt
	InvoiceIsGoodsReceiptBased	I_PurchaseOrderItem	InvoiceIsGoodsReceiptBased	GR-Based IV
	EvaldRcptSettlmtIsAllowed	I_PurchaseOrderItem	EvaldRcptSettlmtIsAllowed	ERS
	UnlimitedOverdeliveryIsAllowed	I_PurchaseOrderItem	UnlimitedOverdeliveryIsAllowed	Unlimited Tol.
	OverdelivTolrtdLmtRatioInPct	I_PurchaseOrderItem	OverdelivTolrtdLmtRatioInPct	Overdeliv. Tol.
	UnderdelivTolrtdLmtRatioInPct	I_PurchaseOrderItem	UnderdelivTolrtdLmtRatioInPct	Underdel. Tol.
	RequisitionerName	I_PurchaseOrderItem	RequisitionerName	Requisitioner
	BaseUnit	I_PurchaseOrderItem	BaseUnit	Unit of Measure
	PurchaseOrderItemCategory	I_PurchaseOrderItem	PurchaseOrderItemCategory	Item Category
	ProfitCenter	I_PurchaseOrderItem	ProfitCenter	Profit Center
	PurchaseOrderPriceUnit	I_PurchaseOrderItem	OrderPriceUnit	Order Price Un.
	ItemVolumeUnit	I_PurchaseOrderItem	ItemVolumeUnit	Volume Unit
	ItemWeightUnit	I_PurchaseOrderItem	ItemWeightUnit	Unit of Weight
	PartialInvoiceDistribution	I_PurchaseOrderItem	PartialInvoiceDistribution	Partial invoice
	PricingDateControl	I_PurchaseOrderItem	PricingDateControl	Pr. Date Cat.
	IsReturnsItem	I_PurchaseOrderItem	IsReturnsItem	Returns Item
	InternationalArticleNumber	I_PurchaseOrderItem	InternationalArticleNumber	EAN/UPC
	PriceIsToBePrinted	I_PurchaseOrderItem	PriceIsToBePrinted	Print Price
	AccountAssignmentCategory	I_PurchaseOrderItem	AccountAssignmentCategory	Acct Assgmt Cat
	PurchasingInfoRecord	I_PurchaseOrderItem	PurchasingInfoRecord	Info Record
	NetAmount	I_PurchaseOrderItem	NetAmount	Stated Amount
	EffectiveAmount	I_PurchaseOrderItem	EffectiveAmount	Effective value
	OrderQuantity	I_PurchaseOrderItem	OrderQuantity	Quantity
	NetPriceAmount	I_PurchaseOrderItem	NetPriceAmount	Net Price
	ItemVolume	I_PurchaseOrderItem	ItemVolume	Volume
	ItemNetWeight	I_PurchaseOrderItem	ItemNetWeight	Net Weight
	OrderPriceUnitToOrderUnitNmrtr	I_PurchaseOrderItem	OrderPriceUnitToOrderUnitNmrtr	Quantity Conversion Numerator
	OrdPriceUnitToOrderUnitDnmntr	I_PurchaseOrderItem	OrdPriceUnitToOrderUnitDnmntr	Quantity Conversion Denominator

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_AssocPurOrdItmPurConItm.
-- 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: PASCPOITMPCONITM

CREATE VIEW P_AssocPurOrdItmPurConItm AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  I_PurchaseOrderItem.PurchaseContract AS PurchaseContract,
  I_PurchaseOrderItem.PurchaseContractItem AS PurchaseContractItem,
  _C_ContractItemFs._PurchaseContract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _C_ContractItemFs._PurchaseContract.PurchaseContractType AS PurchaseContractType,
  _C_ContractItemFs.FormattedPurchaseContractItem AS FormattedPurchaseContractItem,
  _C_ContractItemFs.SupplierName AS SupplierName,
  _C_ContractItemFs.CreatedByUser AS CreatedByUser,
  _C_ContractItemFs.SupplierAddressID AS SupplierAddressID,
  _C_ContractItemFs.Supplier AS Supplier,
  _C_ContractItemFs.SupplyingSupplier AS SupplyingSupplier,
  _C_ContractItemFs.InvoicingParty AS InvoicingParty,
  _C_ContractItemFs.DeliveryAddressID AS DeliveryAddressID,
  _C_ContractItemFs.IncotermsClassification AS IncotermsClassification,
  _C_ContractItemFs.IncotermsTransferLocation AS IncotermsTransferLocation,
  _C_ContractItemFs.Material AS Material,
  _C_ContractItemFs.PurchaseContractItemText AS PurchaseContractItemText,
  _C_ContractItemFs.ContractNetPriceAmount AS ContractNetPriceAmount,
  _C_ContractItemFs.NetPriceQuantity AS NetPriceQuantity,
  _C_ContractItemFs.OrderPriceUnit AS OrderPriceUnit,
  _C_ContractItemFs.OrderQuantityUnit AS OrderQuantityUnit,
  _C_ContractItemFs.ReleasedQuantity AS ReleasedQuantity,
  _C_ContractItemFs.MaterialGroup AS MaterialGroup,
  _C_ContractItemFs.Plant AS Plant,
  _C_ContractItemFs.PlantName AS PlantName,
  _C_ContractItemFs.StorageLocation AS StorageLocation,
  _C_ContractItemFs.StorageLocationName AS StorageLocationName,
  _C_ContractItemFs.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  _C_ContractItemFs.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  _C_ContractItemFs.TargetQuantity AS TargetQuantity,
  _C_ContractItemFs.TargetAmount AS TargetAmount,
  _C_ContractItemFs.DocumentCurrency AS DocumentCurrency,
  _C_ContractItemFs.ManualDeliveryAddressID AS ManualDeliveryAddressID,
  I_PurchaseOrderItem.PurchaseOrderCategory AS PurchaseOrderCategory,
  I_PurchaseOrderItem.DocumentCurrency AS Currency,
  I_PurchaseOrderItem.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  I_PurchaseOrderItem.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_PurchaseOrderItem.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_PurchaseOrderItem.ManufacturerMaterial AS ManufacturerMaterial,
  I_PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  I_PurchaseOrderItem.CompanyCode AS CompanyCode,
  I_PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  I_PurchaseOrderItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  I_PurchaseOrderItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  I_PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  I_PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  I_PurchaseOrderItem.InvoiceIsExpected AS InvoiceIsExpected,
  I_PurchaseOrderItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  I_PurchaseOrderItem.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  I_PurchaseOrderItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  I_PurchaseOrderItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  I_PurchaseOrderItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  I_PurchaseOrderItem.RequisitionerName AS RequisitionerName,
  I_PurchaseOrderItem.BaseUnit AS BaseUnit,
  I_PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  I_PurchaseOrderItem.ProfitCenter AS ProfitCenter,
  I_PurchaseOrderItem.OrderPriceUnit AS PurchaseOrderPriceUnit,
  I_PurchaseOrderItem.ItemVolumeUnit AS ItemVolumeUnit,
  I_PurchaseOrderItem.ItemWeightUnit AS ItemWeightUnit,
  I_PurchaseOrderItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  I_PurchaseOrderItem.PricingDateControl AS PricingDateControl,
  I_PurchaseOrderItem.IsReturnsItem AS IsReturnsItem,
  I_PurchaseOrderItem.InternationalArticleNumber AS InternationalArticleNumber,
  I_PurchaseOrderItem.PriceIsToBePrinted AS PriceIsToBePrinted,
  I_PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_PurchaseOrderItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_PurchaseOrderItem.NetAmount AS NetAmount,
  I_PurchaseOrderItem.EffectiveAmount AS EffectiveAmount,
  I_PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  I_PurchaseOrderItem.NetPriceAmount AS NetPriceAmount,
  I_PurchaseOrderItem.ItemVolume AS ItemVolume,
  I_PurchaseOrderItem.ItemNetWeight AS ItemNetWeight,
  I_PurchaseOrderItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  I_PurchaseOrderItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr
INNER JOIN C_ContractItemFs AS _C_ContractItemFs ON /* join condition not captured in parsed metadata */
;

Depth:

P_AssocPurOrdItmPurConItm view

C_ContractItemFs view