How to Extract data from a transaction..

[Former Member]

Hi All

There are some transactions and report programs which are used daily to produce some results and the requirement is to extract that data into BW

so how can we extract information from a transactions and programs

Any help will be really appreciated and ofcourse rewarded ...

Regards

Lisa

[former_member1293755]

Hi Lisa,

Did you find any solution for this requirement?

Please help here i have the same requirement.

[Former Member · Accepted solution]

POssible soltuions I could think of..

1> Export the output of the Transaction/Report into a Flat file and load them into BW thru a flat file interface. The output of those transactions should be simple enough to store it in a flat file. Still you might have some problems with the format of the file, so this might need some modifications in the program to format the output accordingly.

2> MOdify the Program/Transaction to store the data to be displayed also in a database table. Build a Datasource on the DS table and extract data from that

I'm not sure what kind of report or transactions you are talking abt and why you want to load their output to BW. Perhaps, ppl might give better ideas if you can provide the requirements.

Reagrds,

Sree

[Former Member]

Hey Lisa,

I agree with sree,

It would be great if you send your report code so that we can give you some suggession...

[Former Member]

Hi Lisa,

Goto ST05 and activate Trace..then run your transaction

once it is completed open ST05 and Deactivate tRACE AND PRESS display Trace , it will give you all the selects ....

Assign points upto your satisfaction level....

[Former Member]

Hi Nani

thanks for quick response.

Below is the reply from you

" These tables are not transparent then attach code to the end of your report and keep the details in user table(ZTABLE)then do GDE using table..

3)If you feel that this is overburden to keep details in usertable.then go for function module (RSAX_BIW_GET_DATA_SIMPLE is the template).But you need to write some sort of complex code here..."

can u pls explain in detail , i really appreciate if it is with sample code

thanks & regards

lisa

[Former Member]

Hey lisa,

After pressing F1 you will get an window..in that window toolbar press technical Information button , Right to the book(image).That will give you the technical info...

[Former Member]

Hi Nani,

thanks and can you pls explain how to use SQL trace to find the affected tables

so as per ur explanation once i got the tables then i can go for a view and do Generic extraction . Am i right?

pls clarify..

Regards

Lisa

[Former Member]

Hi Lisa,

May be you can try Generic data source with infoset query ( which is created with logical data base option so that you can take care of your calculations.).

Hope this will help you.

Suneel

[Former Member]

Hi Jacobs,

As per my experiance ..Best way is go with Roberto.Actually your program fetch the data from different tables and gives the output.

1) so If possible findout the tables and create an simple view or abap query and do GDE on that.

2) These tables are not transparent then attach code to the end of your report and keep the details in user table(ZTABLE)then do GDE using table..

3)If you feel that this is overburden to keep details in usertable.then go for function module (RSAX_BIW_GET_DATA_SIMPLE is the template).But you need to write some sort of complex code here...

So first please check your tables all are transparent tables in that system and join conditions are simple or not ,then we can proceed with a wise decision....

[Former Member]

Please let me know how to develop Extractor-Function module link??Do i have to make the extract structure before writing a function Module??If so Can you plz send me some documentation with a complete flow.

Thanks

SCS

[Former Member]

Hi Lisa!

I have already done this in the past and usually I followed this procedure: copy the code (of the report/transaction) in another program with a little difference: at the end, I attached some lines to 'format' the fields as I needed and then fill with this output a dedicated custom table on which then I built a datasource to extract data towards BW...in other words I replaced the code with which the numbers were displayed at screen with other simple code with which I filled a table for BW purpose !

Then, you can use process chain to manage all...

Hope it helps!

Bye,

Roberto

[Former Member]

Hi,

Similarly we can use GenericExtraction with fucnction mudule , with the souce code as almost same as Transaction or Report of R/3.Here the data of result set will be stored in internal table and then passed to BW.

With rgds,

Anil kumar Sharma .P

[Former Member]

Hi ,

Thanks for ur replys and Sorry for this delay. Actually i want to extract some data from iw48 related to work orders.

Roberto can you explain in detail of how to go with that because i have limited knowledge of ABAP.

Sree do u think its feesible to Export into a flat file and then again send it back to BW? Do u find any risks. please explain

Anil can we go with generic extraction with functional module , can u please explain in details or can u send the sample code

Regards

Lisa

[Former Member]

Hi Anil,

Can u pls explain in detail about how to start with and i really appreciate if you can provide some sample code.

Regards

Lisa

[former_member184494]

lisa,

You could start by finding if the data is available in tables.

open the transaction screen:

select a field and press F1 , then if you get a transparent table , then your efforts are reduced. Almost always you will have a structure being used. So next step would be to use ST05 ( SQL Trace) and then find out the affected tables , based on the same , find out which tables are affected and then find if you can find the values there.

This is as far as finding tables goes . You could however try out roberto's method - seems more elegant.

Arun

[Former Member]

Hi Arun

Thanks for your response but when i press F1 in the field then it gives a description of the field but not whether a transparent table or a structure as you said.

Regards

Lisa

[Former Member]

Hi Lisa,

1> Analyse from where the report or the transaction is getting the data from. You will definitely need some ABAP knowledge to understand their working and create a datasource to get that data into BW ODS/Cube

2> It would be better if you can provide some sample data from report/transaction which you are trying to load into BW.

Regards,

Sree

[Former Member]

Hi Sree,

I've analysed from where the data is getting into the transaction. There are around 10 tables.

the transaction had listed some information regarding

orders,date , time,description ,downtime Etc.

so what do you suggest ,shall i create a view sort of thing and go for creating a generic datasource or .....

waiting for ur reply

Regards

Lisa

[Former Member]

Lisa,

Before I suggest somthing, one more question. What is the volume of data expected out of that report? Based on that we can use,

ABAP program Data Source

OR

Function Module based DataSource

OR

Use a DB storage of data in Table and Build a generic Extractor on that.

Regards,

Sree

[Former Member]

Hi sree,

Its 150 to 200 per day

regards

Lisa

[Former Member]

You can use the following methods

Method 1:

*********

1> Create another ABAP program with logic to calculate all the fields, but instead of writing the result data to screenm, it should store it in a internal table and pass it to the extract structure.

2>Create a InfoSet query based on your ABAP program and use that InfoSet

3> Create a DataSource based on this InfoSet query and extract data from the DS to you ODS/Cube

In this method there is no Intermediate storage used.

Method 2:

*********

1> Modify the report/transaction program to store the required data into a Transparent Table (u can create one from SE11) in addition to displaying on the screen.

2> Create a View on this transparent table (from SE11)

3> Create a DataSource on that view and extract data from that into your ODS/Cube.

Here, the required data is stored in the Table in addition to the DataTarget.

But, to implement either of these solution, you will need a decent ABAP knowledge. Else, it will give you a tough time!

Good luck!

Regards,

Sree

[Former Member]

Hi sree,

thank you very much , I'll try out and let u know . But it would be better if you can provide some sample code.

Regards

Lisa