SAP table ROOSOURCE (Table Header for SAP BW OLTP Sources (Relevant From 2.0))

SAP table ROOSOURCE has 2 primary key fields being OLTPSOURCE,OBJVERS.

Field Description Data Type Length Decimals Checktable Data Element
OLTPSOURCE DataSource (OSOA/OSOD) CHAR 30 0 ROOSOURCER
OBJVERS OLTP Source Version CHAR 1 0 ROOBJVERS
A active version
D Delivered Version (From this System)
M Modified Version
P Version Delivered in Patch
TYPE DataSource Type CHAR 4 0 ROOSTYPE
APPE DataSource Append
ATTR Attributes
HIER Hierarchy Nodes
ODS ODS DataSource
SEGM Segmented Data
TEXT Text
TRAN Transactional Data
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 RODELTAM ROGENDELTA
STOCKUPD DataSource generates an initial non-cumulative CHAR 1 0 ROSTOCK
UPDFLG1 Indicator CHAR 1 0 ROFLAG
No
X Yes
UPDFLG2 Indicator CHAR 1 0 ROFLAG
No
X Yes
UPDFLG3 Indicator CHAR 1 0 ROFLAG
No
X Yes
READONLY Key Figures for Extractor Tests in Delta Mode CHAR 1 0 RSONLYREAD
INITSIMU DataSource Controls the Delta Init Simulation Mode CHAR 1 0 ROINITSIMU
undefined
1 supported
2 not supported
INITCOMMIT Extractor Needs SAP-Commit After Init-Phase CHAR 1 0 ROINITCOMM
Undefined
1 SAP Commit Required
2 No SAP Commit Required
ZDD_ABLE Indicator: DataSource Can Post During Delta Init CHAR 1 0 ROZDDABLE
REALTIME DataSource Is Real-Time Enabled CHAR 1 0 ROREALTIME
EXMETHOD DataSource Extraction Method CHAR 2 0 ROEXMETHOD
A DataSource Append
CA Class-Based BI Agent
CO Extraction Using ODP Cursor Interface
D Fixed Values for Domain
F1 Function Module (Complete Interface)
F2 Function Module (Simple Interface)
FS Function Module (Segmented Data Transfer)
Q Extraction Using ABAP Query
V Transparent Table or DB View
EXTRACTOR DataSource Extractor CHAR 30 0 ROEXTRACTO
EXSTRUCT Name of the provider structure for an InfoSource CHAR 30 0 * ROSTRUC
GENFLAG DataSource uses generic interfaces CHAR 1 0 ROGENFLAG
VIRTCUBE DataSource: Extractor Supports Direct Access CHAR 1 0 ROVIRTFL
APPENDFLAG Flag: InfoSource fields were attached at customers CHAR 1 0 RSCUSTFLAG
TSTPNM Last Changed By CHAR 12 0 USR02 RSTSTPNM
TSTPDAT Changed On DATS 8 0 RSTSTPDAT
TSTPTIM Changed at TIMS 6 0 RSTSTPTIM
INVFIELD Field That Transfers Record Mode CHAR 30 0 RSINVFD
GENDELTAFD Delta-Specific Field for DataSource CHAR 30 0 * RSGENDLTFD
GENDELTATP Type of Delta-Relevant Field CHAR 1 0 RSGENDLTTP
Medium
D Day
T Time Stamp (Local)
U Time Stamp (UTC)
DELTASAFE1 Safety Interval Lower Limit CHAR 45 0 RSDLTASAF1
DELTASAFE2 Safety Interval Upper Limit of Delta Selection CHAR 45 0 RSDLTASAFE
DLTAGETMAX Function Module for Determining Maximum Value CHAR 30 0 * RSDLGETMAX
SEGMENT Indicator CHAR 1 0 ROFLAG
No
X Yes
AFTERIMP After-Import Methods of a DataSource CHAR 30 0 * AFTERIMP
BEFOREXP Function name CHAR 30 0 * FUNCNAME
MAINTAIN DataSource Event Maintenance CHAR 30 0 * MAINTAINDS
CHECKDS Function name CHAR 30 0 * FUNCNAME
SAVEDS Save Event of a DataSource CHAR 30 0 * SAVEDS
TRANSPDS Transport Event of a DataSource CHAR 30 0 * TRSANSPDS
DELETE_DS Deletion of Datasource CHAR 30 0 * DELETE_DS
RESETDELTA Function Module for Invalidatin a Delta Update CHAR 30 0 * ROOSFDELTA
APPL_PROP Function name CHAR 30 0 * FUNCNAME
ACTIVATE Activate DataSource Event CHAR 30 0 * ROACTIVATE
ZDD_REPLAY DataSource Event: Replay for Zero Downtime Delta CHAR 30 0 * ROREPLAYZD
TFMETHODS Supported Transfer Methods CHAR 1 0 ROTFMETHDS
Undefined (Depending on Data Type)
1 IDOC Only
2 PSA Only
3 PSA and IDOC
ARCHMETHOD DataSource Archive Connection CHAR 1 0 ROARCHMTHD
No Archive Access
1 Archive Access with Mandatory File Selection
2 Archive Access with Optional File Selection
DUPREC Indicator: DataSource Delivers Duplicate Records CHAR 1 0 RODUPREC
Undefined
0 are not extracted
1 may occur
SCLIENT DataSource is only allwd to be replicated for single client CHAR 1 0 ROSCLIENT
No restrictions
X Replication Only For "Single Client"
PRIMSEGID Primary Segment NUMC 4 0 ROOSPRIMS
OBJECTFD Field Name: Object ID CHAR 30 0 ROOSOBJFD
CONTSRCVERS Content Version of DataSource CHAR 6 0 ROCONTVERS
RECONCILIATION DataSource for Data Reconciliation CHAR 1 0 RORECONCILIATION

ROOSOURCE foreign key relationships

Table Field Check Table Check Field
0 ROOSOURCE DELTA RODELTAM BW Delta Process DELTA
1 ROOSOURCE TSTPNM USR02 Logon Data (Kernel-Side Use) BNAME