I_AdvncdReturnsMgmtProcessStep

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 I_AdvncdReturnsMgmtProcessStep.
-- 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.

CREATE VIEW I_AdvncdReturnsMgmtProcessStep AS
SELECT
  Executed.RetsMgmtProcess AS RetsMgmtProcess,
  Executed.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  Executed.RetsMgmtProcItmQtySplit AS RetsMgmtProcItmQtySplit,
  Executed.RetsMgmtProcessStep AS RetsMgmtProcessStep,
  Executed.ReturnsDocumentType AS ReturnsDocumentType,
  Executed.ReturnsDocument AS ReturnsDocument,
  Executed.ReturnsDocumentItem AS ReturnsDocumentItem,
  Executed.ReturnsReferenceDocumentType AS ReturnsReferenceDocumentType,
  Executed.ReturnsReferenceDocument AS ReturnsReferenceDocument,
  Executed.ReturnsReferenceDocumentItem AS ReturnsReferenceDocumentItem,
  Executed.ReturnsDocumentStatus AS ReturnsDocumentStatus,
  Executed.ReturnsDocumentApprovalStatus AS ReturnsDocumentApprovalStatus,
  Executed.RetsMgmtProcItmExectdSequence AS RetsMgmtProcItmExectdSequence,
  Executed.CustRetItmChainID AS CustRetItmChainID,
  Chain.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  Chain.ReturnsMaterialHasBeenReceived AS ReturnsMaterialHasBeenReceived,
  NextPlants.NextPlantForFollowUpActivity AS NextPlantForFollowUpActivity,
  NextPlants.ReturnsTransshipmentPlant AS ReturnsTransshipmentPlant,
  Executed.ReturnsRefundType AS ReturnsRefundType,
  Executed.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  Executed.PrelimRefundIsDetermined AS PrelimRefundIsDetermined,
  Executed.ReplacementMaterial AS ReplacementMaterial,
  Executed.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  Executed.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  Executed.ReplacementMaterialIsRequested AS ReplacementMaterialIsRequested,
  Executed.ReplacementMatlSupplyingPlant AS ReplacementMatlSupplyingPlant,
  Executed.Supplier AS Supplier,
  Executed.AddressID AS AddressID,
  Executed.SupplierRetMatlAuthzn AS SupplierRetMatlAuthzn,
  Executed.SuplrRetMatlAuthznIsRequired AS SuplrRetMatlAuthznIsRequired,
  Executed.RetMatlInspResultCode AS RetMatlInspResultCode,
  Executed._AdvncdRetsMgmtProcess AS _AdvncdRetsMgmtProcess,
  Executed._AdvncdRetsMgmtProcessItem AS _AdvncdRetsMgmtProcessItem,
  Executed._ReturnsReferenceDocumentType AS _ReturnsReferenceDocumentType,
  Executed._ReturnsRefundType AS _ReturnsRefundType,
  Executed._ReturnsRefundProcgMode AS _ReturnsRefundProcgMode,
  Executed._ReplacementMaterialQtyUnit AS _ReplacementMaterialQtyUnit,
  Executed._Supplier AS _Supplier,
  Executed._Address AS _Address,
  Executed._DfltAddrRprstn AS _DfltAddrRprstn,
  Executed._RetMatlInspResultCode AS _RetMatlInspResultCode
FROM I_AdvncdRetsMgmtProcExecuted AS Executed
LEFT OUTER JOIN I_AdvncdRetsMgmtProcNextPlants AS NextPlants ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AdvncdRetsMgmtProcExecStatus AS ProcgStatus ON /* join condition not captured in parsed metadata */
;