topic Re: mseg index problem in Application Development and Automation Discussions

mseg index problem

Former Member — Thu, 12 Jun 2008 05:12:23 GMT

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

Re: mseg index problem

Jelena_Perfiljeva — Thu, 12 Jun 2008 21:20:05 GMT

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.

Re: mseg index problem

francisco_blay2 — Thu, 06 Oct 2011 09:12:15 GMT

Use table AUFM

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