Hello Gregg,
There is a way to optimize the above look up.
1. Try to perform lookup in start routine(If you are using ABAP routines).
2. before selecting the data from ADSO, check the below condition.
if SOURCE_PACKAGE is not initial.
select f1,f2,f2 from ADSO into ITAB
FOR ALL ENTRIES IN SOURCE_PACKAGE
WHERE CONDITION.
endif.
By writing the code mentioned above the system pulls and stores only the relevant data i.e. for corresponding data available in source package.
Also,
The similar operation can be done even in AMDP Script as well.
Please check and let us if this answer your question.
Thanks,
Jay.
Add comment