P_DwnPaytReqTaskDocStatus

DDL: P_DWNPAYTREQTASKDOCSTATUS Type: view_entity COMPOSITE Package: ODATA_VERIFY_SUPPLIER_DPRS

VSDPR Document Status of Task

P_DwnPaytReqTaskDocStatus is a Composite CDS View that provides data about "VSDPR Document Status of Task" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 3 fields with key field WorkflowTaskInternalID. Part of development package ODATA_VERIFY_SUPPLIER_DPRS.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask I_WorkflowTask from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label VSDPR Document Status of Task view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID WorkflowTaskInternalID
WorkflowTaskStatus WorkflowTaskStatus
TopLevelWorkflowTask TopLevelWorkflowTask 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'VSDPR Document Status of Task'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.private:true
@VDM.viewType: #COMPOSITE

//Calculate Task status for task TS78500119(Manully approved) and TS78500120(Post)

define view entity P_DwnPaytReqTaskDocStatus as select from I_WorkflowTask {
  key WorkflowTaskInternalID,
  
      WorkflowTaskStatus,
      case WorkflowTaskStatus
        when 'READY'
          then 'S' 
        when 'SELECTED'
          then 'S'
        when 'ERROR'
          then 'F'
        when 'EXCPCAUGHT'
          then 'F'
        when 'EXCPHANDLR'
          then 'F'
        when 'CANCELLED'
          then 'C'
        else 
           'W'
        end as AcctgDocumentWorkflowStatus,
        
       cast (case WorkflowTaskStatus
        when 'READY'
          then '2' 
        when 'SELECTED'
          then '2'
        when 'ERROR'
          then '3'
        when 'EXCPCAUGHT'
          then '3'
        when 'EXCPHANDLR'
          then '3'
        when 'CANCELLED'
          then '4'          
        else 
           '1'
        end as int1) as Priority,       
        
        TopLevelWorkflowTask
       
} where TopLevelWorkflowTaskDefinition = 'WS78500134'   // Verify Supplier DPR

    and ( WorkflowTaskType = 'W' or                     // Step: verify and approve

          WorkflowTaskType = 'B' )                      // step: Post

Learn More