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)

SourceAliasJoin Type
I_PurchaseOrderItem I_PurchaseOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_MassUpdtConfCtrlVH _ConfirmationControlVH $projection.SupplierConfirmationControlKey = _ConfirmationControlVH.SupplierConfirmationControlKey

Annotations (13)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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]
;

Learn More