I_SitnDefDomainValueText

@AbapCatalog.sqlViewName: 'ISITDEFDOMVALTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.viewType: #COMPOSITE
@ObjectModel:{
                representativeKey:  'DomainValue',
                dataCategory:       #TEXT,
                usageType:{
                            serviceQuality: #C,
                            sizeCategory: #M,
                            dataClass: #MIXED
                           }
             }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Fixed Domain Values - Text'
define view I_SitnDefDomainValueText
  as select from dd07t
{
      //  @ObjectModel.foreignKey.association: '_Domain'

  key domname    as SAPDataDictionaryDomain,
  key domvalue_l as DomainValue,

      @Semantics.language: true
  key ddlanguage as Language,
      @Semantics.text: true
      ddtext     as DomainText
}
where
          as4local   =  'A'
  and     ddlanguage = $session.system_language
  and(
          domname    =  'SIT_DO_DEF_RANK'
    or    domname    =  'SIT_DO_INST_STAT'
    or    domname    =  'SIT_DO_ACTIV_TYPE'
    or    domname    =  'SWFECLSTYP'
    or    domname    =  'SIT_DO_ACTIV_TRIGGER'
    or    domname    =  'SIT_DO_DEF_ENABLED'
    or    domname    =  'SIT2_DO_ST_ENABLED'
    or    domname    =  'SIT_DO_DEF_TYPE'
    or    domname    =  'SIT2_DO_SCOPE'
    or    domname    =  'SIT2_DO_NOTIF_AGGREGATION_TYPE'
    or    domname    =  'SIT2_DO_ST_BATCH_REPEAT_TYPE'
    or    domname    =  'SIT2_DO_ST_BATCH_REPEAT_INTVL'
    or    domname    =  'SIT2_DO_TRIGGER_ACCMLN_ENABLED'
    or    domname    =  'SIT2_DO_INST_CLOSE_BEHAVIOR'
    or    domname    =  'SIT2_DO_LFCYC_TYPE'
    or(
          domname    =  'SIT2_DO_INSTCE_ACTIVITY'
      and domvalue_l <> '02'
      and domvalue_l <> '00'
    )
    or    domname    =  'SIT2_DO_NOTIF_RECIPIENT'
    or(
          domname    =  'SIT2_DO_INST_STAT'
      and domvalue_l <> '06'
    )
    or(
          domname    =  'SIT2_DO_INST_TARGET_STAT'
      and domvalue_l <> '03'
    )
    or    domname    =  'SIT2_DO_ACTION_TYPE'
    or    domname    =  'SIT2_DO_TRIG_OBJ_BEHVR'
    or    domname    =  'SIT2_DO_REUSABLE'
    or    domname    =  'SIT2_DO_EXTENSIBLE'
    or    domname    =  'SIT2_DO_OBJ_STRUC_TYPE'
    or    domname    =  'SIT2_DO_VH_SRV_PROTOCOL_VERS'
    or    domname    =  'SIT2_DO_VH_SRV_PATH_TYPE'
    or    domname    =  'SIT2_DO_VH_TYPE'
    or    domname    =  'SIT2_DO_BT_TYPE'
    or    domname    =  'SIT2_DO_OBJ_STRUC_TYPE'
    or    domname    =  'SIT2_DO_TRIGGER_TYPE'
    or    domname    =  'SIT2_DO_OBJECT_TYPE'
    or    domname    =  'DDOPTION'
    or    domname    =  'SIT2_DO_ACTION_PARAM_TYPE'
    or    domname    =  'SIT2_DO_ACTION_PARAM_SOURCE'
    or    domname    =  'SIT2_DO_NAVIGATION_TYPE'
    or    domname    =  'SIT2_DO_NAVGN_PARAM_VALUE_TYPE'
    or    domname    =  'SIT2_DO_NAVGN_PARAM_SOURCE'
    or    domname    =  'SIT2_DO_PG_TYPE'
    or    domname    =  'SIT2_DO_PG_COLM_TYPE'
    or    domname    =  'SIT2_DO_PG_SEC_MAP_TYPE'
    or    domname    =  'BOOLE'
    or    domname    =  'SIT2_DO_MON_INST_ENABLED'
    or    domname    =  'ABAP_LANGUAGE_VERSION'

  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/