R_OutputRequestItemTP

DDL: R_OUTPUTREQUESTITEMTP Type: view_entity TRANSACTIONAL

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 51 fields with key field OutputRequestItemUUID. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_OutputRequestItem R_OutputRequestItem from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_OutputRequestItemBinaryData _OutputReqBinaryDataStandard _OutputReqBinaryDataStandard.OutputRequestItemBinaryDataID = ''
[0..1] I_OutputSenderOrgUnitType _OutputSenderOrgUnitType $projection.SenderOrganizationalUnitType = _OutputSenderOrgUnitType.SenderOrganizationalUnitType
[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 _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 (51)

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
TotalPageNumber TotalPageNumber
DocumentPageDescriptionLang DocumentPageDescriptionLang
KnowledgeProviderObjectCat KnowledgeProviderObjectCat
KnowledgeProviderObject KnowledgeProviderObject
FormPDFIsUntagged FormPDFIsUntagged
_DispatchTime _DispatchTime
_OutputChannel _OutputChannel
_OutputControlApplObjectType _OutputControlApplObjectType
_OutputDocumentType _OutputDocumentType
_OutputRequest _OutputRequest
_OutputRequestItemStatus _OutputRequestItemStatus
_OutputRequestItemEmail _OutputRequestItemEmail
_OutputRequestItemAttachment _OutputRequestItemAttachment
_OutputRequestItemLog _OutputRequestItemLog
_OutputReqBinaryDataStandard _OutputReqBinaryDataStandard
_OutputSenderOrgUnitType _OutputSenderOrgUnitType
_SenderCountry _SenderCountry
_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',
                                         '_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_OutputSenderOrgUnitType     as _OutputSenderOrgUnitType     on $projection.SenderOrganizationalUnitType = _OutputSenderOrgUnitType.SenderOrganizationalUnitType
  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
{
      //R_OutputRequestItem

  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,
      FormTemplate,
      FormTemplateType,
      FormTemplateLanguage,
      FormTemplateCountry,
      SenderOrganizationalCenter,
      SenderOrganizationalCenterType,
      SenderOrganizationalUnit,
      @ObjectModel.foreignKey.association: '_OutputSenderOrgUnitType'
      SenderOrganizationalUnitType,
      SenderCountry,
      EmailTemplate,
      SenderEmailAddress,
      PrintQueue,
      PrintQueueItem,
      PrintCopyNumber,
      //  PrintingMethod,

      TotalPageNumber,
      DocumentPageDescriptionLang,
      KnowledgeProviderObjectCat,
      KnowledgeProviderObject,
      FormPDFIsUntagged,
      /* Associations */
      //R_OutputRequestItem

      _DispatchTime,
      _OutputChannel,
      _OutputControlApplObjectType,
      _OutputDocumentType,
      _OutputRequest,
      _OutputRequestItemStatus,
      _OutputRequestItemEmail,
      _OutputRequestItemAttachment,
      _OutputRequestItemLog,
      _OutputReqBinaryDataStandard,
      _OutputSenderOrgUnitType,
      _SenderCountry,
      _FormTemplateCountry,
      _FormTemplateLanguage
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_OUTPUTREQUESTITEM"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_DISPATCHTIME",
"I_LANGUAGE",
"I_OUTPUTCHANNEL",
"I_OUTPUTCONTROLAPPLOBJECTTYPE",
"I_OUTPUTCONTROLOUTPUTTYPE",
"I_OUTPUTREQUESTITEMBINARYDATA",
"I_OUTPUTREQUESTITEMSTATUS",
"I_OUTPUTSENDERORGUNITTYPE",
"R_OUTPUTREQUESTITEMATTCHTP",
"R_OUTPUTREQUESTITEMEMAILTP",
"R_OUTPUTREQUESTITEMLOGTP",
"R_OUTPUTREQUESTTP"
],
"BASE":
[
"R_OUTPUTREQUESTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/