RSDCUBE - Directory of InfoCubes / InfoProvider
Directory of InfoCubes / InfoProvider information is stored in SAP table RSDCUBE.
It is part of development package RSDG in software component BW-WHM-DBA. This development package consists of objects that can be grouped under "BW: Data basis generation".
It is part of development package RSDG in software component BW-WHM-DBA. This development package consists of objects that can be grouped under "BW: Data basis generation".
Fields for table RSDCUBE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| INFOCUBE | InfoCube | X | RSINFOCUBE | CHAR | 60 | |
| OBJVERS | Object version | X | RSOBJVERS | CHAR | 2 | |
| .INCLUDE | RSTLOGO_AM | 0 | ||||
| .INCLUDE | RSTLOGO_A | 0 | ||||
| OBJSTAT | Object Status | RSOBJSTAT | CHAR | 6 | ||
| CONTREL | Content release | RSCONTREL | CHAR | 12 | ||
| CONTTIMESTMP | Content time stamp: Last modification to the object by SAP | RSCONTTIMESTMP | DEC | 8 | ||
| OWNER | Owner (Person Responsible) | RSOWNER | CHAR | 24 | ||
| BWAPPL | BW Application (Namespace) | RSBWAPPL | CHAR | 20 | ||
| ACTIVFL | Active and revised version do not agree | RSACTIVFL | CHAR | 2 | ||
| PROTECFL | Flag: Protected InfoObject, no changes allowed | RSPROTECFL | CHAR | 2 | ||
| INFOAREA | InfoArea | RSINFOAREA | CHAR | 60 | RSDAREA | |
| NCUMTIM | Ref. Time-Char. for Non-cums | RSNCUMTIM | CHAR | 60 | ||
| BCTCOMP | Obsolete - do not translate | RSDBCTCOMP | CHAR | 20 | ||
| SUPERPROV | Higher-Level InfoProvider | RSSUPERPROV | CHAR | 60 | ||
| SUPERTLOGO | TLOGO Type of Higher-Level Provider | RSSUPERTLOGO | CHAR | 8 | ||
| .INCLUDE | RSDPROVTYPE | 0 | ||||
| CUBETYPE | InfoProvider Type | RSCUBETYPE | CHAR | 2 | ||
| CUBESUBTYPE | InfoProvider Subtype | RSCUBESUBTYPE | CHAR | 2 | ||
| .INCLUDE | RSCUBESV | 0 | ||||
| SVRESTR | Obsolete Option! (Convert Restrictions (InfoProvider)) | RSCUBESVRESTR | CHAR | 2 | ||
| SVRESTRNO | No Support of Selection Conditions | RSCUBESVRESTRNO | CHAR | 2 | ||
| SVRESTRGLOBAL | Only Global Selection Conditions | RSCUBESVRESTRGLOBAL | CHAR | 2 | ||
| SVRESTRSEL | Obsolete Option! (Simplify Selections (InfoProvider)) | RSCUBESVRESTRSEL | CHAR | 2 | ||
| SVSUPPHIER | Supports Hierarchies | RSCUBESVSUPPHIER | CHAR | 2 | ||
| SVSUPPACDA | Supports Data Integrity in Provider Implementation | RSCUBESVSUPPACDA | CHAR | 2 | ||
| NOTRANSFRESTR | Do Not Transform Selection Conditions | RSNOTRANSFRESTR | CHAR | 2 | ||
| SVRESTRHIER | Obsolete Option! (Expand Hier. Restrictions (InfoProvider)) | RSCUBESVRESTRHIER | CHAR | 2 | ||
| SVRFCPACK | Pack RFC (InfoProvider) | RSCUBESVRFCPACK | CHAR | 2 | ||
| SVSLOGSYS | Source system | RSSLOGSYS | CHAR | 20 | * | |
| SVSID | SID Support (InfoProvider) | RSCUBESVSID | CHAR | 2 | ||
| SVNAVATTR | Supports Navigation Attributes (InfoProvider) | RSCUBESVNAVATTR | CHAR | 2 | ||
| SVTRANSFSEL | Derive Sel. Conditions from Navigation Attribute | RSSVTRANSFSEL | CHAR | 2 | ||
| SVINTFORMAT | Internal Format (Key Figures) | RSCUBESVINTFORMAT | CHAR | 2 | ||
| FUNCNAME | Name of Function Module/Class/SAP HANA Model | RSCUBESVFUNCNAME | CHAR | 60 | * | |
| HDBMODNM | SAP HANA Model Name | RSHDBMODNM | CHAR | 510 | ||
| AUDITMODEFL | Boolean | RS_BOOL | CHAR | 2 | ||
| CONVEXITFL | Flag: Execute Conversion Exit(s) | RSCONVEXITFL | CHAR | 2 | ||
| BASICCUBE | BasicCube for Aggregate | RSBASICCUBE | CHAR | 60 | ||
| TRANSACT | Real Time / Direct Update | RSDTRANSACT | CHAR | 2 | ||
| SLOGSYS | Source system | RSSLOGSYS | CHAR | 20 | * | |
| .INCLUDE | RSOACUBEEXT | 0 | ||||
| ISOURCE | InfoSource | RSISOURCE | CHAR | 60 | ||
| UNIQUE_SOURCE | Indicator: Unique Source System | RSOAUNIQUESOURCE | CHAR | 2 | ||
| WRITECLASNM | Name of Class for Write Interface | RSDWRITECLASNM | CHAR | 60 | ||
| .INCLUDE | RSDPROVDELTA | 0 | ||||
| DELTACACHE | Update Cache Objects in Delta Process | RRDELTACACHE | CHAR | 2 | ||
| DELTACACHECLSNM | Delta Cache Class Name | RSDCCLSNM | CHAR | 60 | ||
| BUFFERTYPE | Defines the buffer type | RSDBUFFERTYPE | CHAR | 2 | ||
| .INCLUDE | RSDPROVMODE | 0 | ||||
| PARTITIONMODE | Type of SP Grouping for Delta Caching | RRSPPARTITION | NUMC | 2 | ||
| INPUTABLE | InfoProvider is ready for input; there is a write function | RRINPUTPROV | CHAR | 2 | ||
| INPUTMODE | Mode of Input Processing | RRINPUTMODUS | NUMC | 2 | ||
| ACTUALDATA | Data Integrity | RRACTUALDATA | NUMC | 2 | ||
| PACKAGEREAD | Supports Reading by Package | RSDPACKAGEREAD | CHAR | 2 | ||
| NOPARALLEL | Parallel Reading of Provider Not Permitted | RSDNOPARALLEL | CHAR | 2 | ||
| .INCLUDE | RSDPROVDATA | 0 | ||||
| DATASORTED | Data will be sorted first | RSDSVDATASORTED | CHAR | 2 | ||
| DATATRUSTED | Data will be provided "exactly" (no superset) | RSDSVDATATRUSTED | CHAR | 2 | ||
| MATERIALIZE | Materialization of Read Data | RSDMATERIALIZE | CHAR | 2 | ||
| MAT_CHAVL | Materialize CHAVL-Based Queries | RSDMATCHAVL | CHAR | 2 | ||
| MATININDEX | Create as New Index (BWA Index) | RSDMATININDEX | CHAR | 2 | ||
| AGGR_TRUSTED | Return Aggregated Result Set | RSDAGGRTRUSTED | CHAR | 2 | ||
| SIMULATE | Display of Access Plans | RSDSIMULATE | CHAR | 2 | ||
| SIDPREFERRED | SID Display Preferred | RSDSVSIDPREFERRED | CHAR | 2 | ||
| SVINTERNAL | Use of Internal Remote Provider Interface | RSDSVINTERNAL | CHAR | 2 | ||
| SVSUPPREQUID | InfoProvider Supports Ranges on 0REQUID | RSCUBESVSUPPREQUID | CHAR | 2 | ||
| SVSIDX4DATA | SIDs Exist for all Data of Provider | RSDSVSIDX4DATA | CHAR | 2 | ||
| .INCLUDE | RSDPROVADDI | 0 | ||||
| EDSFL | Flag: Generate export data source | RSEDSFL | CHAR | 2 | ||
| MOLAPFL | Flag: with MOLAP cube | RSMOLAPFL | CHAR | 2 | ||
| SAMPLRT | Sample rate in percent | RSSAMPLRATE | NUMC | 4 | ||
| BIA_STATUS | RSD: BW Accelerator Status of InfoCube (BWA Indexes) | RSD_BIA_STATUS | CHAR | 2 | ||
| ALLOWCIC | Indicator: Compounding Inconsistency Permitted | RSDALLOWCIC | CHAR | 2 | ||
| DIMID_UNIQUE | DIMIDs One-to-One to Characteristic Combinations | RSDDIMID_UNIQUE | CHAR | 2 | ||
| DELTA_LOAD | Delta Load Allowed with RSDRI | RSDDELTA_LOAD | CHAR | 2 | ||
| .INCLUDE | RSDCUBETECH | 0 | ||||
| .INCLUDE | RSDPROVTECHPART | 0 | ||||
| PARTMODE | Partitioning Type | RSPARTMODE | CHAR | 2 | ||
| PARTTIM | Partitioning time char. | RSPARTTIM | CHAR | 60 | ||
| PARTVL_FROM | Lower limit (partitioning value) | RSPARTVL_FROM | CHAR | 20 | ||
| PARTVL_TO | Upper Limit (Partitioning Value) | RSPARTVL_TO | CHAR | 20 | ||
| PARTMAXCNT | Maximum number of partitions | RSPARTMAXCNT | INT4 | 4 | ||
| .INCLUDE | RSDPROVTECHSTOR | 0 | ||||
| DIMESIZCAT | BW: Size Category for Dimension Tables | RSDIMESIZCAT | CHAR | 4 | ||
| DIMEDATCLS | BW: Data class for dimension tables | RSDIMEDATCLS | CHAR | 10 | * | |
| CUBESIZCAT | BW: Size Category for InfoCube (Fact) Tables | RSCUBESIZCAT | CHAR | 4 | ||
| CUBEDATCLS | BW: Data class for InfoCube (fact)tables | RSCUBEDATCLS | CHAR | 10 | * | |
| .INCLUDE | RSDCUBEDATASTATE | 0 | ||||
| .INCLUDE | RSDCUBEBWSTAT | 0 | ||||
| BWSTATISTICS | Boolean | RS_BOOL | CHAR | 2 | ||
| BWSTATWHM | Boolean | RS_BOOL | CHAR | 2 | ||
| .INCLUDE | RSDCUBEREQUEST | 0 | ||||
| AUTOQUALOKFL | Set Quality Status to 'OK' Automatically | RSMAUTOQUALOKFL | CHAR | 2 | ||
| AUTOROLLUPFL | Roll up data in the aggregate automatically | RSMAUTOROLLUPFL | CHAR | 2 | ||
| AUTOCOMPRFL | Compress Automatically After Roll-Up (or After Load) | RSMAUTOCOMPRFL | CHAR | 2 | ||
| NOAUTOCMPAGGRFL | Do not collapse aggregates automatically | RSMNOAUTOCMPRAGGRFL | CHAR | 2 | ||
| .INCLUDE | RSDCUBEDBSTAT | 0 | ||||
| .INCLUDE | RSDCUBEDBFLAGS | 0 | ||||
| CLEAR_INDEX | Delete index before each data load and then recreate | RSBOOK3 | CHAR | 2 | ||
| DELTA_INDEX | Delete index before each delta load and then recreate | RSBOOK4 | CHAR | 2 | ||
| REBUILD_STAT | Refresh DB Statistics After Each Data Load | CHAR | 2 | |||
| DELTA_STAT | Also Refresh Statistics After Delta Upload | CHAR | 2 | |||
| PERCENTAGE | Percentage of Data for Structuring Statistics | NUMC | 6 | |||
| NULLCOMP | Zero elimination in the summarization module | CDS_0_ELIM | CHAR | 2 | ||
| COMP_DISJ | Obsolete!! (Previously: Only Disjunct Records) | RSCOMP_DISJ | CHAR | 2 | ||
| REFUPDATE | No update of the non-cumulative marker | CDS_REFUPDATE | CHAR | 2 | ||
| DROP_INDX_ROLLUP | Delete Index Before Rollup | CHAR | 2 | |||
| .INCLUDE | RSDAGGRTECHSTOR | 0 | ||||
| ADIMSIZCAT | BW: Size Category for Aggregate Dimension Tables | RSADIMSIZCAT | CHAR | 4 | ||
| ADIMDATCLS | BW: Data class for aggregate dimension tables | RSADIMDATCLS | CHAR | 10 | * | |
| AGGRSIZCAT | BW: Size Category for Aggregate (Fact) Tables | RSAGGRSIZCAT | CHAR | 4 | ||
| AGGRDATCLS | BW: Default Data Class for Aggregate (Fact) Table | RSAGGRDATCLS | CHAR | 10 | * | |
| .INCLUDE | RSDCUBEQUERYPROP | 0 | ||||
| QPROPVERS | Conversion Version Query Properties | RSQPROPVERS | NUMC | 4 | ||
| READMODE | Read Mode | RSRREADMODE | CHAR | 2 | ||
| CACHEMODE | Query Cache Mode | RSRCACHEMODE | CHAR | 2 | ||
| CACHEDELAY | Cache Validity Period in Seconds | RSRCACHEDELAY | INT4 | 4 | ||
| NLREADMODE | Read Mode for Near-Line Storage | RSD_NLREADMODE | CHAR | 2 | ||
| NOPARALLELQDEF | No Parallel Processing | RRSNOPARALLEL | CHAR | 2 | ||
| KIDSEL | Use Selection of Structure Elements | RRKIDSEL | CHAR | 2 | ||
| CACHEUSEREXIT | Flag: Do not use cache for this report | RSRNOCACHEFL | CHAR | 2 | ||
| NOHPA | Obsolete Field (Do Not Use BWA Index) | RRSNOHPA | CHAR | 2 | ||
| TREXOPS | Operations in SAP HANA/BWA | RSRTREXOPS | CHAR | 2 | ||
| MATERIALIZEQUERYLAYER | Materialize Intermediate Query Result | RSRMATERIALIZEQUERYLAYER | CHAR | 2 | ||
| PACKFLQDEF | Process Key Figure with High Precision | RSDHIGHPRECFL | CHAR | 2 | ||
| HANAMODELFL | External SAP HANA view for BW object | RSMHANAMODEL | CHAR | 2 | ||
| SUPP_QUERY_W_DUPL_KYF | Supp. queries w/ dupl. KYF which cont. diff. aggregations | SUPPORTS_KEYFIGURE_DUPLICATES | CHAR | 2 | ||
| CACHEUSAGEMODE | Cache Usage Mode | RSRCACHEUSAGEMODE | CHAR | 2 | ||
| DATA_INTEGRITY_SCENARIO | Data Integrity Profile | RSR_DATA_INTEGRITY_SCENARIO | CHAR | 2 | ||
| READ_CHILD_KIDS | Also Read the Child Members with Hierarchy Structure Node | RR_READ_CHILD_KIDS | CHAR | 2 | ||
| AUTOREFRESH | Refresh Automatically after Deletion of Request | RSRAUTOREFRESH | CHAR | 2 | ||
| FORCE_DB_PUSHDOWN | Force Access via CalculationScenario | RSR_FORCE_DB_PUSHDOWN | NUMC | 2 | ||
| .INCLUDE | RSDAGGRPROP | 0 | ||||
| AGGRAUTOCHECK | Check Mode for Aggregates ('A', 'Q' or 'C') | RSDDAGGRCHECKMODE | CHAR | 2 | ||
| AGGRCHECKTIME | When Automatic Aggregate Check is Executed | RSDDAGGRCHECKTIME | CHAR | 20 | ||
| .INCLUDE | RSTSTPINT | 0 | ||||
| TSTPNM | Last Changed By | RSTSTPNM | CHAR | 24 | USR02 | |
| TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 8 | ||
| .INCLUDE | RSDCUBEQUERYPROPDEFAULT | 0 | ||||
| CB_DATA_INTEGRITY_SCENARIO | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_READMODE | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_ACTUALDATA | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_NLREADMODE | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_CACHEMODE | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_DELTACACHE | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_PARTITIONMODE | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_TREXOPS | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_MATERIALIZEQUERYLAYER | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_KIDSEL | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_PACKFLQDEF | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_NOPARALLELQDEF | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_CACHEUSEREXIT | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_CACHEDELAY | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_CACHEUSAGEMODE | Boolean | RS_BOOL | CHAR | 2 | ||
| CB_AUTOREFRESH | Boolean | RS_BOOL | CHAR | 2 |