P_SAIS_GAF_SEL

DDL: P_SAIS_GAF_SEL SQL: PSAISGAFSEL Type: view
6 Fields 2 Data Sources

Generic Audit Filter - Value List for DOBJ

P_SAIS_GAF_SEL is a CDS View that provides data about "Generic Audit Filter - Value List for DOBJ" in SAP S/4HANA. It reads from 2 data sources (sais_gaf_dobj, sais_gaf_filt) and exposes 6 fields with key fields filter, field, low.

Data Sources (2)

SourceAliasJoin Type
sais_gaf_dobj dobj inner
sais_gaf_filt filt from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PSAISGAFSEL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Generic Audit Filter - Value List for DOBJ view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY filter sais_gaf_filt filter KPI Filter
KEY field sais_gaf_filt field Logical Field
KEY low sais_gaf_filt low Value from
high sais_gaf_filt high Value up to
dobj sais_gaf_dobj dobj Injured person
dobj_fld sais_gaf_dobj dobj_fld Field Name

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 P_SAIS_GAF_SEL.
-- 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: PSAISGAFSEL

CREATE VIEW P_SAIS_GAF_SEL AS
SELECT
  filt.filter AS filter,
  filt.field AS field,
  filt.low AS low,
  filt.high AS high,
  dobj.dobj AS dobj,
  dobj.dobj_fld AS dobj_fld
FROM sais_gaf_filt AS filt
INNER JOIN sais_gaf_dobj AS dobj ON /* join condition not captured in parsed metadata */
;

Learn More