DD_OBJECT_MAINFLAG

DDL: DD_OBJECT_MAINFLAG Type: view_entity
12 Fields 4 Data Sources 3 Associations

Maintenance Flag for Tables and Views

DD_OBJECT_MAINFLAG is a CDS View that provides data about "Maintenance Flag for Tables and Views" in SAP S/4HANA. It reads from 4 data sources (dd02l, dd02b, tadir, tadir) and exposes 12 fields with key fields tabname, as4local, as4local. It has 3 associations to related views.

Data Sources (4)

SourceAliasJoin Type
dd02l dd02l union
dd02b stob from
tadir tadir inner
tadir tadir inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] dd02bt _text_active _text_active.strucobjn = stob.strucobjn and _text_active.as4local = stob.as4local and _text_active.ddlanguage = $session.system_language -- text English
[0..1] dd02bt _text_english _text_english.strucobjn = stob.strucobjn and _text_english.as4local = stob.as4local and _text_english.ddlanguage = 'E' -- text Original
[0..1] dd02bt _text_original _text_original.strucobjn = stob.strucobjn and _text_original.as4local = stob.as4local and _text_original.ddlanguage = tadir.masterlang

Annotations (3)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Flag for Tables and Views view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY tabname Object Name
KEY as4local dd02b as4local State
tabclass Object category
ddlanguage Language Key
ddtext Short Description of Repository Objects
mainflag dd02b mainflag Maintenance with standard tools allowed
KEY as4local dd02l as4local Activation State
tabclass dd02l tabclass Table Category
ddlanguage
ddtext
mainflag dd02l mainflag Table Maintenance
clidep dd02l clidep Client-specific

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 DD_OBJECT_MAINFLAG.
-- 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 DD_OBJECT_MAINFLAG AS
SELECT
  cast(stob.strucobjn as tabname) AS tabname,
  stob.as4local AS as4local,
  cast( 'VIEW' as abap.char(8)) AS tabclass,
  coalesce( coalesce( _text_active.ddlanguage, _text_english.ddlanguage ), _text_original.ddlanguage ) AS ddlanguage,
  coalesce( coalesce( _text_active.ddtext, _text_english.ddtext ), _text_original.ddtext ) AS ddtext,
  stob.mainflag AS mainflag,
  dd02l.clidep AS clidep
FROM dd02b AS stob
INNER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02bt AS _text_active ON _text_active.strucobjn = stob.strucobjn AND _text_active.as4local = stob.as4local AND _text_active.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN dd02bt AS _text_english ON _text_english.strucobjn = stob.strucobjn AND _text_english.as4local = stob.as4local AND _text_english.ddlanguage = 'E'  -- association [0..1]
LEFT OUTER JOIN dd02bt AS _text_original ON _text_original.strucobjn = stob.strucobjn AND _text_original.as4local = stob.as4local AND _text_original.ddlanguage = tadir.masterlang  -- association [0..1]
-- UNION with additional select branch(es): dd02l
;

Learn More