on 08-22-2007 11:08 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
if u give u r mail id i will send a document.
Regards,
Shahid
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.