P_AU_STRPTPARSERVICETYPE

@AbapCatalog.sqlViewName: 'PAUSRTPARSTYP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_AU_StrpTPARServiceType
  as select from           I_AU_StRpTPARServiceType      as StRpTPARServiceType
    left outer to one join I_AU_StRpTPARGrantsConfignObj as StRpTPARGrantsConfignObj on StRpTPARServiceType.CompanyCode = StRpTPARGrantsConfignObj.CompanyCode
    left outer to one join I_WBSElementBasicData         as WBSElementBasicData      on  StRpTPARServiceType.AU_TPARGrantObject                = WBSElementBasicData.WBSElementExternalID
                                                                                     and StRpTPARServiceType.AU_TPARServiceType                = 'G'
                                                                                     and StRpTPARGrantsConfignObj.AU_TPARGrantHasConfignObject = 'W'

{
  key  StRpTPARServiceType.CompanyCode,
  key  FromGLAccount,
  key  ToGLAccount,
  key  cast ( WBSElementBasicData.WBSElementInternalID as fiau_tpar_grant_object ) as WBSElementInternalIDCharFormat,
       AU_TPARGrantObject,
       AU_TPARServiceType,
       AU_TPARGrantHasConfignObject,
       AU_TPARGrantName
}