Generic data extraction from R/3 into BI

[Former Member]

Hi Friends,

We need to extract some data available in the R/3 side to BI. I have written code in a function module which brings the output into the table e_t_data. now by attaching this function module, we created a Data source also. and then from BI side we replicated this Datasource. when tried to extract the data at BI from R/3, the process keeps on running with out bringing any data into BI.

Regarding this, i referred some docs in the forums. They say that we have to go with the approach followed in the FM 'RSAX_BIW_GET_DATA_SIMPLE'. I have done all the coding and settings similar to this function module. there is no syntax error and code produces the required output in e_t_data.In that FM they used some Select statement under the Open Cursor statement. But in our requirement, we are not selecting anything from Table. but we generate some data by some calculations and these data will be our output. If it is the case, can't we use that open cursor approach...? we need to get the output data not by any select statement but the output will be some internal table entries which are created by some calculations.

Please suggest how to handle this.

Thanks in advance...

Regards

Ram

[Former Member]

Hi,

just fill the output table in your FM by yourself - it will work.

I guess at the beginninig you are selecting data from one (or more tables) and than calculate the final output later. You may use the cursor for packing the data into suitable packages. However, an exact package size is - in most cases - not possible with that scenario.

Kind regards,

HP.

[Former Member]

Hi Holger,

Thanks.... Yes you are correct. i am collecting the data into the output internal table as you told only.

how and where to use the open cursor statement in the function module in this case..?

Regards

Ram

[Former Member]

Hi,

If you are selecting from DB header and dependend data use it at header level (i.e. set cursor for MARA for a package and select keys into internal table. Select from MARC, MARD etc. for all entries selected from MARA into this internal table).

Kind regards,

HP