datasource tables

[Former Member]

Guys,

how can you find from what table a particular datasource is extracting it's data from

Message was edited by:

zsl05

[Former Member]

thanks everyone,

I am very impressed by your knowledge, thanks everyone and suprished to see 0customer_attr actually is based on 4 tables instead of 1 (kna1 - according to bi content)

[Former Member]

Hi,

Use these steps:

1. Goto R/3 -> se11/se16 -> ROOSOURCE table

2. Check for the extractor method field.

3. Now if the extractor method is view/table then check for the fields in se11/se16.

4. If the extractor is fn module based then goto se37 and check for the tables and fields referred in the code. You can use the find option and serach for keywords like "tables" and "select". This should guide you to all the tables which are refered in the extractor.

Bye

Dinesh

(Assign points to all the people who helped you!!)

[Former Member]

I was just using 0customer_attr as an example

I am looking for any given datasource, how you find it within R/3 system.

Message was edited by:

zsl05

[Former Member]

Guys,

I totally agree that most times you can find the source table for a datasource from BI content. My question is for each field in extract structure of a datasource, how can you find it's table of origin from R/3 system.

I didnt put a deserving comment on Roberto's Weblog. I am sorry. It's in fact very helpful.

[Former Member]

it is easy to find out which extract structure fields are from which table.. from help..

check this link..for your datasource.. it gives you both Table of Origin and

Field in the Table of Origin..

http://help.sap.com/saphelp_erp2005vp/helpdata/en/41/6a6da460196936e10000000a114b54/frameset.htm

Regards

Manga

[Former Member]

ZS:

In addition to what Roberto said, it is not difficult at all to get the source table. Start with thr BI content pages.

Thanks

Ravi Thothadri

RThothadrii@yahoo.com

[Former Member]

Hi pradeep,

Let's say I want to find the tables for fields in extract structure of DataSource

0CUSTOMER_ATTR

How do i know from which table they are coming from. (I know on which table this datasource is based)

I tried rso2 but not working.

[Former Member]

go to table ROOSOURCE to find out what type of extraction (view, function, query, ...) is used and which one

in this case: extraction method = F1 (Function Module (complete interface))

and the function module = MDEX_CUSTOMER_MD

check this function module in SE37

start digging

(you should find 4 tables)

[Former Member]

Hi dear,

my weblog is not intended for experienced BW people...it is written just for this kind of situation: it provides a step-by-step solution that, starting from the help (easiest way) and arriving to SQL trace (the harder one), shows the only way (apart to posting a specific question into this forum!) to find what you need in terms of source tables of a specific datasource...

Let me know what you consider "difficult" in my weblog, so I can improve it !

Let me know...

Bye,

Roberto

[Former Member]

Hi,

If you have datasources names then in SAP R3 you can check in RSO2 t-code to find the table name.

Hope this helps,

Pradip.

[Former Member]

Thats a nice blog

but still without experience you can't tell from which table the fields in extract structure is coming from

[former_member188975]

Hi,

See this excellent blog by Roberto:

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

Hope this helps...