CDS_VIEW_FIRST_REFERENCE

CDS View

Returns First View Reference

CDS_VIEW_FIRST_REFERENCE is a CDS View in S/4HANA. Returns First View Reference. It contains 4 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
Accessible_Views view inner Accessible views(START auth checked)
Accessible_Views_Comp view inner Accessible Views - S_RS_COMP validation
BOC_STORY_AUTHORIZED_QUERIES view inner BOC Story : List of Authorized Queries
Cds_View view left_outer List of CDS View based on App Type

Fields (4)

KeyField CDS FieldsUsed in Views
CreferredObject SQLAnalyticalView 2
CSQLViewName CSQLViewName,SQLAnalyticalQuery 3
ReferredObjectDDLSourceName ReferredObjectDDLSourceName 1
SqlViewName SqlViewName 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Returns First View Reference
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CDS_VIEW_FIRST_REFERENCE (
    CREFERREDOBJECT,
    CSQLVIEWNAME,
    REFERREDOBJECTDDLSOURCENAME,
    SQLVIEWNAME
);