SAP table RSDS (DataSource in BW)

SAP table RSDS has 3 primary key fields being DATASOURCE,LOGSYS,OBJVERS.

Field Description Data Type Length Decimals Checktable Data Element
DATASOURCE DataSource (OSOA/OSOD) CHAR 30 0 ROOSOURCER
LOGSYS Source system CHAR 10 0 * RSSLOGSYS
OBJVERS Object version CHAR 1 0 RSOBJVERS
A Active
D Content
H Historic
M Revised
N New
T Transport
OBJSTAT Object Status CHAR 3 0 RSOBJSTAT
ACT Active, executable
INA Inactive, not executable
OFF Switched off
PRO Production
ACTIVFL Active and revised version do not agree CHAR 1 0 RSACTIVFL
TYPE Data Type of a DataSource CHAR 1 0 RSDS_REQUTYPE
D Transaction Data
H Hierarchies
M Master Data Attributes
S Segmented Data
T Master Data Text
PRIMSEGID Primary Segment NUMC 4 0 RSDS_PRIMSEGID
OBJECTFD Field Name: Object ID CHAR 30 0 RSDS_OBJECTFD
APPLNM Application Component CHAR 30 0 RSAPPLNM
BASOSOURCE Internal Name of DataSource CHAR 30 0 ROBASOURCE
DELTA Delta Process for a DataSource CHAR 4 0 * ROGENDELTA
STOCKUPD Flag: Creation of opening balance is supported CHAR 1 0 RSSTOCKUPD
PACKGUPD Repeated request of a data packet supported CHAR 1 0 RSPACKGUPD
REALTIME Real-Time Property of a DataSource CHAR 1 0 RSDS_REALTIME
Real-Time Data Acquisition Is Not Supported
X Real-Time Data Acquisition Supported
TIMDEPFL Data Is Time Dependent CHAR 1 0 RSDS_ISTIMEDEP
LANGUDEPFL Data Is Language Dependent CHAR 1 0 RSDS_ISLANGDEP
EXSTRUCTURE Name of the provider structure for an InfoSource CHAR 30 0 * ROSTRUC
VIRTCUBE DataSource: Extractor Supports Direct Access CHAR 1 0 RSDS_ROVIRT
Not Allowed; Data Replication Without PSA Allowed
1 Allowed
2 Allowed (Pre-Aggregate Data in Extractor)
D Not Allowed; Data Replication Only with PSA
M Allowed; Data Replication Only Without PSA
HYBRIDACCESS DataSource: HybridProvider Access Supported CHAR 1 0 RSDSHYBRIDACCESS
CHARONLY Structure only allows character fields CHAR 1 0 RSCHARONLY
TSTMPOLTP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 RSTIMESTMP
DELTAACT Boolean CHAR 1 0 RS_BOOL
False
X True
ICON Icon in text fields (substitute display, alias) CHAR 4 0 * ICON_D
CONTREL Content release CHAR 6 0 RSCONTREL
CONTTIMESTMP Content time stamp: Last modification to the object by SAP DEC 15 0 RSCONTTIMESTMP
APPL_CALLBACK Function Module Rule Proposal CHAR 30 0 * RSDS_APPLPROP
TFMETHODS Supported transfer methods CHAR 1 0 RSTFMETHODS
Default Value (depending on DataSource type)
1 Only IDOC
2 Only PSA
3 IDOC and PSA
ARCHMETHOD Archive Link of a DataSource CHAR 1 0 RSARCHMTHD
DUPREC Flag: DataSource returns duplicate records CHAR 1 0 RSDUPREC
Undefined
0 None
1 Allowed
INITSIMU Delta process initialization simulation CHAR 1 0 RSINITSIMU
ZDD_ABLE Boolean CHAR 1 0 RS_BOOL
False
X True
RECONCILIATION DataSource for Data Reconciliation CHAR 1 0 RSDS_RECO
CHAR_PSA PSA for All Segments in CHAR Format CHAR 1 0 RSDS_CHAR_PSA
CHAR1000 Thousand separator CHAR 1 0 RSTHOUSAND
DEZICHAR Character for decimal point CHAR 1 0 RSDECIMAL
CONTPACKET Package CHAR 30 0 * DEVCLASS
CONTMASTER Object Name in Object Directory CHAR 40 0 SOBJ_NAME
DELTAFD Delta-Relevant Field of DataSource CHAR 30 0 RSDS_DELTAFD
DELTATP Type of Delta-Relevant Field CHAR 1 0 RSDS_DELTATP
Do not Use
D Date
N Numeric Pointer
T Time Stamp - Short
U Time Stamp Long (UTC)
DELTALOW Safety Interval Lower Limit CHAR 45 0 RSDLTASAF1
DELTAHIGH Safety Interval Upper Limit of Delta Selection CHAR 45 0 RSDLTASAFE
DELTATZ Time Zone CHAR 6 0 TTZZ TZNZONE
TSTPNM Last Changed By CHAR 12 0 USR02 RSTSTPNM
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 RSTIMESTMP
CODEID ID of the Generated Program CHAR 25 0 RSDS_CODEID
TRANSTRUS_APPL Deep Structure: Application Structures of a DataSource CHAR 30 0 * RSDS_STRAPPL
TRANSTRUS_CHAR Deep Structure: DataSource Character Structures CHAR 30 0 * RSDS_STRCHAR
HASHNUMBER Number of Hash Name for DataSource NUMC 5 0 RSDS_HASHNUM
CONTSRCTYPE Content Release Type CHAR 3 0 * RSDS_SRCTYPE
R/3 R/3 Release
SAP Free Versioning
CONTSRCVERS Content Version of DataSource CHAR 6 0 RSDS_SRCVERS
PSADATCLS Data Class for PSA Table CHAR 5 0 * RSDS_PSADATCLS
PSASIZCAT Size Category for PSA Table CHAR 2 0 RSDS_PSASIZCAT
CONVLANGU Conversion Language LANG 1 0 * RSDS_CONVLANGU
EXTTABL Table should be generated as extended table CHAR 1 0 RSEXTTABL
PSA should be generated as normal table
X PSA should be generated as extended table

RSDS foreign key relationships

Table Field Check Table Check Field
0 RSDS DELTATZ TTZZ Time zones TZONE
1 RSDS TSTPNM USR02 Logon Data (Kernel-Side Use) BNAME