C_ProjDemandActivityTypeVH

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true


@EndUserText.label: 'Activity Type Demand for Work'
@AbapCatalog: {
    sqlViewName: 'CPRJDMNDACTVH',

    dataMaintenance: #RESTRICTED

}

@VDM: {
    viewType: #CONSUMPTION
//    lifecycle.contract.type: #SAP_INTERNAL_API

}

@AccessControl: {
    authorizationCheck:     #NOT_REQUIRED,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   semanticKey:       [ 'CostCtrActivityTypeDesc' ],
   representativeKey: 'CostCtrActivityType',
   dataCategory: #VALUE_HELP,
   usageType: {
     serviceQuality:  #B,
     dataClass:       #MIXED,
     sizeCategory:    #L
    }
}

@UI.headerInfo: {
  typeName:         'Activitytype',
  typeNamePlural:   'Activitytypes'
}

@Search.searchable: true
@Consumption.ranked 
define view C_ProjDemandActivityTypeVH

  as select from I_CostCenterActivityType as ActivityType 
            inner join I_UnitOfMeasure as UOM on ( ActivityType.CostCtrActivityTypeQtyUnit = UOM.UnitOfMeasureISOCode or ActivityType.CostCtrActivityTypeQtyUnit = UOM.UnitOfMeasureSAPCode )  
                                              and UOM.UnitOfMeasureDimension = 'TIME' 
                                              and UOM.SIUnitCnvrsnRateNumerator = 3600

{

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @EndUserText.label: 'Activity Type'
      @UI: {
        lineItem:       [{ position: 10, importance: #HIGH }]
      }    
      @ObjectModel: {
        readOnly: false,
        mandatory: true,
        text: { element: [ 'CostCtrActivityTypeDesc' ] } }
      @UI.textArrangement: #TEXT_FIRST
  key ActivityType.CostCtrActivityType,
  
  
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @EndUserText.label: 'Validity End Date'
      @UI: {
        lineItem:       [{ position: 60, importance: #HIGH }]
      }

  key ActivityType.ValidityEndDate,
  
      @UI.hidden: true
  key ActivityType.ControllingArea,
  

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @EndUserText.label: 'Activity Type Description'
      @UI: {
        lineItem:       [{ position: 20, importance: #HIGH }]
      }
      @Semantics.text: true
      ActivityType._Text[1:Language=$session.system_language].CostCtrActivityTypeDesc,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @EndUserText.label: 'Activity Type Unit'
      @UI: {
        lineItem:       [{ position: 30, importance: #HIGH }]
      }
      ActivityType.CostCtrActivityTypeQtyUnit,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @EndUserText.label: 'Cost Center Category'
      @UI: {
        lineItem:       [{ position: 40, importance: #HIGH }]
      }
      ActivityType.CostCtrActivityTypeCategory as CostCtrActivityTypeCategory,
      
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @EndUserText.label: 'Validity Start Date'
      @UI: {
        lineItem:       [{ position: 50, importance: #HIGH }]
      }

      ActivityType.ValidityStartDate,

      @Consumption.filter.hidden: true
      ActivityType._CostCtrActivityTypeCategory,
      
      @Consumption.filter.hidden: true
      ActivityType._ControllingArea
      

     

}

  
            
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTCENTERACTIVITYTYPE",
"I_COSTCENTERACTIVITYTYPETEXT",
"I_UNITOFMEASURE"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_COSTCENTERACTIVITYTYPECAT"
],
"BASE":
[
"I_COSTCENTERACTIVITYTYPE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/