C_DataMigrationValMsg

DDL: C_DATAMIGRATIONVALMSG SQL: CDMVALMSG Type: view CONSUMPTION Package: CA_GTF_MIG_DMCC_ODATA
14 Fields 1 Data Sources 1 Associations

Data Migration PLV Error Messages

C_DataMigrationValMsg is a Consumption CDS View that provides data about "Data Migration PLV Error Messages" in SAP S/4HANA. It reads from 1 data source (I_DataMigrtnLogItemMsg) and exposes 14 fields with key fields DataMigrationObjectID, DataMigrationSenderKey, DataMigrationProjectID, DataMigrationLogItemMsg, SystemMessageClass. It has 1 association to related views. Part of development package CA_GTF_MIG_DMCC_ODATA.

Data Sources (1)

SourceAliasJoin Type
I_DataMigrtnLogItemMsg I_DataMigrtnLogItemMsg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_DataMigrationMsgTypeTxt _DataMigrationMsgTypeTxt _DataMigrationMsgTypeTxt.DomainValue = $projection.SystemMessageType

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CDMVALMSG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data Migration PLV Error Messages view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private false view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
UI.headerInfo.typeName Post load validation view
UI.headerInfo.typeNamePlural Items view
UI.headerInfo.title.value Post load validation view
UI.headerInfo.description.value Post load validation view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationObjectID DataMigrationObjectID
KEY DataMigrationSenderKey DataMigrationSenderKey
KEY DataMigrationProjectID DataMigrationProjectID
KEY DataMigrationLogItemMsg DataMigrationLogItemMsg
KEY SystemMessageClass SystemMessageClass Message ID
KEY SystemMessageNumber SystemMessageNumber Message Number
KEY SystemMessageVariable1 SystemMessageVariable1 Variable 1
KEY SystemMessageVariable2 SystemMessageVariable2 Variable 2
KEY SystemMessageVariable3 SystemMessageVariable3 Variable 3
KEY SystemMessageVariable4 SystemMessageVariable4 Variable 4
SystemMessageType SystemMessageType Message Type
SystemMessageText Message
SystemMessageLongText
_DataMigrationMsgTypeTxt _DataMigrationMsgTypeTxt

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_DataMigrationValMsg.
-- 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: CDMVALMSG

CREATE VIEW C_DataMigrationValMsg AS
SELECT
  DataMigrationObjectID,
  DataMigrationSenderKey,
  DataMigrationProjectID,
  DataMigrationLogItemMsg,
  SystemMessageClass,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  SystemMessageType,
  cast ('' as char255) AS SystemMessageText,
  cast('' as text_description) AS SystemMessageLongText
FROM I_DataMigrtnLogItemMsg
LEFT OUTER JOIN C_DataMigrationMsgTypeTxt AS _DataMigrationMsgTypeTxt ON _DataMigrationMsgTypeTxt.DomainValue = SystemMessageType  -- association [1..1]
;

Learn More