P_StatusInfluenceOnBusTran1

@AbapCatalog.sqlViewName: 'PStatInfluOnBT1'
//@EndUserText.label: 'P_StatusInfluenceOnBusTran1'

//@Analytics : { dataExtraction.enabled : true}

@VDM.viewType : #BASIC
@VDM.private : true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_StatusInfluenceOnBusTran1  as 
select from  jest
             join tj07 on tj07.obtyp = ' ' and
                          jest.stat  = tj07.istat  
  {
    key jest.objnr as StatusObject, 
    key tj07.vrgng as BusTransactionType,
    max(modkz)     as BusTransacTypePermission 
  } 
  where stat like 'I%' and inact = ' '  
  group by jest.objnr,
           tj07.vrgng
                      
  union all 
  
  select from jest 
              join jsto on jsto.objnr  = jest.objnr
              join tj31 on jsto.stsma  = tj31.stsma and  
                           jest.stat   = tj31.estat   
  {
    key jest.objnr as StatusObject,
    key tj31.vrgng as BusTransactionType,
    max(modkz)     as BusTransacTypePermission 
  }
  where stat like 'E%' and inact = ' ' 
  group by jest.objnr,
           tj31.vrgng
      
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"JEST",
"JSTO",
"TJ07",
"TJ31"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/