Are there documents that states which table extractor extracts data?

[Former Member]

Hi Everyone,

Are there any documents on which are the tables that the standard SAP extractors retrieve data from?

For example, datasource 2LIS_02_ITM extracts data from table EKKO, EKPO etc. (Just an assumtion)

Can anyone provide documents or state here how or from which tables the following datasources extract data from?

1) 2LIS_02_HDR

2) 2LIS_02_ITM

3) 2LIS_02_SCL

4) 2LIS_02_CGR

5) 2LIS_02_SGR

6) 2LIS_02_SCN

7) 2LIS_03_BX

😎 2LIS_03_BF

9) 2LIS_03_UM

10) 2LIS_02_S013

11) 2LIS_02_S015

12) 2LIS_02_S174

I have tried to execute the datasource from RSA3 and at the same time do a SQL trace from ST05. But some of the traces does not return any table details at all.

Are there other ways to find out which are the tables the datasources accesses?

Thanks in advance.

Regards,

Shunhui.

[edwin_harpino · Accepted solution]

hi Shunhui,

first try go to help.sap.com, click 'search documentation', and option 'netweaver', then type in the datasource name, and search.

in next screen click 'datasource' in right side.

and click the link provided in left side.

if not help, go with Roberto's excellent weblog

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

hope this helps.

[Former Member · Accepted solution]

Hi A.H.P,

Sometimes the column for Tables of Origin is blank.

Is there other to find out?

Thanks.

Shunhui.

[Former Member · Accepted solution]

As suggested please see Roberto's log for alternate ways to find the required information..

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

cheers,

Vishvesh

[Former Member]

Hello Shunhui,

Please check SAP help and you will find this information there. e.g. check following blink for information on 2LIS_02_ITM.

http://help.sap.com/saphelp_nw04/helpdata/en/58/f6383fdb800804e10000000a114084/frameset.htm

Regards,

Praveen