SAIS_GAF_INFO_USR_SIMPLE

DDL: SAIS_GAF_INFO_USR_SIMPLE Type: view_entity Package: SAIS_GAF

GAF Info: Users with Filters and Matching Data Objects

SAIS_GAF_INFO_USR_SIMPLE is a CDS View that provides data about "GAF Info: Users with Filters and Matching Data Objects" in SAP S/4HANA. It reads from 3 data sources (sais_gaf_dobj, SAIS_GAF_FILT_VALUE, SAIS_GAF_USER_LIST) and exposes 6 fields with key fields Bname, Filter, Lfield, dobj. Part of development package SAIS_GAF.

Data Sources (3)

SourceAliasJoin Type
sais_gaf_dobj dobj inner
SAIS_GAF_FILT_VALUE f_detail inner
SAIS_GAF_USER_LIST x from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label GAF Info: Users with Filters and Matching Data Objects view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Bname SAIS_GAF_USER_LIST Bname User name
KEY Filter SAIS_GAF_USER_LIST Filter KPI Filter
KEY Lfield SAIS_GAF_FILT_VALUE Field Logical Field
KEY dobj sais_gaf_dobj dobj Injured person
Status SAIS_GAF_USER_LIST Status Workflow Status
Status_I SAIS_GAF_USER_LIST Status_I

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 SAIS_GAF_INFO_USR_SIMPLE.
-- 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 SAIS_GAF_INFO_USR_SIMPLE AS
SELECT
  x.Bname AS Bname,
  x.Filter AS Filter,
  f_detail.Field AS Lfield,
  dobj.dobj AS dobj,
  x.Status AS Status,
  x.Status_I AS Status_I
FROM SAIS_GAF_USER_LIST AS x
INNER JOIN SAIS_GAF_FILT_VALUE AS f_detail ON /* join condition not captured in parsed metadata */
INNER JOIN sais_gaf_dobj AS dobj ON /* join condition not captured in parsed metadata */
;