I_CustRetItmFllwUpActivity

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_CustRetItmFllwUpActivity.
-- 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: ICUSRETFLWUP

CREATE VIEW I_CustRetItmFllwUpActivity AS
SELECT
  msr_id AS RetsMgmtProcess,
  doc_item AS ReturnsDocumentItem,
  doc_nr AS ReturnsDocument,
  item AS RetsMgmtProcessItem,
  cast( right(doc_item, 6) as vdm_customer_return_item ) AS CustomerReturnItem,
  inspection_code AS InspectionCode,
  lifnr AS Supplier,
  addrnumber AS AddressID,
  chain_id AS CustRetItmChainID,
  _FollowUp.fu_code AS CustRetItmFollowUpActivity,
  _Inspection.at_customer_site AS ProductIsInspectedAtCustSite,
  _Inspection.inspec_no AS ProductInspectionID
FROM msr_d_executed
LEFT OUTER JOIN msr_i_chain AS _FollowUp ON _FollowUp.chain_id = CustRetItmChainID  -- association [0..1]
LEFT OUTER JOIN /spe/inspecresh AS _Inspection ON _Inspection.msr_id = RetsMgmtProcess AND _Inspection.ref_doc_item = ReturnsDocumentItem AND _Inspection.ref_doc = ReturnsDocument  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_CustomerReturn AS _CustomerReturn ON ReturnsDocument = _CustomerReturn.CustomerReturn  -- association [0..1]
;