ris_ddl_tadir

DDL: RIS_DDL_TADIR SQL: RIS_V_DDL_TADIR Type: view

DDL Sources and TADIR information

ris_ddl_tadir is a CDS View that provides data about "DDL Sources and TADIR information" in SAP S/4HANA. It reads from 2 data sources (ddddlsrc, tadir) and exposes 11 fields.

Data Sources (2)

SourceAliasJoin Type
ddddlsrc ddddlsrc from
tadir tadir inner

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName RIS_V_DDL_TADIR view
EndUserText.label DDL Sources and TADIR information view

Fields (11)

KeyFieldSource TableSource FieldDescription
program_name ddddlsrc ddlname DDL Source Name
state ddddlsrc as4local Activation State
created_by ddddlsrc as4user Person Respons.
changed_by ddddlsrc as4user Person Respons.
object_type tadir object TRFM Object
object_name tadir obj_name Object Name
devclass tadir devclass Package (Obsolete)
component tadir component Softw. Comp.
srcsystem tadir srcsystem Source system
responsible tadir author User Name
source ddddlsrc source ViolationSource

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 ris_ddl_tadir.
-- 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: RIS_V_DDL_TADIR

CREATE VIEW ris_ddl_tadir AS
SELECT
  ddddlsrc.ddlname AS program_name,
  ddddlsrc.as4local AS state,
  ddddlsrc.as4user AS created_by,
  ddddlsrc.as4user AS changed_by,
  tadir.object AS object_type,
  tadir.obj_name AS object_name,
  tadir.devclass AS devclass,
  tadir.component AS component,
  tadir.srcsystem AS srcsystem,
  tadir.author AS responsible,
  ddddlsrc.source AS source
FROM ddddlsrc
INNER JOIN tadir ON /* join condition not captured in parsed metadata */
;