Performance issue for deleting items in VL31n

[dnyandeo_sonje]

Dear Guru's

In inbound delivery  VL31N  there are 10 line items. IF 5 line items are  match to my requirement and 5 are not match if i want delete this 5 remaining items then it takes long time.how to solve this issue.

Regards

Danny

[eduardo_hinojosa]

Hi

Run a trace with ST05 and look at where the bottleneck is, as a first step. It helps you for diagnosing if there are expensive ABAP algorithm in any userexit, VOFM subroutines (copy rules) or size of tables.

Regards

Eduardo

[dnyandeo_sonje]

Thanks for your valuable answer I have done it..

SELECT SINGLE * FROM ekes INTO ets

                     WHERE vbeln EQ i_vbeln AND

                           vbelp EQ i_vbelp .

select * from kna1 up to 1 row where field1 = 'xxx' and field2 = 'yyyy'

ME_CONFIRMATION_READ_GR_B_AVIS

This FM takes large time to update table EKES ...

any solution for this or we not make changes to SAP main Programs. I am new in ABAP so please suggest me

Regards,

Danny

[eduardo_hinojosa]

Hi

Look for notes for this include name, performance and programm error. Check the indexes for EKES. If you don't find notes, check the number of records and think in add a secondary index. Look for suggestions by your basis consultant.

I hope it helps you

Regards

Eduardo

[dnyandeo_sonje]

Thanks