C_DataMigrtnLogItemMsg

DDL: C_DATAMIGRTNLOGITEMMSG SQL: CDMCITMMSG Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Data Migration Log Item Messages

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

Data Sources (1)

SourceAliasJoin Type
I_DataMigrtnLogItemMsg I_DataMigrtnLogItemMsg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_DataMigrationObjectVH _DataMigrationObjectVH _DataMigrationObjectVH.DataMigrationObjectID = $projection.DataMigrationObjectID

Annotations (9)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationProjectID DataMigrationProjectID Migration Project
KEY DataMigrationObjectID DataMigrationObjectID Object Name
KEY DataMigrationSenderKey DataMigrationSenderKey
KEY DataMigrationLogItemMsg DataMigrationLogItemMsg
DataMigrationSenderKeyTxt _DataMigrtnLogItem DataMigrationSenderKeyTxt
DataMigrationProjectDesc Project Name
DataMigrationFileName File Name
DataMigrationLoadingDate _DataMigrtnLogItem DataMigrationLoadingDate Migrated On
SystemMessageType SystemMessageType Message Type
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
SystemMessageText Message
SystemMessageClass SystemMessageClass Message ID
SystemMessageNumber SystemMessageNumber Message Number
DataMigrationObjectDesc _DataMigrationObjectVH DataMigrationObjectDesc Object Name
DataMigrationStatus _DataMigrtnLogItem DataMigrationStatus

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_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: CDMCITMMSG

CREATE VIEW C_DataMigrtnLogItemMsg AS
SELECT
  DataMigrationProjectID,
  DataMigrationObjectID,
  DataMigrationSenderKey,
  DataMigrationLogItemMsg,
  _DataMigrtnLogItem.DataMigrationSenderKeyTxt AS DataMigrationSenderKeyTxt,
  _DataMigrtnLogItem._DataMigrtnProject.DataMigrationProjectDesc AS DataMigrationProjectDesc,
  _DataMigrtnLogItem._DataMigrationFile.DataMigrationFileName AS DataMigrationFileName,
  _DataMigrtnLogItem.DataMigrationLoadingDate AS DataMigrationLoadingDate,
  SystemMessageType,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  cast ('' as char255) AS SystemMessageText,
  SystemMessageClass,
  SystemMessageNumber,
  _DataMigrationObjectVH.DataMigrationObjectDesc AS DataMigrationObjectDesc,
  _DataMigrtnLogItem.DataMigrationStatus AS DataMigrationStatus
FROM I_DataMigrtnLogItemMsg
LEFT OUTER JOIN C_DataMigrationObjectVH AS _DataMigrationObjectVH ON _DataMigrationObjectVH.DataMigrationObjectID = DataMigrationObjectID  -- association [1..1]
;

Learn More