R_SpecWithInheritanceOrRef

DDL: R_SPECWITHINHERITANCEORREF SQL: RSPCINHREF Type: view COMPOSITE
2 Data Sources

Specifications using inheritance or reference

R_SpecWithInheritanceOrRef is a Composite CDS View that provides data about "Specifications using inheritance or reference" in SAP S/4HANA. It reads from 2 data sources (I_SpecReference, I_SpecValAssgmt).

Data Sources (2)

SourceAliasJoin Type
I_SpecReference I_SpecReference from
I_SpecValAssgmt I_SpecValAssgmt union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName RSPCINHREF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Specifications using inheritance or reference view

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 R_SpecWithInheritanceOrRef.
-- 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: RSPCINHREF

CREATE VIEW R_SpecWithInheritanceOrRef AS
SELECT *  -- field list not available in parsed metadata
FROM I_SpecReference
-- UNION with additional select branch(es): I_SpecValAssgmt
;

Learn More