Question Re: ROOSOURCE in Technology Q&A

ROOSOURCE

Former Member — Tue, 13 Jun 2006 07:16:59 GMT

Hello fellows..

I need some help on ROOSOURCE.

Can someone paint a picture on how to use ROOSOURCE in order to discover table of origin or originating datasources?

Thanks in advance.

Re: ROOSOURCE

Former Member — Tue, 13 Jun 2006 07:23:34 GMT

hi,

You can use the table ROOSOURCE in R/3 to view all the info about the datasource. If you want to view the info about the fields then use the table ROOSFIELD

in SE11 or SE16

Shreya

Re: ROOSOURCE

Former Member — Tue, 13 Jun 2006 07:32:34 GMT

Hi David,

See if this helps-

/people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins

regards

Vikash

Re: ROOSOURCE

Former Member — Tue, 13 Jun 2006 11:11:53 GMT

Hi David,

The Table ROOSOURCE is the Header table for SAP BW OLTP Sources.

What kind of information this holds...?

To explain this lets take the example of the Data Source = 0BPARTNER_ATTR (BUsiness Partner).

The following commonly used info is held in this table

OLTPSOURCE = 0BPARTNER_ATTR (name of Data Source)

TYPE = If its an Attribute, text or Hierarchy . IN our case its an attribute.

EXMETHOD = How the data comes , if it comes directly from transparent table or using fixed domain values or function module etc. In our case it comes directly from the standard BP table BUT000.

EXTRACTOR = The source from where the data is got. In our case it comes from the transparent table BUT000.

EXSTRUCT = This is basically the extract structure used. IN our case it is BUS000_BW.

OBJSVERS = Version of the DS.

DELTA = The image of the record.

The table ROOSFIELD is like a Detail table to the Header table ROOSOURCE. The ROOSFIELD table holds the properties of the individual fields of the Data Source.

The important fields to note here are ...

SELECTION = This fields controls if the field of the data source is visible or not and also if it is available for selection.

NOTEXREL = This field decides if the field of the data source will be passed to the extractor or not.

Hope this information helps.

Thanks & Regards,

Re: ROOSOURCE

Former Member — Tue, 13 Jun 2006 11:15:38 GMT

David

This contains the Datasources in the source system and you could check this in SE16 Transaction.

Hope this helps

Thnaks

sat

Re: ROOSOURCE

Former Member — Tue, 13 Jun 2006 11:18:08 GMT

You can use the table ROOSOURCE in R/3 to view all the info about the datasource. U can use the transactions SE11 or SE16 in R/3

Sudha

Re: ROOSOURCE

former_member848074 — Tue, 12 May 2009 06:32:08 GMT

Does anyone know what is the difference between ROOSOURCE and RSDS table ?