SAP table RSDCUBE (Directory of InfoCubes / InfoProvider)

SAP table RSDCUBE has 2 primary key fields being INFOCUBE,OBJVERS.

Field Description Data Type Length Decimals Checktable Data Element
INFOCUBE InfoCube CHAR 30 0 RSINFOCUBE
OBJVERS Object version CHAR 1 0 RSOBJVERS
A Active
D Content
H Historic
M Revised
N New
T Transport
OBJSTAT Object Status CHAR 3 0 RSOBJSTAT
ACT Active, executable
INA Inactive, not executable
OFF Switched off
PRO Production
CONTREL Content release CHAR 6 0 RSCONTREL
CONTTIMESTMP Content time stamp: Last modification to the object by SAP DEC 15 0 RSCONTTIMESTMP
OWNER Owner (Person Responsible) CHAR 12 0 RSOWNER
BWAPPL BW Application (Namespace) CHAR 10 0 RSBWAPPL
ACTIVFL Active and revised version do not agree CHAR 1 0 RSACTIVFL
PROTECFL Flag: Protected InfoObject, no changes allowed CHAR 1 0 RSPROTECFL
INFOAREA InfoArea CHAR 30 0 RSDAREA RSINFOAREA
NCUMTIM Ref. Time-Char. for Non-cums CHAR 30 0 RSNCUMTIM
BCTCOMP Obsolete - do not translate CHAR 10 0 RSDBCTCOMP
SUPERPROV Higher-Level InfoProvider CHAR 30 0 RSSUPERPROV
SUPERTLOGO TLOGO Type of Higher-Level Provider CHAR 4 0 RSSUPERTLOGO
CUBETYPE InfoProvider Type CHAR 1 0 RSCUBETYPE
A Aggregate Cube
B Standard InfoCube
C Composite Provider (-> TLOGO HCPR)
H HybridProvider
M MultiProvider (-> TLOGO MPRO!)
P Append
R Remote InfoCube (-> Cube Subtype)
V Virtual InfoProvider
CUBESUBTYPE InfoProvider Subtype CHAR 1 0 RSCUBESUBTYPE
C Based on Function Module
F Flat InfoCube
H Based on an SAP HANA Model
R Based on BAPI
S Based on DTP/3.x InfoSource
T Based on an SAP HANA Proxytable
SVRESTR Obsolete Option! (Convert Restrictions (InfoProvider)) CHAR 1 0 RSCUBESVRESTR
SVRESTRNO No Support of Selection Conditions CHAR 1 0 RSCUBESVRESTRNO
SVRESTRGLOBAL Only Global Selection Conditions CHAR 1 0 RSCUBESVRESTRGLOBAL
SVRESTRSEL Obsolete Option! (Simplify Selections (InfoProvider)) CHAR 1 0 RSCUBESVRESTRSEL
SVSUPPHIER Supports Hierarchies CHAR 1 0 RSCUBESVSUPPHIER
SVSUPPACDA Supports Data Integrity in Provider Implementation CHAR 1 0 RSCUBESVSUPPACDA
NOTRANSFRESTR Do Not Transform Selection Conditions CHAR 1 0 RSNOTRANSFRESTR
SVRESTRHIER Obsolete Option! (Expand Hier. Restrictions (InfoProvider)) CHAR 1 0 RSCUBESVRESTRHIER
SVRFCPACK Pack RFC (InfoProvider) CHAR 1 0 RSCUBESVRFCPACK
SVSLOGSYS Source system CHAR 10 0 * RSSLOGSYS
SVSID SID Support (InfoProvider) CHAR 1 0 RSCUBESVSID
SVNAVATTR Supports Navigation Attributes (InfoProvider) CHAR 1 0 RSCUBESVNAVATTR
SVTRANSFSEL Derive Sel. Conditions from Navigation Attribute CHAR 1 0 RSSVTRANSFSEL
SVINTFORMAT Internal Format (Key Figures) CHAR 1 0 RSCUBESVINTFORMAT
FUNCNAME Name of Function Module/Class/SAP HANA Model CHAR 30 0 * RSCUBESVFUNCNAME
HDBMODNM SAP HANA Model Name CHAR 255 0 RSHDBMODNM
AUDITMODEFL Boolean CHAR 1 0 RS_BOOL
False
X True
CONVEXITFL Flag: Execute Conversion Exit(s) CHAR 1 0 RSCONVEXITFL
BASICCUBE BasicCube for Aggregate CHAR 30 0 RSBASICCUBE
TRANSACT Real Time / Direct Update CHAR 1 0 RSDTRANSACT
SLOGSYS Source system CHAR 10 0 * RSSLOGSYS
ISOURCE InfoSource CHAR 30 0 RSISOURCE
UNIQUE_SOURCE Indicator: Unique Source System CHAR 1 0 RSOAUNIQUESOURCE
WRITECLASNM Name of Class for Write Interface CHAR 30 0 RSDWRITECLASNM
DELTACACHE Update Cache Objects in Delta Process CHAR 1 0 RRDELTACACHE
DELTACACHECLSNM Delta Cache Class Name CHAR 30 0 RSDCCLSNM
BUFFERTYPE Defines the buffer type CHAR 1 0 RSDBUFFERTYPE
A After-Image Buffer
D Delta Buffer
PARTITIONMODE Type of SP Grouping for Delta Caching NUMC 1 0 RRSPPARTITION
0 No grouping
1 Grouping depending on InfoProvider types
2 Grouping depending on InfoProv. types, InfoCubes separated
3 Every InfoProvider separately
INPUTABLE InfoProvider is ready for input; there is a write function CHAR 1 0 RRINPUTPROV
INPUTMODE Mode of Input Processing NUMC 1 0 RRINPUTMODUS
0 Normal Query (No Input)
1 Contains Input-Ready KIDs
9 Contains Lock KIDs
ACTUALDATA Data Integrity NUMC 1 0 RRACTUALDATA
0 All InfoProviders up to released status (RQTS0)
1 Real-time InfoCubes up to current version
2 All InfoProviders up to current version (to Qualok)
3 All InfoProviders up to current version (all green requests)
7 Every InfoProvider in MultiProvider according to its setting
9 All InfoProviders (including red requests)
PACKAGEREAD Supports Reading by Package CHAR 1 0 RSDPACKAGEREAD
NOPARALLEL Parallel Reading of Provider Not Permitted CHAR 1 0 RSDNOPARALLEL
DATASORTED Data will be sorted first CHAR 1 0 RSDSVDATASORTED
DATATRUSTED Data will be provided "exactly" (no superset) CHAR 1 0 RSDSVDATATRUSTED
MATERIALIZE Materialization of Read Data CHAR 1 0 RSDMATERIALIZE
MAT_CHAVL Materialize CHAVL-Based Queries CHAR 1 0 RSDMATCHAVL
MATININDEX Create as New Index (BWA Index) CHAR 1 0 RSDMATININDEX
AGGR_TRUSTED Return Aggregated Result Set CHAR 1 0 RSDAGGRTRUSTED
SIMULATE Display of Access Plans CHAR 1 0 RSDSIMULATE
SIDPREFERRED SID Display Preferred CHAR 1 0 RSDSVSIDPREFERRED
SVINTERNAL Use of Internal Remote Provider Interface CHAR 1 0 RSDSVINTERNAL
SVSUPPREQUID InfoProvider Supports Ranges on 0REQUID CHAR 1 0 RSCUBESVSUPPREQUID
SVSIDX4DATA SIDs Exist for all Data of Provider CHAR 1 0 RSDSVSIDX4DATA
EDSFL Flag: Generate export data source CHAR 1 0 RSEDSFL
MOLAPFL Flag: with MOLAP cube CHAR 1 0 RSMOLAPFL
SAMPLRT Sample rate in percent NUMC 2 0 RSSAMPLRATE
BIA_STATUS RSD: BW Accelerator Status of InfoCube (BWA Indexes) CHAR 1 0 RSD_BIA_STATUS
No BWA Index
O BWA Index Only
X Has a BWA Index
ALLOWCIC Indicator: Compounding Inconsistency Permitted CHAR 1 0 RSDALLOWCIC
DIMID_UNIQUE DIMIDs One-to-One to Characteristic Combinations CHAR 1 0 RSDDIMID_UNIQUE
DELTA_LOAD Delta Load Allowed with RSDRI CHAR 1 0 RSDDELTA_LOAD
PARTMODE Partitioning Type CHAR 1 0 RSPARTMODE
Not Partitioned
I Index Clustering
M Multi-Dimensional Clustering
X Partitioned
PARTTIM Partitioning time char. CHAR 30 0 RSPARTTIM
PARTVL_FROM Lower limit (partitioning value) CHAR 10 0 RSPARTVL_FROM
PARTVL_TO Upper Limit (Partitioning Value) CHAR 10 0 RSPARTVL_TO
PARTMAXCNT Maximum number of partitions INT4 10 0 RSPARTMAXCNT
DIMESIZCAT BW: Size Category for Dimension Tables CHAR 2 0 RSDIMESIZCAT
DIMEDATCLS BW: Data class for dimension tables CHAR 5 0 * RSDIMEDATCLS
CUBESIZCAT BW: Size Category for InfoCube (Fact) Tables CHAR 2 0 RSCUBESIZCAT
CUBEDATCLS BW: Data class for InfoCube (fact)tables CHAR 5 0 * RSCUBEDATCLS
BWSTATISTICS Boolean CHAR 1 0 RS_BOOL
False
X True
BWSTATWHM Boolean CHAR 1 0 RS_BOOL
False
X True
AUTOQUALOKFL Set Quality Status to 'OK' Automatically CHAR 1 0 RSMAUTOQUALOKFL
AUTOROLLUPFL Roll up data in the aggregate automatically CHAR 1 0 RSMAUTOROLLUPFL
AUTOCOMPRFL Compress Automatically After Roll-Up (or After Load) CHAR 1 0 RSMAUTOCOMPRFL
NOAUTOCMPAGGRFL Do not collapse aggregates automatically CHAR 1 0 RSMNOAUTOCMPRAGGRFL
CLEAR_INDEX Delete index before each data load and then recreate CHAR 1 0 RSBOOK3
DELTA_INDEX Delete index before each delta load and then recreate CHAR 1 0 RSBOOK4
REBUILD_STAT CHAR 1 0
DELTA_STAT CHAR 1 0
PERCENTAGE NUMC 3 0
NULLCOMP Zero elimination in the summarization module CHAR 1 0 CDS_0_ELIM
COMP_DISJ Obsolete!! (Previously: Only Disjunct Records) CHAR 1 0 RSCOMP_DISJ
REFUPDATE No update of the non-cumulative marker CHAR 1 0 CDS_REFUPDATE
DROP_INDX_ROLLUP CHAR 1 0
ADIMSIZCAT BW: Size Category for Aggregate Dimension Tables CHAR 2 0 RSADIMSIZCAT
ADIMDATCLS BW: Data class for aggregate dimension tables CHAR 5 0 * RSADIMDATCLS
AGGRSIZCAT BW: Size Category for Aggregate (Fact) Tables CHAR 2 0 RSAGGRSIZCAT
AGGRDATCLS BW: Default Data Class for Aggregate (Fact) Table CHAR 5 0 * RSAGGRDATCLS
QPROPVERS Conversion Version Query Properties NUMC 2 0 RSQPROPVERS
00 3.X /7.0 to SP12
01 7.0 SP13
02 7.20 SP1
READMODE Read Mode CHAR 1 0 RSRREADMODE
A Query to read all data at once
H Query to read when you navigate or expand hierarchies
X Query to read data during navigation
CACHEMODE Query Cache Mode CHAR 1 0 RSRCACHEMODE
0 Local cache
D Cache in database
I Cache is inactive
P Every provider as set up in provider definition
CACHEDELAY Cache Validity Period in Seconds INT4 10 0 RSRCACHEDELAY
NLREADMODE Read Mode for Near-Line Storage CHAR 1 0 RSD_NLREADMODE
Do not read near-line storage (default)
N Near-line access not allowed or not possible
P Near-line access setting same as for PartProvider
X Read near-line storage
NOPARALLELQDEF No Parallel Processing CHAR 1 0 RRSNOPARALLEL
KIDSEL Use Selection of Structure Elements CHAR 1 0 RRKIDSEL
CACHEUSEREXIT Flag: Do not use cache for this report CHAR 1 0 RSRNOCACHEFL
NOHPA Obsolete Field (Do Not Use BWA Index) CHAR 1 0 RRSNOHPA
TREXOPS Operations in SAP HANA/BWA CHAR 1 0 RSRTREXOPS
0 No optimized operations in SAP HANA/no BWA
2 Individual access per InfoProvider
3 Optimized access
6 Exception aggregation
7 Formulas calculated in SAP HANA
8 Formulas calculated in SAP HANA with complex currency/unit
9 Conditions calculated in SAP HANA
MATERIALIZEQUERYLAYER Materialize Intermediate Query Result CHAR 1 0 RSRMATERIALIZEQUERYLAYER
No
M Yes, in case data is read for multiple subtotal levels
X Yes
PACKFLQDEF Process Key Figure with High Precision CHAR 1 0 RSDHIGHPRECFL
HANAMODELFL External SAP HANA view for BW object CHAR 1 0 RSMHANAMODEL
No external SAP HANA view
E External SAP HANA views for reporting and master data
I External SAP HANA view for master data
X External SAP HANA view for reporting
SUPP_QUERY_W_DUPL_KYF Supp. queries w/ dupl. KYF which cont. diff. aggregations CHAR 1 0 SUPPORTS_KEYFIGURE_DUPLICATES
CACHEUSAGEMODE Cache Usage Mode CHAR 1 0 RSRCACHEUSAGEMODE
Data from query start if possible, otherwise current data
C Always display current data
P As specified in partprovider settings
S Always display data from query start (stable data)
DATA_INTEGRITY_SCENARIO Data Integrity Profile CHAR 1 0 RSR_DATA_INTEGRITY_SCENARIO
Default: No profile (expert settings are used)
C Consistent current data
D Dirty data - no caching
G Guaranteed stable data from query start
M Most current data
P Provider specific: transactional providers with current data
S Data from query start
READ_CHILD_KIDS Also Read the Child Members with Hierarchy Structure Node CHAR 1 0 RR_READ_CHILD_KIDS
AUTOREFRESH Refresh Automatically after Deletion of Request CHAR 1 0 RSRAUTOREFRESH
FORCE_DB_PUSHDOWN Force Access via CalculationScenario NUMC 1 0 RSR_FORCE_DB_PUSHDOWN
0 Off
2 On if CalculationScenario already used
4 On
AGGRAUTOCHECK Check Mode for Aggregates ('A', 'Q' or 'C') CHAR 1 0 RSDDAGGRCHECKMODE
A Full Check
C Check Aggregate
Q Quick & Dirty
AGGRCHECKTIME When Automatic Aggregate Check is Executed CHAR 10 0 RSDDAGGRCHECKTIME
TSTPNM Last Changed By CHAR 12 0 USR02 RSTSTPNM
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 RSTIMESTMP
CB_DATA_INTEGRITY_SCENARIO Boolean CHAR 1 0 RS_BOOL
False
X True
CB_READMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_ACTUALDATA Boolean CHAR 1 0 RS_BOOL
False
X True
CB_NLREADMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_CACHEMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_DELTACACHE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_PARTITIONMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_TREXOPS Boolean CHAR 1 0 RS_BOOL
False
X True
CB_MATERIALIZEQUERYLAYER Boolean CHAR 1 0 RS_BOOL
False
X True
CB_KIDSEL Boolean CHAR 1 0 RS_BOOL
False
X True
CB_PACKFLQDEF Boolean CHAR 1 0 RS_BOOL
False
X True
CB_NOPARALLELQDEF Boolean CHAR 1 0 RS_BOOL
False
X True
CB_CACHEUSEREXIT Boolean CHAR 1 0 RS_BOOL
False
X True
CB_CACHEDELAY Boolean CHAR 1 0 RS_BOOL
False
X True
CB_CACHEUSAGEMODE Boolean CHAR 1 0 RS_BOOL
False
X True
CB_AUTOREFRESH Boolean CHAR 1 0 RS_BOOL
False
X True

RSDCUBE foreign key relationships

Table Field Check Table Check Field
0 RSDCUBE INFOAREA RSDAREA Directory of InfoAreas INFOAREA
0 RSDCUBE INFOAREA RSDAREA Directory of InfoAreas OBJVERS
1 RSDCUBE TSTPNM USR02 Logon Data (Kernel-Side Use) BNAME