Question Re: How to extract data for this tcode in Technology Q&A

How to extract data for this tcode

Former Member — Fri, 23 Jun 2006 14:56:53 GMT

Hello BW Experts,

I have a transaction code in R/3. i observe that is a using a program P1 and structure S1 to generate the table display in the r/3 transaction.

i go to se38 and display the code, it seems to be a module pool.

Any suggestions for extraction of this data is highly appreciated.

Thanks,

BWer

Re: How to extract data for this tcode

Former Member — Fri, 23 Jun 2006 15:03:44 GMT

Hi,

One way to attempt this is to try to find the tables from where data is pulled in this program/transaction and then displayed. You cna do this using the ST05 trace. Activate the trace, then execute the transcation. After the processing is done, turn it off (again in ST05) and then look at the trace.

Hope this helps...

Re: How to extract data for this tcode

Former Member — Fri, 23 Jun 2006 15:40:59 GMT

Hi,

if you know ABAP, analyze the code, which tables are getting update with that. based on these tables either you can create generic extractor or you can search for business content.

you can use SQL Tracer also to find the tables.

go to ST05 --> SWITCH ON THE DEBUGGER(sql trace) ~~> go to your custom transaction~~> create a entry~~> then come back to st05 deactivate the trace~~> then go with display trace.

there you will see what are the tables used for this.

Hope this helps.

All the best.

reagrds,

Nagesh Ganisetti.

Re: How to extract data for this tcode

Former Member — Fri, 23 Jun 2006 18:54:05 GMT

okay

I useed st05 trace and found out the table. its a transparent table.

Is it possible to extract data from a transparent table.?

Any suggestions appreciated.

Thanks,

BWer

Re: How to extract data for this tcode

Former Member — Fri, 23 Jun 2006 18:59:28 GMT

Hi Bwer,

Yes, it is possible. Create a generic data source(Tcode: RSO2) on this transparent table, replicate into BW. create transfer & update rules and load data.

Hope it Helps

Srini