R_PhysInvtryOutpRequestItem

DDL: R_PHYSINVTRYOUTPREQUESTITEM Type: view_entity COMPOSITE

PI Document Output Request Items

R_PhysInvtryOutpRequestItem is a Composite CDS View that provides data about "PI Document Output Request Items" in SAP S/4HANA. It reads from 1 data source (R_OutputRequestItem) and exposes 17 fields with key field OutputRequestItemUUID. It has 4 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
R_OutputRequestItem R_OutputRequestItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_OutputRequestItemStatus _OutputRequestItemStatus $projection.OutputRequestItemStatus = _OutputRequestItemStatus.OutputRequestItemStatus
[0..1] I_OutputChannel _OutputChannel $projection.OutputChannel = _OutputChannel.OutputChannel
[0..1] I_DispatchTime _DispatchTime $projection.DispatchTime = _DispatchTime.DispatchTime

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label PI Document Output Request Items view
VDM.private false view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY OutputRequestItemUUID OutputRequestItemUUID
OutputControlApplicationObject OutputControlApplicationObject
PhysicalInventoryDocument
FiscalYear
PhysicalInventoryDocumentItem
OperationIsPrinted
CreationDateTime CreationDateTime
FormTemplate FormTemplate
OutputRequestItemStatus OutputRequestItemStatus
OutputRequestItemStatusDescr
OutputChannel OutputChannel
OutputChannelDescription
DispatchTime DispatchTime
DispatchTimeDescription
CreatedByUser CreatedByUser
CreatedByUserDescription _CreatedByUser UserDescription
PrintQueue PrintQueue 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'PI Document Output Request Items'

@VDM:{
    private:false,
    viewType: #COMPOSITE,
    lifecycle.contract.type: #SAP_INTERNAL_API }  

@ObjectModel: {
                 usageType: {
                              sizeCategory: #XL,
                              serviceQuality: #C,
                              dataClass: #TRANSACTIONAL
                            }
              }
@Search.searchable: true     

define view entity R_PhysInvtryOutpRequestItem 
 as select from R_OutputRequestItem
 
 association [0..1] to I_User as _CreatedByUser on $projection.CreatedByUser = _CreatedByUser.UserID 
 association [0..1] to I_OutputRequestItemStatus as _OutputRequestItemStatus on  $projection.OutputRequestItemStatus = _OutputRequestItemStatus.OutputRequestItemStatus
 association [0..1] to I_OutputChannel as _OutputChannel on  $projection.OutputChannel = _OutputChannel.OutputChannel 
 association [0..1] to I_DispatchTime as _DispatchTime on $projection.DispatchTime = _DispatchTime.DispatchTime
 
{ 
      @UI.hidden: true
  key OutputRequestItemUUID,                                                                       
      @UI.hidden: true
      OutputControlApplicationObject,                                                                
      substring(OutputControlApplicationObject, 1, 10)                                               as PhysicalInventoryDocument,
       @UI.hidden: true
      cast( substring(OutputControlApplicationObject, 11, 4) as gjahr)                               as FiscalYear,
      @UI.hidden: true
      cast( substring(OutputControlApplicationObject, 15, 3) as dzeile)                              as PhysicalInventoryDocumentItem, 
      @UI.hidden: true
      substring(OutputControlApplicationObject, 21, 1)                                               as OperationIsPrinted,     
      @UI: { lineItem: [{ position: 1, importance: #HIGH }] }
      CreationDateTime,
      @UI: { lineItem: [{ position: 2, importance: #HIGH }] }
      FormTemplate,
      @UI: { lineItem: [{ position: 3, importance: #HIGH }],
       textArrangement: #TEXT_ONLY }
      @ObjectModel.text.element:  [ 'OutputRequestItemStatusDescr' ]
      OutputRequestItemStatus,  
      @UI.hidden: true   
      _OutputRequestItemStatus._Text[1: Language= $session.system_language].OutputRequestItemStatusDescr,   
      @UI: { lineItem: [{ position: 6, importance: #HIGH }],
       textArrangement: #TEXT_ONLY }
      @ObjectModel.text.element:  [ 'OutputChannelDescription' ]
      OutputChannel,
      @UI.hidden: true
      _OutputChannel._Text[1: Language= $session.system_language].OutputChannelDescription,
      @UI: { lineItem: [{ position: 4, importance: #HIGH }],
       textArrangement: #TEXT_ONLY }
      @ObjectModel.text.element:  [ 'DispatchTimeDescription' ]      
      DispatchTime,
      @UI.hidden: true
      _DispatchTime._Text[1: Language= $session.system_language].DispatchTimeDescription,
      @UI: { lineItem: [{ position: 5, importance: #HIGH }] }
      @ObjectModel.text.element:  [ 'CreatedByUserDescription' ]
      @Search: { defaultSearchElement: true,
             fuzzinessThreshold: 0.8,
             ranking: #HIGH }
      CreatedByUser,
      @UI.hidden: true
      @Search: { defaultSearchElement: true,
            fuzzinessThreshold: 0.8,
            ranking: #HIGH }
      _CreatedByUser.UserDescription                                                         as CreatedByUserDescription,
      @UI: { lineItem: [{ position: 7, importance: #HIGH }] }
      PrintQueue
      
}
where
  OutputControlApplObjectType = 'PHYSICAL_INVENTORY'

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DISPATCHTIME",
"I_DISPATCHTIMETEXT",
"I_OUTPUTCHANNEL",
"I_OUTPUTCHANNELTEXT",
"I_OUTPUTREQUESTITEMSTATUS",
"I_OUTPUTREQUESTITEMSTATUSTEXT",
"I_USER",
"R_OUTPUTREQUESTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More