Qb_PrimaryDSNonCube

DDL: QB_PRIMARYDSNONCUBE SQL: QBNONCUBE Type: view
4 Fields 2 Data Sources

Primary Data Source of all Non Cubes

Qb_PrimaryDSNonCube is a CDS View that provides data about "Primary Data Source of all Non Cubes" in SAP S/4HANA. It reads from 2 data sources (dd26s, CDS_VIEW_NONCUBES) and exposes 4 fields with key field SQLViewName.

Data Sources (2)

SourceAliasJoin Type
dd26s dd26s from
CDS_VIEW_NONCUBES noncubes inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName QBNONCUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Primary Data Source of all Non Cubes view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SQLViewName dd26s viewname View Name
ReferredObject dd26s tabname Table/Constant Value
ViewPosition dd26s tabpos Position in a repetition group
ReferredObjectDDLSourceName CDS_VIEW_NONCUBES DDLSourceName DDL Source Name

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_PrimaryDSNonCube.
-- 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: QBNONCUBE

CREATE VIEW Qb_PrimaryDSNonCube AS
SELECT
  dd26s.viewname AS SQLViewName,
  dd26s.tabname AS ReferredObject,
  dd26s.tabpos AS ViewPosition,
  noncubes.DDLSourceName AS ReferredObjectDDLSourceName
FROM dd26s
INNER JOIN CDS_VIEW_NONCUBES AS noncubes ON /* join condition not captured in parsed metadata */
;

Learn More