C_DataMigrtnLgItmCatDataMsg

DDL: C_DATAMIGRTNLGITMCATDATAMSG SQL: CDMITMCATMSG Type: view CONSUMPTION
24 Fields 1 Data Sources

Data Migrtn Log Item Message

C_DataMigrtnLgItmCatDataMsg is a Consumption CDS View that provides data about "Data Migrtn Log Item Message" in SAP S/4HANA. It reads from 1 data source (I_DataMigrtnLgItmCatDataMsg) and exposes 24 fields with key fields DataMigrationObjectID, DataMigrationSenderKey, DataMigrationProjectID, DataMigrtnSndrStrucName, DataMigrationSndrStrucField.

Data Sources (1)

SourceAliasJoin Type
I_DataMigrtnLgItmCatDataMsg I_DataMigrtnLgItmCatDataMsg from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CDMITMCATMSG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data Migrtn Log Item Message view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION 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 (24)

KeyFieldSource TableSource FieldDescription
KEY DataMigrationObjectID DataMigrationObjectID
KEY DataMigrationSenderKey DataMigrationSenderKey Source ID
KEY DataMigrationProjectID DataMigrationProjectID Project
KEY DataMigrtnSndrStrucName DataMigrtnSndrStrucName
KEY DataMigrationSndrStrucField DataMigrationSndrStrucField
KEY DataMigrationSndrStrucFieldVal DataMigrationSndrStrucFieldVal Source Value
KEY SystemMessageType SystemMessageType Message type
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
KEY DataMigrationLogItemMsg DataMigrationLogItemMsg
DataMigrationSenderKeyTxt _DataMigrtnLogItemCatDataEnhcd DataMigrationSenderKeyTxt Description
DataMigrationTgtStrucFieldVal DataMigrationTgtStrucFieldVal S/4HANA Target Value
DataMigrtnSndrStrucDesc _DataMigrtnLogItemCatDataEnhcd DataMigrtnSndrStrucDesc Structure Name
DataMigrtnSndrStrucFieldLabel _DataMigrtnLogItemCatDataEnhcd DataMigrtnSndrStrucFieldLabel Field Name
DataMigrationStggTblName DataMigrationStggTblName Staging Table
DataMigrationFileName
DataMigrationProjectDesc
DataMigrationObjectDesc
DataMigrationLoadingDate _DataMigrtnLogItemCatDataEnhcd DataMigrationLoadingDate Migrated On
DataMigrationStepExtID _DataMigrtnLogItemCatDataEnhcd DataMigrationStepExtID

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_DataMigrtnLgItmCatDataMsg.
-- 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: CDMITMCATMSG

CREATE VIEW C_DataMigrtnLgItmCatDataMsg AS
SELECT
  DataMigrationObjectID,
  DataMigrationSenderKey,
  DataMigrationProjectID,
  DataMigrtnSndrStrucName,
  DataMigrationSndrStrucField,
  DataMigrationSndrStrucFieldVal,
  SystemMessageType,
  SystemMessageClass,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  DataMigrationLogItemMsg,
  _DataMigrtnLogItemCatDataEnhcd.DataMigrationSenderKeyTxt AS DataMigrationSenderKeyTxt,
  DataMigrationTgtStrucFieldVal,
  _DataMigrtnLogItemCatDataEnhcd.DataMigrtnSndrStrucDesc AS DataMigrtnSndrStrucDesc,
  _DataMigrtnLogItemCatDataEnhcd.DataMigrtnSndrStrucFieldLabel AS DataMigrtnSndrStrucFieldLabel,
  DataMigrationStggTblName,
  _DataMigrtnLogItemCatDataEnhcd._DataMigrationFile.DataMigrationFileName AS DataMigrationFileName,
  _DataMigrtnLogItemCatDataEnhcd._DataMigrtnProject.DataMigrationProjectDesc AS DataMigrationProjectDesc,
  _DataMigrtnLogItemCatDataEnhcd._DataMigrtnMigratedObject.DataMigrationObjectDesc AS DataMigrationObjectDesc,
  _DataMigrtnLogItemCatDataEnhcd.DataMigrationLoadingDate AS DataMigrationLoadingDate,
  _DataMigrtnLogItemCatDataEnhcd.DataMigrationStepExtID AS DataMigrationStepExtID
FROM I_DataMigrtnLgItmCatDataMsg
;

Learn More