P_ProjectBillingWrkflwApprvr

DDL: P_PROJECTBILLINGWRKFLWAPPRVR Type: view_entity COMPOSITE

Project Billing Request Approvers

P_ProjectBillingWrkflwApprvr is a Composite CDS View that provides data about "Project Billing Request Approvers" in SAP S/4HANA. It reads from 4 data sources (I_WorkflowTask, I_WorkflowTaskApplObject, I_WorkflowTaskApplObject, I_WorkflowUserWorkItem) and exposes 7 fields with key fields WorkflowTaskInternalID, WorkflowTaskRecipient, WorkflowTaskRecipient.

4 data source(s) 7 fields

Data Sources (4)

SourceAliasJoin Type
I_WorkflowTask _WorkflowTask inner
I_WorkflowTaskApplObject _WorkflowTaskApplObject from
I_WorkflowTaskApplObject _WorkflowTaskApplObject union
I_WorkflowUserWorkItem _WorkflowUserWorkItem inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label Project Billing Request Approvers view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTaskApplObject WorkflowTaskInternalID
KEY WorkflowTaskRecipient I_WorkflowUserWorkItem UserID
TechnicalWrkflwObject I_WorkflowTaskApplObject TechnicalWrkflwObject
WorkflowTaskInternalID
KEY WorkflowTaskRecipient I_WorkflowTask WorkflowTaskCurrentUser
TechnicalWrkflwObject I_WorkflowTaskApplObject TechnicalWrkflwObject
WorkflowTaskResult I_WorkflowTask WorkflowTaskResult 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #COMPOSITE
@VDM.private:true
@EndUserText.label: 'Project Billing Request Approvers'

define view entity P_ProjectBillingWrkflwApprvr

  as select from I_WorkflowTaskApplObject as _WorkflowTaskApplObject
      inner join I_WorkflowUserWorkItem   as _WorkflowUserWorkItem on  _WorkflowUserWorkItem.WorkItem = _WorkflowTaskApplObject.WorkflowTaskInternalID
                                                                   and _WorkflowUserWorkItem.WrkItmIsNotRelevantToSelection is initial
  //  inner join I_WorkflowTaskRecipient as _WorkflowTaskRecipient on _WorkflowTaskRecipient.WorkflowTaskInternalID = _WorkflowTaskApplObject.WorkflowTaskInternalID

  //                                                              and _WorkflowTaskRecipient.WorkflowTaskIsForwarded = 'X'  //_WorkflowTaskRecipient.WorkflowTaskIsVisibleInInbox = 'X'

{
  key _WorkflowTaskApplObject.WorkflowTaskInternalID,
  key _WorkflowUserWorkItem.UserID         as WorkflowTaskRecipient,
      _WorkflowTaskApplObject.TechnicalWrkflwObject,
      cast( 'PENDING' as swf_flex_retval ) as WorkflowTaskResult
      //cast( '00000000' as dats ) as ProjBillgWrkflwTskCreationDate

}
where _WorkflowTaskApplObject.TechnicalWrkflwObjectType = 'CL_PROJBILLGREQ_WORKFLOW'

union

select from  I_WorkflowTaskApplObject as _WorkflowTaskApplObject
  inner join I_WorkflowTask           as _WorkflowTask on  _WorkflowTask.WorkflowTaskInternalID = _WorkflowTaskApplObject.WorkflowTaskInternalID
                                                       and ( _WorkflowTask.WorkflowTaskStatus = 'COMPLETED' or _WorkflowTask.WorkflowTaskStatus = 'WAITING' ) //or _WorkflowTask.WorkflowTaskStatus = 'CANCELLED'

                                                       and _WorkflowTask.WorkflowTaskType = 'W'
{
  key _WorkflowTaskApplObject.WorkflowTaskInternalID,
  key _WorkflowTask.WorkflowTaskCurrentUser as WorkflowTaskRecipient,
      _WorkflowTaskApplObject.TechnicalWrkflwObject,
      _WorkflowTask.WorkflowTaskResult
      // tstmp_to_dats( cast( _WorkflowTask.WrkflwTskCompletionUTCDateTime as timestamp ), abap_system_timezone( $session.client,'NULL' ),

      //                  $session.client, 'NULL' ) as ProjBillgWrkflwTskCreationDate


}
where _WorkflowTaskApplObject.TechnicalWrkflwObjectType = 'CL_PROJBILLGREQ_WORKFLOW'

Learn More