SAIS_GAF_USER_F4

DDL: SAIS_GAF_USER_F4 Type: view_entity
7 Fields 4 Data Sources 1 Associations

GAF Value Help for Users

SAIS_GAF_USER_F4 is a CDS View that provides data about "GAF Value Help for Users" in SAP S/4HANA. It reads from 4 data sources (P_UserAddress002, P_UserAddress002, SAIS_GAF_USER_F4_X, SAIS_GAF_USER_F4_X) and exposes 7 fields with key field Bname. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
P_UserAddress002 adr inner
P_UserAddress002 adr inner
SAIS_GAF_USER_F4_X x from
SAIS_GAF_USER_F4_X x union

Associations (1)

CardinalityTargetAliasCondition
[0..1] usrefus usref usref.bname = x.bname

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label GAF Value Help for Users view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Bname SAIS_GAF_USER_F4_X bname User name
full_name P_UserAddress002 NAME_TEXTC Full Name
mail P_UserAddress002 smtp_addr E-Mail Address
bnameasBname
full_name P_UserAddress002 NAME_TEXTC Full Name
mail P_UserAddress002 smtp_addr E-Mail Address
idadtype P_UserAddress002 idadtype Identity Add. Type

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_USER_F4.
-- 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_USER_F4 AS
SELECT
  x.bname AS Bname,
  adr.NAME_TEXTC AS full_name,
  adr.smtp_addr AS mail,
  adr.idadtype AS bnameasBname,
  adr.idadtype AS idadtype
FROM SAIS_GAF_USER_F4_X AS x
INNER JOIN P_UserAddress002 AS adr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usrefus AS usref ON usref.bname = x.bname  -- association [0..1]
-- UNION with additional select branch(es): SAIS_GAF_USER_F4_X
;

Learn More