ACE_ACEPSOH_VIEW

@AbapCatalog.sqlViewName: 'ACEV_ACEPSOH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Compatibility view for ACEPSOH'
define view ACE_ACEPSOH_VIEW
  as select from acesobj 
// comment out by i337033

// no need to do check for firstyear and lastyear

//  left outer join acdoca on acesobj.comp = acdoca.acrobjtype and

//                            acesobj.ref_key = acdoca.acrobj_id and

//                            acesobj.ref_subkey = acdoca.acrsobj_id and

//                            acesobj.bukrs      = acdoca.rbukrs

{
  key acesobj.mandt,
  key acesobj.comp,
  key acesobj.bukrs,
  key acesobj.objid,
  key acesobj.subid,
      acesobj.uname,



      tstmp_to_dats( acesobj.timestmp,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' ) as cpudt,

      tstmp_to_tims( acesobj.timestmp,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' ) as cputm,
      // cast( substring(cast(acesobj.timestmp as char21 ),8,6 ) as ace_createtime )  as CPUTM,


      acesobj.premtre_fdate as deactdate,
      acesobj.ref_subkey,
      acesobj.status,
      cast ('' as ace_firstyear ) as FIRSTYEAR,
      cast ('' as ace_lastyear ) as LASTYEAR
//      min( acdoca.gjahr ) as firstyear,

//

//      max( acdoca.gjahr ) as lastyear

//      acesobj.firstyear,

//      acesobj.lastyear

}group by acesobj.mandt,
          acesobj.comp,
          acesobj.bukrs,
          acesobj.bukrs,
          acesobj.objid,
          acesobj.subid,
          acesobj.uname,
          acesobj.timestmp,
          acesobj.premtre_fdate,
          acesobj.ref_subkey,
          acesobj.status

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACESOBJ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/