s_ddl_programs_descriptions

DDL: S_DDL_PROGRAMS_DESCRIPTIONS SQL: S_V_PROG_DESCR Type: view Package: SA38
5 Fields 4 Data Sources

View on programs with descriptions

s_ddl_programs_descriptions is a CDS View that provides data about "View on programs with descriptions" in SAP S/4HANA. It reads from 4 data sources (trdir, trdir, trdirt, trdirt) and exposes 5 fields with key field name. Part of development package SA38.

Data Sources (4)

SourceAliasJoin Type
trdir trdir from
trdir trdir union
trdirt trdirt left_outer
trdirt trdirt left_outer

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName S_V_PROG_DESCR view
EndUserText.label View on programs with descriptions view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY name trdir name Zone name
language trdirt sprsl Language Code
nameasname
language Language Code
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 s_ddl_programs_descriptions.
-- 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: S_V_PROG_DESCR

CREATE VIEW s_ddl_programs_descriptions AS
SELECT
  trdir.name AS name,
  trdirt.sprsl AS language,
  trdirt.text as description AS nameasname,
  trdirt.text AS description
FROM trdir
LEFT OUTER JOIN trdirt ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): trdir
;

Learn More