I_SLT_ConfigurationItem

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_ConfigurationItem.
-- 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: ISLTCONFIGNITEM

CREATE VIEW I_SLT_ConfigurationItem AS
SELECT
  ConfigurationHeader.MassTransferCode AS MassTransferCode,
  ConfigurationItemStatus.ReplicationInternalTableName AS ReplicationInternalTableName,
  coalesce( LongTableName.ReplicationTableName, ConfigurationItemStatus.ReplicationInternalTableName ) AS ReplicationTableName,
  _ODQSubstitute.ODQSubstitutionName AS ODQSubstitutionName,
  _LastAction.LastReplicationAction AS LastReplicationAction,
  ConfigurationItemStatus.ReplicationProcessOption AS ReplicationProcessOption,
  ConfigurationItemStatus.ReplicationActionIsBlocked AS ReplicationActionIsBlocked,
  cast ( ConfigurationItemStatus.LoggingTableIsCreated as boolean ) AS LoggingTableIsCreated,
  cast ( ConfigurationItemStatus.TriggerIsActive as boolean ) AS TriggerIsActive,
  cast ( MigrationObjectStatus.MigrationObjectIsCreated as boolean ) AS MigrationObjectIsCreated,
  cast ( MigrationObjectStatus.RuntimeObjectIsGenerated as boolean ) AS RuntimeObjectIsGenerated,
  cast ( MigrationObjectStatus.DataPortionsAreCalculated as boolean ) AS DataPortionsAreCalculated,
  cast ( MigrationObjectStatus.MigrationObjectHasFailed as boolean ) AS MigrationObjectHasFailed,
  ConfigurationItemStatus.ConfigurationItemHasFailed AS ConfigurationItemHasFailed,
  _HealthCheckStatus.ReplicationHealthCheckStatus AS ReplicationHealthCheckStatus,
  _LastReplication.LastReplicationDurationInSecs AS LastReplicationDurationInSecs,
  _ReplicationLatency.MedianRplctnLatencyDurnInSecs AS MedianRplctnLatencyDurnInSecs,
  _ReplicationStatistic.NrOfRecordsDeletedLastHour AS NrOfRecordsDeletedLastHour,
  _ReplicationStatistic.NrOfRecordsInsertedLastHour AS NrOfRecordsInsertedLastHour,
  _ReplicationStatistic.NrOfRecordsUpdatedLastHour AS NrOfRecordsUpdatedLastHour
FROM I_SLT_ConfigurationHeader AS ConfigurationHeader
INNER JOIN I_SLT_ConfigurationItemStatus AS ConfigurationItemStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SLT_RplctnIntTblNameToName AS LongTableName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MIG_MigrationObjectStatus AS MigrationObjectStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SLT_LastConfignItemAction AS _LastAction ON _LastAction.MassTransferCode = ConfigurationHeader.MassTransferCode AND _LastAction.ReplicationInternalTableName = ConfigurationItemStatus.ReplicationInternalTableName  -- association [1..1]
LEFT OUTER JOIN I_SLT_ConfignItemObjectHeader AS _ReplicationObjectName ON _ReplicationObjectName.MassTransferCode = ConfigurationHeader.MassTransferCode AND _ReplicationObjectName.ReplicationInternalTableName = ConfigurationItemStatus.ReplicationInternalTableName  -- association [0..*]
LEFT OUTER JOIN I_SLT_ConfignItemODQSubstitute AS _ODQSubstitute ON _ODQSubstitute.MassTransferCode = ConfigurationHeader.MassTransferCode AND _ODQSubstitute.ReplicationInternalTableName = ConfigurationItemStatus.ReplicationInternalTableName  -- association [0..1]
LEFT OUTER JOIN I_SLT_LastConfignItmRplctnDurn AS _LastReplication ON _LastReplication.MigrationObjectUUID = MigrationObjectStatus.MigrationObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_SLT_ReplicationLatency AS _ReplicationLatency ON _ReplicationLatency.MassTransferCode = ConfigurationHeader.MassTransferCode AND _ReplicationLatency.ReplicationInternalTableName = ConfigurationItemStatus.ReplicationInternalTableName  -- association [1..1]
LEFT OUTER JOIN I_SLT_RplctnStatisticLastHour AS _ReplicationStatistic ON _ReplicationStatistic.MigrationObjectUUID = MigrationObjectStatus.MigrationObjectUUID  -- association [1..1]
LEFT OUTER JOIN I_SLT_Configuration AS _Configuration ON _Configuration.MassTransferCode = ConfigurationHeader.MassTransferCode  -- association [1..1]
LEFT OUTER JOIN I_SLT_ConfignItemHlthChkStatus AS _HealthCheckStatus ON _HealthCheckStatus.MassTransferCode = ConfigurationHeader.MassTransferCode AND _HealthCheckStatus.ReplicationInternalTableName = ConfigurationItemStatus.ReplicationInternalTableName  -- association [1..1]
LEFT OUTER JOIN I_MIG_RmteSystemConnectionName AS _RemoteSystemConnection ON _RemoteSystemConnection.MassTransferCode = ConfigurationHeader.MassTransferCode  -- association [0..1]
;