how to create genaric extractor useing the function modules

[Former Member]

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

[Former Member]

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