suim_get_tables

DDL: SUIM_GET_TABLES Type: view_entity
9 Fields 2 Data Sources 3 Associations

SUIM | Get Table List for Output

suim_get_tables is a CDS View that provides data about "SUIM | Get Table List for Output" in SAP S/4HANA. It reads from 2 data sources (SAIS_WBO, dd02l) and exposes 9 fields with key field tabname. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
SAIS_WBO _wbo left_outer
dd02l x from

Associations (3)

CardinalityTargetAliasCondition
[0..1] SAIS_TDDAT _tddat x.tabname = _tddat.tabname
[0..1] dd02t _tx_s ( _tx_s.tabname = x.tabname and _tx_s.as4local = x.as4local and _tx_s.ddlanguage = $session.system_language )
[0..1] dd02t _tx_m ( _tx_m.tabname = x.tabname and _tx_m.as4local = x.as4local and _tx_m.ddlanguage = x.masterlang )

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label SUIM | Get Table List for Output view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY tabname dd02l tabname Table/Constant Value
ddtext
cclass _tddat cclass Class
tabclass dd02l tabclass Table Category
clidepXthenelseendasclidep
Contflag dd02l contflag Delivery class
devc SAIS_WBO devclass Package (Obsolete)
dlvunit SAIS_WBO dlvunit Softw. Comp.
ps_posid SAIS_WBO ps_posid WBS Element

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 suim_get_tables.
-- 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 suim_get_tables AS
SELECT
  x.tabname AS tabname,
  coalesce( _tx_s.ddtext , _tx_m.ddtext ) AS ddtext,
  _tddat.cclass AS cclass,
  x.tabclass AS tabclass,
  case when x.clidep = 'X' then '' else '' end as clidep AS clidepXthenelseendasclidep,
  x.contflag AS Contflag,
  _wbo.devclass AS devc,
  _wbo.dlvunit AS dlvunit,
  _wbo.ps_posid AS ps_posid
FROM dd02l AS x
LEFT OUTER JOIN SAIS_WBO AS _wbo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SAIS_TDDAT AS _tddat ON x.tabname = _tddat.tabname  -- association [0..1]
LEFT OUTER JOIN dd02t AS _tx_s ON ( _tx_s.tabname = x.tabname AND _tx_s.as4local = x.as4local AND _tx_s.ddlanguage = $session.system_language )  -- association [0..1]
LEFT OUTER JOIN dd02t AS _tx_m ON ( _tx_m.tabname = x.tabname AND _tx_m.as4local = x.as4local AND _tx_m.ddlanguage = x.masterlang )  -- association [0..1]
;

Learn More