I_WORKFLOWTASK

CDS View
34 Fields 109 CDS Views

Workflow work items

I_WORKFLOWTASK is a CDS View in S/4HANA. Workflow work items. It contains 34 fields. 109 CDS views read from this table.

CDS Views using this table (109)

ViewTypeJoinVDMDescription
C_BkPowerOfAttorneyWorkflowEDP view_entity inner CONSUMPTION Power of Attorney Email Data Provider
C_CABillgReqWrkflwEmlTmpl view_entity from CONSUMPTION CA Billing request Workflow Email Templ
C_CADocumentWrkflwEmlTmpl view from CONSUMPTION CA Document Workflow Email Template
C_CAInstlmntPlanWrkflwEmlTmpl view from CONSUMPTION Installment Plan Workflow Email Template
C_CAWriteoffWrkflwEmlTmpl view from CONSUMPTION Write off Workflow Email Template
C_CN_PaymentReleaseListEmlTmpl view from CONSUMPTION CN Email Template for Payt Release List
C_CN_PayReqnWrkflwApprvlTmpl view_entity from CONSUMPTION Payment Requisition Approval Email
C_CN_PayReqnWrkflwNotifTmpl view_entity from CONSUMPTION Payment Requisiton Notification Email
C_CndnContrWorkItem view from CONSUMPTION Condition Contract Work Item
C_CntrlPurContrApprovalEmail view from CONSUMPTION Cntrl Purchase Contract Details for Workflow Approval Email
C_CntrlPurContrWorkflowEmail view from CONSUMPTION Cntrl Purchase Contract Details for Workflow Deadline Email
C_CntrlPurReqnHdrWrkflwAprvEml view from CONSUMPTION Central PurReq HDR Wrkflw AppEmail Notif
C_CntrlPurReqnHdrWrkflwDdlnEml view from CONSUMPTION Central PurchaseRequisition HDR Wrkflw Deadline Email Notif
C_CntrlPurReqnItmWrkflwAprvEml view from CONSUMPTION Central PurReq Item Wrkflw Aprov email notifi
C_CntrlPurReqnItmWrkflwDdlnEml view from CONSUMPTION Central PurchaseRequsition Wrkflw deadline email notifi
C_CntrlSuplrConfWrkflwAprvEml view from CONSUMPTION Central Supplier Conf WF Approval Email
C_CntrlSuplrConfWrkflwDdlnEml view from CONSUMPTION Deadline Notif of Cntrl Confirmation
C_CrdtMemoReqWrkflwEmlTemplate view from CONSUMPTION Email Notification for Credit Memo Request Workflow
C_CustRetWrkflwEmailTemplate view from CONSUMPTION Email Template for Cust Ret Wrkflw
C_DebitMemoReqWrkflwEmlTmpl view from CONSUMPTION Email Template for Debit Memo Req Wrkflw
C_EDCWorkflowTask view_entity from CONSUMPTION EDC Workflow Task
C_GLJrnlEntrToBeVerifiedWrkFlw view from CONSUMPTION Jrnl entry to be verified and work item
C_IHBAccountApprovalStartEml view from CONSUMPTION IHB Account Email Template Provider
C_IHBAcctApprvlRsltAprvdEml view from CONSUMPTION IHB Account Email Template Provider
C_IHBAcctApprvlRsltRjctdEml view from CONSUMPTION IHB Account Email Template Provider
C_IHBCndnApprvlRsltAprvdEml view from CONSUMPTION IHB Cond Email Template Data Provider
C_IHBCndnApprvlRsltRjctdEml view from CONSUMPTION IHB Cond Email Template Data Provider
C_IHBConditionApprovalStartEml view from CONSUMPTION IHB Condition Email Template Data Provider
C_IHBFeeApprovalStartEmail view from CONSUMPTION IHB Fee Email Template Data Provider
C_IHBFeeApprovedEmail view from CONSUMPTION IHB Fee Email Template Data Provider
C_IHBFeeRejectedEmail view from CONSUMPTION IHB Fee Email Template Data Provider
C_IHBIntrstCompnApprvlStrtEml view from CONSUMPTION IHB Interest Compensation Email Template Data Provider
C_IHBIntrstCompnAprvdEml view from CONSUMPTION IHB Interest Compensation Email Template Data Provider
C_IHBIntrstCompnRjctdEml view from CONSUMPTION IHB Interest Compensation Email Template Data Provider
C_IHBLimitApprovalStartEml view from CONSUMPTION IHB Limit Email Template Data Provider
C_IHBLimitApprvlRsltAprvdEml view from CONSUMPTION IHB Cond Email Template Data Provider
C_IHBLimitApprvlRsltRjctdEml view from CONSUMPTION IHB Cond Email Template Data Provider
C_IncidentRelatedProcesses view from CONSUMPTION Other incident related tasks
C_JournalCaseWorkflowItem view_entity from CONSUMPTION Journal Case Workflow Item for Emails
C_OrdWthoutChrgWrkflwEmlTmpl view from CONSUMPTION Eml Tmpl for Sls Ord Wthout Chrg Wrkflw
C_PersSettlmtDocWorkItem view from CONSUMPTION Personnel Settlement Document Work Item
C_PrmtHbRpldPurOrdApprvlEml view from CONSUMPTION PrmtHb Rpld PO Details for Workflow Approval Email
C_PrmtHbRpldPurOrdWrkflwEml view from CONSUMPTION PrmtHb Rpld PO Details for Workflow Deadline Email
C_PrmtHbRpldPurReqnApprvlEml view from CONSUMPTION Purchase Requisition Details for Workflow Approval Email
C_PrmtHbRpldPurReqnItmAprvEml view from CONSUMPTION Purchase Requisition Itm Details for WF Approval Email
C_PrmtHbRpldPurReqnItmWflEml view from CONSUMPTION Purchase Requisition Itm Details for WF Deadline Email
C_PrmtHbRpldPurReqnWrkflwEml view from CONSUMPTION Purchase Requisition Details for Workflow Deadline Email
C_PurchaseOrderWorkflowEmail view from CONSUMPTION Purchase Order Details for Workflow Deadline Email
C_PurContrApprovalEmail view from CONSUMPTION Purchase Contract Details for Workflow Approval Email
C_PurContrApprovalEmail view inner CONSUMPTION Purchase Contract Details for Workflow Approval Email
C_PurContrWorkflowEmail view from CONSUMPTION Purchase Contract Details for Workflow Deadline Email
C_PurOrdWorkflowApprovalEmail view from CONSUMPTION Purchase Order Details for Workflow Approval Email
C_PurOrdWorkflowApprovalEmail view inner CONSUMPTION Purchase Order Details for Workflow Approval Email
C_PurReqnHdrWrkflwApprvlEml view from CONSUMPTION Purchase Requsition Header Workflow email notific
C_PurReqnHdrWrkflwDeadlineEml view from CONSUMPTION PurchaseRequsition HDR Wrkflw deadline email notif
C_PurReqnItmWrkflwApprvlEml view from CONSUMPTION Purchase Requsition Item Workflow email notif
C_PurReqnItmWrkflwDeadlineEml view from CONSUMPTION Purchase Requsition Workflow deadline email notification
C_PurSchedAgrmtApprovalEmail view_entity from CONSUMPTION Purchase Scheduling Agrmnt Appr Email
C_PurSchedAgrmtApprovalEmail view_entity inner CONSUMPTION Purchase Scheduling Agrmnt Appr Email
C_PurSchedAgrmtOverdueEmail view_entity from CONSUMPTION Purchase Scheduling Agrmnt Overdue Email
C_SchedgAgrmtWorkflow view inner CONSUMPTION Scheduling Agreement Workflow
C_SESWorkflowEmail view from CONSUMPTION Email for SES Wfl Approval or Rejection
C_SESWorkflowEmail view inner CONSUMPTION Email for SES Wfl Approval or Rejection
C_SettlmtDocWorkItem view from CONSUMPTION Settlement Document Work Item
C_SlsContrWrkflwEmailTemplate view from CONSUMPTION Eml Tmpl for Sales Contract Workflow
C_SlsOrdWorkflowEmailTemplate view from CONSUMPTION Sales Order Workflow Email Template
C_SlsPrcApprvlReqEmailTemplate view from CONSUMPTION Email Notification for Sales Price Approval Requester
C_SlsPrcWrkflwEmailTemplate view from CONSUMPTION Email Notification for Sales Price Workflow
C_SlsQtnWorkflowEmailTemplate view from CONSUMPTION Email Notification for Sales Quotation Workflow
C_SrvcQtanWorkflowEmail view from CONSUMPTION Email Data Provider for workflow
C_SrvcQtanWrkflwDeadlineEmail view from CONSUMPTION Email Data Provider For Deadline Step
C_SuplrConfWrkflwApprovalEmail view from CONSUMPTION Supplier Confirmation Details for Workflow Approval Email
C_SuplrConfWrkflwApprovalEmail view inner CONSUMPTION Supplier Confirmation Details for Workflow Approval Email
C_SuplrInvcBlkdWrkflwEmlDcsn view from CONSUMPTION Approve or Reject Email for Blocked Invoice
C_SuplrInvcBlkdWrkflwEmlDcsn view inner CONSUMPTION Approve or Reject Email for Blocked Invoice
C_SuplrInvcWrkflwEmlDcsnRsn view from CONSUMPTION Approve or Reject Email for Invoice
C_SuplrInvcWrkflwEmlDcsnRsn view inner CONSUMPTION Approve or Reject Email for Invoice
C_TaskToDwnPaytReqToBeVerified view_entity from CONSUMPTION Email Temp For Task to DPR
C_Workflowtask view from CONSUMPTION DEPRECATED: Work item with text info
C_WrkFlwToDwnPaytReqVerified view_entity from CONSUMPTION Email Temp For Workflow To DPR
I_BkAcctChgReqDeadlineEmail view from COMPOSITE Deadline email
I_EHSTask view from COMPOSITE EHS Task
I_EHSTaskDueDate view inner COMPOSITE EHS Task Due Date
I_IncdntInvestigationStpWrkflw view from COMPOSITE Incdnt investigation step workflow task
I_IncidentInvestigationWrkflw view from COMPOSITE Incident investigation workflow task
I_IncidentWorkflow view from COMPOSITE Incident workflow task
I_LglTransWrkflwEmlDeadLine view from COMPOSITE Email Template for Workflow Deadline
I_LglTransWrkflwInstce view from COMPOSITE Data for Workflow Instance
I_MDGovChgReqMappgTopWrkflw view inner BASIC Mapping From Top Workitem to CR
I_PurReqnItemEmailTemplate view from COMPOSITE Email Template for PurchaseReqn Obsolete
I_PurRequisitionEmailTemplate view from COMPOSITE Email Template for Purchase Requisition
I_SESWorkflowEmailDeadline view from COMPOSITE Email Template for Service Entry Sheet Workflow Deadline
I_SrcgSuplrListEmailTemplate view from COMPOSITE Email Template for Srcg Supplier List
I_SuplrInvcWrkflwEmlDeadLine view from COMPOSITE Supplier Invoice Details for Workflow Deadline Email
I_WorkflowMyDecisionStatus view inner COMPOSITE Current User Decision Status
I_WorkflowStatusDetails view from COMPOSITE Workflow Task
I_WorkflowStatusOverview view from COMPOSITE Workflow
P_DwnPaytReqLatestTaskTimeStmp view_entity inner COMPOSITE VSDPR Latest Task Timestamp
P_DwnPaytReqLatestWrkflwTask view_entity inner COMPOSITE VSDPRn Latest Workflow
P_DwnPaytReqProcessor view_entity from COMPOSITE VSDPR Current Processor
P_DwnPaytReqTaskDocStatus view_entity from COMPOSITE VSDPR Document Status of Task
P_EHSTaskOutCome view from CONSUMPTION
P_EHSWorkflowStep view from COMPOSITE
P_MinDuDteOfOpnActnInstances view from COMPOSITE
P_ProjectBillingWrkflwApprvr view_entity inner COMPOSITE Project Billing Request Approvers
P_PurchaseRequisitionWorkItem view from COMPOSITE
P_PurchasingLastWorkflowStep view from CONSUMPTION WorkItem Details
P_TaskDefAndInstForCount view inner COMPOSITE
R_HCMOvertimeRequestWorkItemTP view_entity from TRANSACTIONAL Overtime Request Approval Workitem - TP

Fields (34)

KeyField CDS FieldsUsed in Views
KEY WorkflowTaskCurrentUser ApprovedByUserFullName,LegalTransactionTaskCurUsr,TaskCurrentUser,WorkflowTaskCurrentUser,WorkflowTaskRecipient 23
KEY WorkflowTaskInternalID LastStepWorkflowTaskInternalID,WorkflowInternalID,WorkflowTaskInternalID 91
KEY WorkflowTaskType LegalTransactionTaskType,SuplrInvcWrkflwTaskType,WorkflowTaskType 21
_TaskApplicationLeadingObject _TaskApplicationLeadingObject 5
_TaskApplicationObject _TaskApplicationObject 5
_TaskDefinition _TaskDefinition 3
_TaskDueDate _TaskDueDate 3
_TaskPriority _TaskPriority 5
_TaskRecipient _TaskRecipient 4
_TaskStartEvent _TaskStartEvent 5
_TaskStatus _TaskStatus 8
_TaskTitle _TaskTitle 5
_TaskType _TaskType 5
_TopLevelTaskDefinition _TopLevelTaskDefinition 2
_WorkflowStepType _WorkflowStepType 1
_WorkflowTaskStepResult _WorkflowTaskStepResult 1
ParentWorkflowTask ParentTask,ParentWorkflowTask 8
TopLevelWorkflowTask HCMWorkItemID,TopLevelTask,TopLevelWorkflowTask 13
TopLevelWorkflowTaskDefinition TopLevelTaskDefinition,TopLevelWorkflowTaskDefinition 9
TopLevelWrkflwTskDefObject TopLevelWrkflwTskDefObject 5
TopLevelWrkflwTskDefObjType TopLevelWrkflwTskDefObjType 5
WorkflowTaskCreatedByUser LegalTransactionTaskCrtedByUsr,TaskCreatedByUser,WorkflowTaskCreatedByUser 19
WorkflowTaskDefinition TaskDefinition,WorkflowTaskDefinition 21
WorkflowTaskDefinitionObject WorkflowTaskDefinitionObject 7
WorkflowTaskDefinitionObjType WorkflowTaskDefinitionObjType 6
WorkflowTaskDefinitionType WorkflowTaskDefinitionType 4
WorkflowTaskDefinitionVersion WorkflowTaskDefinitionVersion 4
WorkflowTaskPriority TaskPriority,WorkflowTaskPriority 21
WorkflowTaskProcessorRole WorkflowTaskProcessorRole 6
WorkflowTaskResult WorkflowTaskResult 7
WorkflowTaskStatus LegalTransactionTaskStatus,SuplrInvcWrkflwTaskStatus,TaskProcessingStatus,TaskStatus,WorkflowTaskStatus 32
WorkflowTaskStepType WorkflowTaskStepType 8
WrkflwTskCompletionUTCDateTime TaskCompletionUTCDateTime,WrkflwTskCompletionUTCDateTime 15
WrkflwTskCreationUTCDateTime LglTransTskCrtnUTCDteTme,SuplrInvcWrkflwTskCrtnDateTime,TaskCreateUTCDateTime,WrkflwTskCreationUTCDateTime 23

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Workflow work items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKFLOWTASK (
    WORKFLOWTASKCURRENTUSER,
    WORKFLOWTASKINTERNALID,
    WORKFLOWTASKTYPE,
    _TASKAPPLICATIONLEADINGOBJECT,
    _TASKAPPLICATIONOBJECT,
    _TASKDEFINITION,
    _TASKDUEDATE,
    _TASKPRIORITY,
    _TASKRECIPIENT,
    _TASKSTARTEVENT,
    _TASKSTATUS,
    _TASKTITLE,
    _TASKTYPE,
    _TOPLEVELTASKDEFINITION,
    _WORKFLOWSTEPTYPE,
    _WORKFLOWTASKSTEPRESULT,
    PARENTWORKFLOWTASK,
    TOPLEVELWORKFLOWTASK,
    TOPLEVELWORKFLOWTASKDEFINITION,
    TOPLEVELWRKFLWTSKDEFOBJECT,
    TOPLEVELWRKFLWTSKDEFOBJTYPE,
    WORKFLOWTASKCREATEDBYUSER,
    WORKFLOWTASKDEFINITION,
    WORKFLOWTASKDEFINITIONOBJECT,
    WORKFLOWTASKDEFINITIONOBJTYPE,
    WORKFLOWTASKDEFINITIONTYPE,
    WORKFLOWTASKDEFINITIONVERSION,
    WORKFLOWTASKPRIORITY,
    WORKFLOWTASKPROCESSORROLE,
    WORKFLOWTASKRESULT,
    WORKFLOWTASKSTATUS,
    WORKFLOWTASKSTEPTYPE,
    WRKFLWTSKCOMPLETIONUTCDATETIME,
    WRKFLWTSKCREATIONUTCDATETIME,
    PRIMARY KEY (WORKFLOWTASKCURRENTUSER, WORKFLOWTASKINTERNALID, WORKFLOWTASKTYPE)
);

Learn More