topic Re: plzzz help in Application Development and Automation Discussions

plzzz help

Former Member — Sun, 09 Dec 2007 18:15:22 GMT

Hiii

i have a table XITAB that can contain 10000 or more record of material.

i have to do a check in table MARA if the record exist and delete all record that doesn't exist from XITAB and for record that doesn't exist i need to put in in another table call e.g. XITAB_ERROR

could someone tell me what is the best performance option to the issue below since there are lots of other processing done in my program.

Re: plzzz help

Former Member — Sun, 09 Dec 2007 18:24:43 GMT

Hi,

Do like this

If XITAB[] is not initial.
Select <fields> from MARA into table it_mara for all entries in xitab where matnr = xitab-matnr.
endif.
describe table xitab lines lv_lines.
Loop at xitab into wa.
 cnt = cnt + 1.
 read table it_mara into wa_mara with key matnr = wa-matnr.
 if sy-subrc = 0.
  Move wa entry to XITAB_SUCCESS.
 else.
  Move wa entry to XITAB_ERROR.
  Delete xitab from wa.
 endif.
 if cnt = lv_lines.
  exit.
 endif.
endloop.

Regards,

Satish

Re: plzzz help

Former Member — Sun, 09 Dec 2007 18:46:52 GMT

that i was thniking of doing but instead of puting all correct material from XITAB to table correct. i'll delete it from xitab directly