c_sais_gaf_filter_assign

DDL: C_SAIS_GAF_FILTER_ASSIGN Type: view_entity
16 Fields 1 Data Sources

Projection on Filter Assignments

c_sais_gaf_filter_assign is a CDS View that provides data about "Projection on Filter Assignments" in SAP S/4HANA. It reads from 1 data source (I_SAIS_gaf_filter_assign) and exposes 16 fields with key fields UserName, FilterName.

Data Sources (1)

SourceAliasJoin Type
I_SAIS_gaf_filter_assign I_SAIS_gaf_filter_assign projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Projection on Filter Assignments view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY UserName UserName User who owns item
KEY FilterName FilterName KPI Filter
Description Description Well Code Des.
Status Status Workflow Status
StatusText StatusText User Group
StatusCriticality StatusCriticality
CreatedBy CreatedBy User Name
CreatedAt CreatedAt Time Stamp
ChangedBy ChangedBy User Name
ChangedAt ChangedAt Time Stamp
_User _User
FullName _User FullName Name
UserAlias _User UserAlias Alias
UserDescription _User UserDescription Full Name
Email _User EMail Rec. Doc. per e-Mail
UserGroup _User UserGroup User Group

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 c_sais_gaf_filter_assign.
-- 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 c_sais_gaf_filter_assign AS
SELECT
  UserName,
  FilterName,
  Description,
  Status,
  StatusText,
  StatusCriticality,
  CreatedBy,
  CreatedAt,
  ChangedBy,
  ChangedAt,
  _User.FullName AS FullName,
  _User.UserAlias AS UserAlias,
  _User.UserDescription AS UserDescription,
  _User.EMail AS Email,
  _User.UserGroup AS UserGroup
FROM I_SAIS_gaf_filter_assign
;

Learn More