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 |