I_RetsMgmtProcessItem

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_RetsMgmtProcessItem.
-- 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: IRMRTSPROCESSITM

CREATE VIEW I_RetsMgmtProcessItem AS
SELECT
  msr_id AS RetsMgmtProcess,
  item AS RetsMgmtProcessItem,
  matnr AS Material,
  ref_doc_type AS ReturnsReferenceDocumentType,
  ref_doc_nr AS ReturnsReferenceDocument,
  ref_doc_item AS ReturnsReferenceDocumentItem,
  rma_customer AS CustRetMatlAuthzn,
  cmr_abgru AS ReturnsRefundRjcnReason
FROM msr_d_item
LEFT OUTER JOIN I_RetsMgmtProcess AS _RetsMgmtProcess ON RetsMgmtProcess = _RetsMgmtProcess.RetsMgmtProcess  -- association [1..1]
LEFT OUTER JOIN I_ReturnsDocumentType AS _ReturnsReferenceDocumentType ON ReturnsReferenceDocumentType = _ReturnsReferenceDocumentType.ReturnsDocumentType  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcItmWthProcgSts AS _RetsMgmtProcItmWthProcgSts ON RetsMgmtProcess = _RetsMgmtProcItmWthProcgSts.RetsMgmtProcess AND RetsMgmtProcessItem = _RetsMgmtProcItmWthProcgSts.RetsMgmtProcessItem  -- association [1..1]
LEFT OUTER JOIN I_RetsMgmtProcessItemExec AS _RetsMgmtProcessItemExec ON RetsMgmtProcess = _RetsMgmtProcessItemExec.RetsMgmtProcess AND RetsMgmtProcessItem = _RetsMgmtProcessItemExec.RetsMgmtProcessItem  -- association [1..1]
LEFT OUTER JOIN I_RetsMgmtProcItmRetOrdExec AS _RetsMgmtProcItmRetOrdExec ON RetsMgmtProcess = _RetsMgmtProcItmRetOrdExec.RetsMgmtProcess AND RetsMgmtProcessItem = _RetsMgmtProcItmRetOrdExec.RetsMgmtProcessItem  -- association [1..1]
LEFT OUTER JOIN I_RetsMgmtProcItmInspExec AS _RetsMgmtProcItmInspExec ON RetsMgmtProcess = _RetsMgmtProcItmInspExec.RetsMgmtProcess AND RetsMgmtProcessItem = _RetsMgmtProcItmInspExec.RetsMgmtProcessItem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _ReturnsRefundRjcnReason ON ReturnsRefundRjcnReason = _ReturnsRefundRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
;