1. Home
  2. Resources
  3. SAP Tables
  4. ROOSOURCE - Table Header for SAP BW OLTP Sources (Relevant From 2.0)

SAP Table ROOSOURCE

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

ROOSOURCE (Table Header for SAP BW OLTP Sources (Relevant From 2.0)) 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 ROOSOURCE to other SAP tables.

ROOSOURCE table fields

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

ROOSOURCE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROOSOURCE DELTA ROOSOURCE DELTA RODELTAM BW Delta Process DELTA
ROOSOURCE TSTPNM * USR02 Logon Data (Kernel-Side Use) MANDT
ROOSOURCE TSTPNM ROOSOURCE TSTPNM USR02 Logon Data (Kernel-Side Use) BNAME