Question Re: Source Tables in Technology Q&A

Source Tables

Former Member — Tue, 11 Sep 2012 07:00:25 GMT

Hi Experts,

My question is how to find source(back end) tables for any standard business data sources in RSA2..

Regards

MS Reddy

Re: Source Tables

Former Member — Tue, 11 Sep 2012 08:15:38 GMT

Hi Madhusudhan

The answer to this question is not simple.

Complex code is used for most of the standard datasources and debugging them is not a simple task. You will gain experience over the years in specific modules like SD, MM or FI and you would be easily able to point out the source tables. Very few datasources have direct assignment to the source table.

I suggest you to check help.sap.com and search for the datasource, read the explanation of its purpose, source tables, fields available. They also tell the behaviour of the datasource. You will have access to a lot of information in help.sap.com. This is the hard way but trust me the best way.

Regards

Murthy

Re: Source Tables

Former Member — Tue, 11 Sep 2012 08:20:45 GMT

If you have any specific datasource, please post it here, I will guide you with the source tables.

-Murthy

Re: Source Tables

Former Member — Tue, 11 Sep 2012 11:04:23 GMT

can you please guide me on 2lis_11_vahdr..

Re: Source Tables

Former Member — Tue, 11 Sep 2012 11:23:19 GMT

Hi Madhu,

This is standard LO DS. For base tables used you can check its extraction structure in LBWE.

Regards;

Jitendra

Re: Source Tables

Former Member — Tue, 11 Sep 2012 11:34:05 GMT

Please check the link for datasource 2LIS_11_VAHDR

http://help.sap.com/saphelp_tm80/helpdata/en/f0/3baf6718d2427a94ced005f298be06/frameset.htm

- This datasource contains the header level details of a sales document.

- In ECC, Sales document is created through tcode - VA01, modified from - VA02 and displayed from tcode - VA03. Please try to use VA03 to check sales document.

- Table VBAK can display the details of sales document. DS 2LIS_11_VAHDR picks most of the fields from VBAK table.

In case, you are looking for SD tables and relation between them, this link is very helpful.

http://scn.sap.com/thread/486121

Also in LO cockpit, when you try to maintain the structure of the DS, it will display the fields along with the respective tables.

Regards

Murthy

Re: Source Tables

esjewett — Tue, 11 Sep 2012 13:34:38 GMT

I've moved this question to the Business Content and Extractors forum because that is the topic. Please follow the SAP Community Network Rules of Engagement in the future and search on these types of questions before asking on the forum. You can probably find all the information you need about this topic under the business content documentation on help.sap.com.

Regards,

Ethan

(moderator)