I_FinSubstnValdtnTranspTask

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'FIN Substitution Validation Transp Task'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_FinSubstnValdtnTranspTask as
select from e070 as task
    right outer join      e071            on  task.trkorr = e071.trkorr
                                          and e071.pgmid  = 'R3TR'
                                          and e071.object = 'SVRL'
    inner join            fin_re_rule     on e071.obj_name = fin_re_rule.finsubstitutionvalidationrule and fin_re_rule.isactive = 'X' //Ensure Rule exists and wasn't deleted

    inner join            e070 as request on request.trkorr = task.strkorr
{
  key task.trkorr as TransportRequestID,
   task.as4user as TransportRequestTaskOwner,
   cast(  e071.obj_name as fin_re_rule_id) as FinSubstitutionValidationRule
}
where
       task.trkorr        is not null
  and  request.trfunction = 'W' //TR_TYPE_CUSTOMIZING_REQUEST

  and(
       request.trstatus   = 'D' //TR_STATUS_MODIFIABLE

    or request.trstatus   = 'L' //TR_STATUS_MODIFIABLE_PROTECTED

  )
  and(
       task.trstatus   = 'D' //TR_STATUS_MODIFIABLE

    or task.trstatus   = 'L' //TR_STATUS_MODIFIABLE_PROTECTED

  )


/* select 
 
from
  I_CustomizingTaskObjects as _custTransportObj
   inner join  I_CustomizingTasks as _custTrans
       on _custTransportObj.TransportRequestTaskID = _custTrans.TransportRequestTaskID
      and _custTransportObj.TransportRequestID     = _custTrans.TransportRequestID
      and _custTrans.TransportRequestTaskStatus = 'D'
    {
    cast( _custTransportObj.TransportRequestObjectName as fin_re_rule_id) as FinSubstitutionValidationRule, 
     _custTrans.TransportRequestTaskOwner,
     _custTransportObj.TransportRequestID
    } 
    
    where     _custTransportObj.TransportRequestID is not initial
    and _custTransportObj.TransportRequestObjectPgmID = 'R3TR'
    and _custTransportObj.TransportRequestObjectType = 'SVRL'
*/
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"E070",
"E071",
"FIN_RE_RULE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/