DD26S

Transparent Table System Table (transport)
8 Fields 18 CDS Views

Base tables and foreign key relationships for a view

DD26S is an SAP database table in S/4HANA. Base tables and foreign key relationships for a view. It contains 8 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
/cfg/cds_Solution view left_outer CDS view for Solution with Parameters
/CFG/V_HASH_DAO view left_outer CDS View for Hashing DAO
/dmbe/i_CDS_Tab_Name view from Base tables and foreign key relationships for a view
/smb/cds_analyze_sol view left_outer CDS view for Solution with Parameters
/SMB/CDS_CCF_SOLDATA view left_outer CDS view for ccf framework
/SMB/CDS_SOL_DATA view left_outer Get solution BBid,subobjectsa andactivities
/SMB/CDS_SOL_DT_S view left_outer Get solution BBid,subobjectsa andactivities
/smb/cds_Solution view left_outer CDS view for Solution with Parameters
ALL_VIEWS_CROSSREFERENCE view from All CDS Views CrossReference
Cds_View_Crossreference view from CDS View CrossReference
DDCDS_BOE_VIEWSTACK_INFO view from View stack heirarchy using entity names
DDCDS_DIRECT_BASE_OBJECTS_V1 view_entity inner Get direct base objects
DDCDS_LIST_DIRECT_BASE_ENTITY view_entity inner List direct base entities
ddddls_viewstack_union view_entity from Viewstack Union
dhamb_base_dp_view view_entity left_outer DI meta data browser: list of DDIC views
QB_CDS_VIEW_CROSS_REFERENCE view from QB CDS View Cross Reference
Qb_PrimaryDSCube view from Primary Data Source of all cubes
Qb_PrimaryDSNonCube view from Primary Data Source of all Non Cubes

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY viewname VIEWNAME View Name
KEY as4local AS4LOCAL Activation State
KEY tabname VIBASTAB Basis Table
KEY as4vers AS4VERS Version
tabpos MCPOS Position in a repetition group
fortabname VIFORTAB Predecess. Tab.
forfield VIFORFIELD For. key field
fordir FORDIR Direction of Foreign Key Dependency

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.

-- Base tables and foreign key relationships for a view
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD26S (
    VIEWNAME,    -- View Name [VIEWNAME]
    AS4LOCAL,    -- Activation State [AS4LOCAL]
    TABNAME,     -- Basis Table [VIBASTAB]
    AS4VERS,     -- Version [AS4VERS]
    TABPOS,      -- Position in a repetition group [MCPOS]
    FORTABNAME,  -- Predecess. Tab. [VIFORTAB]
    FORFIELD,    -- For. key field [VIFORFIELD]
    FORDIR,      -- Direction of Foreign Key Dependency [FORDIR]
    PRIMARY KEY (VIEWNAME, AS4LOCAL, TABNAME, AS4VERS)
);

Learn More