P_SalesOrderInSupplyPurgIssue1

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_SalesOrderInSupplyPurgIssue1.
-- 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: PSOFISSUESU011

CREATE VIEW P_SalesOrderInSupplyPurgIssue1 AS
SELECT
  POI.PurchasingDocument AS PurchasingDocument,
  POI.PurchasingDocumentItem AS PurchasingDocumentItem,
  SOI.SalesDocument AS SalesDocument,
  SOI.SalesDocumentItem AS SalesDocumentItem,
  SOH.SalesOrganization AS SalesOrganization,
  SOH.DistributionChannel AS DistributionChannel,
  SOH.OrganizationDivision AS OrganizationDivision,
  SOH.SalesDocumentType AS SalesDocumentType,
  SOH.RequestedDeliveryDate AS RequestedDeliveryDate,
  SOH.OverallSDProcessStatus AS OverallSDProcessStatus,
  SOH.SalesDocumentDate AS SalesDocumentDate,
  SOH.SalesGroup AS SalesGroup,
  SOH.SalesOffice AS SalesOffice,
  SOH.SoldToParty AS SoldToParty,
  SOH.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  POI.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  POI.IsCompletelyDelivered AS IsCompletelyDelivered,
  POI.IsFinallyInvoiced AS IsFinallyInvoiced,
  POI.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  POI.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  POI.OrderQuantityUnit AS PurgDocOrderQuantityUnit,
  cast(PO_SL.DeliveryDate as due_date_sof) AS DueDate,
  cast(Dats_Days_Between( cast($session.system_date as dats), PO_SL.DeliveryDate) as due_days) AS DueDays,
  DeliveryDate
FROM I_PurchasingDocumentItem AS POI
INNER JOIN P_SalesOrderInSupplyPurgIssue2 AS PO_SL ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurOrdAccountAssignment AS PO_ACC ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocument AS SOH ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentItemBasic AS SOI ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_SalesOrderInSupplyPurgIssue3
;