mseg index problem

[Former Member]

hi all,

I want to fetch data from mseg based on aufnr (order no.) which not primary key. I created a secondary index , but it is effecting other reports (which are using mseg) performance.

so i deleted secondary index for mseg with fields mandt & aufnr.

can anyone tell me is possible to create index for mseg without effecting other reports.

help me

[Former Member]

hi all,

I want to fetch data from mseg based on aufnr (order no.) which not primary key. I created a secondary index , but it is effecting other reports (which are using mseg) performance.

so i deleted secondary index for mseg with fields mandt & aufnr.

can anyone tell me is possible to create index for mseg without effecting other reports.

help me

[Jelena_Perfiljeva]

Try using another table to find MSEG-MBLNR. Not sure what exactly is in AUFNR field, but in sales the connection to the goods movement documents might even be stored in VBFA table. It is also stored in one of the purchasing tables, although it might be not so obvious.

Or consider using a different approach altogether, like setting up an info structure (LIS), for example.

[francisco_blay2]

Use table AUFM

AUFM-AUFNR -> MSEG-MBLNR = AUFM-MBLNR, MSEG-MJAHR = AUFM-MJAHR, MSEG-ZEILE = AUFM-ZEILE