ROOSOURCE SAP (Table Header for SAP BW OLTP Sources (Relevant From 2.0)) Table details
Dictionary Type: Table
Description: Table Header for SAP BW OLTP Sources (Relevant From 2.0)
Description: Table Header for SAP BW OLTP Sources (Relevant From 2.0)
Table field list including key, data, relationships and ABAP select examples
ROOSOURCE is a standard SAP Table which is used to store Table Header for SAP BW OLTP Sources (Relevant From 2.0) data and is available within R/3 SAP systems depending on the version and release level.
The ROOSOURCE table consists of various fields, each holding specific information or linking keys about Table Header for SAP BW OLTP Sources (Relevant From 2.0) data available in SAP. These include OBJVERS (OLTP Source Version), TYPE (DataSource Type), APPLNM (Application Component), BASOSOURCE (Internal Name of DataSource).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = ROOSOURCET
SAP ROOSOURCE table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| OLTPSOURCE | DataSource (OSOA/OSOD) | ROOSOURCER | CHAR | 30 | ROOSOURCED | RO1 | |||
| OBJVERS | OLTP Source Version | ROOBJVERS | CHAR | 1 | ROOBJVERS | ||||
| TYPE | DataSource Type | ROOSTYPE | CHAR | 4 | ROOSTYPE | RO4 | |||
| APPLNM | Application Component | RSAPPLNM | CHAR | 30 | RSAPPLNM | ||||
| BASOSOURCE | Internal Name of DataSource | ROBASOURCE | CHAR | 30 | ROBASOURCE | RO2 | |||
| DELTA | Delta Process for a DataSource | ROGENDELTA | CHAR | 4 | RODELTAM | ALPHA | RODELTA | ||
| STOCKUPD | DataSource generates an initial non-cumulative | ROSTOCK | CHAR | 1 | ROFLAG | ||||
| UPDFLG1 | Indicator | ROFLAG | CHAR | 1 | X | ||||
| UPDFLG2 | Indicator | ROFLAG | CHAR | 1 | X | ||||
| UPDFLG3 | Indicator | ROFLAG | CHAR | 1 | X | ||||
| READONLY | Key Figures for Extractor Tests in Delta Mode | RSONLYREAD | CHAR | 1 | ROFLAG | ||||
| INITSIMU | DataSource Controls the Delta Init Simulation Mode | ROINITSIMU | CHAR | 1 | ROINITSIMU | ||||
| INITCOMMIT | Extractor Needs SAP-Commit After Init-Phase | ROINITCOMM | CHAR | 1 | ROINITCOMM | ||||
| ZDD_ABLE | Indicator: DataSource Can Post During Delta Init | ROZDDABLE | CHAR | 1 | ROFLAG | ||||
| REALTIME | DataSource Is Real-Time Enabled | ROREALTIME | CHAR | 1 | ROFLAG | ||||
| EXMETHOD | DataSource Extraction Method | ROEXMETHOD | CHAR | 2 | ROEXMETHOD | ||||
| EXTRACTOR | DataSource Extractor | ROEXTRACTO | CHAR | 30 | ROEXTRACTO | RO3 | |||
| EXSTRUCT | Name of the provider structure for an InfoSource | ROSTRUC | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
| GENFLAG | DataSource uses generic interfaces | ROGENFLAG | CHAR | 1 | ROFLAG | ||||
| VIRTCUBE | DataSource: Extractor Supports Direct Access | ROVIRTFL | CHAR | 1 | ROVIRT | ||||
| APPENDFLAG | Flag: InfoSource fields were attached at customers | RSCUSTFLAG | CHAR | 1 | X | ||||
| TSTPNM | Last changed by | RSTSTPNM | CHAR | 12 | USR02 | XUBNAME | |||
| TSTPDAT | Changed On | RSTSTPDAT | DATS | 8 | AS4DATE | ||||
| TSTPTIM | Changed at | RSTSTPTIM | TIMS | 6 | AS4TIME | ||||
| INVFIELD | Field That Transfers Record Mode | RSINVFD | CHAR | 30 | RSFIELDNM | ||||
| GENDELTAFD | Delta-Specific Field for DataSource | RSGENDLTFD | CHAR | 30 | Assigned to domain | FDNAME | |||
| GENDELTATP | Type of Delta-Relevant Field | RSGENDLTTP | CHAR | 1 | RSGENDLTTP | ||||
| DELTASAFE1 | Safety Interval Lower Limit | RSDLTASAF1 | CHAR | 45 | RSLOW | ||||
| DELTASAFE2 | Safety Interval Upper Limit of Delta Selection | RSDLTASAFE | CHAR | 45 | RSLOW | ||||
| DLTAGETMAX | Function Module for Determining Maximum Value | RSDLGETMAX | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| SEGMENT | Indicator | ROFLAG | CHAR | 1 | X | ||||
| AFTERIMP | After-Import Methods of a DataSource | AFTERIMP | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| BEFOREXP | Function name | FUNCNAME | CHAR | 30 | Assigned to domain | FUNCNAME | LIB | ||
| MAINTAIN | DataSource Event Maintenance | MAINTAINDS | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| CHECKDS | Function name | FUNCNAME | CHAR | 30 | Assigned to domain | FUNCNAME | LIB | ||
| SAVEDS | Save Event of a DataSource | SAVEDS | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| TRANSPDS | Transport Event of a DataSource | TRSANSPDS | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| DELETE_DS | Deletion of Datasource | DELETE_DS | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| RESETDELTA | Function Module for Invalidatin a Delta Update | ROOSFDELTA | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| APPL_PROP | Function name | FUNCNAME | CHAR | 30 | Assigned to domain | FUNCNAME | LIB | ||
| ACTIVATE | Activate DataSource Event | ROACTIVATE | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| ZDD_REPLAY | DataSource Event: Replay for Zero Downtime Delta | ROREPLAYZD | CHAR | 30 | Assigned to domain | FUNCNAME | |||
| TFMETHODS | Supported Transfer Methods | ROTFMETHDS | CHAR | 1 | ROTFMETHDS | ||||
| ARCHMETHOD | DataSource Archive Connection | ROARCHMTHD | CHAR | 1 | ROARCHMTHD | ||||
| DUPREC | Indicator: DataSource Delivers Duplicate Records | RODUPREC | CHAR | 1 | RODUPREC | ||||
| SCLIENT | DataSource is only allwd to be replicated for single client | ROSCLIENT | CHAR | 1 | ROSCLIENT | ||||
| PRIMSEGID | Primary Segment | ROOSPRIMS | NUMC | 4 | ROOSSEGID | ||||
| OBJECTFD | Field Name: Object ID | ROOSOBJFD | CHAR | 30 | RSFIELDNM | ||||
| CONTSRCVERS | Content Version of DataSource | ROCONTVERS | CHAR | 6 | ROCONTVERS | ||||
| RECONCILIATION | DataSource for Data Reconciliation | RORECONCILIATION | CHAR | 1 | ROFLAG |
| Key field | Non-key field |
How do I retrieve data from SAP table ROOSOURCE using ABAP code
The following ABAP code Example will allow you to do a basic selection on ROOSOURCE to SELECT all data from the tableDATA: WA_ROOSOURCE TYPE ROOSOURCE.
SELECT SINGLE *
FROM ROOSOURCE
INTO CORRESPONDING FIELDS OF WA_ROOSOURCE
WHERE...
How to access SAP table ROOSOURCE
Within an ECC or HANA version of SAP you can also view further information about ROOSOURCE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects