MIGO taking a long time to post

[Former Member]

Hi,

Tcode: MIGO takes a long time (approx 20 mins) to post the GR and generate Material document.

On analysis, this happens only when posting GR for PO's for a specific vendor XXXXXXXX.

However, the material document is posted!!

Any idea why is this so..

Regards//

[Former Member]

You need to do table indexing for this issue go to MSEG table and add the fields doc year, MBLNR etc and save it

MANDT

MATNR

WERKS

LGORT

BWART

SOBKZ

Activate it and save it you will be need ABAP id for the same.

BR

[Former Member]

Hi

This problem is due to heavy data in MSEG table. You need to create a secondary index for MSEG table with following data with the help of ABAPER

MANDT Client CLNT 3

LFBJA Fiscal Year of a Reference Document NUMC 4

LFBNR Document No. of a Reference Document CHAR 10

LFPOS Item of a Reference Document NUMC 4

This solution was given by SAP when we had similar problem

Regards

Antony

[Former Member]

Thanks Antony.

My question is- If MSEG table is loaded, this should affect When posting GR anytime. But, why is this specific to only posting GR for PO with a specific vendor only???

[Former Member]

Hi

During MIRO LFBJA, LFBNR, LFPOS these fields are searched in MSEG by program. The MSEG table do not have these fields as primary index in it. So it takes more time to fetch data relevent to that MIRO. If you make a secondary index for these field then system searches the required information for MIRO faster. Hope my answer solved your problem

Regards

Antony

[Former Member]

Your document will be reffered by other departments or same master data must be in access in other transactions which will get updated.

BR

[Former Member]

you have to indexing of MSEG table. There is informative SAP note available for this

[Former Member]

Hi,

Can you Pl provide more information on this, Pl?

This has to be done by ABAPer or functional consultant??

[Former Member]

this has to be done by ABAper