01-11-2013 6:38 AM
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
01-11-2013 2:16 PM
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.
01-11-2013 2:16 PM
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.