How to extract data for this tcode

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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...