R_OUTPUTREQUESTITEMEMAIL

CDS View

Output Request Item Email for R AP

R_OUTPUTREQUESTITEMEMAIL is a CDS View in S/4HANA. Output Request Item Email for R AP. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_OutputRequestItemEmailTP view_entity from TRANSACTIONAL Output Request Item Email for R AP - TP 
@AbapCatalog: {
  sqlViewName: 'RORITEMEMAILRAP',
  compiler.compareFilter: true
}
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #REQUIRED
}
@ObjectModel: {
   representativeKey: 'OutputRequestItemEmailUUID',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
@ClientHandling: {
     type: #INHERITED,
     algorithm: #SESSION_VARIABLE
}
@Metadata.ignorePropagatedAnnotations: false
@Metadata.allowExtensions: false
@EndUserText.label: 'Output Request Item Email for R AP'

define view R_OutputRequestItemEmail
  as select from apoc_d_or_item_e
  association [1..1] to R_OutputRequest               as _OutputRequest               on  $projection.OutputRequestUUID           = _OutputRequest.OutputRequestUUID
  association [1..1] to R_OutputRequestItem           as _OutputRequestItem           on  $projection.OutputRequestItemUUID       = _OutputRequestItem.OutputRequestItemUUID
  association [0..1] to I_OutputControlApplObjectType as _OutputControlApplObjectType on  $projection.OutputControlApplObjectType = _OutputControlApplObjectType.OutputControlApplObjectType
  association [0..1] to I_OCEmRecRole                 as _EmRecRole                   on  $projection.OutputRequestItemEmailRole  = _EmRecRole.OutputRequestItemEmailRole
{

  key apoc_d_or_item_e.db_key           as OutputRequestItemEmailUUID,
      apoc_d_or_item_e.parent_key       as OutputRequestItemUUID,
      apoc_d_or_item_e.root_key         as OutputRequestUUID,

      apoc_d_or_item_e.appl_object_type as OutputControlApplObjectType,
      apoc_d_or_item_e.appl_object_id   as OutputControlApplicationObject,
      apoc_d_or_item_e.item_id          as OutputRequestItem,      
         
      apoc_d_or_item_e.counter          as OutputRequestItemEmailID,       
      apoc_d_or_item_e.email_role       as OutputRequestItemEmailRole,
      apoc_d_or_item_e.email_uri        as OutputRequestItemEmailAddress,
      apoc_d_or_item_e.email_origin     as OutputRequestItemEmailOrigin,

      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _OutputRequestItem,
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _OutputRequest,
      _OutputControlApplObjectType,
      _EmRecRole
}

Learn More