I_DataMigrtnLogItemMsg

DDL: I_DATAMIGRTNLOGITEMMSG SQL: IDMCCLOGITMMSG Type: view COMPOSITE
18 Fields 1 Data Sources 1 Associations

Data Migration Log Item Message

I_DataMigrtnLogItemMsg is a Composite CDS View that provides data about "Data Migration Log Item Message" in SAP S/4HANA. It reads from 1 data source (I_DataMigrtnLgItemCkptMsg) and exposes 18 fields with key fields DataMigrationObjectID, DataMigrationProjectID, DataMigrationSenderKey, DataMigrationLogItemMsg. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DataMigrtnLgItemCkptMsg I_DataMigrtnLgItemCkptMsg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_DataMigrtnLogItem _DataMigrtnLogItem $projection.DataMigrtnLogItemMsgID = _DataMigrtnLogItem.DataMigrtnLogItemMsgID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IDMCCLOGITMMSG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data Migration Log Item Message view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationObjectID DataMigrationObjectID
KEY DataMigrationProjectID DataMigrationProjectID
KEY DataMigrationSenderKey DataMigrationSenderKey
KEY DataMigrationLogItemMsg DataMigrationLogItemMsg
SystemMessageType SystemMessageType Message type
SystemMessageClass SystemMessageClass Message ID
SystemMessageNumber SystemMessageNumber Message Number
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
DataMigrationFileUUID DataMigrationFileUUID
DataMigrationStggTblName DataMigrationStggTblName
DataMigrtnLogItemMsgID DataMigrtnLogItemMsgID
DataMigrationLoadingDate DataMigrationLoadingDate
DataMigrationStatus DataMigrationStatus
DataMigrationStepExtID DataMigrationStepExtID
_DataMigrtnLogItem _DataMigrtnLogItem

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_DataMigrtnLogItemMsg.
-- 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: IDMCCLOGITMMSG

CREATE VIEW I_DataMigrtnLogItemMsg AS
SELECT
  DataMigrationObjectID,
  DataMigrationProjectID,
  DataMigrationSenderKey,
  DataMigrationLogItemMsg,
  SystemMessageType,
  SystemMessageClass,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  DataMigrationFileUUID,
  DataMigrationStggTblName,
  DataMigrtnLogItemMsgID,
  DataMigrationLoadingDate,
  DataMigrationStatus,
  DataMigrationStepExtID
FROM I_DataMigrtnLgItemCkptMsg
LEFT OUTER JOIN I_DataMigrtnLogItem AS _DataMigrtnLogItem ON DataMigrtnLogItemMsgID = _DataMigrtnLogItem.DataMigrtnLogItemMsgID  -- association [1..1]
;

Learn More