P_RespyMOpenWrkbnTransptReq

DDL: P_RESPYMOPENWRKBNTRANSPTREQ SQL: PRSMOPNWBTR Type: view BASIC

P_RespyMOpenWrkbnTransptReq is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (e070c, e070) and exposes 6 fields.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
e070c _Client inner
e070 _Task from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PRSMOPNWBTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
as4user e070 as4user
trfunction e070 trfunction
trstatus e070 trstatus
ABAPTransportTask e070 trkorr
ABAPTransportRequest e070 strkorr
ABAPTransportRequestDesc _Text as4text 
@AbapCatalog.sqlViewName: 'PRSMOPNWBTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
                usageType:{
                            serviceQuality: #C,
                            sizeCategory: #M,
                            dataClass: #MIXED
                          }
                          }
//@EndUserText.label: 'Responsibility Management Open Workbench Transport Requests'

define view P_RespyMOpenWrkbnTransptReq
  as select from           e070  as _Task
    left outer to one join e07t  as _Text   on  _Text.trkorr = _Task.trkorr
                                            and _Text.langu  = $session.system_language
    inner join             e070c as _Client on  _Client.client = $session.client
                                            and _Client.trkorr = _Task.trkorr
{
  _Task.as4user,
  _Task.trfunction,
  _Task.trstatus,
  _Task.trkorr  as ABAPTransportTask,
  _Task.strkorr as ABAPTransportRequest,
  _Text.as4text as ABAPTransportRequestDesc
}
where
     _Task.trfunction = 'K'
  or _Task.trfunction = 'R'
  or _Task.trfunction = 'S'
  or _Task.trfunction = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"E070",
"E070C",
"E07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More