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

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ BC-BW (Application Component) BW Service API
     ⤷ RSUM (Package) BW Service API: Metadata

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ROOSOURCE	Table Relationship Diagram
Short Description	Table Header for SAP BW OLTP Sources (Relevant From 2.0)

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OLTPSOURCE	☑	ROOSOURCER	ROOSOURCED	CHAR	30	0	DataSource (OSOA/OSOD)
2	OBJVERS	☑	ROOBJVERS	ROOBJVERS	CHAR	1	0	OLTP Source Version
3	TYPE	☐	ROOSTYPE	ROOSTYPE	CHAR	4	0	DataSource Type
4	APPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
5	BASOSOURCE	☐	ROBASOURCE	ROBASOURCE	CHAR	30	0	Internal Name of DataSource
6	.INCLUDE	☐				0	0	Indicators for Delta Extraction
7	DELTA	☐	ROGENDELTA	RODELTA	CHAR	4	0	Delta Process for a DataSource	RODELTAM
8	STOCKUPD	☐	ROSTOCK	ROFLAG	CHAR	1	0	DataSource generates an initial non-cumulative
9	UPDFLG1	☐	ROFLAG	X	CHAR	1	0	Indicator
10	UPDFLG2	☐	ROFLAG	X	CHAR	1	0	Indicator
11	UPDFLG3	☐	ROFLAG	X	CHAR	1	0	Indicator
12	READONLY	☐	RSONLYREAD	ROFLAG	CHAR	1	0	Key Figures for Extractor Tests in Delta Mode
13	INITSIMU	☐	ROINITSIMU	ROINITSIMU	CHAR	1	0	DataSource Controls the Delta Init Simulation Mode
14	INITCOMMIT	☐	ROINITCOMM	ROINITCOMM	CHAR	1	0	Extractor Needs SAP-Commit After Init-Phase
15	ZDD_ABLE	☐	ROZDDABLE	ROFLAG	CHAR	1	0	Indicator: DataSource Can Post During Delta Init
16	REALTIME	☐	ROREALTIME	ROFLAG	CHAR	1	0	DataSource Is Real-Time Enabled
17	.INCLUDE	☐				0	0	Description of Extraction for a DataSource
18	EXMETHOD	☐	ROEXMETHOD	ROEXMETHOD	CHAR	2	0	DataSource Extraction Method
19	EXTRACTOR	☐	ROEXTRACTO	ROEXTRACTO	CHAR	30	0	DataSource Extractor
20	EXSTRUCT	☐	ROSTRUC	AS4TAB	CHAR	30	0	Name of the provider structure for an InfoSource	*
21	GENFLAG	☐	ROGENFLAG	ROFLAG	CHAR	1	0	DataSource uses generic interfaces
22	VIRTCUBE	☐	ROVIRTFL	ROVIRT	CHAR	1	0	DataSource: Extractor Supports Direct Access
23	APPENDFLAG	☐	RSCUSTFLAG	X	CHAR	1	0	Flag: InfoSource fields were attached at customers
24	.INCLUDE	☐				0	0	Include: Last changed by, date, time
25	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
26	TSTPDAT	☐	RSTSTPDAT	AS4DATE	DATS	8	0	Changed On
27	TSTPTIM	☐	RSTSTPTIM	AS4TIME	TIMS	6	0	Changed at
28	INVFIELD	☐	RSINVFD	RSFIELDNM	CHAR	30	0	Field That Transfers Record Mode
29	.INCLUDE	☐				0	0	Metadata for Generic Delta
30	GENDELTAFD	☐	RSGENDLTFD	FDNAME	CHAR	30	0	Delta-Specific Field for DataSource	*
31	GENDELTATP	☐	RSGENDLTTP	RSGENDLTTP	CHAR	1	0	Type of Delta-Relevant Field
32	DELTASAFE1	☐	RSDLTASAF1	RSLOW	CHAR	45	0	Safety Interval Lower Limit
33	DELTASAFE2	☐	RSDLTASAFE	RSLOW	CHAR	45	0	Safety Interval Upper Limit of Delta Selection
34	DLTAGETMAX	☐	RSDLGETMAX	FUNCNAME	CHAR	30	0	Function Module for Determining Maximum Value	*
35	SEGMENT	☐	ROFLAG	X	CHAR	1	0	Indicator
36	.INCLUDE	☐				0	0	DataSource Methods
37	AFTERIMP	☐	AFTERIMP	FUNCNAME	CHAR	30	0	After-Import Methods of a DataSource	*
38	BEFOREXP	☐	FUNCNAME	FUNCNAME	CHAR	30	0	Function name	*
39	MAINTAIN	☐	MAINTAINDS	FUNCNAME	CHAR	30	0	DataSource Event Maintenance	*
40	CHECKDS	☐	FUNCNAME	FUNCNAME	CHAR	30	0	Function name	*
41	SAVEDS	☐	SAVEDS	FUNCNAME	CHAR	30	0	Save Event of a DataSource	*
42	TRANSPDS	☐	TRSANSPDS	FUNCNAME	CHAR	30	0	Transport Event of a DataSource	*
43	DELETE_DS	☐	DELETE_DS	FUNCNAME	CHAR	30	0	Deletion of Datasource	*
44	RESETDELTA	☐	ROOSFDELTA	FUNCNAME	CHAR	30	0	Function Module for Invalidatin a Delta Update	*
45	APPL_PROP	☐	FUNCNAME	FUNCNAME	CHAR	30	0	Function name	*
46	ACTIVATE	☐	ROACTIVATE	FUNCNAME	CHAR	30	0	Activate DataSource Event	*
47	ZDD_REPLAY	☐	ROREPLAYZD	FUNCNAME	CHAR	30	0	DataSource Event: Replay for Zero Downtime Delta	*
48	TFMETHODS	☐	ROTFMETHDS	ROTFMETHDS	CHAR	1	0	Supported Transfer Methods
49	ARCHMETHOD	☐	ROARCHMTHD	ROARCHMTHD	CHAR	1	0	DataSource Archive Connection
50	DUPREC	☐	RODUPREC	RODUPREC	CHAR	1	0	Indicator: DataSource Delivers Duplicate Records
51	SCLIENT	☐	ROSCLIENT	ROSCLIENT	CHAR	1	0	DataSource is only allwd to be replicated for single client
52	PRIMSEGID	☐	ROOSPRIMS	ROOSSEGID	NUMC	4	0	Primary Segment
53	OBJECTFD	☐	ROOSOBJFD	RSFIELDNM	CHAR	30	0	Field Name: Object ID
54	CONTSRCVERS	☐	ROCONTVERS	ROCONTVERS	CHAR	6	0	Content Version of DataSource
55	RECONCILIATION	☐	RORECONCILIATION	ROFLAG	CHAR	1	0	DataSource for Data Reconciliation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROOSOURCE	DELTA	RODELTAM	DELTA	KEY	1	CN
2	ROOSOURCE	TSTPNM	USR02	BNAME	KEY	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in