Introduction

Generic Extractor is mainly used for extracting the data from other Source Systems like R/3 to BI.To extract the required Data we need to create the Data Source. Here In this document we will see the various steps involved to create a Custom Data Source.

Creation of Structure

Create a structure with the necessary fields.

/wp-content/uploads/2014/01/1_373010.png

/wp-content/uploads/2014/01/2_373011.png

  Please note the Currency and quantity  fields must have reference fields also.

Creation of Function Module

In transaction SE80,Select Function group, name RSAX. Right click and Copy.

/wp-content/uploads/2014/01/3_373012.png

Creation of Function Module

In transaction SE80, Select Function group, name RSAX. Right click and Copy.

/wp-content/uploads/2014/01/4_373019.png

  Give the New Name as ZRSAX_FICOPA

/wp-content/uploads/2014/01/5_373020.png

/wp-content/uploads/2014/01/6_373022.png

Select the required function Module.

/wp-content/uploads/2014/01/7_373021.png

  Give the name for Function Module (For Eg ZMFA_GET_DATA_PA)

The Function Module in SE37 will be like this, we haveto do light modification

In table tables Tab Maintain the entries as per the below screen shots

/wp-content/uploads/2014/01/8_373024.png

In Source code Tab. Write this Code

CODE :  Please see the attachment.

Now Save, Activate the function module.

Go to SE80 -> Select Function Group, Activate the Function Group.

Note:If you do not activate  function Group, You will not be able to create data source in RS02.

Data Source Creation

Then you have to create the data source, the data source name must be the name given in the source code of the Function module.

RSO2 -> Create

/wp-content/uploads/2014/01/9_373030.png

Select Extraction by Function Module, Give name of Applc component, Function Module, Extract Structure, Save.

/wp-content/uploads/2014/01/10_373034.png

Checking Extraction

Now give the selection Conditions and save.

RSA3 ->Give data source name and check extraction

/wp-content/uploads/2014/01/11_373035.png

Click on Display ALV result

/wp-content/uploads/2014/01/12_373036.png

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply