P_OverduePO3

DDL: P_OVERDUEPO3 SQL: POVRDUEPO3 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
22 Fields 2 Data Sources

Overdue PO with Return Items

P_OverduePO3 is a Consumption CDS View that provides data about "Overdue PO with Return Items" in SAP S/4HANA. It reads from 2 data sources (I_PurgAnalyticsConfiguration, I_PurchaseOrderScheduleLine) and exposes 22 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
I_PurgAnalyticsConfiguration MigrationStatus from
I_PurchaseOrderScheduleLine ScheduleLine inner

Parameters (2)

NameTypeDefault
P_StartDate mm_a_delivery_date
P_EndDate mm_a_delivery_date

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName POVRDUEPO3 view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Overdue PO with Return Items view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder Purchasing Document
KEY PurchaseOrderItem Purchasing Document Item
Supplier _PurchaseOrder Supplier Supplier
PurchasingOrganization _PurchaseOrder PurchasingOrganization Purchasing Organization
PurchasingGroup _PurchaseOrder PurchasingGroup Purchasing Group
PurchaseOrderItemCategory _PurchaseOrderItem PurchaseOrderItemCategory Item Category
PurchaseOrderCategory _PurchaseOrderItem PurchaseOrderCategory Doc. Category
PurchaseOrderType _PurchaseOrder PurchaseOrderType PO Type
SupplierConfirmationControlKey _PurchaseOrderItem SupplierConfirmationControlKey Conf. Control
Material _PurchaseOrderItem Material Vehicle Model
MaterialGroup _PurchaseOrderItem MaterialGroup Product Group
PurchaseOrderItemText _PurchaseOrderItem PurchaseOrderItemText Short Text
PurgDocHdrCompanyCode _PurchaseOrder CompanyCode Receiver Company Code
CompanyCode _PurchaseOrderItem CompanyCode Receiver Company Code
Plant _PurchaseOrderItem Plant Valuation Area
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
OrderQuantity _PurchaseOrderItem OrderQuantity Quantity
DocumentCurrency _PurchaseOrderItem DocumentCurrency Document Currency
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
OpenPurchaseOrderQuantity OpenPurchaseOrderQuantity Open Purchase Order Quantity
GoodsReceiptQuantity RoughGoodsReceiptQty Delivered
OpenPurchaseOrderNetAmount

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_OverduePO3.
-- 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: POVRDUEPO3
-- Parameters: P_StartDate : mm_a_delivery_date, P_EndDate : mm_a_delivery_date

CREATE VIEW P_OverduePO3 AS
SELECT
  cast( PurchaseOrder as vdm_purchaseorder ) AS PurchaseOrder,
  cast( PurchaseOrderItem as vdm_purchaseorderitem ) AS PurchaseOrderItem,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItem.PurchaseOrderCategory AS PurchaseOrderCategory,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrderItem.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  _PurchaseOrderItem.Material AS Material,
  _PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  _PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  _PurchaseOrder.CompanyCode AS PurgDocHdrCompanyCode,
  _PurchaseOrderItem.CompanyCode AS CompanyCode,
  _PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderQuantityUnit,
  _PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  _PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  ScheduleLineDeliveryDate,
  OpenPurchaseOrderQuantity,
  RoughGoodsReceiptQty AS GoodsReceiptQuantity,
  OpenPurchaseOrderNetAmount * cast( case when _PurchaseOrderItem.IsReturnsItem = 'X' then -1 else 1 end as int2 ) AS OpenPurchaseOrderNetAmount
FROM I_PurgAnalyticsConfiguration AS MigrationStatus
INNER JOIN I_PurchaseOrderScheduleLine AS ScheduleLine ON /* join condition not captured in parsed metadata */
;

Learn More