Question Re: how to create genaric extractor useing the function modules in Technology Q&A

how to create genaric extractor useing the function modules

Former Member — Wed, 22 Aug 2007 10:08:25 GMT

Hi BW Friends,

I dont know how to use genaric extractor with function module. give me step by step and how to put delta in generic extractor..

Thanks

Ram

Re: how to create genaric extractor useing the function modules

Former Member — Wed, 22 Aug 2007 10:19:26 GMT

Hi,

please have a look here: /people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module

It might be of some help.

regards

Siggi

Re: how to create genaric extractor useing the function modules

Former Member — Wed, 22 Aug 2007 10:19:43 GMT

Hi Ram,

under Generic Extraction... normally... when we dont have a bussiness content then only we go for generic extraction..

in that , we select Function module for a specific conditions... that means. when we want to extract data from multiple tbales...(more than one table..) and those tables having ONE- TO MANY relationship. then we select this functionmodule extractions..

if the relationship between tables is ONE -TO - ONE, then we go for extract from Views

For function module means.. you have to create function module. in RSAX..in R/3 side

and you want to extract data using Query means...you have to create Infoset query in (SQ01,SQ02,SQO3) IN r/3 Side

you can refer this blog also..

to Function module "RSAX_BIW_GET_DATA_SIMPLE" and there is very good weblog . Search "generic extraction" for weblog. /people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module

procedure:

just goto SE37 in r/3 side..

and give the function module name..which you want to create..

and give the function group name...(if you dont know have existed function group means~~> in the same screen GOTO menu~~> in that select Function Group --> and create..

now give the import and export parameters.. and now write the code for fetching the data from database tables... you need to write the coding based on what criteria you want to fetch the data from tables..

save and activate it...

now come to RSO2 give that function module name in the Generic Datasource...

regards

@jay

Re: how to create genaric extractor useing the function modules

Former Member — Wed, 22 Aug 2007 10:24:36 GMT

Hi,

We use function module for generic extraction when our data is comming from different source tables based on complex logic.

The easiest way to work out with Function Module is to copy the standard one and modify according to your reqirement.

The standard one is RSAX_BIW_GET_DATA_SIMPLE .

Dont forget to copy the Function grp RSAX into a custom defined Grp and Modify the Ranges options as per ur req.

and in Function module, in Sourcecode and Tables, Do modify the E_T_data with ur Generic datasource ,make sure u also modify the select statements within the sourcecode. If you have an idea on ABAP its really easy to work out.

check this link for sample code:

And regarding the creation of Datasource:

- Goto RSO2

- choose what kind of datasource u r creating and a name

- Choose the approriate app. comp. under which you want to create the generic datsource

- Click on Extraction by FM

- Give the function module name

-Then you can save and select the fields required (with generic delta capabilities).

- check in rsa3 to make sure it can extract data (after activating the datasource)

Regards,

Dhanya.

Re: how to create genaric extractor useing the function modules

Former Member — Wed, 22 Aug 2007 10:50:25 GMT

if u give u r mail id i will send a document.

Regards,

Shahid

Re: how to create genaric extractor useing the function modules

Former Member — Thu, 30 Aug 2007 03:21:52 GMT

my mail id is ramakotiv@gmail.com