cross_references

DDL: CROSS_REFERENCES SQL: CROSS_REF_V Type: view
31 Fields 10 Data Sources

Where Used Index

cross_references is a CDS View that provides data about "Where Used Index" in SAP S/4HANA. It reads from 10 data sources and exposes 31 fields with key fields otype, name, include, state, name.

Data Sources (10)

SourceAliasJoin Type
cross_v cross_v union_all
cross_v cross_v union_all
sedt_bdef sedt_bdef left_outer
wbcrossgt wbcrossgt left_outer
wbcrossgt wbcrossgt union_all
wbcrossgti wbcrossgti left_outer
wbcrossgti wbcrossgti union_all
wbcrossgtx wbcrossgtx from
wbcrossgtx wbcrossgtx union_all
wbcrossi wbcrossi union_all

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName CROSS_REF_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Where Used Index view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY otype wbcrossgt otype Type of Val.
KEY name wbcrossgt name Zone name
KEY include wbcrossgt include
KEY state Vehicle Region
fullname wbcrossgtx long_name
otype Type of Val.
KEY name wbcrossgti name Zone name
KEY include wbcrossgti include
KEY state Vehicle Region
fullname wbcrossgtx long_name
KEY name name Zone name
KEY include include
KEY state Vehicle Region
KEY name name Zone name
KEY include include
KEY state Vehicle Region
KEY name name Zone name
KEY include include
KEY state state Vehicle Region
grade
KEY name cross_v name Zone name
KEY include cross_v include
KEY state cross_v state Vehicle Region
grade
fullname
KEY name name Zone name
KEY include include
KEY state state Vehicle Region
grade
fullname
refs refs

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_references.
-- 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_REF_V

CREATE VIEW cross_references AS
SELECT
  wbcrossgt.otype AS otype,
  wbcrossgt.name AS name,
  wbcrossgt.include AS include,
  ' ' AS state,
  wbcrossgtx.long_name AS fullname,
  '1' AS grade,
  refs
FROM wbcrossgtx
LEFT OUTER JOIN wbcrossgt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN wbcrossgti ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sedt_bdef ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): wbcrossgtx, wbcrossgt, wbcrossgti, cross_v, wbcrossi
;

Learn More