P_POItemEnhancedFetch

DDL: P_POITEMENHANCEDFETCH SQL: PPOITEMENHFET Type: view CONSUMPTION Package: ODATA_MM_PUR_POITEMS_MONI
63 Fields 1 Data Sources 3 Associations

Purchase Order Items Enhanced

P_POItemEnhancedFetch is a Consumption CDS View that provides data about "Purchase Order Items Enhanced" in SAP S/4HANA. It reads from 1 data source (P_PurOrdItemCastedAmounts) and exposes 63 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 3 associations to related views. Part of development package ODATA_MM_PUR_POITEMS_MONI.

Data Sources (1)

SourceAliasJoin Type
P_PurOrdItemCastedAmounts P_PurOrdItemCastedAmounts from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_PurOrdOpnScheduleLine _NextSchdLine $projection.PurchaseOrder = _NextSchdLine.PurchaseOrder and $projection.PurchaseOrderItem = _NextSchdLine.PurchaseOrderItem and $projection.PurchasingOrganization = _NextSchdLine.PurchasingOrganization
[0..1] P_PurOrdItmAggregationSchEnhcd _POItemHistory $projection.PurchaseOrder = _POItemHistory.PurchaseOrder and $projection.PurchaseOrderItem = _POItemHistory.PurchaseOrderItem
[0..1] P_PurOrdConvrtdValues _POItemConvertedValues $projection.PurchaseOrder = _POItemConvertedValues.PurchaseOrder and $projection.PurchaseOrderItem = _POItemConvertedValues.PurchaseOrderItem and $projection.PurchasingOrganization = _POItemConvertedValues.PurchasingOrganization

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPOITEMENHFET view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Order Items Enhanced view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderType PurchaseOrderType PO Type
Supplier Supplier Supplier
SupplyingPlant SupplyingPlant Supplying Plant
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
DocumentCurrency DocumentCurrency Document Currency
PurchaseOrderDate PurchaseOrderDate PO Date
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
SupplierQuotation SupplierQuotation RFQ
SupplierQuotationItem SupplierQuotationItem Supplier Quotation Item
PurchaseOrderItemText PurchaseOrderItemText Short Text
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ProductType ProductType Product Type Group
PurchaseOrderItemCategory PurchaseOrderItemCategory Item Category
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
ServicePerformer ServicePerformer Service Performer
IsReturnsItem IsReturnsItem Returns Item
GoodsReceiptIsExpected GoodsReceiptIsExpected Goods Receipt
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated GR Non-Valuated
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
InvoiceIsExpected InvoiceIsExpected Invoice Receipt
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased GR-Based IV
IsFinallyInvoiced IsFinallyInvoiced Final Invoice
IsCompleted IsCompleted
StorageLocation StorageLocation StorageLocation
PurchasingInfoRecord PurchasingInfoRecord Info Record
IsInfoRecordUpdated IsInfoRecordUpdated InfoUpdate
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
RequestForQuotation RequestForQuotation RFQ
RequestForQuotationItem RequestForQuotationItem RFQ Item
RequirementTracking RequirementTracking Tracking Number
RequisitionerName RequisitionerName Requisitioner
ScheduleLine _NextSchdLine ScheduleLine Schedule Line
ScheduleLineDeliveryDate _NextSchdLine ScheduleLineDeliveryDate Delivery Date
ScheduleLineOpenQuantity _NextSchdLine ScheduleLineOpenQuantity SchLineOpenQuan
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
OverallLimitAmount OverallLimitAmount Overall Limit
OrderQuantity OrderQuantity Quantity
NetPriceAmount NetPriceAmount Net Price
AnalyticalReportingCurrency _POItemConvertedValues AnalyticalReportingCurrency
NetPriceInReportingCurrency _POItemConvertedValues NetPriceInReportingCurrency
AnalyticalReportingCurrency2 _POItemConvertedValues AnalyticalReportingCurrency2
NetPriceInReportingCurrency2 _POItemConvertedValues NetPriceInReportingCurrency2
NetPriceQuantity NetPriceQuantity Price Unit
NetAmount NetAmount Stated Amount
NetAmountInReportingCurrency _POItemConvertedValues NetAmountInReportingCurrency
NetAmountInReportingCurrency2 _POItemConvertedValues NetAmountInReportingCurrency2
GoodsReceiptQty _POItemConvertedValues GoodsReceiptQuantity Delivered
GoodsReceiptAmount _POItemHistory GoodsReceiptAmount
InvoiceReceiptQty _POItemHistory InvoiceReceiptQty
InvoiceReceiptAmount _POItemHistory InvoiceReceiptAmount
InvcRcptAmtWthoutNonDcblTaxAmt _POItemHistory InvcRcptAmtWthoutNonDcblTaxAmt
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
OrderPriceUnit OrderPriceUnit Order Price Un.

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_POItemEnhancedFetch.
-- 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: PPOITEMENHFET

CREATE VIEW P_POItemEnhancedFetch AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderType,
  Supplier,
  SupplyingPlant,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  DocumentCurrency,
  PurchaseOrderDate,
  CreationDate,
  CreatedByUser,
  SupplierQuotation,
  SupplierQuotationItem,
  PurchaseOrderItemText,
  Material,
  MaterialGroup,
  Plant,
  ProductType,
  PurchaseOrderItemCategory,
  AccountAssignmentCategory,
  ServicePerformer,
  IsReturnsItem,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  IsCompletelyDelivered,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  IsFinallyInvoiced,
  IsCompleted,
  StorageLocation,
  PurchasingInfoRecord,
  IsInfoRecordUpdated,
  PurchaseContract,
  PurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  RequestForQuotation,
  RequestForQuotationItem,
  RequirementTracking,
  RequisitionerName,
  _NextSchdLine.ScheduleLine AS ScheduleLine,
  _NextSchdLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _NextSchdLine.ScheduleLineOpenQuantity AS ScheduleLineOpenQuantity,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  OrderQuantity,
  NetPriceAmount,
  _POItemConvertedValues.AnalyticalReportingCurrency AS AnalyticalReportingCurrency,
  _POItemConvertedValues.NetPriceInReportingCurrency AS NetPriceInReportingCurrency,
  _POItemConvertedValues.AnalyticalReportingCurrency2 AS AnalyticalReportingCurrency2,
  _POItemConvertedValues.NetPriceInReportingCurrency2 AS NetPriceInReportingCurrency2,
  NetPriceQuantity,
  NetAmount,
  _POItemConvertedValues.NetAmountInReportingCurrency AS NetAmountInReportingCurrency,
  _POItemConvertedValues.NetAmountInReportingCurrency2 AS NetAmountInReportingCurrency2,
  _POItemConvertedValues.GoodsReceiptQuantity AS GoodsReceiptQty,
  _POItemHistory.GoodsReceiptAmount AS GoodsReceiptAmount,
  _POItemHistory.InvoiceReceiptQty AS InvoiceReceiptQty,
  _POItemHistory.InvoiceReceiptAmount AS InvoiceReceiptAmount,
  _POItemHistory.InvcRcptAmtWthoutNonDcblTaxAmt AS InvcRcptAmtWthoutNonDcblTaxAmt,
  PurchaseOrderQuantityUnit,
  OrderPriceUnit
FROM P_PurOrdItemCastedAmounts
LEFT OUTER JOIN P_PurOrdOpnScheduleLine AS _NextSchdLine ON PurchaseOrder = _NextSchdLine.PurchaseOrder AND PurchaseOrderItem = _NextSchdLine.PurchaseOrderItem AND PurchasingOrganization = _NextSchdLine.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN P_PurOrdItmAggregationSchEnhcd AS _POItemHistory ON PurchaseOrder = _POItemHistory.PurchaseOrder AND PurchaseOrderItem = _POItemHistory.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN P_PurOrdConvrtdValues AS _POItemConvertedValues ON PurchaseOrder = _POItemConvertedValues.PurchaseOrder AND PurchaseOrderItem = _POItemConvertedValues.PurchaseOrderItem AND PurchasingOrganization = _POItemConvertedValues.PurchasingOrganization  -- association [0..1]
;

Learn More