I_SAIS_GAF_User

DDL: I_SAIS_GAF_USER Type: view_entity
8 Fields 1 Data Sources 1 Associations

User Assigments for Filters

I_SAIS_GAF_User is a CDS View that provides data about "User Assigments for Filters" in SAP S/4HANA. It reads from 1 data source (sais_gaf_user) and exposes 8 fields with key fields UserName, FilterName. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
sais_gaf_user User from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SAIS_GAF_FILTER_TEXT _FilterText $projection.FilterName = _FilterText.Filter and _FilterText.LanguageCode = $session.system_language

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label User Assigments for Filters view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY UserName bname User name
KEY FilterName filter KPI Filter
Description _FilterText Description Well Code Des.
AssignmentStatus status Workflow Status
CreatedBy created_by Version Created By
CreatedAt created_at Uploaded On
LastChangedBy changed_by User Name
LastChangedAt changed_at 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 I_SAIS_GAF_User.
-- 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.

CREATE VIEW I_SAIS_GAF_User AS
SELECT
  bname AS UserName,
  filter AS FilterName,
  _FilterText.Description AS Description,
  status AS AssignmentStatus,
  created_by AS CreatedBy,
  created_at AS CreatedAt,
  changed_by AS LastChangedBy,
  changed_at AS LastChangedAt
FROM sais_gaf_user AS User
LEFT OUTER JOIN I_SAIS_GAF_FILTER_TEXT AS _FilterText ON FilterName = _FilterText.Filter AND _FilterText.LanguageCode = $session.system_language  -- association [0..1]
;

Learn More