SAIS_TDDAT_MAINT

DDL: SAIS_TDDAT_MAINT SQL: SAIS_TDDATMAINT Type: view

Maintenance Authorization Groups for Tables and Views

SAIS_TDDAT_MAINT is a CDS View that provides data about "Maintenance Authorization Groups for Tables and Views" in SAP S/4HANA. It reads from 3 data sources (SAIS_TDDAT_MAINT_VIEW, SAIS_TDDAT_MAINT_STOB, SAIS_TDDAT_MAINT_TABL) and exposes 40 fields with key field tabname.

Data Sources (3)

SourceAliasJoin Type
SAIS_TDDAT_MAINT_VIEW ddic_view union
SAIS_TDDAT_MAINT_STOB stob union
SAIS_TDDAT_MAINT_TABL tabl from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SAIS_TDDATMAINT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Authorization Groups for Tables and Views view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY tabname SAIS_TDDAT_MAINT_TABL tabname Table/Constant Value
dobj_type Source type
cclass SAIS_TDDAT_MAINT_TABL cclass Class
bezei SAIS_TDDAT_MAINT_TABL bezei TrContType name
sap_cclass SAIS_TDDAT_MAINT_TABL sap_cclass SAP default
tabclass SAIS_TDDAT_MAINT_TABL tabclass Table Category
ddlanguage SAIS_TDDAT_MAINT_TABL ddlanguage Lang.
ddtext SAIS_TDDAT_MAINT_TABL ddtext Short text
devclass SAIS_TDDAT_MAINT_TABL devclass Package (Obsolete)
dlvunit SAIS_TDDAT_MAINT_TABL dlvunit Softw. Comp.
ps_posid SAIS_TDDAT_MAINT_TABL ps_posid WBS Element
mainflag SAIS_TDDAT_MAINT_TABL mainflag Table Maintenance
clidep SAIS_TDDAT_MAINT_TABL clidep Client-specific
masterlang SAIS_TDDAT_MAINT_TABL masterlang Single-Character Flag
dobj_type SAIS_TDDAT_MAINT_VIEW dobj_type Source type
cclass SAIS_TDDAT_MAINT_VIEW cclass Class
bezei SAIS_TDDAT_MAINT_VIEW bezei TrContType name
sap_cclass SAIS_TDDAT_MAINT_VIEW sap_cclass SAP default
tabclass SAIS_TDDAT_MAINT_VIEW tabclass Table Category
ddlanguage SAIS_TDDAT_MAINT_VIEW ddlanguage Lang.
ddtext SAIS_TDDAT_MAINT_VIEW ddtext Short text
devclass SAIS_TDDAT_MAINT_VIEW devclass Package (Obsolete)
dlvunit SAIS_TDDAT_MAINT_VIEW dlvunit Softw. Comp.
ps_posid SAIS_TDDAT_MAINT_VIEW ps_posid WBS Element
mainflag SAIS_TDDAT_MAINT_VIEW mainflag Table Maintenance
clidep SAIS_TDDAT_MAINT_VIEW clidep Client-specific
masterlang SAIS_TDDAT_MAINT_VIEW masterlang Single-Character Flag
dobj_type Source type
cclass SAIS_TDDAT_MAINT_STOB cclass Class
bezei SAIS_TDDAT_MAINT_STOB bezei TrContType name
sap_cclass SAIS_TDDAT_MAINT_STOB sap_cclass SAP default
tabclass SAIS_TDDAT_MAINT_STOB tabclass Table Category
ddlanguage SAIS_TDDAT_MAINT_STOB ddlanguage Lang.
ddtext SAIS_TDDAT_MAINT_STOB ddtext Short text
devclass SAIS_TDDAT_MAINT_STOB devclass Package (Obsolete)
dlvunit SAIS_TDDAT_MAINT_STOB dlvunit Softw. Comp.
ps_posid SAIS_TDDAT_MAINT_STOB ps_posid WBS Element
mainflag SAIS_TDDAT_MAINT_STOB mainflag Table Maintenance
clidep SAIS_TDDAT_MAINT_STOB clidep Client-specific
masterlang SAIS_TDDAT_MAINT_STOB masterlang Single-Character Flag

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_TDDAT_MAINT.
-- 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: SAIS_TDDATMAINT

CREATE VIEW SAIS_TDDAT_MAINT AS
SELECT
  tabl.tabname AS tabname,
  cast( 'ABAP Table' as char20 ) AS dobj_type,
  tabl.cclass AS cclass,
  tabl.bezei AS bezei,
  tabl.sap_cclass AS sap_cclass,
  tabl.tabclass AS tabclass,
  tabl.ddlanguage AS ddlanguage,
  tabl.ddtext AS ddtext,
  tabl.devclass AS devclass,
  tabl.dlvunit AS dlvunit,
  tabl.ps_posid AS ps_posid,
  tabl.mainflag AS mainflag,
  tabl.clidep AS clidep,
  tabl.masterlang AS masterlang
FROM SAIS_TDDAT_MAINT_TABL AS tabl
-- UNION with additional select branch(es): SAIS_TDDAT_MAINT_VIEW, SAIS_TDDAT_MAINT_STOB
;