P_PurDocInfoNtwkGraph

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_PurDocInfoNtwkGraph.
-- 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: PURDOCINFONTWK

CREATE VIEW P_PurDocInfoNtwkGraph AS
SELECT
  PurchaseOrder AS PurchasingDocument,
  PurchaseOrderItem AS PurchasingDocumentItem,
  cast(concat(concat(PurchaseOrder, '/'), PurchaseOrderItem) as vdm_formattedpurchasedocitm ) AS FormattedPurchasingDocItem,
  cast(PurchaseOrderItemText as farp_pa_sgtxt) AS PurchasingDocumentItemText,
  cast(Material as bagrp) AS Assembly,
  _Material._Text[1: Language = $session.system_language].MaterialName AS AssemblyName,
  Plant,
  _Plant.PlantName AS PlantName,
  cast(_PurchaseOrder.Supplier as vdm_subcontractor) AS Subcontractor,
  _PurchaseOrder._Supplier.SupplierName AS SubcontractorName,
  MaterialGroup,
  cast( _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName as ps_s4_wgbez ) AS MaterialGroupName,
  cast(AccountAssignmentCategory as knttp_ll preserving type) AS AccountAssignmentCategory,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast (_PurchaseOrder.PurchasingOrganization as ekorg_ll) AS PurchasingOrganization,
  cast ( _PurchaseOrder._PurchasingOrganization.PurchasingOrganizationName as vdm_purchasingorgname) AS PurchasingOrganizationName,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  cast (_PurchaseOrder._PurchasingGroup.PurchasingGroupName as vdm_purchasinggroupname) AS PurchasingGroupName,
  StorageLocation,
  cast (_StorageLocation.StorageLocationName as ps_s4_lgort_name ) AS StorageLocationName,
  cast(RequirementTracking as rqmttrckgnmbr_ll) AS RequirementTracking,
  PurchaseOrderCategory AS PurchasingDocumentCategory,
  _PurgDocumentCategory._Text[1: Language = $session.system_language].PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  cast ('' as bsart) AS PurchasingDocumentType,
  cast ('' as batxt) AS PurchasingDocumentTypeName,
  cast ('' as abap.char(10)) AS SchedAgrmtValidityStatus,
  cast ('' as abap.char(10)) AS StatusDescription,
  cast ('00000000' as kdatb) AS ValidityStartDate,
  cast ('00000000' as kdate) AS ValidityEndDate,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder._PurchaseOrderType._Text[1: Language = $session.system_language].PurchasingDocumentTypeName AS PurchaseOrderTypeName,
  OrderQuantity,
  NetAmount,
  cast(0 as ktwrt) AS TargetAmount,
  cast(0 as abap.quan(13,3)) AS ReleasedQuantity,
  cast(0 as vdm_releasedvalue) AS ReleasedAmount,
  cast(_QtyAndValueCalc.GoodsReceiptQty as mm_a_delivererd_quantity) AS GoodsReceiptQty,
  cast(_QtyAndValueCalc.GoodsReceiptAmountInCoCodeCrcy as mm_delivered_value) AS GoodsReceiptAmountInCoCodeCrcy,
  cast(_QtyAndValueCalc.StillToBeDeliveredQuantity as vdm_stilltobedeliveredquantity ) AS StillToBeDeliveredQuantity,
  cast(_QtyAndValueCalc.StillToBeDeliveredValue as vdm_stilltobedeliveredvalue) AS StillToBeDeliveredValue,
  cast(_NextDeliveryCalc.ScheduleLineDeliveryDate as vdm_nextscheddelivdte) AS ScheduleLineDeliveryDate,
  cast(_NextDeliveryCalc.ScheduleLineOpenQty as nextscheddelivqty_ll) AS OpenPurchaseOrderQuantity,
  cast(_NextDeliveryCalc.DeliveryStatus as vdm_nextscheddelivsts) AS DeliveryStatus,
  cast (_NextDeliveryCalc._DeliveryStatusText.DomainText as vdm_nextscheddelivsts) AS DeliveryStatusDescription,
  cast(' ' as vdm_component) AS MaterialComponent,
  cast(' ' as maktx) AS MaterialName,
  cast(' ' as vdm_thirdptysuplr) AS Supplier,
  cast(' ' as suppliername) AS SupplierName,
  cast(' ' as vdm_nextschedshipgsts) AS ShippingStatus,
  cast (' ' as vdm_nextschedshipgsts) AS ShippingStatusText,
  cast('00000000' as vdm_nextschedshipgdte) AS RequirementDate,
  cast(0 as nextschedshipgqty_ll) AS RequiredQuantity,
  DocumentCurrency,
  PurchaseOrderQuantityUnit,
  PurchaseOrderQuantityUnit AS BaseUnit,
  PurchaseOrderItemCategory,
  SupplierIsSubcontractor,
  cast( 0 as abap.int4) AS DifferenceInDays,
  MRPArea
FROM I_PurchaseOrderItem
LEFT OUTER JOIN C_POItemNextDeliveryCalc AS _NextDeliveryCalc ON PurchasingDocument = _NextDeliveryCalc.PurchaseOrder AND PurchasingDocumentItem = _NextDeliveryCalc.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN C_POItemQtyAndValueCalc AS _QtyAndValueCalc ON PurchasingDocument = _QtyAndValueCalc.PurchaseOrder AND PurchasingDocumentItem = _QtyAndValueCalc.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN C_SchedgAgrmtItmDelivCalc AS _SchedgAgrmtItmDelivCalc ON PurchasingDocument = _SchedgAgrmtItmDelivCalc.SchedulingAgreement AND PurchasingDocumentItem = _SchedgAgrmtItmDelivCalc.SchedulingAgreementItem  -- association [0..1]
-- UNION ALL with additional select branch(es): I_SchedgAgrmtItm
;