C_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 C_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: CSLTCONFIGNITEM

CREATE VIEW C_SLT_ConfigurationItem AS
SELECT
  ConfigurationItem.MassTransferCode AS MassTransferCode,
  ConfigurationItem.ReplicationInternalTableName AS ReplicationInternalTableName,
  ConfigurationItem.ReplicationHealthCheckStatus AS ReplicationHealthCheckStatus,
  ConfigurationItem.MedianRplctnLatencyDurnInSecs AS MedianRplctnLatencyDurnInSecs,
  ConfigurationItem.LastReplicationDurationInSecs AS LastReplicationDurationInSecs,
  ConfigurationItem.NrOfRecordsInsertedLastHour AS NrOfRecordsInsertedLastHour,
  ConfigurationItem.NrOfRecordsUpdatedLastHour AS NrOfRecordsUpdatedLastHour,
  ConfigurationItem.NrOfRecordsDeletedLastHour AS NrOfRecordsDeletedLastHour,
  ConfigurationItem.LoggingTableIsCreated AS LoggingTableIsCreated,
  ConfigurationItem.TriggerIsActive AS TriggerIsActive,
  ConfigurationItem.ProxyTableIsCreated AS ProxyTableIsCreated,
  ConfigurationItem.TargetTableIsCreated AS TargetTableIsCreated,
  ConfigurationItem.TargetSynonymIsCreated AS TargetSynonymIsCreated,
  ConfigurationItem.SourceTableIsCreated AS SourceTableIsCreated,
  ConfigurationItem.SourceSynonymIsCreated AS SourceSynonymIsCreated,
  ConfigurationItem.MigrationObjectIsCreated AS MigrationObjectIsCreated,
  ConfigurationItem.RuntimeObjectIsGenerated AS RuntimeObjectIsGenerated,
  ConfigurationItem.DataPortionsAreCalculated AS DataPortionsAreCalculated,
  ConfigurationItem.LoggingTableIsRequired AS LoggingTableIsRequired,
  ConfigurationItem.TriggerIsRequired AS TriggerIsRequired,
  ConfigurationItem.ProxyTableIsRequired AS ProxyTableIsRequired,
  ConfigurationItem.TargetTableIsRequired AS TargetTableIsRequired,
  ConfigurationItem.TargetSynonymIsRequired AS TargetSynonymIsRequired,
  ConfigurationItem.SourceTableIsRequired AS SourceTableIsRequired,
  ConfigurationItem.SourceSynonymIsRequired AS SourceSynonymIsRequired,
  ConfigurationItem.MigrationObjectIsRequired AS MigrationObjectIsRequired,
  ConfigurationItem.RuntimeObjectIsRequired AS RuntimeObjectIsRequired,
  ConfigurationItem.DataPortionsAreRequired AS DataPortionsAreRequired,
  ConfigurationItem.CurrentReplicationAction AS CurrentReplicationAction,
  ConfigurationItem.RplctnPreparationStepStatus AS RplctnPreparationStepStatus
FROM I_SLT_ConfigurationItem AS ConfigurationItem
LEFT OUTER JOIN C_SLT_Configuration AS _Configuration ON _Configuration.MassTransferCode = ConfigurationItem.MassTransferCode  -- association [1..1]
LEFT OUTER JOIN I_SLT_ConfignItemObjectHeader AS _ReplicationObjectName ON ConfigurationItem.MassTransferCode = _ReplicationObjectName.MassTransferCode AND ConfigurationItem.ReplicationInternalTableName = _ReplicationObjectName.ReplicationInternalTableName  -- association [0..*]
LEFT OUTER JOIN I_SLT_RplctnPrepStepStatusText AS _PreparationStepStatusText ON _PreparationStepStatusText.RplctnPreparationStepStatus = ConfigurationItem.RplctnPreparationStepStatus  -- association [0..*]
LEFT OUTER JOIN I_SLT_CurReplicationActionText AS _CurrentReplicationActionText ON _CurrentReplicationActionText.CurrentReplicationAction = ConfigurationItem.CurrentReplicationAction  -- association [0..*]
;