ROOSOURCE table in SAP

ROOSOURCE table in SAP provides you detail information of each of the standard datasource irrespective of whether it is active.

Here you can check the following

1. whether delta is applicable
2. If yes, what is the delta method.

The following delta process are available. this is import to decide on the datatargets to use in the BW side.

BLANK     Delta Only Via Full Upload (ODS or InfoPackage Selection)
A    ALE Update Pointer (Master Data)
ABR  Complete Delta with Deletion Flag Via Delta Queue(Cube-Comp)
ABR1 Like Method 'ABR' But Serialization Only by Requests
ADD  Additive Extraction Via Extracto (e.g. LIS Info Structures)
ADDD Like 'ADD' But Via Delta Queue (Cube-Compatible)
AIE  After-Images Via Extractor (FI-GL/AP/AR)
AIED After-Images with Deletion Flag Via Extractor (FI-GL/AP/AR)
AIM  After-Images Via Delta Queue (e.g. FI-AP/AR)
AIMD After-Images with Deletion Flag Via Delta Queue (e.g. BtB)
CUBE InfoCube Extraction
D    Unspecific Delta Via Delta Queue (Not ODS-Compatible)
E    Unspecific Delta Via Extractor (Not ODS-Compatible)
FIL0 Delta Via File Import with After-Images
FIL1 Delta Via File Import with Delta Images
NEWD Only New Records (Inserts) Via Delta Queue (Cube-Compatible)
NEWE Only New Records (Inserts) Via Extractor (Cube-Compatible)
O
ODS  ODS Extraction
X    Delta Unspecified (Do Not Use!)



Further, you can find the
extract structure name,
extractor program,
delta specific field for datasource,
lower safety interval for delta selection
upper safety interval for delta selection

A good undersanding of this table is important to have better understanding of datasources and its usage in SAP BW.