P_PROJECTBILLINGWRKFLWAPPRVR

CDS View

Project Billing Request Approvers

P_PROJECTBILLINGWRKFLWAPPRVR is a CDS View in S/4HANA. Project Billing Request Approvers. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProjectBillingWrkflwApprvr view from CONSUMPTION Project Billing Request Approvers 
@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKFLOWTASK",
"I_WORKFLOWTASKAPPLOBJECT",
"I_WORKFLOWUSERWORKITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More