R_OUTPUTREQUEST

CDS View

Output Request Root for RAP

R_OUTPUTREQUEST is a CDS View in S/4HANA. Output Request Root for RAP. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_REOutputRequestBasic view_entity from BASIC Real Estate Output Requests Basic
R_OutputRequestTP view_entity from TRANSACTIONAL Output Request Root for RAP
@AbapCatalog: {
  sqlViewName: 'ROUTREQ',
  compiler.compareFilter: true,
  preserveKey: true
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   representativeKey: 'OutputRequestUUID',
   compositionRoot: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   }
}
@ClientHandling: {
     type: #INHERITED,
     algorithm: #SESSION_VARIABLE
}
//@Metadata.ignorePropagatedAnnotations: false

@Metadata.allowExtensions:false
@EndUserText.label: 'Output Request Root for RAP'

define view R_OutputRequest
  as select from apoc_d_or_root
  association [0..*] to R_OutputRequestItem as _OutputRequestItem on  $projection.OutputControlApplicationObject = _OutputRequestItem.OutputControlApplicationObject
                                                                  and $projection.OutputControlApplObjectType    = _OutputRequestItem.OutputControlApplObjectType
{
      //apoc_d_or_root

  key db_key           as OutputRequestUUID,
      appl_object_type as OutputControlApplObjectType,
      appl_object_id   as OutputControlApplicationObject,
      output_parameter as OutputParameterText,
      crea_date_time   as CreationDateTime,
      crea_ident_uuid  as CreatedByUser,
      lchg_date_time   as LastChangeDateTime,
      lchg_ident_uuid  as LastChangedByUser,
      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _OutputRequestItem
}