I_ClfnObjectCharcValueBasic

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'INGCCLFN23'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Clfn Obj Characteristic Valuation Basic'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC
define view I_ClfnObjectCharcValueBasic
  as select from ausp as Valuation
{
  key Valuation.objek               as ClfnObjectID,
  key cast ( Valuation.atinn as atinn_no_conv preserving type ) as CharcInternalID,
  key Valuation.atzhl               as CharcValuePositionNumber,
  key Valuation.mafid               as ClfnObjectType,
  key Valuation.klart               as ClassType,
  key Valuation.adzhl               as TimeIntervalNumber,            
      Valuation.atcod               as CharcValueIntervalType,
      Valuation.atcod               as CharcValueDependency,       // deprecated, use CharcValueIntervalType

      Valuation.atwrt               as CharcValue,
      Valuation.atflv               as CharcFromNumericValue,  
      Valuation.atawe               as CharcFromNumericValueUnit,
      Valuation.atflb               as CharcToNumericValue,     
      Valuation.ataw1               as CharcToNumericValueUnit,
      Valuation.dec_value_from      as CharcFromDecimalValue,
      Valuation.dec_value_to        as CharcToDecimalValue,      
      @Semantics.amount.currencyCode: 'Currency'      
      Valuation.curr_value_from     as CharcFromAmount,
      @Semantics.amount.currencyCode: 'Currency'  
      Valuation.curr_value_to       as CharcToAmount,
      Valuation.currency            as Currency,
      Valuation.date_from           as CharcFromDate,
      Valuation.date_to             as CharcToDate,
      Valuation.time_from           as CharcFromTime,
      Valuation.time_to             as CharcToTime, 
      Valuation.ataut               as CharacteristicAuthor,      
      Valuation.aennr               as ChangeNumber,
      Valuation.atsrt               as CharcValueSortPosition,
      Valuation.datuv               as ValidityStartDate,
      Valuation.datub               as ValidityEndDate,
      Valuation.lkenz               as IsDeleted
}