Skip to Content
avatar image
Former Member

how to create genaric extractor useing the function modules

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2007 at 10:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 10:50 AM

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

    Regards,

    Shahid

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 10:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 10:24 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded