Skip to Content
0
Former Member
Oct 16, 2006 at 03:44 AM

select querry error

17 Views

Hi,

while debugging values are populating for mkpftbl but not to msegtbl. can anyone suggest where i am going wrong.

if sy-batch = 'X'.

select mblnr mjahr bldat cputm

from mkpf

into table mkpftbl

where bldat eq wtoday

and tcode2 eq ctcode2.

else.

select mblnr mjahr bldat cputm

into table mkpftbl

from mkpf

where mblnr in mblnr

and mjahr in mjahr

and tcode2 eq ctcode2.

endif.

if not mkpftbl[] is initial.

  • loop at mkpftbl.

select zeile charg matnr werks menge

into corresponding fields of table msegtbl

from mseg

  • Appending table msegtbl

for all entries in mkpftbl

where mblnr eq mkpftbl-wmblnr

and mjahr eq mkpftbl-wmjahr

and bwart eq cbwart

and werks eq splant.

*endloop.