TIME_OUT Dump while reading EABL/EABLG in function module ISU_DB_EABL_SELECT_EQUNR_PRE

[Former Member]

Hi Experts.

While creating a customer Move-In document (Transaction EC50E), a TIME_OUT error occurs in the function module ISU_DB_EABL_SELECT_EQUNR_PRE

at the point it access an inner join between tables EABL and EABLG:

select * appending table t_reading

            from eabl as a inner join eablg as b

            on    a~ablbelnr =  b~ablbelnr

            for all entries  in t_equnr_ieq

            where a~equnr    eq t_equnr_ieq-equnr

            and   a~zwnummer in tx_zwnummer

            and   a~adatsoll in tx_adatsoll              " note 961218-2

            and   a~ablstat  =  co_as_vorbereitet

            and   a~ablesart in r_ablesart

            and   a~mdenr    in r_mdenr

            and   b~ablesgr  in tx_ablesgr.

I tried to look for a SAP note to fix the problem but could not find one specifically for this FM.

My system is sitting on MS SQL server DB.

Please assist urgently,

Regards,

Kudzai

[Former Member · Accepted solution]

Hi Experts,

This problem is now solved, apparently I just needed to adjust and activate the table EABL in SE14, then update table statistics for both tables to resolve it.