cross_relation

DDL: CROSS_RELATION SQL: CROSS_RELATION_V Type: view

Source code relations to used objects

cross_relation is a CDS View that provides data about "Source code relations to used objects" in SAP S/4HANA. It reads from 7 data sources and exposes 7 fields.

Data Sources (7)

SourceAliasJoin Type
cross_tadir cross_tadir union_all
dd02l dd02l left_outer
ddtypes ddtypes left_outer
wbcrossgt_raw relation from
wbcrossgt_raw relation union_all
sedt_bdef sedt_bdef left_outer
sedt_type type_groups left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CROSS_RELATION_V view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Source code relations to used objects view

Fields (7)

KeyFieldSource TableSource FieldDescription
include wbcrossgt_raw include
fullname wbcrossgt_raw fullname Name
fullname Name
used_object sedt_type type_group_name Zone name
fullname fullname Name
used_object name Zone name
used_type tadir_type

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 cross_relation.
-- 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: CROSS_RELATION_V

CREATE VIEW cross_relation AS
SELECT
  relation.include AS include,
  relation.fullname AS fullname,
  type_groups.type_group_name AS used_object,
  tadir_type AS used_type
FROM wbcrossgt_raw AS relation
LEFT OUTER JOIN ddtypes ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sedt_bdef ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sedt_type AS type_groups ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): wbcrossgt_raw, cross_tadir
;