RSDCUBE SAP (Directory of InfoCubes / InfoProvider) Table details
Dictionary Type: Table
Description: Directory of InfoCubes / InfoProvider
Description: Directory of InfoCubes / InfoProvider
Table field list including key, data, relationships and ABAP select examples
RSDCUBE is a standard SAP Table which is used to store Directory of InfoCubes / InfoProvider data and is available within R/3 SAP systems depending on the version and release level.
The RSDCUBE table consists of various fields, each holding specific information or linking keys about Directory of InfoCubes / InfoProvider data available in SAP. These include OBJVERS (Object version), OBJSTAT (Object Status), CONTREL (Content release), CONTTIMESTMP (Content time stamp: Last modification to the object by SAP).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
Text table = RSDCUBET
SAP RSDCUBE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
INFOCUBE | InfoCube | RSINFOCUBE | CHAR | 30 | RSINFOCUBE | RSI | |||
OBJVERS | Object version | RSOBJVERS | CHAR | 1 | RSOBJVERS | ||||
OBJSTAT | Object Status | RSOBJSTAT | CHAR | 3 | RSOBJSTAT | ||||
CONTREL | Content release | RSCONTREL | CHAR | 6 | CHAR6 | ||||
CONTTIMESTMP | Content time stamp: Last modification to the object by SAP | RSCONTTIMESTMP | DEC | 15 | TZNTSTMPS | ||||
OWNER | Owner (Person Responsible) | RSOWNER | CHAR | 12 | Assigned to domain | XUBNAME | RS_OWNER | ||
BWAPPL | BW Application (Namespace) | RSBWAPPL | CHAR | 10 | |||||
ACTIVFL | Active and revised version do not agree | RSACTIVFL | CHAR | 1 | XFELD | ||||
PROTECFL | Flag: Protected InfoObject, no changes allowed | RSPROTECFL | CHAR | 1 | X | ||||
INFOAREA | InfoArea | RSINFOAREA | CHAR | 30 | RSDAREA | RSINFOAREA | RSAREA | ||
NCUMTIM | Ref. Time-Char. for Non-cums | RSNCUMTIM | CHAR | 30 | RSIOBJNM | ||||
BCTCOMP | Obsolete - do not translate | RSDBCTCOMP | CHAR | 10 | |||||
SUPERPROV | Higher-Level InfoProvider | RSSUPERPROV | CHAR | 30 | RSINFOPROV | RSI | RSINFOPROV | ||
SUPERTLOGO | TLOGO Type of Higher-Level Provider | RSSUPERTLOGO | CHAR | 4 | RSTLOGO | ||||
CUBETYPE | InfoProvider Type | RSCUBETYPE | CHAR | 1 | RSCUBETYPE | ||||
CUBESUBTYPE | InfoProvider Subtype | RSCUBESUBTYPE | CHAR | 1 | RSCUBESUBTYPE | ||||
SVRESTR | Obsolete Option! (Convert Restrictions (InfoProvider)) | RSCUBESVRESTR | CHAR | 1 | RSD_XFELD_EXT | ||||
SVRESTRNO | No Support of Selection Conditions | RSCUBESVRESTRNO | CHAR | 1 | XFELD | ||||
SVRESTRGLOBAL | Only Global Selection Conditions | RSCUBESVRESTRGLOBAL | CHAR | 1 | XFELD | ||||
SVRESTRSEL | Obsolete Option! (Simplify Selections (InfoProvider)) | RSCUBESVRESTRSEL | CHAR | 1 | RSD_XFELD_EXT | ||||
SVSUPPHIER | Supports Hierarchies | RSCUBESVSUPPHIER | CHAR | 1 | XFELD | ||||
SVSUPPACDA | Supports Data Integrity in Provider Implementation | RSCUBESVSUPPACDA | CHAR | 1 | XFELD | ||||
NOTRANSFRESTR | Do Not Transform Selection Conditions | RSNOTRANSFRESTR | CHAR | 1 | XFELD | ||||
SVRESTRHIER | Obsolete Option! (Expand Hier. Restrictions (InfoProvider)) | RSCUBESVRESTRHIER | CHAR | 1 | RSD_XFELD_EXT | ||||
SVRFCPACK | Pack RFC (InfoProvider) | RSCUBESVRFCPACK | CHAR | 1 | XFELD | ||||
SVSLOGSYS | Source system | RSSLOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
SVSID | SID Support (InfoProvider) | RSCUBESVSID | CHAR | 1 | XFELD | ||||
SVNAVATTR | Supports Navigation Attributes (InfoProvider) | RSCUBESVNAVATTR | CHAR | 1 | XFELD | ||||
SVTRANSFSEL | Derive Sel. Conditions from Navigation Attribute | RSSVTRANSFSEL | CHAR | 1 | XFELD | ||||
SVINTFORMAT | Internal Format (Key Figures) | RSCUBESVINTFORMAT | CHAR | 1 | XFELD | ||||
FUNCNAME | Name of Function Module/Class/SAP HANA Model | RSCUBESVFUNCNAME | CHAR | 30 | Assigned to domain | FUNCNAME | |||
HDBMODNM | SAP Hana Model Name | RSHDBMODNM | CHAR | 64 | RSHDBMODNM | ||||
CONVEXITFL | Flag: Execute Conversion Exit(s) | RSCONVEXITFL | CHAR | 1 | RS_BOOL | ||||
BASICCUBE | BasicCube for Aggregate | RSBASICCUBE | CHAR | 30 | RSINFOCUBE | ||||
TRANSACT | Real Time / Direct Update | RSDTRANSACT | CHAR | 1 | RS_BOOL | ||||
SLOGSYS | Source system | RSSLOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
ISOURCE | InfoSource | RSISOURCE | CHAR | 30 | RSISOURCE | RSS | |||
UNIQUE_SOURCE | Indicator: Unique Source System | RSOAUNIQUESOURCE | CHAR | 1 | RS_BOOL | ||||
WRITECLASNM | Name of Class for Write Interface | RSDWRITECLASNM | CHAR | 30 | SEOCLSNAME | ||||
DELTACACHE | Update Cache Objects in Delta Process | RRDELTACACHE | CHAR | 1 | RSBOOL | ||||
DELTACACHECLSNM | Name of Class for Delta Cache | RSDCCLSNM | CHAR | 30 | SEOCLSNAME | ||||
BUFFERTYPE | Defines the buffer type | RSDBUFFERTYPE | CHAR | 1 | RSDBUFFERTYPE | ||||
PARTITIONMODE | Type of SP Grouping for Delta Caching | RRSPPARTITION | NUMC | 1 | RRSPPARTITION | ||||
INPUTABLE | InfoProvider is ready for input; there is a write function | RRINPUTPROV | CHAR | 1 | RS_BOOL | ||||
INPUTMODE | Mode of Input Processing | RRINPUTMODUS | NUMC | 1 | RRINPUTMODUS | ||||
ACTUALDATA | Data Integrity | RRACTUALDATA | NUMC | 1 | RRACTUALDATA | ||||
PACKAGEREAD | Supports Reading by Package | RSDPACKAGEREAD | CHAR | 1 | XFELD | ||||
NOPARALLEL | Parallel Reading of Provider Not Permitted | RSDNOPARALLEL | CHAR | 1 | XFELD | ||||
DATASORTED | Data will be sorted first | RSDSVDATASORTED | CHAR | 1 | XFELD | ||||
DATATRUSTED | Data will be provided 'exactly' (no superset) | RSDSVDATATRUSTED | CHAR | 1 | XFELD | ||||
MATERIALIZE | Materialization of Read Data | RSDMATERIALIZE | CHAR | 1 | XFELD | ||||
MAT_CHAVL | Materialize CHAVL-Based Queries | RSDMATCHAVL | CHAR | 1 | XFELD | ||||
MATININDEX | Create as New Index (BWA Index) | RSDMATININDEX | CHAR | 1 | XFELD | ||||
AGGR_TRUSTED | Return Aggregated Result Set | RSDAGGRTRUSTED | CHAR | 1 | XFELD | ||||
SIMULATE | Display of Access Plans | RSDSIMULATE | CHAR | 1 | XFELD | ||||
SIDPREFERRED | SID Display Preferred | RSDSVSIDPREFERRED | CHAR | 1 | XFELD | ||||
SVINTERNAL | Use of Internal Remote Provider Interface | RSDSVINTERNAL | CHAR | 1 | XFELD | ||||
SVSUPPREQUID | InfoProvider Supports Ranges on 0REQUID | RSCUBESVSUPPREQUID | CHAR | 1 | XFELD | ||||
SVSIDX4DATA | SIDs Exist for all Data of Provider | RSDSVSIDX4DATA | CHAR | 1 | RS_BOOL | ||||
EDSFL | Flag: Generate export data source | RSEDSFL | CHAR | 1 | XFLAG | ||||
MOLAPFL | Flag: with MOLAP cube | RSMOLAPFL | CHAR | 1 | XFELD | ||||
SAMPLRT | Sample rate in percent | RSSAMPLRATE | NUMC | 2 | NUMC2 | ||||
BIA_STATUS | RSD: BW Accelerator Status of InfoCube (BWA Indexes) | RSD_BIA_STATUS | CHAR | 1 | RSD_BIA_STATUS | ||||
ALLOWCIC | Indicator: Compounding Inconsistency Permitted | RSDALLOWCIC | CHAR | 1 | XFELD | ||||
DIMID_UNIQUE | DIMIDs One-to-One to Characteristic Combinations | RSDDIMID_UNIQUE | CHAR | 1 | XFELD | ||||
DELTA_LOAD | Delta Load Allowed with RSDRI | RSDDELTA_LOAD | CHAR | 1 | XFELD | ||||
PARTMODE | Partitioning Type | RSPARTMODE | CHAR | 1 | RSPARTMODE | ||||
PARTTIM | Partitioning time char. | RSPARTTIM | CHAR | 30 | RSIOBJNM | ||||
PARTVL_FROM | Lower limit (partitioning value) | RSPARTVL_FROM | CHAR | 10 | RSPARTVL | ||||
PARTVL_TO | Upper Limit (Partitioning Value) | RSPARTVL_TO | CHAR | 10 | RSPARTVL | ||||
PARTMAXCNT | Maximum number of partitions | RSPARTMAXCNT | INT4 | 10 | |||||
DIMESIZCAT | BW: Size Category for Dimension Tables | RSDIMESIZCAT | CHAR | 2 | TABKAT | ||||
DIMEDATCLS | BW: Data class for dimension tables | RSDIMEDATCLS | CHAR | 5 | Assigned to domain | TABART | |||
CUBESIZCAT | BW: Size Category for InfoCube (Fact) Tables | RSCUBESIZCAT | CHAR | 2 | TABKAT | ||||
CUBEDATCLS | BW: Data class for InfoCube (fact)tables | RSCUBEDATCLS | CHAR | 5 | Assigned to domain | TABART | |||
PERCENTAGE | Percentage of Data for Structuring Statistics | 0 | |||||||
NULLCOMP | Zero elimination in the summarization module | CDS_0_ELIM | CHAR | 1 | RS_BOOL | ||||
COMP_DISJ | Obsolete!! (Previously: Only Disjunct Records) | RSCOMP_DISJ | CHAR | 1 | XFELD | ||||
BWSTATISTICS | Boolean | RS_BOOL | CHAR | 1 | RS_BOOL | ||||
BWSTATWHM | Boolean | RS_BOOL | CHAR | 1 | RS_BOOL | ||||
REFUPDATE | No update of the non-cumulative marker | CDS_REFUPDATE | CHAR | 1 | RS_BOOL | ||||
DROP_INDX_ROLLUP | Delete Index Before Rollup | 0 | |||||||
AUTOQUALOKFL | Set Quality Status to 'OK' Automatically | RSMAUTOQUALOKFL | CHAR | 1 | RSBOOL | ||||
ADIMSIZCAT | BW: Size Category for Aggregate Dimension Tables | RSADIMSIZCAT | CHAR | 2 | TABKAT | ||||
AUTOROLLUPFL | Roll up data in the aggregate automatically | RSMAUTOROLLUPFL | CHAR | 1 | RSBOOL | ||||
ADIMDATCLS | BW: Data class for aggregate dimension tables | RSADIMDATCLS | CHAR | 5 | Assigned to domain | TABART | |||
AUTOCOMPRFL | Compress Automatically After Roll-Up (or After Load) | RSMAUTOCOMPRFL | CHAR | 1 | RSBOOL | ||||
AGGRSIZCAT | BW: Size Category for Aggregate (Fact) Tables | RSAGGRSIZCAT | CHAR | 2 | TABKAT | ||||
NOAUTOCMPAGGRFL | Do not collapse aggregates automatically | RSMNOAUTOCMPRAGGRFL | CHAR | 1 | RSBOOL | ||||
AGGRDATCLS | BW: Default Data Class for Aggregate (Fact) Table | RSAGGRDATCLS | CHAR | 5 | Assigned to domain | TABART | |||
CLEAR_INDEX | Delete index before each data load and then recreate | RSBOOK3 | CHAR | 1 | CHAR1 | ||||
DELTA_INDEX | Delete index before each delta load and then recreate | RSBOOK4 | CHAR | 1 | CHAR1 | ||||
REBUILD_STAT | Refresh DB Statistics After Each Data Load | 0 | |||||||
DELTA_STAT | Also Refresh Statistics After Delta Upload | 0 | |||||||
PERCENTAGE | Percentage of Data for Structuring Statistics | 0 | |||||||
NULLCOMP | Zero elimination in the summarization module | CDS_0_ELIM | CHAR | 1 | RS_BOOL | ||||
COMP_DISJ | Obsolete!! (Previously: Only Disjunct Records) | RSCOMP_DISJ | CHAR | 1 | XFELD | ||||
REFUPDATE | No update of the non-cumulative marker | CDS_REFUPDATE | CHAR | 1 | RS_BOOL | ||||
DROP_INDX_ROLLUP | Delete Index Before Rollup | 0 | |||||||
ADIMSIZCAT | BW: Size Category for Aggregate Dimension Tables | RSADIMSIZCAT | CHAR | 2 | TABKAT | ||||
ADIMDATCLS | BW: Data class for aggregate dimension tables | RSADIMDATCLS | CHAR | 5 | Assigned to domain | TABART | |||
AGGRSIZCAT | BW: Size Category for Aggregate (Fact) Tables | RSAGGRSIZCAT | CHAR | 2 | TABKAT | ||||
AGGRDATCLS | BW: Default Data Class for Aggregate (Fact) Table | RSAGGRDATCLS | CHAR | 5 | Assigned to domain | TABART | |||
QPROPVERS | Conversion Version Query Properties | RSQPROPVERS | NUMC | 2 | RSQPROPVERS | ||||
READMODE | Read Mode | RSRREADMODE | CHAR | 1 | RSRREADMODE | ||||
CACHEMODE | Cache Mode | RSRCACHEMODE | CHAR | 1 | RSRCACHEMODE | ||||
CACHEDELAY | Cache Validity Period in Seconds | RSRCACHEDELAY | INT4 | 10 | |||||
NLREADMODE | Read Modus for Near-Line Storage | RSD_NLREADMODE | CHAR | 1 | RSD_NLREADMODE | ||||
NOPARALLELQDEF | no parallel processing | RRSNOPARALLEL | CHAR | 1 | RS_BOOL | ||||
KIDSEL | Use Selection of Structure Elements | RRKIDSEL | CHAR | 1 | RS_BOOL | ||||
CACHEUSEREXIT | Indicator: Do not Use Cache for this Report | RSRNOCACHEFL | CHAR | 1 | RSBOOL | ||||
NOHPA | Obsolete Field (Do Not Use BWA Index) | RRSNOHPA | CHAR | 1 | RS_BOOL | ||||
TREXOPS | Operations in SAP HANA/BWA | RSRTREXOPS | CHAR | 1 | RSRTREXOPS | ||||
PACKFLQDEF | Process key figure with high precision | RSDHIGHPRECFL | CHAR | 1 | RS_BOOL | ||||
AGGRAUTOCHECK | Check Mode for Aggregates ('A', 'Q' or 'C') | RSDDAGGRCHECKMODE | CHAR | 1 | RSDDAGGRCHECKMODE | ||||
AGGRCHECKTIME | When Automatic Aggregate Check is Executed | RSDDAGGRCHECKTIME | CHAR | 10 | CHAR10 | ||||
TSTPNM | Last changed by | RSTSTPNM | CHAR | 12 | USR02 | XUBNAME | |||
TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP table RSDCUBE using ABAP code
The following ABAP code Example will allow you to do a basic selection on RSDCUBE to SELECT all data from the tableDATA: WA_RSDCUBE TYPE RSDCUBE.
SELECT SINGLE *
FROM RSDCUBE
INTO CORRESPONDING FIELDS OF WA_RSDCUBE
WHERE...
How to access SAP table RSDCUBE
Within an ECC or HANA version of SAP you can also view further information about RSDCUBE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects