SDraft_Expy_Rel

DDL: SDRAFT_EXPY_REL SQL: VRAFT_EXPY_REL Type: view

Relative Draft Expiry

SDraft_Expy_Rel is a CDS View that provides data about "Relative Draft Expiry" in SAP S/4HANA. It reads from 1 data source (SDraft_Configuration_Client) and exposes 7 fields.

Data Sources (1)

SourceAliasJoin Type
SDraft_Configuration_Client SDraft_Configuration_Client from

Parameters (3)

NameTypeDefault
p_expiry_event sdraft_expiry_event
p_current_time timestampl
p_global_token sdraft_entity_name

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName VRAFT_EXPY_REL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Relative Draft Expiry view

Fields (7)

KeyFieldSource TableSource FieldDescription
draft_entity Admin draft_entity Entity Name
draft_key Admin draft_key UUID
access_type Admin access_type Draft Access Type
client Admin client Workflow definition: Client
created_at Admin created_at Uploaded On
created_by Admin created_by Version Created By
kept_by_user Admin kept_by_user Draft Is Kept By User

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 SDraft_Expy_Rel.
-- 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: VRAFT_EXPY_REL
-- Parameters: p_expiry_event : sdraft_expiry_event, p_current_time : timestampl, p_global_token : sdraft_entity_name

CREATE VIEW SDraft_Expy_Rel AS
SELECT
  Admin.draft_entity AS draft_entity,
  Admin.draft_key AS draft_key,
  Admin.access_type AS access_type,
  Admin.client AS client,
  Admin.created_at AS created_at,
  Admin.created_by AS created_by,
  Admin.kept_by_user AS kept_by_user
FROM SDraft_Configuration_Client
;