Rv_I_DataSource

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 Rv_I_DataSource.
-- 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: RVIDATASRC

CREATE VIEW Rv_I_DataSource AS
SELECT
  dataSource,
  logSys,
  type,
  applicName,
  delta,
  realtime,
  directAccess,
  openingBalance,
  extendedTable,
  lastChangedBy,
  cast(lastChangedAt as rvlsttstmp) AS lastChangedAt,
  cast(cast(1 as abap.int4) as rvcounter) AS counter
FROM Rv_P_DataSource_
LEFT OUTER JOIN Rv_P_DataSourceText_ AS _text ON _text.dataSource = dataSource AND _text.logSys = logSys  -- association [0..*]
LEFT OUTER JOIN Rv_P_LogSys AS _logSys ON _logSys.logSys = logSys  -- association [1..1]
LEFT OUTER JOIN Rv_I_Rsds_Requtype AS _type ON _type.type = type  -- association [0..*]
LEFT OUTER JOIN Rv_P_DeltaProcess AS _delta ON _delta.delta = delta  -- association [0..*]
LEFT OUTER JOIN Rv_I_Rs_Bool AS _boolRT ON _boolRT.booleanValue = realtime  -- association [0..1]
LEFT OUTER JOIN Rv_I_Rsds_Rovirt AS _directAccess ON _directAccess.directAccess = directAccess  -- association [0..*]
LEFT OUTER JOIN Rv_I_Rs_Bool AS _boolOB ON _boolOB.booleanValue = openingBalance  -- association [0..1]
LEFT OUTER JOIN Rv_I_Rs_Bool AS _boolET ON _boolET.booleanValue = extendedTable  -- association [0..1]
LEFT OUTER JOIN Rv_P_User AS _lastChangedBy ON _lastChangedBy.userName = lastChangedBy  -- association [0..1]
;