I_SITNDEFDOMAINVALUETEXT

CDS View

Fixed Domain Values - Text

I_SITNDEFDOMAINVALUETEXT is a CDS View in S/4HANA. Fixed Domain Values - Text. It contains 2 fields. 47 CDS views read from this table.

Used by 47 CDS view(s) 2 fields

CDS Views using this table (47)

ViewTypeJoinVDMDescription
C_Sitn2ABAPLanguageVersionVH view from CONSUMPTION Abap Language Version
C_Sitn2ActionTypeVH view from CONSUMPTION Action Type
C_Sitn2ActnParamSourceVH view from CONSUMPTION Source of Action Parameter
C_Sitn2ActnParamValueTypeVH view from CONSUMPTION Type of Action Parameter Value
C_Sitn2BaseTmplObjStrucTypeVH view from CONSUMPTION Object Structure Type for Sitn Scenario
C_Sitn2BaseTmplTrggrObjBehvrVH view from CONSUMPTION Trigger Object Behavior for Sitn Scenario
C_Sitn2BaseTmplTypeVH view from CONSUMPTION Situation Scenario Type
C_Sitn2DefBatchRepeatTypeVH view from CONSUMPTION Batch Repeat Type
C_Sitn2DefBatchReptIntervalVH view from CONSUMPTION Repeat Interval for Batch Scheduling
C_Sitn2DefDataCntxtEnabledVH view_entity from CONSUMPTION Data Context Enabled
C_Sitn2DefEnabledVH view from CONSUMPTION Value Help for Definition Status
C_Sitn2DefInstceClsBehaviorVH view from CONSUMPTION Instance Closing Behavior
C_Sitn2DefMntrInstceEnabledVH view from CONSUMPTION Monitor Instance Enabled
C_Sitn2DefNotifAggrgnTypeVH view from CONSUMPTION Notification Aggregation Type
C_Sitn2DefObjGrpLfcycTypeVH view from CONSUMPTION Life Cycle Type
C_Sitn2DefRecmdnEnabledVH view_entity from CONSUMPTION Recommendation Enabled
C_Sitn2DefTrggrAccmlnEnabledVH view from CONSUMPTION Trigger Accumulation Enabled
C_Sitn2DefTypeVH view from CONSUMPTION Situation Definition Type
C_Sitn2EventCategoryVH view_entity from CONSUMPTION Situation Event Category
C_Sitn2ExtensibleVH view_entity from CONSUMPTION Situation Extensible
C_Sitn2InstceActivityVH view from CONSUMPTION Instance Activity
C_Sitn2InstceCurrentStatusVH view from CONSUMPTION Current Status
C_Sitn2InstceLfcycActivityVH view from CONSUMPTION Life Cycle Activity of Instance
C_Sitn2InstceNotifRecipientVH view from CONSUMPTION Notification Recipient
C_Sitn2InstceTargetStatusVH view from CONSUMPTION Target Status
C_Sitn2MappingOperatorVH view from CONSUMPTION Mapping Operators
C_Sitn2NavgnParamSourceVH view from CONSUMPTION Source of Navigation Parameter
C_Sitn2NavgnParamValueTypeVH view from CONSUMPTION Type of Navigation Parameter Value
C_Sitn2NavgnTypeVH view from CONSUMPTION Type of Navigation
C_Sitn2ObjPageSecMappingTypeVH view from CONSUMPTION Mapping type of Object Page Section
C_Sitn2ObjStrucPrsnlDtaLevelVH view_entity from CONSUMPTION Personal Data Level of Object Structure
C_Sitn2ObjStructureTypeVH view_entity from CONSUMPTION Situation Object Structure Type
C_Sitn2ObjTypeVH view from CONSUMPTION Object Types
C_Sitn2PageColumnTypeVH view from CONSUMPTION Type of Situation Page Column
C_Sitn2PageTypeVH view from CONSUMPTION Type of Situation Page
C_Sitn2ReusableVH view_entity from CONSUMPTION Situation Reusable
C_Sitn2ScopeVH view_entity from CONSUMPTION Situation Scope
C_Sitn2TemplateScopeVH view from CONSUMPTION Situation Template Scope
C_Sitn2TriggerTypeVH view from CONSUMPTION Trigger Types In Situations
C_Sitn2ValHelpSrvcPathTypeVH view_entity from CONSUMPTION Sitn Filter Help Service Path Type
C_Sitn2ValHelpSrvcProtclVersVH view_entity from CONSUMPTION Sitn Filter Help Service Protcl Version
C_Sitn2ValueHelpTypeVH view_entity from CONSUMPTION Situation Filter Help Type
C_SitnCndnInstceStatusVH view from CONSUMPTION Situation Condition Instance Status
C_SitnDefEnabledVH view from CONSUMPTION Value Help for Situation Definition Status
C_SitnDefRankVH view from CONSUMPTION Situation Rank Value Help
C_SitnInstceCurrentStatusVH view from CONSUMPTION Situation Instance Status
C_SitnInstceStatusVH view from CONSUMPTION Situation Instance Status

Fields (2)

KeyField CDS FieldsUsed in Views
KEY DomainText SituationInstanceStatusDesc 3
KEY DomainValue SitnInstceStatus 3 
@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    =  'SIT2_DO_DATA_CTX_ENABLED'
    or    domname    =  'SIT2_DO_RECOMM_ENABLED'
    or    domname    =  'ABAP_LANGUAGE_VERSION'
    or    domname    =  'SIT2_DO_OBJ_STR_P_DTA_LVL'

  )

Learn More