topic Re: Getting Time_OUT dump in Application Development and Automation Discussions

Getting Time_OUT dump

Former Member — Thu, 21 Jan 2010 12:18:52 GMT

Hi ,

i am getting time_out dump when i am innerjoining MAPL and PLPO tables.

SELECT mapl matnr mapl werks mapl plnty mapl plnnr mapl plnal

plpo plnkn plpo zaehl plpo vgw04

FROM mapl INNER JOIN plpo ON

mapl plnnr = plpo plnnr

INTO TABLE ist_mapl

FOR ALL ENTRIES IN main_ltb

WHERE mapl matnr = main matnr

AND mapl werks = mainltb werks

AND vornr = '0010' .

Re: Getting Time_OUT dump

Former Member — Thu, 21 Jan 2010 13:21:37 GMT

Hi Vikas ,

Please check if you have check the internal table is initial or not before using FOR ALL ENTRIES IN main_ltb in Select query.

If internal table main_ltb is initial and you use for all entries with this, there will be full table scan .

Also I dont see any filtering criteria from internal table in where clause.

Regards,

Nikhil

Re: Getting Time_OUT dump

Former Member — Thu, 21 Jan 2010 13:25:34 GMT

Hi,

Please check this


IF NOT main_ltb[]  IS INITIAL. "Check this
SELECT mapl matnr mapl werks mapl plnty mapl plnnr mapl plnal
plpo plnkn plpo zaehl plpo vgw04
FROM mapl INNER JOIN plpo ON
mapl~plnnr = plpo~plnnr
INTO TABLE ist_mapl
FOR ALL ENTRIES IN main_ltb
WHERE mapl matnr = main matnr
AND mapl werks = mainltb werks
AND vornr = '0010' 
AND <field> = main_ltb-<field>.  "Check this
ENDIF.

Re: Getting Time_OUT dump

Former Member — Thu, 21 Jan 2010 13:27:42 GMT

Hi NIkhil ,

i am checking my internal table for initilization.

Re: Getting Time_OUT dump

Former Member — Thu, 21 Jan 2010 14:03:18 GMT

And the second recommendation I given you ?

Re: Getting Time_OUT dump

Former Member — Thu, 21 Jan 2010 14:35:20 GMT

your problem is not related to the FAE, but to the join:


INTO TABLE ist_mapl
FROM         mapl AS a
INNER JOIN plpo AS b
ON  b~plnnr = a~plnnr
FOR ALL ENTRIES IN main_ltb
WHERE a~matnr  = main matnr
AND      a~werks = mainltb werks
AND      b~plnty =  ????
AND vornr = '0010' .

You need PLNTY? If you don't know it, then you can add

as list of all possible values

PLNTY IN ( '...', '...' ... )

it should help.

Siegfried

Re: Getting Time_OUT dump

Former Member — Fri, 22 Jan 2010 05:48:37 GMT

Hello,

My recomendation would be do not to mix the Join and the for all entries in one statement as this would definately cause performance problem.

You better can use for all entries or Join with some more where conditions.

Please try this and let me know if you have any further doubt

Br,

Rajesh Gupta