Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

ODSOBJECT

DataStore Object

RSDODSOBJECT

CHAR

OBJVERS

Object version

RSOBJVERS

CHAR

Value	Description
A	Active
M	Revised
N	New
D	Content
H	Historic
T	Transport

CONTREL

Content release

RSCONTREL

CHAR

CONTTIMESTMP

Content time stamp: Last modification to the object by SAP

RSCONTTIMESTMP

DEC

OWNER

Owner (Person Responsible)

RSOWNER

CHAR

BWAPPL

BW Application (Namespace)

RSBWAPPL

CHAR

INFOAREA

InfoArea

RSINFOAREA

CHAR

BCTCOMP

Obsolete - do not translate

RSDBCTCOMP

CHAR

SUPERPROV

Higher-Level InfoProvider

RSSUPERPROV

CHAR

SUPERTLOGO

TLOGO Type of Higher-Level Provider

RSSUPERTLOGO

CHAR

Value	Description
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

PLANNING_MODE

DataStore Object: Mode for Use as Planning DSO

RSDODSO_PLANNING_MODE

CHAR

Value	Description
X	Yes
NULL	No

ACTVIEWGEN

DataStore Object: Active Table Database View to be Generated

RSDODSO_ACTVIEWGEN

CHAR

Value	Description
X	Yes
NULL	No

AUTOQUALOKFL

Set Quality Status to 'OK' Automatically

RSMAUTOQUALOKFL

CHAR

Value	Description
NULL	false
X	True

AUTOCOMPRFL

Compress Automatically After Roll-Up (or After Load)

RSMAUTOCOMPRFL

CHAR

Value	Description
NULL	false
X	True

NOEDSFL

Flag: Do Not Generate Export DataSource

RSDODSO_NOEDSFL

CHAR

Value	Description
X	Yes
NULL	No

BEXFL

SID Generation

RSDBEXFL

CHAR

Value	Description
NULL	During Reporting
X	During Activation
N	Never Create SIDs

ODSOTYPE

Type of DataStore Object

RSDODSOTYPE

CHAR

Value	Description
NULL	Standard
T	Direct Update
W	Write-Optimized

IMOFL

DataStore Object: SAP HANA-Optimized

RSDODSO_IMOFL

CHAR

Value	Description
X	Yes
NULL	No

DELTACHECK

Delta Consistency Check for DataStore

RSMDELTACHECK

CHAR

Value	Description
NULL	False
X	True

UOM_IOBJNM

Reference InfoObject for Quantity Conversion

RSDG_UOM_IOBJNM

CHAR

AUTOACTIVATEFL

Activate DataStore Object Data Automatically

RSMAUTOACTIVATEFL

CHAR

Value	Description
NULL	false
X	True

AUTOPROCESSFL

Update Data from DataStore Object Automatically

RSMAUTOPROCESSFL

CHAR

Value	Description
NULL	false
X	True

ODSASIZCAT

Size Category for DS Tables of Active Records

RSDODSASIZCAT

CHAR

Value	Description
NULL	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

ODSMSIZCAT

Size Category for DS Activation Queue

RSDODSMSIZCAT

CHAR

Value	Description
NULL	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

INSERTONLY

Overwriting data records not permitted

RSINSERTONLY

CHAR

Value	Description
X	Yes
NULL	No

KEY_NOT_UNIQUE

Allow Duplicate Data Records

RSDODSO_KEY_NOT_UNIQUE

CHAR

Value	Description
X	Yes
NULL	No

TSTPNM

Last changed by

RSTSTPNM

USR02

CHAR

TIMESTMP

UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

RSTIMESTMP

DEC

BWSTATISTICS

Boolean

RS_BOOL

CHAR

Value	Description
NULL	False
X	True

BWSTATWHM

Boolean

RS_BOOL

CHAR

Value	Description
NULL	False
X	True

QPROPVERS

Conversion Version Query Properties

RSQPROPVERS

NUMC

Value	Description
00	3.X /7.0 to SP12
01	7.0 SP13
02	7.20 SP1

READMODE

Read Mode

RSRREADMODE

CHAR

Value	Description
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

Value	Description
I	Cache is inactive
NULL	Local Cache
D	Cache in DataBase

CACHEDELAY

Cache Validity Period in Seconds

RSRCACHEDELAY

INT4

NLREADMODE

Read Modus for Near-Line Storage

RSD_NLREADMODE

CHAR

Value	Description
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

Value	Description
NULL	False
X	True

KIDSEL

Use Selection of Structure Elements

RRKIDSEL

CHAR

Value	Description
NULL	False
X	True

CACHEUSEREXIT

Indicator: Do not Use Cache for this Report

RSRNOCACHEFL

CHAR

Value	Description
NULL	false
X	True

NOHPA

Obsolete Field (Do Not Use BWA Index)

RRSNOHPA

CHAR

Value	Description
NULL	False
X	True

TREXOPS

Operations in SAP HANA/BWA

RSRTREXOPS

CHAR

Value	Description
NULL	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

Value	Description
NULL	False
X	True

PARTMODE

Partitioning Type

RSPARTMODE

CHAR

Value	Description
NULL	Not Partitioned
X	Partitioned
M	Multi-Dimensional Clustering
I	Index Clustering

PARTTIM

Partitioning time char.

RSPARTTIM

CHAR

PARTVL_FROM

Lower limit (partitioning value)

RSPARTVL_FROM

CHAR

PARTVL_TO

Upper Limit (Partitioning Value)

RSPARTVL_TO

CHAR

MPPFL

DataStore Object: Flag for Massively Parallel Processing

RSDODSO_MPPFL

CHAR

Value	Description
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