What is P_PurchaseOrderItemsImpacted in SAP S/4HANA?

P_PurchaseOrderItemsImpacted is a consumption CDS view in SAP S/4HANA. Purchase Order Items Impacted It contains 149 fields.

Which tables does P_PurchaseOrderItemsImpacted read from?

P_PurchaseOrderItemsImpacted reads data from: I_PurchaseOrderItem.

What VDM layer is P_PurchaseOrderItemsImpacted?

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

P_PurchaseOrderItemsImpacted

DDL: P_PURCHASEORDERITEMSIMPACTED SQL: PPURORDITMIMPCTD Type: view CONSUMPTION

149 Fields 1 Data Sources 1 Associations

Purchase Order Items Impacted

P_PurchaseOrderItemsImpacted is a Consumption CDS View that provides data about "Purchase Order Items Impacted" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 149 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_PurchaseOrderItem	I_PurchaseOrderItem	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	C_MassUpdtConfCtrlVH	_ConfirmationControlVH	`$projection.SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	PPURORDITMIMPCTD	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Purchase Order Items Impacted	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	PurchaseOrderItem	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
VDM.private	true	view

Fields (149)

Key	Field	Source Field	Description
KEY	PurchaseOrder	PurchaseOrder	Purchasing Document
KEY	PurchaseOrderItem	PurchaseOrderItem	Purchasing Document Item
	PurchaseOrderItemUniqueID	PurchaseOrderItemUniqueID	Document Item
	PurchaseOrderCategory	PurchaseOrderCategory	Doc. Category
	DocumentCurrency	DocumentCurrency	Document Currency
	PurchasingDocumentDeletionCode	PurchasingDocumentDeletionCode	Del. Indicator
	MaterialGroup	MaterialGroup	Product Group
	Material	Material	Vehicle Model
	MaterialType	MaterialType	Material Type
	SupplierMaterialNumber	SupplierMaterialNumber	Supp. Mat. No.
	SupplierSubrange	SupplierSubrange	Suppl. Subrange
	ManufacturerPartNmbr	ManufacturerPartNmbr	Mfr Part Number
	Manufacturer	Manufacturer	Manufacturer
	ManufacturerMaterial	ManufacturerMaterial	MPN: Material
	PurchaseOrderItemText	PurchaseOrderItemText	Short Text
	ProductType	ProductType	Product Type Group
	CompanyCode	CompanyCode	Receiver Company Code
	Plant	Plant	Valuation Area
	ManualDeliveryAddressID	ManualDeliveryAddressID	Address Number
	ReferenceDeliveryAddressID	ReferenceDeliveryAddressID	Reference Address
	Customer	Customer	Sold-to Party
	Subcontractor	Subcontractor	Supplier
	SupplierIsSubcontractor	SupplierIsSubcontractor	SC Supplier
	CrossPlantConfigurableProduct	CrossPlantConfigurableProduct	Cross-plant CP
	ArticleCategory	ArticleCategory	Prod Category
	PlndOrderReplnmtElmntType	PlndOrderReplnmtElmntType	Kanban Indicat.
	ProductPurchasePointsQtyUnit	ProductPurchasePointsQtyUnit	Points Unit
	ProductPurchasePointsQty	ProductPurchasePointsQty	Points
	StorageLocation	StorageLocation	StorageLocation
	PurchaseOrderQuantityUnit	PurchaseOrderQuantityUnit	Order Unit
	OrderItemQtyToBaseQtyNmrtr	OrderItemQtyToBaseQtyNmrtr	Equal To
	OrderItemQtyToBaseQtyDnmntr	OrderItemQtyToBaseQtyDnmntr	Denominator
	NetPriceQuantity	NetPriceQuantity	Price Unit
	IsCompletelyDelivered	IsCompletelyDelivered	Is completely delivered
	IsFinallyInvoiced	IsFinallyInvoiced	Final Invoice
	GoodsReceiptIsExpected	GoodsReceiptIsExpected	Goods Receipt
	InvoiceIsExpected	InvoiceIsExpected	Invoice Receipt
	InvoiceIsGoodsReceiptBased	InvoiceIsGoodsReceiptBased	GR-Based IV
	PurchaseContractItem	PurchaseContractItem	Item
	PurchaseContract	PurchaseContract	Purchasing Doc.
	PurchaseRequisition	PurchaseRequisition	Requisition
	RequirementTracking	RequirementTracking	Tracking Number
	IsOrderAcknRqd	IsOrderAcknRqd	Acknowl. Reqd.
	PurchaseRequisitionItem	PurchaseRequisitionItem	Requisn. item
	RequestForQuotation	RequestForQuotation	RFQ
	RequestForQuotationItem	RequestForQuotationItem	RFQ Item
	SupplierQuotation	SupplierQuotation	RFQ
	SupplierQuotationItem	SupplierQuotationItem	Supplier Quotation Item
	EvaldRcptSettlmtIsAllowed	EvaldRcptSettlmtIsAllowed	ERS
	UnlimitedOverdeliveryIsAllowed	UnlimitedOverdeliveryIsAllowed	Unlimited Tol.
	OverdelivTolrtdLmtRatioInPct	OverdelivTolrtdLmtRatioInPct	Overdeliv. Tol.
	UnderdelivTolrtdLmtRatioInPct	UnderdelivTolrtdLmtRatioInPct	Underdel. Tol.
	RequisitionerName	RequisitionerName	Requisitioner
	PlannedDeliveryDurationInDays	PlannedDeliveryDurationInDays	Plnd dely time
	GoodsReceiptDurationInDays	GoodsReceiptDurationInDays	GR proc. time
	PartialDeliveryIsAllowed	PartialDeliveryIsAllowed	Partial Deliv.
	ConsumptionPosting	ConsumptionPosting	Consumption Posting
	ServicePerformer	ServicePerformer	Service Performer
	ServicePackage	ServicePackage	Package number
	BaseUnit	BaseUnit	Unit of Measure
	PurchaseOrderItemCategory
	PurgDocItemCategoryName
	ProfitCenter	ProfitCenter	Profit Center
	OrderPriceUnit	OrderPriceUnit	Order Price Un.
	ItemVolumeUnit	ItemVolumeUnit	Volume Unit
	ItemWeightUnit	ItemWeightUnit	Unit of Weight
	MultipleAcctAssgmtDistribution	MultipleAcctAssgmtDistribution	Distribution
	PartialInvoiceDistribution	PartialInvoiceDistribution	Partial invoice
	PricingDateControl	PricingDateControl	Pr. Date Cat.
	IsStatisticalItem	IsStatisticalItem	Statisticl.Indicator
	PurchasingParentItem	PurchasingParentItem	Parent Item No
	GoodsReceiptLatestCreationDate	GoodsReceiptLatestCreationDate	Latest GR Date
	IsReturnsItem	IsReturnsItem	Returns Item
	PurchasingOrderReason	PurchasingOrderReason	Reason for Ord.
	IncotermsClassification	IncotermsClassification	Incoterms
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms 2
	IncotermsLocation1	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	IncotermsLocation2	Inco. Location2
	PriorSupplier	PriorSupplier	Prior Supplier
	InternationalArticleNumber	InternationalArticleNumber	EAN/UPC
	IntrastatServiceCode	IntrastatServiceCode	Intrastat Srvc. Code
	CommodityCode	CommodityCode	Commodity Code
	MaterialFreightGroup	MaterialFreightGroup	Mat.Freight Grp
	DiscountInKindEligibility	DiscountInKindEligibility	Disc. in kind
	PurgItemIsBlockedForDelivery	PurgItemIsBlockedForDelivery	Shipping block
	SupplierConfirmationControlKey	SupplierConfirmationControlKey	Conf. Control
	PriceIsToBePrinted	PriceIsToBePrinted	Print Price
	AccountAssignmentCategory	AccountAssignmentCategory	Acct Assgmt Cat
	PurchasingInfoRecord	PurchasingInfoRecord	Info Record
	NetAmount	NetAmount	Stated Amount
	GrossAmount	GrossAmount	Gross value
	EffectiveAmount	EffectiveAmount	Effective value
	Subtotal1Amount	Subtotal1Amount	Subtotal 1 Amount
	Subtotal2Amount	Subtotal2Amount	Subtotal 2 Amount
	Subtotal3Amount	Subtotal3Amount	Subtotal 3 Amount
	Subtotal4Amount	Subtotal4Amount	Subtotal 4 Amount
	Subtotal5Amount	Subtotal5Amount	Subtotal 5 Amount
	Subtotal6Amount	Subtotal6Amount	Subtotal 6 Amount
	OrderQuantity	OrderQuantity	Quantity
	NetPriceAmount	NetPriceAmount	Net Price
	ItemVolume	ItemVolume	Volume
	ItemGrossWeight	ItemGrossWeight	Gross Weight
	ItemNetWeight	ItemNetWeight	Net Weight
	OrderPriceUnitToOrderUnitNmrtr	OrderPriceUnitToOrderUnitNmrtr	Quantity Conversion Numerator
	OrdPriceUnitToOrderUnitDnmntr	OrdPriceUnitToOrderUnitDnmntr	Quantity Conversion Denominator
	GoodsReceiptIsNonValuated	GoodsReceiptIsNonValuated	GR Non-Valuated
	TaxCode	TaxCode	Tax Code
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	ShippingInstruction	ShippingInstruction	Shipping Instr.
	NonDeductibleInputTaxAmount	NonDeductibleInputTaxAmount	Non-deductible
	StockType	StockType	Stock Type
	ValuationType	ValuationType	Valuation Type
	ValuationCategory	ValuationCategory	Valuation Cat.
	ItemIsRejectedBySupplier	ItemIsRejectedBySupplier	Rejection Ind.
	PurgDocPriceDate	PurgDocPriceDate	Price Date
	IsInfoRecordUpdated	IsInfoRecordUpdated	InfoUpdate
	PurgDocReleaseOrderQuantity	PurgDocReleaseOrderQuantity	Rel. order qty.
	EarmarkedFundsDocument	EarmarkedFundsDocument	Earmarked Funds
	EarmarkedFundsDocumentItem	EarmarkedFundsDocumentItem	Document Item
	_PurchaseOrder	_PurchaseOrder
	_DocumentCurrency	_DocumentCurrency
	_PurchaseOrderItemCalcFields	_PurchaseOrderItemCalcFields
	_CompanyCode	_CompanyCode
	_Plant	_Plant
	_StorageLocation	_StorageLocation
	_Material	_Material
	_ManufacturerMaterial	_ManufacturerMaterial
	_MaterialGroup	_MaterialGroup
	_OrderPriceUnit	_OrderPriceUnit
	_ManualDeliveryAddress	_ManualDeliveryAddress
	_ManualDeliveryAddress_2	_ManualDeliveryAddress_2
	_ReferenceDeliveryAddress	_ReferenceDeliveryAddress
	_ReferenceDeliveryAddress_2	_ReferenceDeliveryAddress_2
	_PurgDocumentCategory	_PurgDocumentCategory
	_IncotermsClassification	_IncotermsClassification
	_PriorSupplier	_PriorSupplier
	_ConsumptionPosting	_ConsumptionPosting
	_PurchaseRequisitionItem	_PurchaseRequisitionItem
	_PurchasingInfoRecord	_PurchasingInfoRecord
	_Customer	_Customer
	_Subcontractor	_Subcontractor
	_ConfigurableProduct	_ConfigurableProduct
	_PurchaseRequisition	_PurchaseRequisition
	_PurchaseContract	_PurchaseContract
	_PurchaseContractItem	_PurchaseContractItem
	_ServicePerformer	_ServicePerformer
	_OrderQuantityUnit	_OrderQuantityUnit
	_ProductType	_ProductType
	_ConfirmationControlVH	_ConfirmationControlVH

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_PurchaseOrderItemsImpacted.
-- 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: PPURORDITMIMPCTD

CREATE VIEW P_PurchaseOrderItemsImpacted AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderItemUniqueID,
  PurchaseOrderCategory,
  DocumentCurrency,
  PurchasingDocumentDeletionCode,
  MaterialGroup,
  Material,
  MaterialType,
  SupplierMaterialNumber,
  SupplierSubrange,
  ManufacturerPartNmbr,
  Manufacturer,
  ManufacturerMaterial,
  PurchaseOrderItemText,
  ProductType,
  CompanyCode,
  Plant,
  ManualDeliveryAddressID,
  ReferenceDeliveryAddressID,
  Customer,
  Subcontractor,
  SupplierIsSubcontractor,
  CrossPlantConfigurableProduct,
  ArticleCategory,
  PlndOrderReplnmtElmntType,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  StorageLocation,
  PurchaseOrderQuantityUnit,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  NetPriceQuantity,
  IsCompletelyDelivered,
  IsFinallyInvoiced,
  GoodsReceiptIsExpected,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  PurchaseContractItem,
  PurchaseContract,
  PurchaseRequisition,
  RequirementTracking,
  IsOrderAcknRqd,
  PurchaseRequisitionItem,
  RequestForQuotation,
  RequestForQuotationItem,
  SupplierQuotation,
  SupplierQuotationItem,
  EvaldRcptSettlmtIsAllowed,
  UnlimitedOverdeliveryIsAllowed,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  RequisitionerName,
  PlannedDeliveryDurationInDays,
  GoodsReceiptDurationInDays,
  PartialDeliveryIsAllowed,
  ConsumptionPosting,
  ServicePerformer,
  ServicePackage,
  BaseUnit,
  _PurgDocumentItemCategory._Text[1:Language = $session.system_language].PurgDocExternalItemCategory AS PurchaseOrderItemCategory,
  _PurgDocumentItemCategory._Text[1:Language = $session.system_language].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  ProfitCenter,
  OrderPriceUnit,
  ItemVolumeUnit,
  ItemWeightUnit,
  MultipleAcctAssgmtDistribution,
  PartialInvoiceDistribution,
  PricingDateControl,
  IsStatisticalItem,
  PurchasingParentItem,
  GoodsReceiptLatestCreationDate,
  IsReturnsItem,
  PurchasingOrderReason,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  PriorSupplier,
  InternationalArticleNumber,
  IntrastatServiceCode,
  CommodityCode,
  MaterialFreightGroup,
  DiscountInKindEligibility,
  PurgItemIsBlockedForDelivery,
  SupplierConfirmationControlKey,
  PriceIsToBePrinted,
  AccountAssignmentCategory,
  PurchasingInfoRecord,
  NetAmount,
  GrossAmount,
  EffectiveAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  OrderQuantity,
  NetPriceAmount,
  ItemVolume,
  ItemGrossWeight,
  ItemNetWeight,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  GoodsReceiptIsNonValuated,
  TaxCode,
  TaxJurisdiction,
  ShippingInstruction,
  NonDeductibleInputTaxAmount,
  StockType,
  ValuationType,
  ValuationCategory,
  ItemIsRejectedBySupplier,
  PurgDocPriceDate,
  IsInfoRecordUpdated,
  PurgDocReleaseOrderQuantity,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem
FROM I_PurchaseOrderItem
LEFT OUTER JOIN C_MassUpdtConfCtrlVH AS _ConfirmationControlVH ON SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey  -- association [0..1]
;

Depth:

P_PurchaseOrderItemsImpacted view

I_PurchaseOrderItem view