I_WorkflowTaskURLConfigBase

DDL: I_WORKFLOWTASKURLCONFIGBASE Type: view BASIC

Workflow work item URL configuration

I_WorkflowTaskURLConfigBase is a Basic CDS View that provides data about "Workflow work item URL configuration" in SAP S/4HANA. It reads from 1 data source (swp_url_config) and exposes 7 fields with key field id.

Data Sources (1)

SourceAliasJoin Type
swp_url_config swp_url_config from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWRKFLWTSKURLCFB view
AbapCatalog.buffering.type #NONE view
EndUserText.label Workflow work item URL configuration view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
char525asBaseURL
char1asBaseURLHasQueryParameter
SAPClient flp_client Client
char104asIntentRoute
char121asIntentRoutePrefix
char121asIntentRouteSuffix

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 I_WorkflowTaskURLConfigBase.
-- 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 I_WorkflowTaskURLConfigBase AS
SELECT
  id,
  cast( case when swp_url_config.port is not initial then concat(swp_url_config.protocol, concat(': concat(swp_url_config.host, concat(':', concat(swp_url_config.port, swp_url_config.flp_alias) ) ) ) ) else concat(swp_url_config.protocol, concat(': concat(swp_url_config.host, swp_url_config.flp_alias) ) ) end as abap.char( 525 ) ) as BaseURL AS char525asBaseURL,
  cast( case instr(swp_url_config.flp_alias, '?') when 0 then ' ' else 'X' end as abap.char(1) ) as BaseURLHasQueryParameter AS char1asBaseURLHasQueryParameter,
  flp_client AS SAPClient,
  cast( replace( '&/detail_deep/%param%/%wiid%/TaskCollection(SAP__Origin=''%param%'',InstanceID=''%wiid%'')', '%param%', swp_url_config.param ) as abap.char(104) ) as IntentRoute AS char104asIntentRoute,
  cast( case when swp_url_config.route_prefix is not initial then concat(swp_url_config.route_prefix, '&') else '' end as abap.char(121) ) as IntentRoutePrefix AS char121asIntentRoutePrefix,
  cast( case when swp_url_config.route_suffix is not initial then concat('&', swp_url_config.route_suffix) else '' end as abap.char(121) ) as IntentRouteSuffix AS char121asIntentRouteSuffix
FROM swp_url_config
;