I_PubSecCmtmtAgingBasic

@AbapCatalog.sqlViewName: 'ICMTMTAGINGBASIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'commitment aging basic view'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel: {
     usageType: {
         dataClass: #MIXED,
         serviceQuality: #D,
         sizeCategory: #XXL
     }
}


define view I_PubSecCmtmtAgingBasic
  as select from P_ACDOCA as main
{
  key cast( main.src_awtyp as fins_src_awtyp )                                          as SourceReferenceDocumentType,
  key cast( main.src_awref as fins_src_awref preserving type )                          as SourceReferenceDocument,
  key cast( main.src_awitem as fins_src_awitem )                                        as SourceReferenceDocumentItem,
      cast( min( main.bdgt_cnsmpn_date ) as psm_open_cmtmt_aging_date preserving type ) as PubSecOpenCmtmtAgingDate,
      sum(main.tsl)                                                                     as PubSecOpnCmtmtAmtInTransCrcy
}
where
       main.rldnr         = '0E'
  and  main.xcommitment   = 'X'
  and  main.bdgt_relevant = 'X'
  and(
       main.src_awtyp     = 'PORD'
    or main.src_awtyp     = 'PREQ'
    or main.src_awtyp     = 'FMRES'
  )
group by
  main.src_awtyp,
  main.src_awref,
  main.src_awitem
having
  sum(
    main.tsl
  ) <> 0