I_AdvncdRetsMgmtProcExecuted

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_AdvncdRetsMgmtProcExecuted.
-- 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_AdvncdRetsMgmtProcExecuted AS
SELECT
  msr_id AS RetsMgmtProcess,
  item AS RetsMgmtProcessItem,
  split_id AS RetsMgmtProcItmQtySplit,
  executed_step_id AS RetsMgmtProcessStep,
  doc_type AS ReturnsDocumentType,
  doc_nr AS ReturnsDocument,
  doc_item AS ReturnsDocumentItem,
  cast (right(doc_item, 6) as posnr) AS SDDocumentItem,
  executed_seq_id AS RetsMgmtProcItmExectdSequence,
  chain_id AS CustRetItmChainID,
  quantity AS QuantityInBaseUnit,
  unit AS BaseUnit,
  ref_doc_type AS ReturnsReferenceDocumentType,
  ref_doc_nr AS ReturnsReferenceDocument,
  ref_doc_item AS ReturnsReferenceDocumentItem,
  doc_status AS ReturnsDocumentStatus,
  appr_status AS ReturnsDocumentApprovalStatus,
  im_plant AS TargetPlant,
  lgort AS TargetStorageLocation,
  insmk AS TargetStockType,
  im_material AS TgtProdForGdsMvtPostg,
  refund_type AS ReturnsRefundType,
  cast (refund_control as returns_refund_procg_mode preserving type) AS ReturnsRefundProcgMode,
  pre_refund AS PrelimRefundIsDetermined,
  replace_matnr AS ReplacementMaterial,
  replace_qty AS ReplacementMaterialQuantity,
  replace_unit AS ReplacementMaterialQtyUnit,
  replace_request AS ReplacementMaterialIsRequested,
  paying_plant AS ReplacementMatlSupplyingPlant,
  replaced_qty AS ReplacedMaterialQuantity,
  replaced_unit AS ReplacedMaterialQtyUnit,
  lifnr AS Supplier,
  addrnumber AS AddressID,
  rma_vendor AS SupplierRetMatlAuthzn,
  rma_vendor_req AS SuplrRetMatlAuthznIsRequired,
  inspection_code AS RetMatlInspResultCode
FROM msr_d_executed AS Executed
LEFT OUTER JOIN I_AdvncdReturnsMgmtProcess AS _AdvncdRetsMgmtProcess ON RetsMgmtProcess = _AdvncdRetsMgmtProcess.RetsMgmtProcess  -- association [1..1]
LEFT OUTER JOIN I_AdvncdReturnsMgmtProcessItem AS _AdvncdRetsMgmtProcessItem ON RetsMgmtProcess = _AdvncdRetsMgmtProcessItem.RetsMgmtProcess AND RetsMgmtProcessItem = _AdvncdRetsMgmtProcessItem.RetsMgmtProcessItem  -- association [1..1]
LEFT OUTER JOIN I_ReturnsDocumentType AS _ReturnsReferenceDocumentType ON ReturnsReferenceDocumentType = _ReturnsReferenceDocumentType.ReturnsDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ReturnsDocumentType AS _ReturnsDocumentType ON ReturnsDocumentType = _ReturnsDocumentType.ReturnsDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundType AS _ReturnsRefundType ON ReturnsRefundType = _ReturnsRefundType.ReturnsRefundType  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundProcgModeActive AS _ReturnsRefundProcgMode ON ReturnsRefundProcgMode = _ReturnsRefundProcgMode.ReturnsRefundProcgMode AND ReturnsRefundType = _ReturnsRefundProcgMode.ReturnsRefundType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ReplacementMaterialQtyUnit ON ReplacementMaterialQtyUnit = _ReplacementMaterialQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ReplacedMaterialQtyUnit ON ReplacedMaterialQtyUnit = _ReplacedMaterialQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [1..1]
LEFT OUTER JOIN I_Address_2 AS _DfltAddrRprstn ON AddressID = _DfltAddrRprstn.AddressID AND _DfltAddrRprstn.AddressRepresentationCode is initial  -- association [1..*]
LEFT OUTER JOIN I_RetMatlInspResultCode AS _RetMatlInspResultCode ON RetMatlInspResultCode = _RetMatlInspResultCode.RetMatlInspResultCode  -- association [0..1]
;