P_ReturnedApproval

DDL: P_RETURNEDAPPROVAL SQL: PRETURNEDAPPR Type: view COMPOSITE Package: ODATA_BANK_PAYMENT_APPROVAL
1 Fields 1 Data Sources

Workitem with returned approval info

P_ReturnedApproval is a Composite CDS View that provides data about "Workitem with returned approval info" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTaskCustomAttribute) and exposes 1 field with key field workitem_id. Part of development package ODATA_BANK_PAYMENT_APPROVAL.

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTaskCustomAttribute wf_attr from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRETURNEDAPPR 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_ReturnedApproval.
-- 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: PRETURNEDAPPR

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

Learn More