Enhancing DataSources

[Former Member]

To Divyesh:

Hi,

while iu2019m trying to enhance BSIK and BSAK Extractors I got the following Problem.

Iu2019ll need to read table RKWA during extraction but this table is rather huge. So I want to preselect all relevant data into an internal table like:

Select * from RKWA into WA_RKWA

WHEREu2026

And then in special coding I could say:

READ WA_RKWA

WITH KEY u2026.

This definitely should have a better performance than SELECT SINGLE * FROM RKWA in special coding

Where is the right place in Z_SA_DEPD to do this? Iu2019ll only find global data definition but nothing like a start routine or something else.

Thanks

Pascal

[Former Member · Accepted solution]

Hi Pascal,

You can either add the table RKWA in the table relationship list or you can write that code in the reference field for one of the table. The code in reference fields get added before or after select statement(depending on what you choose) and hence will be outside the loop.

Thanks,

Divyesh