P_SalesOrderInDelivDueDate

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_SalesOrderInDelivDueDate.
-- 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: PSODUEDATEREUSE5

CREATE VIEW P_SalesOrderInDelivDueDate AS
SELECT
  SOH.SalesDocument AS SalesOrder,
  DDI.DeliveryDocument AS DeliveryDocument,
  DDI.DeliveryDocumentItem AS DeliveryDocumentItem,
  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,
  DDH.DeliveryBlockReason AS DeliveryBlockReason,
  DDH.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  DDI.GoodsMovementStatus AS GoodsMovementStatus,
  DDH.OverallDelivReltdBillgStatus AS OverallDelivReltdBillgStatus,
  DDH.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  DDH.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  DDH.HeaderDelivIncompletionStatus AS HeaderDelivIncompletionStatus,
  DDH.HdrGoodsMvtIncompletionStatus AS HdrGoodsMvtIncompletionStatus,
  DDH.HeaderPackingIncompletionSts AS HeaderPackingIncompletionSts,
  DDH.HeaderPickgIncompletionStatus AS HeaderPickgIncompletionStatus,
  DDI.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  but might be replaced by item states below (14.10.2019: no longer used ) DDH.OverallDangerousGoodsStatus AS OverallDangerousGoodsStatus,
  but might be replaced by item states below (14.10.2019: no longer used ) DDH.OverallSafetyDataSheetStatus AS OverallSafetyDataSheetStatus,
  but might be replaced by item states below (14.10.2019: no longer used ) DDI.ChmlCmplncStatus AS ChmlCmplncStatus,
  DDH.BillingDocumentDate AS BillingDocumentDate,
  DDH.OverallPickingStatus AS OverallPickingStatus,
  case when AS casewhenCASE1TPStatusisopen
FROM I_DeliveryDocument AS DDH
INNER JOIN I_DeliveryDocumentItem AS DDI ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentBasic AS SOH ON /* join condition not captured in parsed metadata */
;