P_SAIS_GAF_DOBJ_LIST

DDL: P_SAIS_GAF_DOBJ_LIST SQL: PSAISGAFDOBJLIST Type: view Package: SAIS_GAF
4 Fields 2 Data Sources

Generic Audit Filter - Show SAIS_GAF_DOBJ in Dialog

P_SAIS_GAF_DOBJ_LIST is a CDS View that provides data about "Generic Audit Filter - Show SAIS_GAF_DOBJ in Dialog" in SAP S/4HANA. It reads from 2 data sources (sais_gaf_dobj, tadir) and exposes 4 fields with key fields dobj, dobj_fld, field. Part of development package SAIS_GAF.

Data Sources (2)

SourceAliasJoin Type
sais_gaf_dobj dobj from
tadir gado left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PSAISGAFDOBJLIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Generic Audit Filter - Show SAIS_GAF_DOBJ in Dialog view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY dobj sais_gaf_dobj dobj Injured person
KEY dobj_fld sais_gaf_dobj dobj_fld Field Name
KEY field sais_gaf_dobj field Logical Field
field_de

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_DOBJ_LIST.
-- 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: PSAISGAFDOBJLIST

CREATE VIEW P_SAIS_GAF_DOBJ_LIST AS
SELECT
  dobj.dobj AS dobj,
  dobj.dobj_fld AS dobj_fld,
  dobj.field AS field,
  coalesce( flds.rollname , '' ) AS field_de
FROM sais_gaf_dobj AS dobj
LEFT OUTER JOIN tadir AS gado ON /* join condition not captured in parsed metadata */
;

Learn More