R_SWF_FLEX_WF_TEMPLATE

DDL: R_SWF_FLEX_WF_TEMPLATE Type: view_entity

Workflow Template

R_SWF_FLEX_WF_TEMPLATE is a CDS View that provides data about "Workflow Template" in SAP S/4HANA. It reads from 1 data source (swf_flex_templat) and exposes 13 fields with key fields WorkflowTemplateId, WorkflowScenarioDefinition.

Data Sources (1)

SourceAliasJoin Type
swf_flex_templat swf_flex_templat from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Workflow Template view
Metadata.allowExtensions true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTemplateId appl_obj_id Instance ID
KEY WorkflowScenarioDefinition scenario_id Workflow definition
CreationUser creation_user User
CreationTimestamp creation_ts Time Stamp
ChangeUser change_user User Name
ChangeTimestamp change_ts Time Stamp
WorkflowScenarioVersion scenario_version Version
Stream stream Streams Allowed
FormatVersion format_version Field of length 16
Language langu Primary lang.
Type type Worklist Type
WorkflowId workflow_id Workflow definition
WorkflowScenarioUUID scenario_uuid UUID

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 R_SWF_FLEX_WF_TEMPLATE.
-- 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.

CREATE VIEW R_SWF_FLEX_WF_TEMPLATE AS
SELECT
  appl_obj_id AS WorkflowTemplateId,
  scenario_id AS WorkflowScenarioDefinition,
  creation_user AS CreationUser,
  creation_ts AS CreationTimestamp,
  change_user AS ChangeUser,
  change_ts AS ChangeTimestamp,
  scenario_version AS WorkflowScenarioVersion,
  Stream,
  format_version AS FormatVersion,
  langu AS Language,
  Type,
  workflow_id AS WorkflowId,
  scenario_uuid AS WorkflowScenarioUUID
FROM swf_flex_templat
;