I_DataMigrationLogItemText

DDL: I_DATAMIGRATIONLOGITEMTEXT SQL: IDMCCLOGITMTXT Type: view BASIC

Data Migration Log Item Approval Text

I_DataMigrationLogItemText is a Basic CDS View that provides data about "Data Migration Log Item Approval Text" in SAP S/4HANA. It reads from 2 data sources (dmc_plv_text, I_Text_Templates) and exposes 8 fields with key fields DataMigrtnLogItemMsgID, ArchObjectNumber.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
dmc_plv_text _plv_text from
I_Text_Templates _Text_Template inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IDMCCLOGITMTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data Migration Log Item Approval Text view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY DataMigrtnLogItemMsgID message_id
KEY ArchObjectNumber audit_commentid
CreatedByUser created_by
DataMigrationLogItemAuditSts audit_status
CreationDateTime created_on
DocumentText I_Text_Templates DocumentText Text ID
Language I_Text_Templates Language
NoteDescription 
@AbapCatalog.sqlViewName: 'IDMCCLOGITMTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Data Migration Log Item Approval Text'

@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
define view I_DataMigrationLogItemText
  as select from dmc_plv_text     as _plv_text
    inner join   I_Text_Templates as _Text_Template on _Text_Template.ArchitecturalObjectNumber = _plv_text.audit_commentid
{
  key  message_id                                                                   as  DataMigrtnLogItemMsgID,
  key  audit_commentid                                                              as  ArchObjectNumber,
       created_by                                                                   as  CreatedByUser,
       audit_status                                                                 as  DataMigrationLogItemAuditSts,
       created_on                                                                   as  CreationDateTime,
       @EndUserText.label: 'Text ID'
       _Text_Template.DocumentText,

       _Text_Template.Language,

       cast('' as text_description)                                                 as  NoteDescription
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXT_TEMPLATES",
"DMC_PLV_TEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More