Generic Extractor based on Function Module

[Loed]

Hi guyz,

I still didn't get the solution in my problem below..

As an alternative, I'm planning to do a full load based on system date using the FM /POSDW/SEARCH_TLOG..I saw several documents but all of them are telling me to use the FM RSAX_BIW_GET_DATA_SIMPLE or RSAX_BIW_GET_DATA..

Some documents:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8d...

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

Khoder Elzein's Blog: Create Generic Datasource using Function Module and Timestamps

I just want to ask if using the mentioned FM is the only way to do a generic extractor based on FM? I tried to use directly the FM /POSDW/SEARCH_TLOG and in the extract structure I used the ET_TRANSACTION in the EXPORT part of the FM..

But I got the error below:

I also tried to use the structure /POSDW/TRANSACTION_INT of the table above but also got this error:

I searched for some threads to solve the error above and got this..

Create Datasource with RSO2 & Function Module | SCN

But after copying the FM and creating my own table or structure to be included in the TABLES tab, I still encountered the same errors above..

Any idea how can I use the FM /POSDW/SEARCH_TLOG to create a GENERIC EXTRACTOR?

Thank you..

Loed

[sander_vanwilligen]

Hi Loed,

The main reason for using a Function Module extractor is the scalability. The OPEN CURSOR and FETCH are meant to retrieve and process a data package with a certain package size.

However, it must be used in conjunction with a SELECT statement on a single table or join on multiple tables. It doesn't work directly in conjunction with Function Module /POSDW/SEARCH_TLOG.

I suggest to analyze Function Module /POSDW/SEARCH_TLOG. Maybe you can reuse the logic for the Function Module extractor. If it turns out to be difficult or cumbersome to reuse the logic, then it might be better to look for alternative solutions.

Best regards,

Sander

[Loed]

Hi Sander,

Thank you for your input..

I will also try to look for alternative or maybe do the suggestion of Raf..

Loed