1. Home
  2. Resources
  3. SAP Tables
  4. RSMDATASTATE_S - Structure for Data Status in InfoCubes

SAP Table RSMDATASTATE_S

Structure for Data Status in InfoCubes

RSMDATASTATE_S (Structure for Data Status in InfoCubes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RSMDATASTATE_S to other SAP tables.

RSMDATASTATE_S table fields

Field Data element Checktable Datatype Length Decimals
INFOCUBE InfoCube RSINFOCUBE CHAR 30 0
TECHOK Request SID for which all requests are technically o.k. RSMTECHOK INT4 10 0
QUALOK Request SID for which all requests checked for quality RSMQUALOK INT4 10 0
ROLLUP Request SID, up to which all aggregates are rolled up RSMROLLUP INT4 10 0
DMEXIST Upper limit for data mart delta request RSDMHIGH INT4 10 0
DMALL Lower limit for data mart delta request RSDMLOW INT4 10 0
TMSTMP_ROLLUP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) RSTIMESTMP DEC 15 0
TMSTMP_QUALOK UTC Time Stamp in Short Form (YYYYMMDDhhmmss) RSTIMESTMP DEC 15 0
COMPR Request SID up to which InfoCube is to be compressed RSMCOMPR INT4 10 0
AGGREXIST Boolean RS_BOOL CHAR 1 0
NULL False
X True
CNSID MID of the last chnage run RSMCNSID_LAST INT4 10 0
ROLLUP_RSVD_DUAL Request SID, up to which aggregates are to be rolled up RSMROLLUP_RSVD INT4 10 0
COMPR_DUAL Request SID up to which InfoCube is to be compressed RSMCOMPR INT4 10 0
BWSTATISTICS Boolean RS_BOOL CHAR 1 0
NULL False
X True
BWSTATWHM Boolean RS_BOOL CHAR 1 0
NULL False
X True
AUTOQUALOKFL Set Quality Status to 'OK' Automatically RSMAUTOQUALOKFL CHAR 1 0
NULL false
X True
AUTOROLLUPFL Roll up data in the aggregate automatically RSMAUTOROLLUPFL CHAR 1 0
NULL false
X True
AUTOCOMPRFL Compress Automatically After Roll-Up (or After Load) RSMAUTOCOMPRFL CHAR 1 0
NULL false
X True
NOAUTOCMPAGGRFL Do not collapse aggregates automatically RSMNOAUTOCMPRAGGRFL CHAR 1 0
NULL false
X True
CLEAR_INDEX Delete index before each data load and then recreate RSBOOK3 CHAR 1 0
DELTA_INDEX Delete index before each delta load and then recreate RSBOOK4 CHAR 1 0
REBUILD_STAT CHAR 1 0
DELTA_STAT CHAR 1 0
PERCENTAGE NUMC 3 0
NULLCOMP Zero elimination in the summarization module CDS_0_ELIM CHAR 1 0
NULL False
X True
COMP_DISJ Obsolete!! (Previously: Only Disjunct Records) RSCOMP_DISJ CHAR 1 0
X Yes
NULL No
REFUPDATE No update of the non-cumulative marker CDS_REFUPDATE CHAR 1 0
NULL False
X True
DROP_INDX_ROLLUP CHAR 1 0
ADIMSIZCAT BW: Size Category for Aggregate Dimension Tables RSADIMSIZCAT CHAR 2 0
0 Tables < 500K
1 Tables < 1.5 MB
2 Tables < 6.5 MB
3 Tables < 25 MB
4 Tables > 160 MB
5 Value cannot be maintained manually (Early Watch value)
6 Value cannot be maintained manually (Early Watch value)
7 Value cannot be maintained manually (Early Watch value)
8 Value cannot be maintained manually (Early Watch value)
9 Value cannot be maintained manually (Early Watch value)
10 Value cannot be maintained manually (Early Watch value)
11 Value cannot be maintained manually (Early Watch value)
12 Value cannot be maintained manually (Early Watch value)
13 Value cannot be maintained manually (Early Watch value)
14 Value cannot be maintained manually (Early Watch value)
ADIMDATCLS BW: Data class for aggregate dimension tables RSADIMDATCLS CHAR 5 0
AGGRSIZCAT BW: Size Category for Aggregate (Fact) Tables RSAGGRSIZCAT CHAR 2 0
0 Tables < 500K
1 Tables < 1.5 MB
2 Tables < 6.5 MB
3 Tables < 25 MB
4 Tables > 160 MB
5 Value cannot be maintained manually (Early Watch value)
6 Value cannot be maintained manually (Early Watch value)
7 Value cannot be maintained manually (Early Watch value)
8 Value cannot be maintained manually (Early Watch value)
9 Value cannot be maintained manually (Early Watch value)
10 Value cannot be maintained manually (Early Watch value)
11 Value cannot be maintained manually (Early Watch value)
12 Value cannot be maintained manually (Early Watch value)
13 Value cannot be maintained manually (Early Watch value)
14 Value cannot be maintained manually (Early Watch value)
AGGRDATCLS BW: Default Data Class for Aggregate (Fact) Table RSAGGRDATCLS CHAR 5 0
QPROPVERS Conversion Version Query Properties RSQPROPVERS NUMC 2 0
00 3.X /7.0 to SP12
01 7.0 SP13
02 7.20 SP1
READMODE Read Mode RSRREADMODE CHAR 1 0
A Query to Read All Data At Once
X Query to Read Data During Navigation
H Query to Read When You Navigate or Expand Hierarchies
CACHEMODE Cache Mode RSRCACHEMODE CHAR 1 0
I Cache is inactive
0 Local Cache
D Cache in DataBase
CACHEDELAY Cache Validity Period in Seconds RSRCACHEDELAY INT4 10 0
NLREADMODE Read Modus for Near-Line Storage RSD_NLREADMODE CHAR 1 0
NULL Near-Line Access Switched Off (Default)
N Near-Line Access Not Allowed or Not Possible
X Near-Line Access Switched On
P Near-Line Access Set the Same as for PartProvider
NOPARALLELQDEF no parallel processing RRSNOPARALLEL CHAR 1 0
NULL False
X True
KIDSEL Use Selection of Structure Elements RRKIDSEL CHAR 1 0
NULL False
X True
CACHEUSEREXIT Indicator: Do not Use Cache for this Report RSRNOCACHEFL CHAR 1 0
NULL false
X True
NOHPA Obsolete Field (Do Not Use BWA Index) RRSNOHPA CHAR 1 0
NULL False
X True
TREXOPS Operations in SAP HANA/BWA RSRTREXOPS CHAR 1 0
0 No Optimized Operations in SAP HANA/No BWA
2 Individual Access per InfoProvider (as in Release 7.0)
3 Standard
6 Exception Aggregation
PACKFLQDEF Process key figure with high precision RSDHIGHPRECFL CHAR 1 0
NULL False
X True
AGGRAUTOCHECK Check Mode for Aggregates ('A', 'Q' or 'C') RSDDAGGRCHECKMODE CHAR 1 0
A Full Check
Q Quick & Dirty
C Check Aggregate
AGGRCHECKTIME When Automatic Aggregate Check is Executed RSDDAGGRCHECKTIME CHAR 10 0
DOUBLE_FACT Boolean RS_BOOL CHAR 1 0
NULL False
X True
ODSOBJECT DataStore Object RSDODSOBJECT RSDODSO CHAR 30 0
DELTAINA DataMart delta update status RSDELTAINA CHAR 1 0
ACTIVE Max. Delta Slice in Change Log RSBACTIVE INT4 10 0
PROCESSED_ALL Max. delta slice that was extracted by all receivers RSBROLLUPALL INT4 10 0
PROCESSED_ONE Max. delta slice extracted until now RSBROLLUPONE INT4 10 0
COMPR_ODS Delta slice up to which compression has taken place RSBCOMPR INT4 10 0
ODSVERSION Active version of the Operational Data Store RSODSVERSION NUMC 3 0
AUTOACTIVATEFL Activate DataStore Object Data Automatically RSMAUTOACTIVATEFL CHAR 1 0
NULL false
X True
AUTOPROCESSFL Update Data from DataStore Object Automatically RSMAUTOPROCESSFL CHAR 1 0
NULL false
X True
TLOGO BW: Object Type (TLOGO) RSTLOGO CHAR 4 0
CTRT Currency Translation Type
UOMT Quantity Conversion Type
AREA InfoArea
APCO Application
ROUT Routine
RSFO BW Formula
IOBJ InfoObject
IOBC InfoObject Catalog
ODSO DataStore Object
CUBE InfoCube
AGGR Aggregate
HYBR HybridProvider
LPOA Semantically Partitioned Object
ISET InfoSet
COPR CompositeProvider
HCPR CompositeProvider 740
ODPE Operational Data Provider (ESH-Based)
MPRO MultiProvider
ALVL Aggregation Level
DAPA Data Archiving Process
ISTD 3.x InfoSource
ISCS Communication Structure
TRCS InfoSource
UPDR Update rules
LSYS Source System
ISFS 3.x DataSource
RSDS DataSource
INSP Inspection Plan
ISMP Transfer Rules
ISTS Transfer structure
DEST Open Hub Destination
ELEM Query Element
TRFN Transformation
ISIP InfoPackage
ISIG InfoPackage Group
RASE Reporting Agent Setting
RAPA Reporting Agent Scheduling Package
RRCA RRI InfoCube Receiver
RRQA RRI Query Receiver
XLWB Workbook
SPOK InfoSpoke
EVEN Event Processing Chain
DDAS Data Access Service
RSPT Process Chain Starter
RSPI Interrupt Process
WWPA Web Design Time Parameter Metadata
WWIB Web Design Time Item Metadata
QVIW Query View
EREL Enterprise Report: Reusable Element
ERPT Enterprise Report
ITEM Web Item (Format SAP BW 3.x)
BITM BEx Web Item
TMPL Web Template (Format SAP BW 3.x)
BTMP BEx Web Template
KPDF KPI Definition
KPCE KPI Catalog Entry
BRSE Broadcast Setting
ANMO Mining Model
ANSO Model Source
DMMO Data Model (currently not used)
ANPR Analysis Process
ACGR Role
CRWB Crystal Report
AQBG InfoSet Query User Group
AQSG InfoSet
AQQU InfoSet Query
DTPA Data Transfer Process
PLST Planning Function Type
PLSE Planning Function
PLSQ Planning Sequence
THEM Theme
PLCR Characteristic Relationships
THJT Key Date of Type Derivation
DMOD Data Flow
RSPV Process Variants
RSPC Process Chain
PLDS Data Slices
ENHO Enhancement/Append
ASOB Analytics Security Object (BI Analysis Authorization)
RRUL Remodeling Rule
RDAC Configuration for Real-Time Data Acqusition
APPS Appplication Set (BPC - Transport)
BIXP Conversion Object
XCLS Xcelsius Dashboard
AAOE Analysis Office Excel Workbook
AAOP Analysis Office PowerPoint
TRPR Operational Data Provider
AZAP Analysis Application
IO_TYPE Type of Requested Data - Also New DS Types RSBWREQUTYPE CHAR 1 0
T Master data text (language dependent description)
H Hierachies
M Master Data Attributes
D Transaction Data
S Segmented DS
LOADALWD Allow loading for real-time data targets RSLOADALLOWED CHAR 1 0
COMPR_AGGR Request SID up to which InfoCube is to be compressed RSMCOMPR INT4 10 0
VALID_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) RSTIMESTMP DEC 15 0
VALID_SID Master data ID RSSID INT4 10 0
TIMDIM_INCON Boolean RS_BOOL CHAR 1 0
NULL False
X True
ARCH_DONE Lower Limit for Write-Only DSO Archiving RSARCH_DONE INT4 10 0
ARCH_TODO Upper Limit for Write-Only DSO Archiving RSARCH_TODO INT4 10 0

RSMDATASTATE_S foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RSMDATASTATE_S ODSOBJECT RSMDATASTATE_S ODSOBJECT RSDODSO Directory of all DataStores ODSOBJECT
RSMDATASTATE_S ODSOBJECT * RSDODSO Directory of all DataStores OBJVERS