on 2005 Jul 06 1:32 PM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Lisa,
I agree with sree,
It would be great if you send your report code so that we can give you some suggession...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
User | Count |
---|---|
77 | |
29 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.