I_RECORDEDCONTENTREQUESTS

CDS View

Requests: Content Recorded Customizing and Workbench

I_RECORDEDCONTENTREQUESTS is a CDS View in S/4HANA. Requests: Content Recorded Customizing and Workbench. It contains 10 fields.

10 fields

Fields (10)

KeyField CDS FieldsUsed in Views
KEY TransportRequestID TransportRequestID 1
TransportRequestCategory TransportRequestCategory 1
TransportRequestChangedAt TransportRequestChangedAt 1
TransportRequestChangedOn TransportRequestChangedOn 1
TransportRequestDesc TransportRequestDesc 1
TransportRequestOwner TransportRequestOwner 1
TransportRequestSourceClient TransportRequestSourceClient 1
TransportRequestStatus TransportRequestStatusOld 1
TransportRequestTarget TransportRequestTarget 1
TransportRequestType TransportRequestType 1 
@AbapCatalog.sqlViewName: 'IREC_REQUEST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Requests: Content Recorded Customizing and Workbench'
define view I_RecordedContentRequests
  as select distinct from  I_RequestsHeader     as RequestHeader
        inner join   I_RequestsAttributes as RequestAttribute on RequestHeader.TransportRequestID             = RequestAttribute.TransportRequestID
                                                             and(
                                                               RequestAttribute.TransportRequestAttribute    = 'SAP_CUS_TRANSPORT_CATEGORY' //IF_ATO_TRANSPORT_TYPE_CONSTANT=>cv_cus_transport_category

                                                               or RequestAttribute.TransportRequestAttribute = 'SAP_ATO_TRANSPORT_TYPE'
                                                             )                                                                              //IF_ATO_TRANSPORT_TYPE_CONSTANT=>cv_transport_attribute

    left outer join bctools_cust         as Customizing      on id = 'BCFG_TRANSPORT_API' // IF_BCTOOLS_FEATURE_CONTROL=>BCFG_TRANSPORT_API

{
  key RequestHeader.TransportRequestID,
      RequestHeader.ABAPSourceSystem,
      RequestHeader.TransportRequestSourceClient,
      RequestHeader.TransportRequestType,
      RequestHeader.TransportRequestStatus,
      RequestHeader.TransportRequestTarget,
      RequestHeader.TransportRequestCategory,
      RequestHeader.TransportRequestOwner,
      RequestHeader.TransportRequestChangedOn,
      RequestHeader.TransportRequestChangedAt,
      RequestHeader.TransportRequestDesc,
      case Customizing.value when 'ABAP_CP' then 'X' // IF_BCTOOLS_FEATURE_CONTROL=>MC_VALUES-ABAP_CP

      else '' end as NoProjectDetails
//      RequestAttribute.TransportRequestAttribute,

//      RequestAttribute.TransportRequestAttributeValue

}
where
       RequestHeader.TransportRequestSourceClient      = $session.client
  and(
       RequestHeader.TransportRequestType              = 'W' // Customizing Requests

    or RequestHeader.TransportRequestType              = 'K' // Workbench Requests

  )
  and(
       RequestAttribute.TransportRequestAttributeValue = 'DEFAULT_CUST' //IF_ATO_TRANSPORT_TYPE_CONSTANT=>CS_CUS_TRANSPORT_CATEGORY_VALUE-default_customizing

    or RequestAttribute.TransportRequestAttributeValue = 'MANUAL_CUST'  //IF_ATO_TRANSPORT_TYPE_CONSTANT=>CS_CUS_TRANSPORT_CATEGORY_VALUE-manual_customizing

    or RequestAttribute.TransportRequestAttributeValue = 'DEFAULT_CUSY' //IF_ATO_TRANSPORT_TYPE_CONSTANT=>CS_CUS_TRANSPORT_CATEGORY_VALUE-default_crossclnt_customizing

    or RequestAttribute.TransportRequestAttributeValue = 'MANUAL_CUSY'  //IF_ATO_TRANSPORT_TYPE_CONSTANT=>CS_CUS_TRANSPORT_CATEGORY_VALUE-manual_crossclient_customizing

    or RequestAttribute.TransportRequestAttributeValue = 'CBC'          //IF_ATO_TRANSPORT_TYPE_CONSTANT=>CS_TRANSPORT_ATTRIBUTE_VALUE-CBC

    or RequestAttribute.TransportRequestAttributeValue = 'BC'           //IF_ATO_TRANSPORT_TYPE_CONSTANT=>CS_TRANSPORT_ATTRIBUTE_VALUE-BC

    or RequestAttribute.TransportRequestAttributeValue = 'CCC'          //IF_ATO_TRANSPORT_TYPE_CONSTANT=>CS_TRANSPORT_ATTRIBUTE_VALUE-CCC

  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REQUESTSATTRIBUTES",
"I_REQUESTSHEADER",
"BCTOOLS_CUST",
"T000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More