sais_scan_abap_tabl

DDL: SAIS_SCAN_ABAP_TABL SQL: SAISSCANABAPTABL Type: view
4 Fields 1 Data Sources

AIS - Search Programs with Changing Table Access

sais_scan_abap_tabl is a CDS View that provides data about "AIS - Search Programs with Changing Table Access" in SAP S/4HANA. It reads from 1 data source (dd02l) and exposes 4 fields with key field tabname.

Data Sources (1)

SourceAliasJoin Type
dd02l dd02l from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName SAISSCANABAPTABL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view
EndUserText.label AIS - Search Programs with Changing Table Access view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY tabname dd02l tabname Table/Constant Value
exist
protokoll dd09 protokoll Log
protokollXthenelseendasprotokoll_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_scan_abap_tabl.
-- 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: SAISSCANABAPTABL

CREATE VIEW sais_scan_abap_tabl AS
SELECT
  dd02l.tabname AS tabname,
  'X' AS exist,
  dd09.protokoll AS protokoll,
  case when dd09.protokoll = 'X' then '' else '' end as protokoll_i AS protokollXthenelseendasprotokoll_i
FROM dd02l
;

Learn More