I_CLFNCHARCBASIC

@AbapCatalog.sqlViewName: 'INGCCHR20'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Classification Characteristic Basic'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.supportedCapabilities:
  [  #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,
     #SQL_DATA_SOURCE                  ]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API  
@VDM.viewType: #BASIC
define view I_ClfnCharcBasic
  as select from cabn as Characteristic       
{
    key cast ( Characteristic.atinn as atinn_no_conv preserving type ) as CharcInternalID,
    key Characteristic.adzhl      as TimeIntervalNumber,        
        Characteristic.atnam      as Characteristic,
        Characteristic.atidn      as CharcIdentificationCode,
        Characteristic.atmst      as CharcStatus,
        Characteristic.atfor      as CharcDataType,
        Characteristic.anzst      as CharcLength,
        Characteristic.anzdz      as CharcDecimals,
        Characteristic.atsch      as CharcTemplate,
        Characteristic.atkle      as ValueIsCaseSensitive,
        Characteristic.atkon      as CharcConversionRoutine,
        cast ( Characteristic.atkla as charcgroup preserving type ) as CharcGroup,
        Characteristic.aterf      as EntryRequiredCode,        
        case 
          when Characteristic.atein = '*' then '*'
          when Characteristic.atein = ''  then 'X' 
          when not ( Characteristic.atein = '*' and Characteristic.atein = '' ) then ''
        end as MultipleValuesAllowedCode,          
        Characteristic.unit       as CharcValueUnit,          
        Characteristic.currency   as Currency,    
        Characteristic.atdex      as CharcExponentFormat,
        Characteristic.atdim      as CharcExponentValue,
        Characteristic.atint      as ValueIntervalAllowedCode,
        Characteristic.atson      as AdditionalValueAllowedCode,        
        Characteristic.atvor      as NegativeValueIsAllowed,
        @Semantics.businessDate.from: true
        Characteristic.datuv      as ValidityStartDate,
        @Semantics.businessDate.to: true
        Characteristic.datub      as ValidityEndDate,         
        Characteristic.aennr      as ChangeNumber,
        Characteristic.lkenz      as IsDeleted,
        Characteristic.dokar      as DocumentInfoRecordDocType,
        Characteristic.doknr      as DocumentInfoRecordDocNumber,
        Characteristic.dokvr      as DocumentInfoRecordDocVersion,
        Characteristic.doktl      as DocumentInfoRecordDocPart,
        Characteristic.atauth     as CharcMaintAuthGrp,
        Characteristic.atinp      as CharcReadOnlyCode,
        Characteristic.atvie      as CharcHiddenCode,
        Characteristic.atgla      as CharcRestrictableCode,
        Characteristic.attab      as CharcReferenceTable,
        Characteristic.atfel      as CharcReferenceTableField,
        Characteristic.atprt      as CharcCheckTable,
        Characteristic.atprf      as CharcCheckFunctionModule,
        Characteristic.atfod      as CharcEntryNotFormatCtrldCode,
        Characteristic.atvsc      as CharcTemplateDisplayedCode,
        Characteristic.auswahlmge as CharcSelectedSet,
        Characteristic.werks      as Plant,
        Characteristic.katalogart as CharcCatalogType,
        Characteristic.aname      as CreatedByUser,
        Characteristic.adatu      as CreationDate,
        Characteristic.vname      as LastChangedByUser,
        Characteristic.vdatu      as LastChangeDate,
        Characteristic.lastchangeddatetime as CharcLastChangedDateTime         
}