How to include 2 new fileds from a table to functionmodule data source

[sona_devi]

Hi All,

Could you please help me out step by step as how to include 2 more fileds from a single table to an existing functional module datasource.

Thanks in Advance,

Harshitha

[Former Member]

Hi,

you can append those two fields to the 'extract structure' (under extraction by FM in RSO2) and then write the logic in FM , after saving the data source, unhide the newly appended fields then replicate data source to BW.

[sona_devi]

Could it be more detail please

Thanks,

Harshitha

[Former Member]

Hi Harshitha,

Below are the steps needs to follow,

1. Enhance the extract structure by adding the two new fields (RSO2 - Click on Extract Structure).

2. Modify the FM, to populate the data to the new fields added to the extract structure.

3. Deselect the "Hide" option in the RSO2 to transfer the fields to BW.

Hope this helps you.

Thanks and Regards,

Mahesh

[Former Member]

Hi ,

• if your data source is generic data source, goto t.code RSO2 in source system, then you will find extract structure name .
• double on the extract structure , and click on 'append structure' --> create append name, then add the two fields inside the components tab , save and activate it
• now in the extract structure, you will see the newly added fields
• click on save data source, it will display you all fields in the structure, your newly added fields will be hidden (hide tad checked) by default, you need to unhide them and save
• now go to function module and write the logic to bring the data for the newly added two fields from the respective table.
• once done, test the data from t code RSA3, if you can see data for newly added fields, then replicate the data source to BW
• activate transformation, dtp and then load data.

hope its clear, and if you are still not clear, you can search in SCN, there are many documents regarding appending .

[former_member183519]

Hi Harshita,

Go to RSO2-> enter data source name -> display

Under Extaction by FM-> Extarct struc. double click on that -> it will opens database dictionary.

click on Append structure.

add your 2 fields

write code for the same in FM.

Note :Deselect the  "Hide" option in the RSO2 to transfer  added fields to BW side.

Regards,

HItesh