APS_V_RCV_CDS_INFO

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 APS_V_RCV_CDS_INFO.
-- 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: V_RCV_INFO

CREATE VIEW APS_V_RCV_CDS_INFO AS
SELECT
  DDLSourceName AS View_Name,
  _CDSSTOBView.STOB_Name AS stob_name,
  userName AS Responsible,
  CDSOriginKey,
  _CDSSQLView.SQLViewName AS SQL_View_Name,
  _Text.ddtext AS description
FROM APS_V_RCV_CDS_LIST
LEFT OUTER JOIN APS_V_RCV_SQLVIEW_LIST AS _CDSSQLView ON View_Name = _CDSSQLView.DDLSourceName  -- association [1..*]
LEFT OUTER JOIN APS_V_RCV_STOB_LIST AS _CDSSTOBView ON View_Name = _CDSSTOBView.DDLSourceName  -- association [1..*]
LEFT OUTER JOIN ddddlsrc02bt AS _Text ON View_Name = _Text.ddlname AND _Text.ddlanguage = $session.system_language  -- association [1..*]
;