R_Sitn2LogMessage

DDL: R_SITN2LOGMESSAGE SQL: RSITN2LGMSG Type: view BASIC

Log Message Details

R_Sitn2LogMessage is a Basic CDS View that provides data about "Log Message Details" in SAP S/4HANA. It reads from 1 data source (t100) and exposes 6 fields with key fields Language, SitnMsgClassID, SitnMsgNumber. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
t100 _t100 from

Associations (1)

CardinalityTargetAliasCondition
[1] t100t _t100t $projection.Language = _t100t.sprsl and $projection.SitnMsgClassID = _t100t.arbgb

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName RSITN2LGMSG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Log Message Details view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Language t100 sprsl
KEY SitnMsgClassID t100 arbgb
KEY SitnMsgNumber t100 msgnr
SitnMsgText t100 text
SitnMsgFilterKey
SitnMsgClassText _t100t stext 
@AbapCatalog.sqlViewName: 'RSITN2LGMSG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
                usageType:{
                            serviceQuality:#C,
                            sizeCategory: #L,
                            dataClass: #TRANSACTIONAL
                           }
             }
@EndUserText.label: 'Log Message Details'
define view R_Sitn2LogMessage as select from t100 as _t100
 association [1] to t100t as _t100t on  $projection.Language       = _t100t.sprsl
                                     and $projection.SitnMsgClassID = _t100t.arbgb
{
  key _t100.sprsl                                                                        as Language,
  key _t100.arbgb                                                                        as SitnMsgClassID,
  key _t100.msgnr                                                                        as SitnMsgNumber,
      _t100.text                                                                         as SitnMsgText,
      cast(concat( concat( _t100.arbgb, _t100.msgnr ), '                                               ')  as sit2_de_msg_fltr_key preserving type )   as SitnMsgFilterKey,
      _t100t.stext                                                                       as SitnMsgClassText
}
where
  _t100.sprsl = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T100",
"T100T"
],
"ASSOCIATED":
[
"T100T"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More