I_Sitn2InstceTextAPI

DDL: I_SITN2INSTCETEXTAPI Type: view_entity COMPOSITE Package: CA_SIT2_PUB

Situation Instances - Text

I_Sitn2InstceTextAPI is a Composite CDS View that provides data about "Situation Instances - Text" in SAP S/4HANA. It reads from 1 data source (R_Sitn2RtmeTypeVersMessageText) and exposes 6 fields with key fields SitnAnchorObjectSOT, SitnAnchorObjectSONT, SitnInstceAnchorObjectKey, SitnInstceKey. It is exposed through 1 OData service (C_SITN2DEMOFLIGHTSRV). Part of development package CA_SIT2_PUB.

Data Sources (1)

SourceAliasJoin Type
R_Sitn2RtmeTypeVersMessageText _text from

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Situation Instances - Text view

OData Services (1)

ServiceBindingVersionContractRelease
C_SITN2DEMOFLIGHTSRV C_SITN2DEMOFLIGHTV4 V4 C1 NOT_RELEASED

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SitnAnchorObjectSOT _instance SitnAnchorObjectSOT
KEY SitnAnchorObjectSONT _instance SitnAnchorObjectSONT
KEY SitnInstceAnchorObjectKey _instance SitnInstceAnchorObjectKey
KEY SitnInstceKey _instance SitnInstceKey
SituationTitle R_Sitn2RtmeTypeVersMessageText SituationTitle
SituationText R_Sitn2RtmeTypeVersMessageText SituationText
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@ObjectModel:{
//             dataCategory: #TEXT,

             usageType:{
                          serviceQuality: #C,
                          sizeCategory: #L,
                          dataClass: #MIXED
                        }
             }
@EndUserText.label: 'Situation Instances - Text'
//define view entity I_Sitn2InstceTextAPI

//  as select from R_Sitn2RuntimeTypeText

//{

//  key SitnTypeID,

//  key SitnTypeVersion,

//      @Semantics.language:true

//  key Language,

//  key SitnObjectGroupID,

//  key SitnObjGrpMessageID,

//

//      SituationTitle,

//      SituationText

//}

define view entity I_Sitn2InstceTextAPI
  as select from R_Sitn2RtmeTypeVersMessageText as _text
  join R_Sitn2InstanceAPI as _instance
  on _instance.SitnObjGrpMessageID    = _text.SitnObjGrpMessageID
     and _instance.SitnTypeID         = _text.SitnTypeID
     and _instance.SitnTypeVersion    = _text.SitnTypeVersion
     and _instance.SitnObjectGroupID  = _text.SitnObjectGroupID
  {
  key _instance.SitnAnchorObjectSOT,
  key _instance.SitnAnchorObjectSONT,
  key _instance.SitnInstceAnchorObjectKey, 
  key _instance.SitnInstceKey,
  _text.SituationTitle,
  _text.SituationText
  
  }
  where _text.Language = $session.system_language