Skip to Content
avatar image
Gregg De Wet

Look ups on ADSO

Jun 15, 2018 at 12:49 AM | 88 Views

Hello Experts,

We are trying to do a look up on ADSO using the select statement which has some 5 keys and 2 data fields. When we are executing the DTP which does the load nearly 1 million data with that select look up on ADSO , we see that the work process is spending lot of time nearly 8 mins in the RSDBAMDP program and doing a sequential read of the ADSO . Apparently the ADSO has just 87 records and select on this ADSO has all seven fields as well. So can anyone let me know is there's any best way to read data from an ADSO.

Thanks in advance.

BW SAP HANA Data Warehousing
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Jayashankar T N
    Oct 26, 2018 at 11:38 AM

    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
    10|10000 characters needed characters exceeded