Skip to Content
0
Dec 03, 2006 at 11:28 AM

Function module based extraction

26 Views

I've read the sample" target="_blank">http://www.bwexpertonline.com/downloads/zbw_sfli001_ds_abap.txt">sample code related to the article by David Eady on BWExpert: http://www.bwexpertonline.com/archive/Volume_04_(2006)/Issue_07_(July_and_August)/V4I7A4.cfm?session=">Simplify Complicated Extractions with Function Modules.

This example extracts:

- those records in the table <b>SBOOK</b> for which the datasource's selections hold;

- the corresponding records in the table <b>SFLIGHT</b> (foreign key relationship).

These two sets of data are saved in an <b>internal table</b>, with the same structure of the extraction structure. Then the content of this internal table is persisted on a <b>database table</b>, with the same structure of the extraction structure too. Finally a cursor is opened for this<b> DB table</b> and MAXSIZE records are extracted from it for each FM call.

Is there any advantage with persisting the datasource content on a <b>DB table</b>, before transmitting it to BW? Wouldn't be less time consuming selecting MAXSIZE records from <b>SBOOK</b>, matching them with the records from <b>SFILGHT</b>, and passing them to the datasource?

Thanks, Davide