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

[Former Member]

Hi Loed,

The RSAX_* FMs are the right templates to use for creating a Datasource. The reason is that the Datasource expects a certain set of Importing, Exporting and Changing parameters in the FM. You can ensure that only by copying one of the RSAX* FM.

So to meet this requirement, please copy an RSAX* template and call the  /POSDW/SEARCH_TLOG in the code

Regards,

Suhas

[Loed]

Hi Suhas,

So to meet this requirement, please copy an RSAX* template and call the /POSDW/SEARCH_TLOG in the code..

Can you guide me in the CALL the /POSDW/SEARCH_TLOG part?

I already copied the RSAX_BIW_GET_DATA_SIMPLE based on this document:

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

But I am stuck in PAGE 9, I already did all steps until ENDLOOP command..How can I use the /POSDW/SEARCH_TLOG in the FM RSAX_BIW_GET_DATA_SIMPLE?

Thank you..

Loed

[Former Member]

Remove the OPEN CURSOR and FETCH statements if you don't see a use for them.

Then, at the place where FETCH was written, write the CALL FUNCTION ... command to call the /POSDW/ FM.

The basic idea in the FM is that the E_T_DATA should be filled up, as that is the data that will go to BW. So where the FETCH was, you write the CALL FUNCTION and then take the results and fill up E_T_DATA.

[RafkeMagic]

hmmm... if you remove the open cursor & fetch, then you're not really using the most important parameters of the function, are you?

there are better ways to do so then (for example: check out this link for more information)

[Former Member]

OK, I wasn't aware that you could write a program for Infoset queries. Thanks for highlighting that, I agree that is a better approach than an FM.