I_SLT_RemoteSystemConnection

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_SLT_RemoteSystemConnection.
-- 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: ISLTRMTESYSTCONN

CREATE VIEW I_SLT_RemoteSystemConnection AS
SELECT
  ConfigurationHeader.ReplicationConfigurationUUID AS ReplicationConfigurationUUID,
  ConfigurationHeader.MassTransferCode AS MassTransferCode,
  _ConnectionName.SourceConnection AS SourceConnection,
  _ConnectionName.SourceConnectionType AS SourceConnectionType,
  _ConnectionName.TargetConnection AS TargetConnection,
  _ConnectionName.TargetConnectionType AS TargetConnectionType,
  _ConncnParameter.SourceSystemHostName AS SourceSystemHostName,
  _ConncnParameter.SourceSystemHostInstanceNumber AS SourceSystemHostInstanceNumber,
  _ConncnParameter.ReplicationSourceSystem AS ReplicationSourceSystem,
  _ConncnParameter.SourceDatabaseCode AS SourceDatabaseCode,
  _ConncnParameter.SourceDatabaseSchema AS SourceDatabaseSchema,
  _ConncnParameter.TargetSystemHostName AS TargetSystemHostName,
  _ConncnParameter.TargetSystemHostInstanceNumber AS TargetSystemHostInstanceNumber,
  _ConncnParameter.ReplicationTargetSystem AS ReplicationTargetSystem,
  _ConncnParameter.TargetDatabaseCode AS TargetDatabaseCode,
  _ConncnParameter.TargetDatabaseSchema AS TargetDatabaseSchema
FROM I_SLT_ConfigurationHeader AS ConfigurationHeader
LEFT OUTER JOIN I_SLT_RmteSystConncnParameter AS _ConncnParameter ON _ConncnParameter.ReplicationConfigurationUUID = ConfigurationHeader.ReplicationConfigurationUUID  -- association [1..1]
LEFT OUTER JOIN I_MIG_RmteSystemConnectionName AS _ConnectionName ON _ConnectionName.MassTransferCode = ConfigurationHeader.MassTransferCode  -- association [1..1]
;