SWF_CPWF_MON_MAIN

DDL: SWF_CPWF_MON_MAIN SQL: SWFCPWFMONMAIN Type: view Package: SWF_CPWF_MON

Cloud Platform Workflow Instances

SWF_CPWF_MON_MAIN is a CDS View that provides data about "Cloud Platform Workflow Instances" in SAP S/4HANA. It reads from 2 data sources (swf_cpwf_error, swf_cpwf_inst) and exposes 19 fields with key field CpWorkflowHandle. Part of development package SWF_CPWF_MON.

Data Sources (2)

SourceAliasJoin Type
swf_cpwf_error cpwf_error left_outer
swf_cpwf_inst cpwf_inst from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SWFCPWFMONMAIN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cloud Platform Workflow Instances view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CpWorkflowHandle swf_cpwf_inst cp_wf_handle WF Handle ID
CpWorkflowDefId swf_cpwf_inst cp_wf_def_id Ext Workflow ID
CpWorkflowId swf_cpwf_inst cp_wf_id CPWF Instance ID
ConsumerType swf_cpwf_inst consumer Consumer Type
Status swf_cpwf_inst status Workflow Status
Outcome swf_cpwf_inst outcome Action Outcome
Operation swf_cpwf_inst operation Transaction
RetryCounter swf_cpwf_inst retry_counter Retry Counter
BgRfcUnitId swf_cpwf_inst bgrfc_unit_id Unit ID
RetentionTime swf_cpwf_inst retention_time Retention Time
CreatedBy swf_cpwf_inst created_by Version Created By
CreatedOn swf_cpwf_inst crea_on Created on
LastChangedBy swf_cpwf_inst last_changed_by Username
LastChangedOn swf_cpwf_inst last_chng_on Changed on
CallbackClass swf_cpwf_inst callback_class Callback Class
ContextData swf_cpwf_inst context Context Data
CpWorkflowLog swf_cpwf_inst cp_wf_log Workflow Log
ErrorFlavor swf_cpwf_error error_flavor Error Flavor
ErrorMessage swf_cpwf_error message Error Message

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SWF_CPWF_MON_MAIN.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SWFCPWFMONMAIN

CREATE VIEW SWF_CPWF_MON_MAIN AS
SELECT
  cpwf_inst.cp_wf_handle AS CpWorkflowHandle,
  cpwf_inst.cp_wf_def_id AS CpWorkflowDefId,
  cpwf_inst.cp_wf_id AS CpWorkflowId,
  cpwf_inst.consumer AS ConsumerType,
  cpwf_inst.status AS Status,
  cpwf_inst.outcome AS Outcome,
  cpwf_inst.operation AS Operation,
  cpwf_inst.retry_counter AS RetryCounter,
  cpwf_inst.bgrfc_unit_id AS BgRfcUnitId,
  cpwf_inst.retention_time AS RetentionTime,
  cpwf_inst.created_by AS CreatedBy,
  cpwf_inst.crea_on AS CreatedOn,
  cpwf_inst.last_changed_by AS LastChangedBy,
  cpwf_inst.last_chng_on AS LastChangedOn,
  cpwf_inst.callback_class AS CallbackClass,
  cpwf_inst.context AS ContextData,
  cpwf_inst.cp_wf_log AS CpWorkflowLog,
  cpwf_error.error_flavor AS ErrorFlavor,
  cpwf_error.message AS ErrorMessage
FROM swf_cpwf_inst AS cpwf_inst
LEFT OUTER JOIN swf_cpwf_error AS cpwf_error ON /* join condition not captured in parsed metadata */
;