P_FirstApproval

DDL: P_FIRSTAPPROVAL SQL: PFIRSTAPPR Type: view COMPOSITE
1 Fields 1 Data Sources

P_FirstApproval is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_WorkflowTaskCustomAttribute) and exposes 1 field with key field workitem_id.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTaskCustomAttribute wf_attr from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFIRSTAPPR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY workitem_id WorkflowTaskInternalID Work Item ID

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_FirstApproval.
-- 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: PFIRSTAPPR

CREATE VIEW P_FirstApproval AS
SELECT
  WorkflowTaskInternalID AS workitem_id
FROM I_WorkflowTaskCustomAttribute AS wf_attr
;

Learn More