1. Home
  2. Resources
  3. SAP Tables
  4. RSD_S_DTA - Properties InfoProvider

SAP Table RSD_S_DTA

Properties InfoProvider

RSD_S_DTA (Properties InfoProvider) 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 RSD_S_DTA to other SAP tables.

RSD_S_DTA table fields

Field Data element Checktable Datatype Length Decimals
INFOPROV InfoProvider RSINFOPROV CHAR 30 0
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 RSREQUTYPE CHAR 1 0
T Master data text (language dependent description)
H Hierachies
M Master data attributes
D Transaction data
IS_TRANSIENT Property: Is transient (InfoProvider, InfoObject) RSD_IS_TRANSIENT CHAR 1 0
NULL Blank
. Radio button
X Selection
CONTAINS_TRANSIENT InfoProvider Contains Transient Objects RSDCONTAINS_TRANS CHAR 1 0
NULL false
X True
DMPROVTYPE Data Manager: Provider Type RSDDMPROVTYPE 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
OBJVERS Object version RSOBJVERS CHAR 1 0
A Active
M Revised
N New
D Content
H Historic
T Transport
LANGU Language Key LANGU LANG 1 0
TXTLG Long description RSTXTLG CHAR 60 0
TXTSH Short description RSTXTSH CHAR 20 0
OBJSTAT Object Status RSOBJSTAT CHAR 3 0
ACT Active, executable
INA Inactive, not executable
OFF Switched off
PRO Productive
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
ACTIVFL Active and revised version do not agree RSACTIVFL CHAR 1 0
X Yes
NULL No
PROTECFL Flag: Protected InfoObject, no changes allowed RSPROTECFL CHAR 1 0
X Yes
NULL No
INFOAREA InfoArea RSINFOAREA CHAR 30 0
NCUMTIM Ref. Time-Char. for Non-cums RSNCUMTIM CHAR 30 0
BCTCOMP Obsolete - do not translate RSDBCTCOMP CHAR 10 0
WIPROGID ID for generated InfoCube write program RSWIPROGID CHAR 25 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
CUBETYPE InfoProvider Type RSCUBETYPE CHAR 1 0
A Aggregate Cube
B Standard InfoCube
H HybridProvider
R Remote InfoCube (-> Cube Subtype)
M MultiProvider (-> TLOGO MPRO!)
P Append
V Virtual InfoProvider
CUBESUBTYPE InfoProvider Subtype RSCUBESUBTYPE CHAR 1 0
R Based on BAPI
S Based on DTP/3.x InfoSource
C Based on Function Module
F SAP HANA-Optimized InfoCube
H Based on an SAP HANA Model
SVRESTR Obsolete Option! (Convert Restrictions (InfoProvider)) RSCUBESVRESTR CHAR 1 0
X Yes
NULL No
O Obsolete (Do Not Use)
SVRESTRNO No Support of Selection Conditions RSCUBESVRESTRNO CHAR 1 0
X Yes
NULL No
SVRESTRGLOBAL Only Global Selection Conditions RSCUBESVRESTRGLOBAL CHAR 1 0
X Yes
NULL No
SVRESTRSEL Obsolete Option! (Simplify Selections (InfoProvider)) RSCUBESVRESTRSEL CHAR 1 0
X Yes
NULL No
O Obsolete (Do Not Use)
SVSUPPHIER Supports Hierarchies RSCUBESVSUPPHIER CHAR 1 0
X Yes
NULL No
SVSUPPACDA Supports Data Integrity in Provider Implementation RSCUBESVSUPPACDA CHAR 1 0
X Yes
NULL No
NOTRANSFRESTR Do Not Transform Selection Conditions RSNOTRANSFRESTR CHAR 1 0
X Yes
NULL No
SVRESTRHIER Obsolete Option! (Expand Hier. Restrictions (InfoProvider)) RSCUBESVRESTRHIER CHAR 1 0
X Yes
NULL No
O Obsolete (Do Not Use)
SVRFCPACK Pack RFC (InfoProvider) RSCUBESVRFCPACK CHAR 1 0
X Yes
NULL No
SVSLOGSYS Source system RSSLOGSYS CHAR 10 0
SVSID SID Support (InfoProvider) RSCUBESVSID CHAR 1 0
X Yes
NULL No
SVNAVATTR Supports Navigation Attributes (InfoProvider) RSCUBESVNAVATTR CHAR 1 0
X Yes
NULL No
SVTRANSFSEL Derive Sel. Conditions from Navigation Attribute RSSVTRANSFSEL CHAR 1 0
X Yes
NULL No
SVINTFORMAT Internal Format (Key Figures) RSCUBESVINTFORMAT CHAR 1 0
X Yes
NULL No
FUNCNAME Name of Function Module/Class/SAP HANA Model RSCUBESVFUNCNAME CHAR 30 0
HDBMODNM SAP Hana Model Name RSHDBMODNM CHAR 64 0
CONVEXITFL Flag: Execute Conversion Exit(s) RSCONVEXITFL CHAR 1 0
NULL False
X True
BASICCUBE BasicCube for Aggregate RSBASICCUBE CHAR 30 0
TRANSACT Real Time / Direct Update RSDTRANSACT CHAR 1 0
NULL False
X True
SLOGSYS Source system RSSLOGSYS CHAR 10 0
ISOURCE InfoSource RSISOURCE CHAR 30 0
UNIQUE_SOURCE Indicator: Unique Source System RSOAUNIQUESOURCE CHAR 1 0
NULL False
X True
WRITECLASNM Name of Class for Write Interface RSDWRITECLASNM CHAR 30 0
DELTACACHE Update Cache Objects in Delta Process RRDELTACACHE CHAR 1 0
NULL false
X True
DELTACACHECLSNM Name of Class for Delta Cache RSDCCLSNM CHAR 30 0
BUFFERTYPE Defines the buffer type RSDBUFFERTYPE CHAR 1 0
A After-Image Buffer
D Delta Buffer
PARTITIONMODE Type of SP Grouping for Delta Caching RRSPPARTITION NUMC 1 0
0 No Grouping
1 Grouping Depending on InfoProvider Types
2 Grouping Depending on InfoProv. Types, InfoCubes Separately
3 Every Provider Separate
INPUTABLE InfoProvider is ready for input; there is a write function RRINPUTPROV CHAR 1 0
NULL False
X True
INPUTMODE Mode of Input Processing RRINPUTMODUS NUMC 1 0
0 Normal Query (No Input)
1 Contains Input-Ready KIDs
9 Contains Lock KIDs
ACTUALDATA Data Integrity RRACTUALDATA NUMC 1 0
0 All InfoProviders up to released status (RQTS0)
1 Real-time InfoCubes up to current version
2 All InfoProviders up to current version (to Qualok)
3 All InfoProviders up to current version (all green requests)
7 Every InfoProvider in MultiProvider according to its setting
9 All InfoProviders (including red requests)
PACKAGEREAD Supports Reading by Package RSDPACKAGEREAD CHAR 1 0
X Yes
NULL No
NOPARALLEL Parallel Reading of Provider Not Permitted RSDNOPARALLEL CHAR 1 0
X Yes
NULL No
DATASORTED Data will be sorted first RSDSVDATASORTED CHAR 1 0
X Yes
NULL No
DATATRUSTED Data will be provided "exactly" (no superset) RSDSVDATATRUSTED CHAR 1 0
X Yes
NULL No
MATERIALIZE Materialization of Read Data RSDMATERIALIZE CHAR 1 0
X Yes
NULL No
MAT_CHAVL Materialize CHAVL-Based Queries RSDMATCHAVL CHAR 1 0
X Yes
NULL No
MATININDEX Create as New Index (BWA Index) RSDMATININDEX CHAR 1 0
X Yes
NULL No
AGGR_TRUSTED Return Aggregated Result Set RSDAGGRTRUSTED CHAR 1 0
X Yes
NULL No
SIMULATE Display of Access Plans RSDSIMULATE CHAR 1 0
X Yes
NULL No
SIDPREFERRED SID Display Preferred RSDSVSIDPREFERRED CHAR 1 0
X Yes
NULL No
SVINTERNAL Use of Internal Remote Provider Interface RSDSVINTERNAL CHAR 1 0
X Yes
NULL No
SVSUPPREQUID InfoProvider Supports Ranges on 0REQUID RSCUBESVSUPPREQUID CHAR 1 0
X Yes
NULL No
SVSIDX4DATA SIDs Exist for all Data of Provider RSDSVSIDX4DATA CHAR 1 0
NULL False
X True
EDSFL Flag: Generate export data source RSEDSFL CHAR 1 0
NULL Blank
. Radio button
X Selection
MOLAPFL Flag: with MOLAP cube RSMOLAPFL CHAR 1 0
X Yes
NULL No
SAMPLRT Sample rate in percent RSSAMPLRATE NUMC 2 0
BIA_STATUS RSD: BW Accelerator Status of InfoCube (BWA Indexes) RSD_BIA_STATUS CHAR 1 0
NULL No BWA Index
X Has a BWA Index
O BWA Index Only
ALLOWCIC Indicator: Compounding Inconsistency Permitted RSDALLOWCIC CHAR 1 0
X Yes
NULL No
DIMID_UNIQUE DIMIDs One-to-One to Characteristic Combinations RSDDIMID_UNIQUE CHAR 1 0
X Yes
NULL No
DELTA_LOAD Delta Load Allowed with RSDRI RSDDELTA_LOAD CHAR 1 0
X Yes
NULL No
FACTTAB Fact table (of an InfoCube) RSFACTTAB CHAR 30 0
FACTVIEW View: Fact table RSFACTVIEW CHAR 30 0
COMPTAB Compressed fact table RSCOMPTAB CHAR 30 0
NCUMVALTAB Non-cumulative value validity table (of an InfoCube) RSNCUMVALTAB CHAR 30 0
VIEWTOTAL View: InfoObjects + navigation attributes RSVIEWTOTAL CHAR 30 0
VIEWIOBJ View: Only InfoObjects RSVIEWIOBJ CHAR 30 0
VIEWNAVATR View: Only navigation attributes RSVIEWNAVATR CHAR 30 0
VIEWIIOBJNM View: Only InfoObjects with InfoObject field names RSVIEWIIOBJNM CHAR 30 0
VIEWTIOBJNM View: InfoObjects + nav.attr. with InfoObject field names RSVIEWTIOBJNM CHAR 30 0
VIEWTIOBJNM2 View: InfoObjects + Nav.Attr. with InfoObject field names(2) RSVIEWTIOBJNM2 CHAR 30 0
VIEWHIOBJNM View: InfoObjects + Nav. attr + Hier. w InfoObj field names RSVIEWHIOBJNM CHAR 30 0
VIEWISET View on InfoSet RSVIEWISET CHAR 30 0
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
PARTMAXCNT Maximum number of partitions RSPARTMAXCNT INT4 10 0
DIMESIZCAT BW: Size Category for Dimension Tables RSDIMESIZCAT 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)
DIMEDATCLS BW: Data class for dimension tables RSDIMEDATCLS CHAR 5 0
CUBESIZCAT BW: Size Category for InfoCube (Fact) Tables RSCUBESIZCAT 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)
CUBEDATCLS BW: Data class for InfoCube (fact)tables RSCUBEDATCLS CHAR 5 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
TSTPNM Last changed by RSTSTPNM USR02 CHAR 12 0
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) RSTIMESTMP DEC 15 0
MASTERPROV InfoProvider RSINFOPROV CHAR 30 0
MASTERTLOGO 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
DBROUTID ID for Generated DataStore Program RSODSPROGID CHAR 25 0
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

RSD_S_DTA foreign key relationships

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