Questions about datasource

[Former Member]

Hi All,

I have two question.

1. If i know a field then how do i find in what all datasources it is used.

2. If i know a datasource then how do i find on which tables the datasource is created. I mean from what all tables the datasource extracts data.

I need this information urgently.

Regards,

Sachi

[Former Member · Accepted solution]

Hi,

to find data source is using which tables in the source system :

Go to RSA2 (DS Repository) in your source system and display your source system.

If Extraction Method is 'V' - then you see table name where data is taken from.

If it is F* - function module is used, and you have to go thru its code to see all the tables it uses and logic how data is

processed.

Ext. Meth Short text

V Transparent Table or DB View

D Fixed Domain Value

F1 Function Module (Complete Interface)

F2 Function Module (Simple Interface)

Q Extraction Using ABAP Query

A DataSource Append

OR

Goto Tcode ST05 in SAP R/3 -> Enable SQL Trace for your user -> Open new session ->RSA3 -> put datasource name -> Extract -> Goto first session -> Disable the trace- .

The clcik on Display trace and you will see all the tables that were hit by the extractor checker to

retrieve data and present it to you.

Hope this helps you ..

Reagrds,

shikha

[Former Member · Accepted solution]

Thanks Shikha. But i need information for the below datasources. Can you help me with them:

2LIS_01_S001 Customer

2LIS_01_S005 Shipping point

2LIS_11_VAHDR Sales Document Header Data

2LIS_11_VAITM Sales Document Item Data

2LIS_12_VCHDR Delivery Header Data

2LIS_12_VCITM Delivery Item Data

2LIS_12_VCSCL Sales-Shipping Schedule Line Delivery

2LIS_13_VDHDR Billing Doc. Header Data

2LIS_13_VDITM Billing Document Item Data

2LIS_13_VDKON Billing Document Condition

I need the tables from which the above datasources extracts data.

Regards,

Sachi

[Former Member · Accepted solution]

Hi, check with this table once ..

TMC4 >>> Global Control Elements: LIS Info Structure

Regards,

Shikha

[Former Member · Accepted solution]

Hi Shikha,

Thanks for your response but I could only find information related to 2LIS_01_S001 and 2LIS_01_S005 from the table you mentioned. Can you tell me how to find the table information for other datasources.

Regards,

Sachi

[Former Member]

Hi

Goto Tcode ST05 and activate trace then goto rsa3 and execute the extract checker.

Goto ST05 again and deactiavte Trace and display the trace then it will show you the tables.

Hope it helps...

Regards,

Chama.

[Former Member]

Hi,

To find the tables related to DS

1.Goto TCode LBWE in R/3 system

2.Search the particular Data Source i.e. 2LIS_01_S001

3.Now Click on Maintenance, and then continue

4.Drill down the Filter field on the top right corner of Selection Criteria screen that appears

5.This gives the structures defined and last 4 letters gives the table name.

Hope it is useful.

Regards,

Meera

[Former Member]

Hi,

check the corresponding extract structure.. it will give you the tables from which the datasource is getting the data.

Sunil.

[Former Member]

search the forums. this has been discussed.