QB_VIEW_CROSSREFERENCE

DDL: QB_VIEW_CROSSREFERENCE SQL: QBVIEWCROSSREF Type: view
6 Fields 1 Data Sources

CDS View CrossReference

QB_VIEW_CROSSREFERENCE is a CDS View that provides data about "CDS View CrossReference" in SAP S/4HANA. It reads from 1 data source (Qb_PrimaryDataSourceAll) and exposes 6 fields with key fields SQLViewName, ReferredObject, ViewPosition.

Data Sources (1)

SourceAliasJoin Type
Qb_PrimaryDataSourceAll dd26s from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName QBVIEWCROSSREF view
EndUserText.label CDS View CrossReference view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SQLViewName Qb_PrimaryDataSourceAll SQLViewName View Name
KEY ReferredObject Qb_PrimaryDataSourceAll ReferredObject Basis Table
KEY ViewPosition Qb_PrimaryDataSourceAll ViewPosition Position in a repetition group
ReferredObjectDDLSourceName Qb_PrimaryDataSourceAll ReferredObjectDDLSourceName DDL Source Name
CSQLViewName Qb_PrimaryDataSourceAll SQLViewName View Name
CReferredObject Qb_PrimaryDataSourceAll ReferredObject Basis Table

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 QB_VIEW_CROSSREFERENCE.
-- 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: QBVIEWCROSSREF

CREATE VIEW QB_VIEW_CROSSREFERENCE AS
SELECT
  dd26s.SQLViewName AS SQLViewName,
  dd26s.ReferredObject AS ReferredObject,
  dd26s.ViewPosition AS ViewPosition,
  dd26s.ReferredObjectDDLSourceName AS ReferredObjectDDLSourceName,
  dd26s.SQLViewName AS CSQLViewName,
  dd26s.ReferredObject AS CReferredObject
FROM Qb_PrimaryDataSourceAll AS dd26s
;

Learn More