I_SITNINSTCEMESSAGEPARAMETER

CDS View

Message Parameter for Situation Instance

I_SITNINSTCEMESSAGEPARAMETER is a CDS View in S/4HANA. Message Parameter for Situation Instance. It contains 3 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 3 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SitnInstceMessageParameter view from CONSUMPTION Situation Instance Message Parameter
P_SitnMblInstceAttribute view_entity from COMPOSITE Situation Instance Attr API
P_SitnMblInstceAttribValue view_entity from COMPOSITE Situation Instce Attr Val API

Fields (3)

KeyField CDS FieldsUsed in Views
SitnInstanceID SitnInstceKey 1
SitnMsgParamName SitnInstceAttribName 1
SitnMsgParamSearchVal SitnInstceAttribValue 1 
@AbapCatalog:{
    sqlViewName: 'ISITNMSGPARAM',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
 viewType: #BASIC,
 lifecycle: {
  status: #DEPRECATED
//  sucessor: <name of successor view> 

}}
@ObjectModel:{
    usageType:{
        serviceQuality: #C,
        sizeCategory: #L,
        dataClass: #MIXED
   }
}
@EndUserText.label: 'Message Parameter for Situation Instance'

define view I_SitnInstceMessageParameter
  as select from           sit_msg_param as Param

    left outer to one join sit_msg_ph    as ParamMap
      on  Param.sitndefinitionid = ParamMap.sitndefinitionid
      and Param.sitnmsgparamname = ParamMap.sitnplchldrvalue

  association [0..1] to I_SitnDefinition as _Definition on $projection.SitnDefinitionID = _Definition.SitnDefinitionID

{
  key Param.sitninstanceid        as SitnInstanceID,
  key Param.sitnmsgtextversion    as SitnMsgTextVersion,

  key ParamMap.sitnplchldr        as SitnMsgParamName,

      Param.sitnmsgparameterval   as SitnMsgParamVal,
      Param.sitnmsgparamsearchval as SitnMsgParamSearchVal,
      Param.sitnmsgparamvaltype   as SitnMsgParamType,

      Param.sitndefinitionid      as SitnDefinitionID,

      _Definition
}
where _Definition.SitnDefinitionID is not null

Learn More