RSDCUBE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| RSODP_BW_Extraction | view | union | ODP BW Extraction | |
| Rv_P_Cube_ | view | from |
Fields (134)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA