R_OutputRequestItemTP
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)
| Source | Alias | Join Type |
|---|---|---|
| R_OutputRequestItem | R_OutputRequestItem | from |
Associations (16)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA