I_CaseAttributes

@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@AbapCatalog.sqlViewName: 'ICASEATTR'
@EndUserText.label: 'Case Attributes'
@VDM.viewType: #COMPOSITE
//@VDM.private: false

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ObjectModel.representativeKey: 'CaseUUID'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, 
                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                     #ANALYTICAL_DIMENSION,
                                     #EXTRACTION_DATA_SOURCE ]
define view I_CaseAttributes
  //  as select from    scmg_t_case_attr

  //    left outer join P_BusinessUser on scmg_t_case_attr.processor = P_BusinessUser.UserID

  as select from I_CaseAttribute
  association [0..1] to I_User as _User on $projection.CaseProcessor = _User.UserID
{
  key CaseUniqueID                     as CaseUUID,
      CaseID,
      CaseProcessor,
      _User.UserDescription            as DisputeCaseProcessorFullName,
      cast( CaseCreatedOn as char17 )  as CreationDateTime, //CAST needed because of existing conversion exit

      cast( CaseClosedTime as char17 ) as CloseDateTime, //CAST needed because of existing conversion exit

      // incompatible change:

      //      cast( CaseCreatedOn as fincs_timestamp preserving type )  as CreationDateTime, //CAST needed because of existing conversion exit

      //      cast( CaseClosedTime as fincs_timestamp preserving type ) as CloseDateTime, //CAST needed because of existing conversion exit


      CaseReason,
      CaseType,
      CaseStatusProfile                as CaseStatusProfile,
      CaseStatus                       as CaseProcessingStatus,
      CasePriority                     as DisputeCasePriority
}