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

{

  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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"APOC_D_OR_ITEM_E"
],
"ASSOCIATED":
[
"I_OUTPUTCONTROLAPPLOBJECTTYPE",
"R_OUTPUTREQUEST",
"R_OUTPUTREQUESTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More