I_SitnDefCondition

DDL: I_SITNDEFCONDITION Type: view BASIC

Situation Condition

I_SitnDefCondition is a Basic CDS View that provides data about "Situation Condition" in SAP S/4HANA. It reads from 1 data source (sit_cond) and exposes 5 fields with key field SitnDefinitionID. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
sit_cond Condition from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISITNCONDITION 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
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Situation Condition view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SitnDefinitionID sit_cond sitndefinitionid
SitnTriggerObjectView sit_cond sitntriggerobjectview
SitnTriggerObjectKeyField sit_cond sitntriggerobject
SitnDefTriggerType sit_cond sitndeftriggertype
_Definition _Definition 
@AbapCatalog:{
    sqlViewName: 'ISITNCONDITION',
    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
                           }          
              }  
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Situation Condition'

define view I_SitnDefCondition as select from sit_cond as Condition
association [1..1] to I_SitnDefinition as _Definition on $projection.SitnDefinitionID = _Definition.SitnDefinitionID
{

    key Condition.sitndefinitionid          as SitnDefinitionID         , 
//        Condition.sitncndnfunctionid        as SitnCndnFunctionID       , 

        Condition.sitntriggerobjectview     as SitnTriggerObjectView    , 
        Condition.sitntriggerobject         as SitnTriggerObjectKeyField,   // SitnTriggerObject was replaced with SitnTriggerObjectKeyField              

        Condition.sitndeftriggertype        as SitnDefTriggerType       ,
        _Definition
}
//union all select from sit_t_cond as ConditionTemplate

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

//{

//    key $session.client                             as Mandt                    ,

//    key ConditionTemplate.sitndefinitionid          as SitnDefinitionID         , 

//        ConditionTemplate.sitncndnfunctionid        as SitnCndnFunctionID       , 

//        ConditionTemplate.sitntriggerobjectview     as SitnTriggerObjectView    , 

//        ConditionTemplate.sitntriggerobject         as SitnTriggerObject        ,

//        _Definition

//   }

Learn More