sedt_ddl_programs_view

DDL: SEDT_DDL_PROGRAMS_VIEW SQL: SEDT_PROG_VIEW Type: view
3 Fields 3 Data Sources

Available programs with shorttext

sedt_ddl_programs_view is a CDS View that provides data about "Available programs with shorttext" in SAP S/4HANA. It reads from 3 data sources (sedt_program, t002, trdirt) and exposes 3 fields with key field name.

Data Sources (3)

SourceAliasJoin Type
sedt_program sedt_program from
t002 t002 cross
trdirt trdirt left_outer

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName SEDT_PROG_VIEW view
EndUserText.label Available programs with shorttext view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY name sedt_program name Zone name
language t002 spras Off. Language
description trdirt text User Group

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 sedt_ddl_programs_view.
-- 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: SEDT_PROG_VIEW

CREATE VIEW sedt_ddl_programs_view AS
SELECT
  sedt_program.name AS name,
  t002.spras AS language,
  trdirt.text AS description
FROM sedt_program
CROSS JOIN t002
LEFT OUTER JOIN trdirt ON /* join condition not captured in parsed metadata */
;

Learn More