P_Facvd_Ver_Diag_Max_Timestamp

DDL: P_FACVD_VER_DIAG_MAX_TIMESTAMP SQL: PFIDIAGTS Type: view BASIC Package: ODATA_GL_JOURNALENTRY_VER

Workflow Latest Dialog timestamp

P_Facvd_Ver_Diag_Max_Timestamp is a Basic CDS View that provides data about "Workflow Latest Dialog timestamp" in SAP S/4HANA. It reads from 3 data sources (vbkpf, swwwihead, sww_wi2obj) and exposes 3 fields with key field Workflow. Part of development package ODATA_GL_JOURNALENTRY_VER.

Data Sources (3)

SourceAliasJoin Type
vbkpf _doc from
swwwihead _head inner
sww_wi2obj _wi2obj inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFIDIAGTS 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 (3)

KeyFieldSource TableSource FieldDescription
KEY Workflow swwwihead top_wi_id Top Level Workflow
instid sww_wi2obj instid Instance ID
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_Ver_Diag_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: PFIDIAGTS

CREATE VIEW P_Facvd_Ver_Diag_Max_Timestamp AS
SELECT
  _head.top_wi_id AS Workflow,
  _wi2obj.instid AS instid,
  cast( max( _head.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 _head ON /* join condition not captured in parsed metadata */
;