SAP Table RSDODSO

Directory of all DataStores

RSDODSO (Directory of all DataStores) 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 RSDODSO to other SAP tables.

RSDODSO table fields

Field Data element Checktable Datatype Length Decimals
ODSOBJECT DataStore Object RSDODSOBJECT CHAR 30 0
OBJVERS Object version RSOBJVERS CHAR 1 0
A Active
M Revised
N New
D Content
H Historic
T Transport
CONTREL Content release RSCONTREL CHAR 6 0
CONTTIMESTMP Content time stamp: Last modification to the object by SAP RSCONTTIMESTMP DEC 15 0
OWNER Owner (Person Responsible) RSOWNER CHAR 12 0
BWAPPL BW Application (Namespace) RSBWAPPL CHAR 10 0
INFOAREA InfoArea RSINFOAREA CHAR 30 0
BCTCOMP Obsolete - do not translate RSDBCTCOMP CHAR 10 0
SUPERPROV Higher-Level InfoProvider RSSUPERPROV CHAR 30 0
SUPERTLOGO TLOGO Type of Higher-Level Provider RSSUPERTLOGO 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
NCUMTIM Ref. Time-Char. for Non-cums RSNCUMTIM CHAR 30 0
PLANNING_MODE DataStore Object: Mode for Use as Planning DSO RSDODSO_PLANNING_MODE CHAR 1 0
X Yes
NULL No
ACTVIEWGEN DataStore Object: Active Table Database View to be Generated RSDODSO_ACTVIEWGEN CHAR 1 0
X Yes
NULL No
AUTOQUALOKFL Set Quality Status to 'OK' Automatically RSMAUTOQUALOKFL CHAR 1 0
NULL false
X True
AUTOCOMPRFL Compress Automatically After Roll-Up (or After Load) RSMAUTOCOMPRFL CHAR 1 0
NULL false
X True
NOEDSFL Flag: Do Not Generate Export DataSource RSDODSO_NOEDSFL CHAR 1 0
X Yes
NULL No
BEXFL SID Generation RSDBEXFL CHAR 1 0
NULL During Reporting
X During Activation
N Never Create SIDs
ODSOTYPE Type of DataStore Object RSDODSOTYPE CHAR 1 0
NULL Standard
T Direct Update
W Write-Optimized
IMOFL DataStore Object: SAP HANA-Optimized RSDODSO_IMOFL CHAR 1 0
X Yes
NULL No
DELTACHECK Delta Consistency Check for DataStore RSMDELTACHECK CHAR 1 0
NULL False
X True
UOM_IOBJNM Reference InfoObject for Quantity Conversion RSDG_UOM_IOBJNM CHAR 30 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
ODSASIZCAT Size Category for DS Tables of Active Records RSDODSASIZCAT 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)
ODSADATCLS Data Type for DataStore Tables of Active Records RSDODSADATCLS CHAR 5 0
ODSMSIZCAT Size Category for DS Activation Queue RSDODSMSIZCAT 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)
ODSMDATCLS Data Class for DS Activation Queue RSDODSMDATCLS CHAR 5 0
INSERTONLY Overwriting data records not permitted RSINSERTONLY CHAR 1 0
X Yes
NULL No
KEY_NOT_UNIQUE Allow Duplicate Data Records RSDODSO_KEY_NOT_UNIQUE CHAR 1 0
X Yes
NULL No
TSTPNM Last changed by RSTSTPNM USR02 CHAR 12 0
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) RSTIMESTMP DEC 15 0
BWSTATISTICS Boolean RS_BOOL CHAR 1 0
NULL False
X True
BWSTATWHM Boolean RS_BOOL CHAR 1 0
NULL False
X True
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
PARTMODE Partitioning Type RSPARTMODE CHAR 1 0
NULL Not Partitioned
X Partitioned
M Multi-Dimensional Clustering
I Index Clustering
PARTTIM Partitioning time char. RSPARTTIM CHAR 30 0
PARTVL_FROM Lower limit (partitioning value) RSPARTVL_FROM CHAR 10 0
PARTVL_TO Upper Limit (Partitioning Value) RSPARTVL_TO CHAR 10 0
MPPFL DataStore Object: Flag for Massively Parallel Processing RSDODSO_MPPFL CHAR 1 0
X Yes
NULL No

RSDODSO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RSDODSO TSTPNM * USR02 Logon Data (Kernel-Side Use) MANDT
RSDODSO TSTPNM RSDODSO TSTPNM USR02 Logon Data (Kernel-Side Use) BNAME