Datasource using Function module

[Former Member]

Hi All,

I have created a datasource to extract data through Function module.When i run the Function module independandtly in Tcode SE37 it is giving me the exact result.But when i check the data in RSA3 extract checker i can find that the data is totally not matching.

For ex in se37 when i executed the function module i could get the output as 32 entries.

But in RSA3 i get it as 320 . i.e 10 datapackets with 32 entries.

RSA3 output.

DataPa Record

     1     32
     2     32
     3     32
     4     32
     5     32
     6     32
     7     32
     8     32
     9     32
    10     32

* Tota    320

Can someone tell me whether i am doing something wrong.What do i need to do to get the same ouput in RSA3 as SE37 output.

Thanks in advance for you valuable suggestions.

Regards,

kumar

[naresh_babu3]

Hi,

Can you check the data in RSA 3 whether it have the duplicates.

Compare with FM in se37 output.

If it doesnt have the duplicates in RSA3, paste the code will check and get back to you.

Naresh

[Former Member]

Hi Naresh,

If i run it in RSA3 by changing the display call as just value 1i am able to get the exact result as SE37 output.

But when i run the infopackage in BW to extract the data from R/3 system then the job keeps running and the records are getting added.The job doesnt stop at all.Any suggestions.

Kumar

[Former Member]

Hi,

It seems exception NO_MORE_DATA has not been handled in your code. Thats the reason while being executed from BW , job doesnt stop.

Please refer to following link for more details about how this FM is to be used and how this exception gets system out of the loop of open cursor and fetch next cursor..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30f1a423-02ae-2e10-bd85-bde64e61f...

Hope that helps.

Regards

Nimesh Kapadia