R_Sitn2TransportRequestTask

@AbapCatalog.sqlViewName: 'RSITN2TRTASK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC 
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel: {
                usageType:{
                            serviceQuality: #C,
                            sizeCategory: #M,
                            dataClass: #MIXED
                          }
              }
@EndUserText.label: 'Transport Request Task Information'
define view R_Sitn2TransportRequestTask
  as select from           e070  as Transport
    left outer to one join e07t  as TransportText   on  TransportText.trkorr = Transport.trkorr
                                                    and TransportText.langu  = $session.system_language
    inner join             e070c as TransportClient on  TransportClient.trkorr = Transport.trkorr
                                                    and TransportClient.client = $session.client
{

  key       Transport.trkorr      as TransportRequestTaskID,
  key       Transport.as4user     as TransportRequestTaskOwner,
  key       Transport.strkorr     as TransportRequestID,
            TransportText.as4text as TransportRequestTaskDesc,
            // Transport.trfunction  as TransportRequestTaskType,   - as ATC comes for GFN Data Type , if field needed then find appropriate name

            Transport.trstatus    as TransportRequestTaskStatus,
            Transport.tarsystem   as TransportRequestTarget,
            Transport.korrdev     as TransportRequestTaskCategory
}

where
       Transport.trstatus   = 'D' //Modifiable

  and  Transport.as4user    = $session.user
  and(
       Transport.trfunction = 'S' //Development/Correction

    or Transport.trfunction = 'X' //Unclassified

    or Transport.trfunction = 'Q' //Customizing

  )

// we can not select from I_TasksHeader or I_RequestsHeader

//    as select from           I_TasksHeader  as Transport

//

//    inner join             I_RequestsHeader as TransportClient on  TransportClient.TransportRequestID = Transport.TransportRequestID

//                                                    and TransportClient.TransportRequestSourceClient = $session.client

//{

//

//  key       Transport.TransportRequestTaskID          as TransportRequestTaskID,

//  key       Transport.TransportRequestTaskOwner       as TransportRequestTaskOwner,

//  key       Transport.TransportRequestID              as TransportRequestID,

//            Transport.TransportRequestTaskDesc        as TransportRequestTaskDesc,

//            Transport.TransportRequestTaskStatus      as TransportRequestTaskStatus,

//            Transport.TransportRequestTaskTarget      as TransportRequestTarget,

//            Transport.TransportRequestTaskCategory    as TransportRequestTaskCategory

//}

//

//where

//       Transport.TransportRequestTaskStatus   = 'D' //Modifiable

//  and  Transport.TransportRequestTaskOwner    = $session.user

//  and(

//       Transport.TransportRequestTaskType = 'S' //Development/Correction

//    or Transport.TransportRequestTaskType = 'X' //Unclassified

//    or Transport.TransportRequestTaskType = 'Q' //Customizing

//  )


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"E070",
"E070C",
"E07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/