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 C_OverdueNotReleased.
-- 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: CMMOVERDUEPONREL
-- Parameters: P_DisplayCurrency : displaycurrency, P_DateFunction : datefunctionid, P_StartDate : mm_a_delivery_date, P_EndDate : mm_a_delivery_date, P_Language : sylangu
CREATE VIEW C_OverdueNotReleased AS
SELECT
resultElement: 'DateFunctionStartDate' AS resultElementDateFunctionStartDate,
resultElement: 'DateFunctionEndDate' AS resultElementDateFunctionEndDate,
binding: [ { targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' AS PurchaseOrder,
PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
cast(PurchaseOrderItem.ScheduleLineDeliveryDate as mm_a_delivery_date) AS DeliveryDate,
PurchaseOrderItem.PurchasingOrganization AS PurchasingOrganization,
PurchaseOrderItem.PurchasingOrganizationName AS PurchasingOrganizationName,
PurchaseOrderItem.PurchasingGroup AS PurchasingGroup,
PurchaseOrderItem.PurchasingGroupName AS PurchasingGroupName,
PurchaseOrderItem.CompanyCode AS CompanyCode,
PurchaseOrderItem.CompanyCodeName AS CompanyCodeName,
PurchaseOrderItem.Supplier AS Supplier,
PurchaseOrderItem.SupplierName AS SupplierName,
PurchaseOrderItem.Material AS Material,
PurchaseOrderItem.MaterialName AS MaterialName,
PurchaseOrderItem.MaterialGroup AS MaterialGroup,
PurchaseOrderItem.MaterialGroupName AS MaterialGroupName,
PurchaseOrderItem.PurchasingCategory AS PurchasingCategory,
PurchaseOrderItem.PurgCatName AS PurgCatName,
PurchaseOrderItem.Plant AS Plant,
PurchaseOrderItem.PlantName AS PlantName,
PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
PurchaseOrderItem.PurchaseOrderStatus AS PurchaseOrderItemStatus,
PurchaseOrderItem.PurchaseOrderOutputStatusName AS PurchasingDocumentStatusName,
PurchaseOrderItem.DeliveryStatus AS DeliveryStatus,
PurchaseOrderItem.DeliveryStatusDescription AS DeliveryStatusDescription,
cast(:P_DisplayCurrency as displaycurrency) AS DisplayCurrency,
PurchaseOrderItem.StillToInvoiceValue AS StillToInvoiceValue,
PurchaseOrderItem.OrderQuantity AS OrderQuantity,
PurchaseOrderItem.ScheduleLineOpenQty AS ScheduleLineOpenQty,
PurchaseOrderItem.GoodsReceiptQty AS GoodsReceiptQty,
cast(dats_days_between(ScheduleLineDeliveryDate,_OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).today)as mm_a_overdue_days) AS OverdueDays,
cast(cast(1 as abap.int4) as mm_a_open_items_number) AS NumberOfOpenItems,
PurchaseOrderItem.PurchaseOrderDate AS PurchaseOrderDate,
_OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).SupplierCountry AS SupplierCountry,
_OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate)._Country._Text[1: Language = $parameters.P_Language].CountryName AS CountryName,
cast(_OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).PurchaseOrderQty as mm_a_ordered_quantity) AS OrderedQuantity,
cast(cast(_OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).OpenPurchaseOrderQuantity as abap.quan(13, 3)) as mm_a_open_quantity) AS OpenPurchaseOrderQuantity,
cast(cast((_OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).PurchaseOrderQty - _OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).OpenPurchaseOrderQuantity)as abap.quan(13, 3))as mm_a_delivererd_quantity) AS DeliveredQuantity,
case when _OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).IsConfirmedScheduleLine is null then '' else _OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).IsConfirmedScheduleLine end AS IsConfirmedScheduleLine,
_OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).Currency AS Currency,
_OverdueNotReleased(P_StartDate : $parameters.P_StartDate, P_EndDate : $parameters.P_EndDate).ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
_UnitOfMeasure.UnitOfMeasure AS UnitOfMeasure,
_UnitOfMeasure._Text[1: Language = $parameters.P_Language].UnitOfMeasureName AS UnitOfMeasureName
FROM C_PurchaseOrderItemMoni
LEFT OUTER JOIN I_Country AS _Country ON suppliercountry = _Country.Country -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = 'TAG' -- association [1..1]
LEFT OUTER JOIN P_OverdueNotReleased AS _OverdueNotReleased ON PurchaseOrder = _OverdueNotReleased.PurchaseOrder AND PurchaseOrderItem = _OverdueNotReleased.PurchaseOrderItem -- association [1..1]
;