P_Facvd_Wf_Task_Max_Timestamp

DDL: P_FACVD_WF_TASK_MAX_TIMESTAMP SQL: PWFTASKTS Type: view BASIC
2 Fields 3 Data Sources

P_Facvd_Wf_Task_Max_Timestamp is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (vbkpf, sww_wi2obj, swwwihead) and exposes 2 fields with key field wi_id.

Data Sources (3)

SourceAliasJoin Type
vbkpf _doc from
sww_wi2obj _wi2obj inner
swwwihead task inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PWFTASKTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY wi_id swwwihead top_wi_id Top Level Workflow
timestamp

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 P_Facvd_Wf_Task_Max_Timestamp.
-- 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: PWFTASKTS

CREATE VIEW P_Facvd_Wf_Task_Max_Timestamp AS
SELECT
  task.top_wi_id AS wi_id,
  cast( max( task.crea_tmp ) as swfrcrets ) AS timestamp
FROM vbkpf AS _doc
INNER JOIN sww_wi2obj AS _wi2obj ON /* join condition not captured in parsed metadata */
INNER JOIN swwwihead AS task ON /* join condition not captured in parsed metadata */
;

Learn More