Swf_Flex_Sddl_Tokens

DDL: SWF_FLEX_SDDL_TOKENS SQL: SWF_V_TOKENS Type: view Package: SWF_FLEX_ENGINE

Workflow: CDS for Runtime Tokens

Swf_Flex_Sddl_Tokens is a CDS View that provides data about "Workflow: CDS for Runtime Tokens" in SAP S/4HANA. It reads from 1 data source (swf_flex_token) and exposes 10 fields with key fields wf_id, tokenIdentifier. Part of development package SWF_FLEX_ENGINE.

Data Sources (1)

SourceAliasJoin Type
swf_flex_token swf_flex_token from

Parameters (1)

NameTypeDefault
timeZoneUpdate tznzone

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SWF_V_TOKENS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Workflow: CDS for Runtime Tokens view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY wf_id swf_flex_token wf_id Workflow ID
KEY tokenIdentifier swf_flex_token token_id INT4
splitIdentifier swf_flex_token split_id WM Split Number
waitingType swf_flex_token waiting_type Waiting Type
waitingNode swf_flex_token waiting_node Workflow Step
waitingId swf_flex_token waiting_id Work Item ID
lastNode swf_flex_token last_node Workflow Step
clientNULLasupdateDateZonlo
clientNULLasupdateTimeZonlo
update_ts swf_flex_token update_ts Time Stamp

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_Flex_Sddl_Tokens.
-- 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: SWF_V_TOKENS
-- Parameters: timeZoneUpdate : tznzone

CREATE VIEW Swf_Flex_Sddl_Tokens AS
SELECT
  swf_flex_token.wf_id AS wf_id,
  swf_flex_token.token_id AS tokenIdentifier,
  swf_flex_token.split_id AS splitIdentifier,
  swf_flex_token.waiting_type AS waitingType,
  swf_flex_token.waiting_node AS waitingNode,
  swf_flex_token.waiting_id AS waitingId,
  swf_flex_token.last_node AS lastNode,
  tstmp_to_dats( swf_flex_token.update_ts, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as updateDateZonlo AS clientNULLasupdateDateZonlo,
  tstmp_to_tims( swf_flex_token.update_ts, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as updateTimeZonlo AS clientNULLasupdateTimeZonlo,
  swf_flex_token.update_ts AS update_ts
FROM swf_flex_token
;