I_SitnDefinitionText

DDL: I_SITNDEFINITIONTEXT Type: view BASIC

Situation Type Details

I_SitnDefinitionText is a Basic CDS View that provides data about "Situation Type Details" in SAP S/4HANA. It reads from 1 data source (sit_def_t) and exposes 10 fields with key fields SitnDefinitionID, SitnDefLongTextVersion, Language. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
sit_def_t DefinitionText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SitnDefinition _Definition $projection.SitnDefinitionID = _Definition.SitnDefinitionID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISITNDEFTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.lifecycle.status #DEPRECATED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey SitnDefinitionID view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Situation Type Details view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SitnDefinitionID sit_def_t sitndefinitionid
KEY SitnDefLongTextVersion sit_def_t sitndeflongtextversion
KEY Language sit_def_t language
SitnDefName sit_def_t sitndefname
SitnDefShortText sit_def_t sitndefshorttext
SitnDefLongText sit_def_t sitndeflongtext
SitnCndnDescription sit_def_t sitncndndescription
SitnDefDetailsLinkText sit_def_t sitndefdetailslinktext
SitnDefDetailsLink sit_def_t sitndefdetailslink
_Definition _Definition 
@AbapCatalog:{
    sqlViewName: 'ISITNDEFTEXT',
    compiler.compareFilter: true,
    preserveKey:true 
}

@AccessControl.authorizationCheck: #CHECK
@VDM: {
 viewType: #BASIC, 
 lifecycle: {
  status: #DEPRECATED
// successor: <name of successor view>

}}
@ObjectModel:{
                usageType:{
                            serviceQuality: #C,
                            sizeCategory: #M,
                            dataClass: #MIXED
                           }, 
                semanticKey:  [ 'SitnDefinitionID' ],
                dataCategory: #TEXT,
                representativeKey: 'SitnDefinitionID'
              }  
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Situation Type Details'
define view I_SitnDefinitionText as select from sit_def_t as DefinitionText 
association [1..1] to I_SitnDefinition          as _Definition     on $projection.SitnDefinitionID = _Definition.SitnDefinitionID
{ 
    key DefinitionText.sitndefinitionid         as SitnDefinitionID, 
    key DefinitionText.sitndeflongtextversion   as SitnDefLongTextVersion, 
    key DefinitionText.language                 as Language,
        DefinitionText.sitndefname              as SitnDefName, 
        DefinitionText.sitndefshorttext         as SitnDefShortText, 
        DefinitionText.sitndeflongtext          as SitnDefLongText,
        DefinitionText.sitncndndescription      as SitnCndnDescription,
        DefinitionText.sitndefdetailslinktext   as SitnDefDetailsLinkText,
        DefinitionText.sitndefdetailslink       as SitnDefDetailsLink,
       _Definition    
}
// union select from sit_t_def_t as DefTextTemplate

// association [1..1] to I_SitnDefUnion as _Definition on $projection.SitnDefinitionID = _Definition.SitnDefinitionID

// {

//    key $session.client                         as Mandt            ,

//    key DefTextTemplate.sitndefinitionid        as SitnDefinitionID , 

//    key DefTextTemplate.language                as Language         , 

//        DefTextTemplate.sitndefname             as SitnDefName      , 

//        DefTextTemplate.sitndefshorttext        as SitnDefShortText , 

//        DefTextTemplate.sitndeflongtext         as SitnDefLongText  ,

//        DefTextTemplate.sitncndndescription     as SitnCndnDescription,    

//        cast ('                                                                                                    ' as sit_de_def_linktext preserving type )  as SitnDefDetailsLinkText,       

//        cast ('                                                                                                                                    ' as url preserving type )  as SitnDefDetailsLink,        

//       _Definition

//} 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SIT_DEF_T"
],
"ASSOCIATED":
[
"I_SITNDEFINITION"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More