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