I_CnsldtnTaskRunStatus

DDL: I_CNSLDTNTASKRUNSTATUS Type: view BASIC

Consolidation Task Run Status

I_CnsldtnTaskRunStatus is a Basic CDS View (Dimension) that provides data about "Consolidation Task Run Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field ConsolidationTaskRunStatus. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dd07l Domain from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CnsldtnTaskRunStatusText _Text $projection.ConsolidationTaskRunStatus = _Text.ConsolidationTaskRunStatus

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName ICSTSKRUNSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey ConsolidationTaskRunStatus view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name ConsolidationTaskRunStatus view
Search.searchable true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Consolidation Task Run Status view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationTaskRunStatus
DomainValue dd07l domvalue_l
_Text _Text
@AbapCatalog:{
  sqlViewName: 'ICSTSKRUNSTS',
  compiler.compareFilter: true,
  preserveKey: true
}
@Analytics: {
  dataCategory: #DIMENSION,
  internalName: #LOCAL,
  dataExtraction.enabled: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata:{
  ignorePropagatedAnnotations: true
}
@ObjectModel:{
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #B,
    sizeCategory: #S},
  resultSet.sizeCategory: #XS,
  representativeKey: 'ConsolidationTaskRunStatus',
  modelingPattern: #ANALYTICAL_DIMENSION,
  supportedCapabilities: [#CDS_MODELING_DATA_SOURCE,
                          #CDS_MODELING_ASSOCIATION_TARGET,
                          #SQL_DATA_SOURCE,
                          #EXTRACTION_DATA_SOURCE,
                          #ANALYTICAL_DIMENSION],
  sapObjectNodeType.name: 'ConsolidationTaskRunStatus'                          
}
@Search.searchable: true
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@EndUserText.label: 'Consolidation Task Run Status'

/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ]  } */
define view I_CnsldtnTaskRunStatus as 
  select from dd07l as Domain

    association [0..*] to I_CnsldtnTaskRunStatusText as _Text on $projection.ConsolidationTaskRunStatus = _Text.ConsolidationTaskRunStatus
{
      @ObjectModel.text.association: '_Text'
  key cast( left( Domain.domvalue_l,2 ) as fincs_taskrun_status preserving type )     as ConsolidationTaskRunStatus,
      
      @Consumption.hidden: true
      @Analytics.hidden: true
      @Search: {
        defaultSearchElement: true,
        ranking: #HIGH,
        fuzzinessThreshold: 0.8
      }
      Domain.domvalue_l                                                               as DomainValue,
      
      _Text
}
 where 
      Domain.domname = 'FC_STATUS'
  and Domain.as4local = 'A';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_CNSLDTNTASKRUNSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/