RSDCUBE

Transparent Table Control Table (SAP+Cust)

Directory of InfoCubes / InfoProvider

RSDCUBE is an SAP database table in S/4HANA. Directory of InfoCubes / InfoProvider. It contains 134 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
RSODP_BW_Extraction view union ODP BW Extraction
Rv_P_Cube_ view from

Fields (134)

KeyField Data ElementDescription DomainTypeLength
KEY infocube RSINFOCUBE InfoCube
KEY objvers RSOBJVERS Version
objstat RSOBJSTAT Object Status
contrel RSCONTREL Content release
conttimestmp RSCONTTIMESTMP Cont.time stamp
owner RSOWNER Person Respons.
bwappl RSBWAPPL BW Application
activfl RSACTIVFL active
protecfl RSPROTECFL Protected InfoObject
infoarea RSINFOAREA InfoArea
ncumtim RSNCUMTIM Ref.time-char.
bctcomp RSDBCTCOMP Component (BCT)
superprov RSSUPERPROV Higher Level
supertlogo RSSUPERTLOGO Type (Provider)
cubetype RSCUBETYPE InfoProvider Type
cubesubtype RSCUBESUBTYPE Cube Subtype
svrestr RSCUBESVRESTR Obsolete Option! (Convert Restrictions (InfoProvider))
svrestrno RSCUBESVRESTRNO No Support of Selection Conditions
svrestrglobal RSCUBESVRESTRGLOBAL Only Global Selection Conditions
svrestrsel RSCUBESVRESTRSEL Obsolete Option! (Simplify Selections (InfoProvider))
svsupphier RSCUBESVSUPPHIER Supports Hierarchies
svsuppacda RSCUBESVSUPPACDA Supports Data Integrity in Provider Implementation
notransfrestr RSNOTRANSFRESTR Do Not Transform
svrestrhier RSCUBESVRESTRHIER Obsolete Option! (Expand Hier. Restrictions (InfoProvider))
svrfcpack RSCUBESVRFCPACK Pack RFC (InfoProvider)
svslogsys RSSLOGSYS Source system
svsid RSCUBESVSID SID Support (InfoProvider)
svnavattr RSCUBESVNAVATTR Navigation Attributes
svtransfsel RSSVTRANSFSEL Derive Sel. Conditions
svintformat RSCUBESVINTFORMAT Internal Format
funcname RSCUBESVFUNCNAME FM/Class/HANA
hdbmodnm RSHDBMODNM SAP HANA View Name
auditmodefl RS_BOOL Boolean
convexitfl RSCONVEXITFL Execute Conv. Exit
basiccube RSBASICCUBE BasicCube
transact RSDTRANSACT Direct Update
slogsys RSSLOGSYS Source system
isource RSISOURCE InfoSource
unique_source RSOAUNIQUESOURCE Unique Source System
writeclasnm RSDWRITECLASNM Write Interface
deltacache RRDELTACACHE Update Cache Objects
deltacacheclsnm RSDCCLSNM Delta Cache Class
buffertype RSDBUFFERTYPE Buff.Type
partitionmode RRSPPARTITION SP Grouping
inputable RRINPUTPROV InfoProvider is ready for input; there is a write function
inputmode RRINPUTMODUS Mode of Input Processing
actualdata RRACTUALDATA Data Integrity
packageread RSDPACKAGEREAD Supports Reading by Package
noparallel RSDNOPARALLEL Parallel Reading of Provider Not Permitted
datasorted RSDSVDATASORTED Data will be sorted first
datatrusted RSDSVDATATRUSTED Data will be provided "exactly" (no superset)
materialize RSDMATERIALIZE Materialization
mat_chavl RSDMATCHAVL Materialize CHAVL-Based Queries
matinindex RSDMATININDEX Create as New Index
aggr_trusted RSDAGGRTRUSTED Return Aggregated Result Set
simulate RSDSIMULATE Access Plan
sidpreferred RSDSVSIDPREFERRED SID Display Preferred
svinternal RSDSVINTERNAL Use of Internal Remote Provider Interface
svsupprequid RSCUBESVSUPPREQUID With REQUID
svsidx4data RSDSVSIDX4DATA SIDs for Data
edsfl RSEDSFL Export data src
molapfl RSMOLAPFL MOLAP Cube
samplrt RSSAMPLRATE Sample rate
bia_status RSD_BIA_STATUS BWA Status
allowcic RSDALLOWCIC Inconsistent
dimid_unique RSDDIMID_UNIQUE DIMIDs One-to-One
delta_load RSDDELTA_LOAD Delta Load
partmode RSPARTMODE Partitioning Type
parttim RSPARTTIM Part.time char.
partvl_from RSPARTVL_FROM Lower limit
partvl_to RSPARTVL_TO Upper Limit
partmaxcnt RSPARTMAXCNT Max. partitions
dimesizcat RSDIMESIZCAT Size Category
dimedatcls RSDIMEDATCLS Data Type
cubesizcat RSCUBESIZCAT Size Category
cubedatcls RSCUBEDATCLS Data Type
bwstatistics RS_BOOL Boolean
bwstatwhm RS_BOOL Boolean
autoqualokfl RSMAUTOQUALOKFL Set Quality Status to 'OK' Automatically
autorollupfl RSMAUTOROLLUPFL Rollup
autocomprfl RSMAUTOCOMPRFL Compress Automatically After Roll-Up (or After Load)
noautocmpaggrfl RSMNOAUTOCMPRAGGRFL Do not collapse aggregates automatically
clear_index RSBOOK3 Delete index before each data load and then recreate
delta_index RSBOOK4 Delete index before each delta load and then recreate
rebuild_stat abap.char
delta_stat abap.char
percentage abap.numc
nullcomp CDS_0_ELIM Zero eliminatn
comp_disj RSCOMP_DISJ Disjunct recs.
refupdate CDS_REFUPDATE Marker inactive
drop_indx_rollup abap.char
adimsizcat RSADIMSIZCAT Size Category
adimdatcls RSADIMDATCLS Data Type
aggrsizcat RSAGGRSIZCAT Size Category
aggrdatcls RSAGGRDATCLS Data Type
qpropvers RSQPROPVERS Version QP
readmode RSRREADMODE Query Read Mode
cachemode RSRCACHEMODE Query Cache Mode
cachedelay RSRCACHEDELAY Cache Validity (S)
nlreadmode RSD_NLREADMODE N-Line Storage Mode
noparallelqdef RRSNOPARALLEL No Parallel Process.
kidsel RRKIDSEL Selection of Struct.
cacheuserexit RSRNOCACHEFL Do Not Use Cache
nohpa RRSNOHPA Do Not Use BWA
trexops RSRTREXOPS SAP HANA/BWA Ops
materializequerylayer RSRMATERIALIZEQUERYLAYER Materialize Result
packflqdef RSDHIGHPRECFL Key F. w/ High Prec.
hanamodelfl RSMHANAMODEL SAP HANA View
supp_query_w_dupl_kyf SUPPORTS_KEYFIGURE_DUPLICATES Supp. queries w/ dupl. KYF which cont. diff. aggregations
cacheusagemode RSRCACHEUSAGEMODE Cache Usage Mode
data_integrity_scenario RSR_DATA_INTEGRITY_SCENARIO Data Integrity Prof.
read_child_kids RR_READ_CHILD_KIDS Read Child Members
autorefresh RSRAUTOREFRESH Automatic Refresh
force_db_pushdown RSR_FORCE_DB_PUSHDOWN Force Access via CS
aggrautocheck RSDDAGGRCHECKMODE Check Mode
aggrchecktime RSDDAGGRCHECKTIME Aggr.Check
tstpnm RSTSTPNM Last Changed By
timestmp RSTIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
cb_data_integrity_scenario RS_BOOL Boolean
cb_readmode RS_BOOL Boolean
cb_actualdata RS_BOOL Boolean
cb_nlreadmode RS_BOOL Boolean
cb_cachemode RS_BOOL Boolean
cb_deltacache RS_BOOL Boolean
cb_partitionmode RS_BOOL Boolean
cb_trexops RS_BOOL Boolean
cb_materializequerylayer RS_BOOL Boolean
cb_kidsel RS_BOOL Boolean
cb_packflqdef RS_BOOL Boolean
cb_noparallelqdef RS_BOOL Boolean
cb_cacheuserexit RS_BOOL Boolean
cb_cachedelay RS_BOOL Boolean
cb_cacheusagemode RS_BOOL Boolean
cb_autorefresh RS_BOOL Boolean

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.

-- Directory of InfoCubes / InfoProvider
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSDCUBE (
    INFOCUBE,                    -- InfoCube [RSINFOCUBE]
    OBJVERS,                     -- Version [RSOBJVERS]
    OBJSTAT,                     -- Object Status [RSOBJSTAT]
    CONTREL,                     -- Content release [RSCONTREL]
    CONTTIMESTMP,                -- Cont.time stamp [RSCONTTIMESTMP]
    OWNER,                       -- Person Respons. [RSOWNER]
    BWAPPL,                      -- BW Application [RSBWAPPL]
    ACTIVFL,                     -- active [RSACTIVFL]
    PROTECFL,                    -- Protected InfoObject [RSPROTECFL]
    INFOAREA,                    -- InfoArea [RSINFOAREA]
    NCUMTIM,                     -- Ref.time-char. [RSNCUMTIM]
    BCTCOMP,                     -- Component (BCT) [RSDBCTCOMP]
    SUPERPROV,                   -- Higher Level [RSSUPERPROV]
    SUPERTLOGO,                  -- Type (Provider) [RSSUPERTLOGO]
    CUBETYPE,                    -- InfoProvider Type [RSCUBETYPE]
    CUBESUBTYPE,                 -- Cube Subtype [RSCUBESUBTYPE]
    SVRESTR,                     -- Obsolete Option! (Convert Restrictions (InfoProvider)) [RSCUBESVRESTR]
    SVRESTRNO,                   -- No Support of Selection Conditions [RSCUBESVRESTRNO]
    SVRESTRGLOBAL,               -- Only Global Selection Conditions [RSCUBESVRESTRGLOBAL]
    SVRESTRSEL,                  -- Obsolete Option! (Simplify Selections (InfoProvider)) [RSCUBESVRESTRSEL]
    SVSUPPHIER,                  -- Supports Hierarchies [RSCUBESVSUPPHIER]
    SVSUPPACDA,                  -- Supports Data Integrity in Provider Implementation [RSCUBESVSUPPACDA]
    NOTRANSFRESTR,               -- Do Not Transform [RSNOTRANSFRESTR]
    SVRESTRHIER,                 -- Obsolete Option! (Expand Hier. Restrictions (InfoProvider)) [RSCUBESVRESTRHIER]
    SVRFCPACK,                   -- Pack RFC (InfoProvider) [RSCUBESVRFCPACK]
    SVSLOGSYS,                   -- Source system [RSSLOGSYS]
    SVSID,                       -- SID Support (InfoProvider) [RSCUBESVSID]
    SVNAVATTR,                   -- Navigation Attributes [RSCUBESVNAVATTR]
    SVTRANSFSEL,                 -- Derive Sel. Conditions [RSSVTRANSFSEL]
    SVINTFORMAT,                 -- Internal Format [RSCUBESVINTFORMAT]
    FUNCNAME,                    -- FM/Class/HANA [RSCUBESVFUNCNAME]
    HDBMODNM,                    -- SAP HANA View Name [RSHDBMODNM]
    AUDITMODEFL,                 -- Boolean [RS_BOOL]
    CONVEXITFL,                  -- Execute Conv. Exit [RSCONVEXITFL]
    BASICCUBE,                   -- BasicCube [RSBASICCUBE]
    TRANSACT,                    -- Direct Update [RSDTRANSACT]
    SLOGSYS,                     -- Source system [RSSLOGSYS]
    ISOURCE,                     -- InfoSource [RSISOURCE]
    UNIQUE_SOURCE,               -- Unique Source System [RSOAUNIQUESOURCE]
    WRITECLASNM,                 -- Write Interface [RSDWRITECLASNM]
    DELTACACHE,                  -- Update Cache Objects [RRDELTACACHE]
    DELTACACHECLSNM,             -- Delta Cache Class [RSDCCLSNM]
    BUFFERTYPE,                  -- Buff.Type [RSDBUFFERTYPE]
    PARTITIONMODE,               -- SP Grouping [RRSPPARTITION]
    INPUTABLE,                   -- InfoProvider is ready for input; there is a write function [RRINPUTPROV]
    INPUTMODE,                   -- Mode of Input Processing [RRINPUTMODUS]
    ACTUALDATA,                  -- Data Integrity [RRACTUALDATA]
    PACKAGEREAD,                 -- Supports Reading by Package [RSDPACKAGEREAD]
    NOPARALLEL,                  -- Parallel Reading of Provider Not Permitted [RSDNOPARALLEL]
    DATASORTED,                  -- Data will be sorted first [RSDSVDATASORTED]
    DATATRUSTED,                 -- Data will be provided "exactly" (no superset) [RSDSVDATATRUSTED]
    MATERIALIZE,                 -- Materialization [RSDMATERIALIZE]
    MAT_CHAVL,                   -- Materialize CHAVL-Based Queries [RSDMATCHAVL]
    MATININDEX,                  -- Create as New Index [RSDMATININDEX]
    AGGR_TRUSTED,                -- Return Aggregated Result Set [RSDAGGRTRUSTED]
    SIMULATE,                    -- Access Plan [RSDSIMULATE]
    SIDPREFERRED,                -- SID Display Preferred [RSDSVSIDPREFERRED]
    SVINTERNAL,                  -- Use of Internal Remote Provider Interface [RSDSVINTERNAL]
    SVSUPPREQUID,                -- With REQUID [RSCUBESVSUPPREQUID]
    SVSIDX4DATA,                 -- SIDs for Data [RSDSVSIDX4DATA]
    EDSFL,                       -- Export data src [RSEDSFL]
    MOLAPFL,                     -- MOLAP Cube [RSMOLAPFL]
    SAMPLRT,                     -- Sample rate [RSSAMPLRATE]
    BIA_STATUS,                  -- BWA Status [RSD_BIA_STATUS]
    ALLOWCIC,                    -- Inconsistent [RSDALLOWCIC]
    DIMID_UNIQUE,                -- DIMIDs One-to-One [RSDDIMID_UNIQUE]
    DELTA_LOAD,                  -- Delta Load [RSDDELTA_LOAD]
    PARTMODE,                    -- Partitioning Type [RSPARTMODE]
    PARTTIM,                     -- Part.time char. [RSPARTTIM]
    PARTVL_FROM,                 -- Lower limit [RSPARTVL_FROM]
    PARTVL_TO,                   -- Upper Limit [RSPARTVL_TO]
    PARTMAXCNT,                  -- Max. partitions [RSPARTMAXCNT]
    DIMESIZCAT,                  -- Size Category [RSDIMESIZCAT]
    DIMEDATCLS,                  -- Data Type [RSDIMEDATCLS]
    CUBESIZCAT,                  -- Size Category [RSCUBESIZCAT]
    CUBEDATCLS,                  -- Data Type [RSCUBEDATCLS]
    BWSTATISTICS,                -- Boolean [RS_BOOL]
    BWSTATWHM,                   -- Boolean [RS_BOOL]
    AUTOQUALOKFL,                -- Set Quality Status to 'OK' Automatically [RSMAUTOQUALOKFL]
    AUTOROLLUPFL,                -- Rollup [RSMAUTOROLLUPFL]
    AUTOCOMPRFL,                 -- Compress Automatically After Roll-Up (or After Load) [RSMAUTOCOMPRFL]
    NOAUTOCMPAGGRFL,             -- Do not collapse aggregates automatically [RSMNOAUTOCMPRAGGRFL]
    CLEAR_INDEX,                 -- Delete index before each data load and then recreate [RSBOOK3]
    DELTA_INDEX,                 -- Delete index before each delta load and then recreate [RSBOOK4]
    REBUILD_STAT,                -- abap.char
    DELTA_STAT,                  -- abap.char
    PERCENTAGE,                  -- abap.numc
    NULLCOMP,                    -- Zero eliminatn [CDS_0_ELIM]
    COMP_DISJ,                   -- Disjunct recs. [RSCOMP_DISJ]
    REFUPDATE,                   -- Marker inactive [CDS_REFUPDATE]
    DROP_INDX_ROLLUP,            -- abap.char
    ADIMSIZCAT,                  -- Size Category [RSADIMSIZCAT]
    ADIMDATCLS,                  -- Data Type [RSADIMDATCLS]
    AGGRSIZCAT,                  -- Size Category [RSAGGRSIZCAT]
    AGGRDATCLS,                  -- Data Type [RSAGGRDATCLS]
    QPROPVERS,                   -- Version QP [RSQPROPVERS]
    READMODE,                    -- Query Read Mode [RSRREADMODE]
    CACHEMODE,                   -- Query Cache Mode [RSRCACHEMODE]
    CACHEDELAY,                  -- Cache Validity (S) [RSRCACHEDELAY]
    NLREADMODE,                  -- N-Line Storage Mode [RSD_NLREADMODE]
    NOPARALLELQDEF,              -- No Parallel Process. [RRSNOPARALLEL]
    KIDSEL,                      -- Selection of Struct. [RRKIDSEL]
    CACHEUSEREXIT,               -- Do Not Use Cache [RSRNOCACHEFL]
    NOHPA,                       -- Do Not Use BWA [RRSNOHPA]
    TREXOPS,                     -- SAP HANA/BWA Ops [RSRTREXOPS]
    MATERIALIZEQUERYLAYER,       -- Materialize Result [RSRMATERIALIZEQUERYLAYER]
    PACKFLQDEF,                  -- Key F. w/ High Prec. [RSDHIGHPRECFL]
    HANAMODELFL,                 -- SAP HANA View [RSMHANAMODEL]
    SUPP_QUERY_W_DUPL_KYF,       -- Supp. queries w/ dupl. KYF which cont. diff. aggregations [SUPPORTS_KEYFIGURE_DUPLICATES]
    CACHEUSAGEMODE,              -- Cache Usage Mode [RSRCACHEUSAGEMODE]
    DATA_INTEGRITY_SCENARIO,     -- Data Integrity Prof. [RSR_DATA_INTEGRITY_SCENARIO]
    READ_CHILD_KIDS,             -- Read Child Members [RR_READ_CHILD_KIDS]
    AUTOREFRESH,                 -- Automatic Refresh [RSRAUTOREFRESH]
    FORCE_DB_PUSHDOWN,           -- Force Access via CS [RSR_FORCE_DB_PUSHDOWN]
    AGGRAUTOCHECK,               -- Check Mode [RSDDAGGRCHECKMODE]
    AGGRCHECKTIME,               -- Aggr.Check [RSDDAGGRCHECKTIME]
    TSTPNM,                      -- Last Changed By [RSTSTPNM]
    TIMESTMP,                    -- UTC Time Stamp in Short Form (YYYYMMDDhhmmss) [RSTIMESTMP]
    CB_DATA_INTEGRITY_SCENARIO,  -- Boolean [RS_BOOL]
    CB_READMODE,                 -- Boolean [RS_BOOL]
    CB_ACTUALDATA,               -- Boolean [RS_BOOL]
    CB_NLREADMODE,               -- Boolean [RS_BOOL]
    CB_CACHEMODE,                -- Boolean [RS_BOOL]
    CB_DELTACACHE,               -- Boolean [RS_BOOL]
    CB_PARTITIONMODE,            -- Boolean [RS_BOOL]
    CB_TREXOPS,                  -- Boolean [RS_BOOL]
    CB_MATERIALIZEQUERYLAYER,    -- Boolean [RS_BOOL]
    CB_KIDSEL,                   -- Boolean [RS_BOOL]
    CB_PACKFLQDEF,               -- Boolean [RS_BOOL]
    CB_NOPARALLELQDEF,           -- Boolean [RS_BOOL]
    CB_CACHEUSEREXIT,            -- Boolean [RS_BOOL]
    CB_CACHEDELAY,               -- Boolean [RS_BOOL]
    CB_CACHEUSAGEMODE,           -- Boolean [RS_BOOL]
    CB_AUTOREFRESH,              -- Boolean [RS_BOOL]
    PRIMARY KEY (INFOCUBE, OBJVERS)
);