topic Re: help mseg in Application Development and Automation Discussions

help mseg

Former Member — Fri, 30 May 2008 08:05:42 GMT

hi experts,

I want to get the mblnr, bwart, matnr, charg, menge, aufnr fields data from mseg table based on aufnr.

but aufnr is not key field it is taking so much time.

even secondary index is not working.

is there any other table where I can get these fields data other than mseg based on aufnr.

help required.

Re: help mseg

prasanth_kasturi — Fri, 30 May 2008 08:25:36 GMT

hi,

go to mseg table and you create a secondary index in that table with mandt and aufnr

start the name of secondary index with z

reward if helpful

prasanth

Re: help mseg

Former Member — Fri, 30 May 2008 08:31:53 GMT

Hi Uday,

Just paste your code here so that we can help modify it.

Re: help mseg

Former Member — Fri, 30 May 2008 08:32:25 GMT

U can create Secondary Index With any name , Only System will give u warning..

Re: help mseg

Former Member — Fri, 30 May 2008 08:37:08 GMT

hi uday,

what other selections or values do you obtain befire doing a SELECT on MSEG.

What selection criteria do you use in you report.

do let us know we can guide you on this .

Thanks

Venugopal

Re: help mseg

Former Member — Fri, 30 May 2008 09:02:43 GMT

hi,

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

SELECT-OPTIONS: s_date FOR afko-gltrp. "start to finish date

SELECTION-SCREEN END OF BLOCK b1.

START-OF-SELECTION.

SELECT aufnr gstrp gltrp FROM afko INTO TABLE i_prod WHERE gltrp IN s_date.

IF sy-subrc EQ 0.

SELECT mblnr

mjahr

zeile

bwart

matnr

werks

lgort

charg

menge

meins

aufnr FROM mseg INTO TABLE i_mseg

FOR ALL ENTRIES IN i_prod WHERE aufnr = i_prod-aufnr

%_HINTS ORACLE 'INDEX("MSEG" "MSEG~ZPD")'.

fetching from mseg table is taking more time even after using secondary index.

Re: help mseg

christine_evans — Fri, 30 May 2008 09:20:08 GMT

Are you sure that it is using the secondary index - have you checked in ST05? Database hints usually work but if you get the syntax wrong the system will ignore them and the only way I have got one to work is to use a slightly different syntax.

%_HINTS ORACLE 'INDEX("&TABLE&" "SETHEADER" "SETHEADER~2")'.

Personally, I would only create a new index on an important SAP standard table as a last resort. In your case, I would first try using the Controlling tables COEP / COBK, or COVP (a view of the two). COEP-OBJNR is indexed and holds the object reference of the AUFNR which you can get from AUFK.

Re: help mseg

Former Member — Fri, 30 May 2008 11:12:06 GMT

problem solved.

secondary index has been activated well & it is working fine.