I_MigratedDataInstanceLog

DDL: I_MIGRATEDDATAINSTANCELOG SQL: IMIGDATAINSTLOG Type: view BASIC
13 Fields 1 Data Sources 1 Associations

Message Log of Data Instance

I_MigratedDataInstanceLog is a Basic CDS View that provides data about "Message Log of Data Instance" in SAP S/4HANA. It reads from 1 data source (dmc_miginstlog) and exposes 13 fields with key field DataMigrationInstanceLogUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dmc_miginstlog dmc_miginstlog from

Associations (1)

CardinalityTargetAliasCondition
[1] I_MigratedDataInstance _DataInstance $projection.DataMigrationInstanceUUID = _DataInstance.DataMigrationInstanceUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMIGDATAINSTLOG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Message Log of Data Instance view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationInstanceLogUUID log_id Log UUID
DataMigrationInstanceUUID instance_id Instance ID
DataMigrationExecutionUUID execution_id Item
SystemMessageType msgtype Message Type
SystemMessageClass msgid Message ID
SystemMessageNumber msgno Message Number
SystemMessageVariable1 msgv1 Message variable 1
SystemMessageVariable2 msgv2 Message variable 2
SystemMessageVariable3 msgv3 Message variable 3
SystemMessageVariable4 msgv4 Message variable 4
LastChangeDateTime changed_at Timestamp
DataMigrtnInstceLogRefFldName msg_field Field name
_DataInstance _DataInstance

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_MigratedDataInstanceLog.
-- 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: IMIGDATAINSTLOG

CREATE VIEW I_MigratedDataInstanceLog AS
SELECT
  log_id AS DataMigrationInstanceLogUUID,
  instance_id AS DataMigrationInstanceUUID,
  execution_id AS DataMigrationExecutionUUID,
  msgtype AS SystemMessageType,
  msgid AS SystemMessageClass,
  msgno AS SystemMessageNumber,
  msgv1 AS SystemMessageVariable1,
  msgv2 AS SystemMessageVariable2,
  msgv3 AS SystemMessageVariable3,
  msgv4 AS SystemMessageVariable4,
  changed_at AS LastChangeDateTime,
  msg_field AS DataMigrtnInstceLogRefFldName
FROM dmc_miginstlog
LEFT OUTER JOIN I_MigratedDataInstance AS _DataInstance ON DataMigrationInstanceUUID = _DataInstance.DataMigrationInstanceUUID  -- association [1]
;

Learn More