P_CustRetProcFlow05

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_CustRetProcFlow05.
-- 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: PCUSTRETPROCF05

CREATE VIEW P_CustRetProcFlow05 AS
SELECT
  Level1.InspectionDocument AS Level1Document,
  Level1.ReferenceDocumentItem AS Level1DocumentItem,
  'INSP' AS Level1DocumentCategory,
  Level0.SDDocumentCategory AS SDDocumentCategory,
  Level0.CustomerReturnType AS CustomerReturnType,
  Level0.CustomerReturn AS CustomerReturn,
  Level1.ProductIsInspectedAtCustSite AS ProductIsInspectedAtCustSite,
  Level1.ReturnsDelivery AS ReturnsDelivery,
  Level1.ReturnsDeliveryItem AS ReturnsDeliveryItem,
  Level0.SalesOrganization AS SalesOrganization,
  Level0.DistributionChannel AS DistributionChannel,
  Level0.OrganizationDivision AS OrganizationDivision,
  Level1.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  ARMProcessExcuted.RetsMgmtProcItmQtySplit AS RetsMgmtProcItmQtySplit
FROM P_CustRetProcFlow0 AS Level0
INNER JOIN I_AdvncdRetsMgmtMatlInspection AS Level1 ON /* join condition not captured in parsed metadata */
INNER JOIN I_AdvncdRetsMgmtProcExecuted AS ARMProcessExcuted ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocumentItemBasic AS _CustomerReturnItem ON Level0.CustomerReturn = _CustomerReturnItem.SalesDocument AND Level1.ReferenceDocumentItem = _CustomerReturnItem.SalesDocumentItem  -- association [1..1]
;