unable to tcode LT22 without transaction time out

[Bharath84]

Hi All,

Users are unable to run LT22 without transaction timing out. They were running this with the parameters in the attachment previously with no issue now it times out. After running for about an hour following message, "work process re-started, session terminated". Anyone have any idea why it is being timed out. Please advice.

Thanks,

Haritha

[Former Member]

Hi Haritha,

Just another idea, please ask your Basis-guys if the statistics-update is running daily, if not, ask them to run this, and especially make sure that this statistics-update will run against those tables you are using when calling this LT22 transaction (check via SM50 during the run you will see which tables are being called).

If this is not helping, then try to create an extra index on those tables.

Maybe you (and Basis guys) need to analyze the used SQL-statement first, to check the execution-plan.

I hope this will help you.

Regards,

Andre

[Bharath84]

Hi Andre,

Two Indexes are created for table LTAP:

Transfer order items for material:  for fields LGNUM, PQUIT and MATNR.

Transfer order items for source storage type : for fields LGNUM, PQUIT, VLTYP and VLPLA.

And for table LTAP the index is:

Transfer orders for reference number : for fields LGNUM and REFNR

Will this be the cause for performance.

In ST05, it is taking time in program SAPDBT3L for the below select query.

select (ltak_fields-fields) from ltak

  appending corresponding fields of table iltak

  for all entries in itanum

   where lgnum =  t3_lgnum

   and   tanum =  itanum-tanum

   and (ltak_sel-where_tab).

Below is from SM50.

Please help.

Thanks,

Haritha

[Former Member]

Hi Haritha,

Does your LTAK table have indexes as well?

Try to check in the execution plan, is this query using your LTAK-index or "TABLE ACCESS FULL LTAK"?

If there is and index(es) and your query still doesn't use this, maybe you can try to drop and rebuild those indexes on LTAK. Assuming that those tables are getting statistics update as well.

I hope this will help you.

Regards,

Andre

[balaji_ganesan2]

Hi Haritha,

In most the cases, this is due to the more number of entries in the tables LTAK & LTAP from which system is trying to fetch the data.

Could you please use the tCode LT23 instead of LT22 with the same search criteria as because LT23 selects via LTAK first and then LTAP.

Also, please refer the SAP note 534135 in SMP which could be helpful to optimize the performance of the LT22 tCode.

Thanks & Regards,

Balaji