R_OutputRequestItemTP

DDL: R_OUTPUTREQUESTITEMTP Type: view_entity TRANSACTIONAL Package: RAP_CA_OC_OR

Output Request Item for RAP

R_OutputRequestItemTP is a Transactional CDS View that provides data about "Output Request Item for RAP" in SAP S/4HANA. It reads from 1 data source (R_OutputRequestItem) and exposes 64 fields with key field OutputRequestItemUUID. It has 16 associations to related views. Part of development package RAP_CA_OC_OR.

Data Sources (1)

SourceAliasJoin Type
R_OutputRequestItem R_OutputRequestItem from

Associations (16)

CardinalityTargetAliasCondition
[0..1] I_OutputRequestItemBinaryData _OutputReqBinaryDataStandard _OutputReqBinaryDataStandard.OutputRequestItemBinaryDataID = ''
[0..1] I_OutputSenderOrgCenterType _OutputSenderOrgType $projection.SenderOrganizationalCenterType = _OutputSenderOrgType.SenderOrganizationalCenterType
[0..1] I_OutputSenderOrgUnitType _OutputSenderOrgUnitType $projection.SenderOrganizationalUnitType = _OutputSenderOrgUnitType.SenderOrganizationalUnitType
[0..1] I_OutpReqItmPqVH _PrintQueueVH $projection.PrintQueue = _PrintQueueVH.PrintQueue
[0..1] C_OQ_QUEUE_VH _OutputQueueVH $projection.OutputQueue = _OutputQueueVH.Qname
[0..1] I_OCFormTemplate _FormTemplate $projection.OutputControlApplObjectType = _FormTemplate.OutputControlApplObjectType and $projection.OutputDocumentType = _FormTemplate.OutputDocumentType and $projection.FormTemplateType = _FormTemplate.FormType and $projection.FormTemplate = _FormTemplate.FormTemplate
[0..1] I_OCEmailTemplate _EmailTemplate $projection.OutputControlApplObjectType = _EmailTemplate.OutputControlApplObjectType and $projection.OutputDocumentType = _EmailTemplate.OutputDocumentType and $projection.EmailTemplate = _EmailTemplate.EmailTemplate
[0..1] I_Country _SenderCountry $projection.SenderCountry = _SenderCountry.Country
[0..1] I_Country _FormTemplateCountry $projection.FormTemplateCountry = _FormTemplateCountry.Country
[0..1] I_Language _FormTemplateLanguage $projection.FormTemplateLanguage = _FormTemplateLanguage.Language
[0..*] R_OutputRequestItemEmailTP _OutputRequestItemEmailTo $projection.OutputRequestItemUUID = _OutputRequestItemEmailTo.OutputRequestItemUUID and _OutputRequestItemEmailTo.OutputRequestItemEmailRole = 'TO'
[0..*] R_OutputRequestItemEmailTP _OutputRequestItemEmailCc $projection.OutputRequestItemUUID = _OutputRequestItemEmailCc.OutputRequestItemUUID and _OutputRequestItemEmailCc.OutputRequestItemEmailRole = 'CC'
[0..*] R_OutputRequestItemEmailTP _OutputRequestItemEmailBcc $projection.OutputRequestItemUUID = _OutputRequestItemEmailBcc.OutputRequestItemUUID and _OutputRequestItemEmailBcc.OutputRequestItemEmailRole = 'BCC'
[0..*] R_OutputRequestItemEmailTP _OutputRequestItemEmail
[0..*] R_OutputRequestItemAttchTP _OutputRequestItemAttachment
[0..*] R_OutputRequestItemLogTP _OutputRequestItemLog

Annotations (11)

NameValueLevelField
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey OutputRequestItemUUID view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label Output Request Item for RAP view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY OutputRequestItemUUID OutputRequestItemUUID
OutputControlApplObjectType OutputControlApplObjectType
OutputControlApplicationObject OutputControlApplicationObject
OutputRequestItem OutputRequestItem
OutputRequestUUID OutputRequestUUID
OutputRequestItemStatus OutputRequestItemStatus
OutputDocumentType OutputDocumentType
OutputChannel OutputChannel
OutputRequestItemOrigin OutputRequestItemOrigin
Recipient Recipient
RecipientRole RecipientRole
IsChangeDocument IsChangeDocument
DispatchTime DispatchTime
OutputRequestItemRefUUID OutputRequestItemRefUUID
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangedByUser
FormTemplate FormTemplate
FormTemplateType FormTemplateType
FormTemplateLanguage FormTemplateLanguage
FormTemplateCountry FormTemplateCountry
SenderOrganizationalCenter SenderOrganizationalCenter
SenderOrganizationalCenterType SenderOrganizationalCenterType
SenderOrganizationalUnit SenderOrganizationalUnit
SenderOrganizationalUnitType SenderOrganizationalUnitType
SenderCountry SenderCountry
EmailTemplate EmailTemplate
SenderEmailAddress SenderEmailAddress
PrintQueue PrintQueue
PrintQueueItem PrintQueueItem
PrintCopyNumber PrintCopyNumber
SpoolRequest SpoolRequest
OutputQueue OutputQueue
OutputQueueItem OutputQueueItem
OutputItemDataTransferMode OutputItemDataTransferMode
TotalPageNumber TotalPageNumber
DocumentPageDescriptionLang DocumentPageDescriptionLang
KnowledgeProviderObjectCat KnowledgeProviderObjectCat
KnowledgeProviderObject KnowledgeProviderObject
FormPDFIsUntagged FormPDFIsUntagged
_DispatchTime _DispatchTime
_DataTransferMode _DataTransferMode
_OutputChannel _OutputChannel
_OutputControlApplObjectType _OutputControlApplObjectType
_OutputDocumentType _OutputDocumentType
_OutputRequest _OutputRequest
_OutputRequestItemStatus _OutputRequestItemStatus
_OutputRequestItemEmail _OutputRequestItemEmail
_OutputRequestItemEmailTo _OutputRequestItemEmailTo
_OutputRequestItemEmailCc _OutputRequestItemEmailCc
_OutputRequestItemEmailBcc _OutputRequestItemEmailBcc
_OutputRequestItemAttachment _OutputRequestItemAttachment
_OutputRequestItemLog _OutputRequestItemLog
_OutputReqBinaryDataStandard _OutputReqBinaryDataStandard
_OutputSenderOrgType _OutputSenderOrgType
_OutputSenderOrgUnitType _OutputSenderOrgUnitType
_PrintQueueVH _PrintQueueVH
_OutputQueueVH _OutputQueueVH
_SenderCountry _SenderCountry
_EmailTemplate _EmailTemplate
_FormTemplate _FormTemplate
_FormTemplateCountry _FormTemplateCountry
_FormTemplateLanguage _FormTemplateLanguage
@ObjectModel: {
   usageType.serviceQuality: #B,
   usageType.sizeCategory: #XXL,
   usageType.dataClass: #TRANSACTIONAL,
   semanticKey: [ 'OutputRequestItem' ],
   representativeKey: 'OutputRequestItemUUID'
}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: [ '_OutputRequest',
                                         '_OutputRequestItemEmail',
                                         '_OutputRequestItemEmailTo',
                                         '_OutputRequestItemEmailCc',
                                         '_OutputRequestItemEmailBcc',
                                         '_OutputRequestItemAttachment',
                                         '_OutputRequestItemLog' ]
@AccessControl.personalData.blocking: #REQUIRED
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true //shall be changed to false, because MDE on this level(TP) is not needed anymore

@EndUserText.label: 'Output Request Item for RAP'
define view entity R_OutputRequestItemTP
  as select from R_OutputRequestItem
  association        to parent R_OutputRequestTP      as _OutputRequest               on  $projection.OutputRequestUUID = _OutputRequest.OutputRequestUUID
  composition [0..*] of R_OutputRequestItemEmailTP    as _OutputRequestItemEmail
  composition [0..*] of R_OutputRequestItemAttchTP    as _OutputRequestItemAttachment
  composition [0..*] of R_OutputRequestItemLogTP      as _OutputRequestItemLog
  association [0..1] to I_OutputRequestItemBinaryData as _OutputReqBinaryDataStandard on  _OutputReqBinaryDataStandard.OutputRequestItemBinaryDataID = ''
  association [0..1] to I_OutputSenderOrgCenterType   as _OutputSenderOrgType         on  $projection.SenderOrganizationalCenterType = _OutputSenderOrgType.SenderOrganizationalCenterType
  association [0..1] to I_OutputSenderOrgUnitType     as _OutputSenderOrgUnitType     on  $projection.SenderOrganizationalUnitType = _OutputSenderOrgUnitType.SenderOrganizationalUnitType
  association [0..1] to I_OutpReqItmPqVH              as _PrintQueueVH                on  $projection.PrintQueue = _PrintQueueVH.PrintQueue
  association [0..1] to C_OQ_QUEUE_VH                 as _OutputQueueVH               on  $projection.OutputQueue = _OutputQueueVH.Qname
  association [0..1] to I_OCFormTemplate              as _FormTemplate                on  $projection.OutputControlApplObjectType = _FormTemplate.OutputControlApplObjectType
                                                                                      and $projection.OutputDocumentType          = _FormTemplate.OutputDocumentType
                                                                                      and $projection.FormTemplateType            = _FormTemplate.FormType
                                                                                      and $projection.FormTemplate                = _FormTemplate.FormTemplate
  association [0..1] to I_OCEmailTemplate             as _EmailTemplate               on  $projection.OutputControlApplObjectType = _EmailTemplate.OutputControlApplObjectType
                                                                                      and $projection.OutputDocumentType          = _EmailTemplate.OutputDocumentType
                                                                                      and $projection.EmailTemplate               = _EmailTemplate.EmailTemplate
  association [0..1] to I_Country                     as _SenderCountry               on  $projection.SenderCountry = _SenderCountry.Country
  association [0..1] to I_Country                     as _FormTemplateCountry         on  $projection.FormTemplateCountry = _FormTemplateCountry.Country
  association [0..1] to I_Language                    as _FormTemplateLanguage        on  $projection.FormTemplateLanguage = _FormTemplateLanguage.Language
  association [0..*] to R_OutputRequestItemEmailTP    as _OutputRequestItemEmailTo    on  $projection.OutputRequestItemUUID                    = _OutputRequestItemEmailTo.OutputRequestItemUUID
                                                                                      and _OutputRequestItemEmailTo.OutputRequestItemEmailRole = 'TO'
  association [0..*] to R_OutputRequestItemEmailTP    as _OutputRequestItemEmailCc    on  $projection.OutputRequestItemUUID                    = _OutputRequestItemEmailCc.OutputRequestItemUUID
                                                                                      and _OutputRequestItemEmailCc.OutputRequestItemEmailRole = 'CC'
  association [0..*] to R_OutputRequestItemEmailTP    as _OutputRequestItemEmailBcc   on  $projection.OutputRequestItemUUID                     = _OutputRequestItemEmailBcc.OutputRequestItemUUID
                                                                                      and _OutputRequestItemEmailBcc.OutputRequestItemEmailRole = 'BCC'

{
  key OutputRequestItemUUID,
      @ObjectModel.foreignKey.association: '_OutputControlApplObjectType'
      OutputControlApplObjectType,
      OutputControlApplicationObject,
      OutputRequestItem,
      OutputRequestUUID,
      @ObjectModel.foreignKey.association: '_OutputRequestItemStatus'
      OutputRequestItemStatus,
      @ObjectModel.foreignKey.association: '_OutputDocumentType'
      OutputDocumentType,
      @ObjectModel.foreignKey.association: '_OutputChannel'
      OutputChannel,
      OutputRequestItemOrigin,
      Recipient,
      RecipientRole,
      IsChangeDocument,
      @ObjectModel.foreignKey.association: '_DispatchTime'
      DispatchTime,
      @UI.hidden: true
      OutputRequestItemRefUUID,
      @Semantics.systemDateTime.createdAt: true
      CreationDateTime,
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      @ObjectModel.foreignKey.association: '_FormTemplate'
      FormTemplate,
      FormTemplateType,
      FormTemplateLanguage,
      FormTemplateCountry,
      SenderOrganizationalCenter,
      @ObjectModel.foreignKey.association: '_OutputSenderOrgType'
      SenderOrganizationalCenterType,
      SenderOrganizationalUnit,
      @ObjectModel.foreignKey.association: '_OutputSenderOrgUnitType'
      SenderOrganizationalUnitType,
      SenderCountry,
      @ObjectModel.foreignKey.association: '_EmailTemplate'
      EmailTemplate,
      SenderEmailAddress,
      @ObjectModel.foreignKey.association: '_PrintQueueVH'
      PrintQueue,
      PrintQueueItem,
      PrintCopyNumber,
      //  PrintingMethod,

      SpoolRequest,
      OutputQueue,
      OutputQueueItem,
      OutputItemDataTransferMode,
      TotalPageNumber,
      DocumentPageDescriptionLang,
      KnowledgeProviderObjectCat,
      KnowledgeProviderObject,
      FormPDFIsUntagged,
      /* Associations */
      //R_OutputRequestItem

      _DispatchTime,
      _DataTransferMode,
      _OutputChannel,
      _OutputControlApplObjectType,
      _OutputDocumentType,
      _OutputRequest,
      _OutputRequestItemStatus,
      _OutputRequestItemEmail,
      _OutputRequestItemEmailTo,
      _OutputRequestItemEmailCc,
      _OutputRequestItemEmailBcc,
      _OutputRequestItemAttachment,
      _OutputRequestItemLog,
      _OutputReqBinaryDataStandard,
      _OutputSenderOrgType,
      _OutputSenderOrgUnitType,
      _PrintQueueVH,
      _OutputQueueVH,
      _SenderCountry,
      _EmailTemplate,
      _FormTemplate,
      _FormTemplateCountry,
      _FormTemplateLanguage
}