FM based extractor
Requirement: To create a generic function module based extractor on ECC R/3 side.
a: first, we need to create the structure and function module and
b: then create the data-source.
c: Test the extractor.
Step1: Create Extract Structure in T-code Se11.
Select radio-button : data-type: enter name and press create button.
Enter the fields and description you would like to have in your data-source.
These fields you can get from standard tables from which you want to retrieve the data.
Step2: Create function module in t-code SE37.
The steps for function module are explained later in Step4.
Once we have the function module ready, we can go to Step3.
Step3: Enter details in RSO2 transaction: Application Component, function module, extract structure.
On BW side: The data-source will be visible in this application component
Press the field list button(F7), next to change pencil button, to set the selection parameters for the extractor.
The fields list will be coming from extractor.
Step4_01: Function module: Enter values in Tabs: Import, Tables, Exceptions as shown. Make sure the checkbox are selected.
Step 4_02: Place the code in Source code tab.
I have taken field from these tables, which are linked by a key like company code, financial transaction number or deal number.
I have attached the code later.
Step5: Test in RSA3. Give the extractor name and press enter.
We have got 21 records as our output.
Step6: Code Structure:
**1 – Tables and Internal tables declaration
**2 – Declare Output internal tables similar to Extract Structure
**3 – Declare selection screen and other counters
**4 – Capture Select ranges values
**5 – Capture Extractor
* Check DataSource validity
* Fill parameter buffer ranges for data extraction calls
**6 – Use Open Cursor for first and main select statement
**7 – Other Select Statements
**8 – Generate Output data
**9 Assign the final output internal table to E_T_DATA for result set
Step7: BW-side: Replicate the data-sources for the ECC Source system.
You will find your newly created data-source in the list of application
component.We know the application component we have chosen is TR-CM.
Create info-package and you can do the first load till PSA.