topic need to delete the data from table in Application Development and Automation Discussions

need to delete the data from table

Former Member — Wed, 30 Jan 2008 04:59:14 GMT

call function 'ZCPD_POPUP_FOR_INPUT'

exporting

i_vbeln = vbap-vbeln

i_posnr = vbap-posnr

tables

t_curr = it_temp.

1)need to move from it_temp into it_currinp

it_currinp[] = it_temp[].

2) need to delete from temp where record exist in posnr and also

delete from it_currinp not exits in posnr .

Edited by: anil kumar on Jan 30, 2008 10:30 AM

Former Member — Wed, 30 Jan 2008 05:04:49 GMT

HI,

loop at it_temp where posnr is not initial.

delete it_temp index sy-tabix.

endloop.

loop at it_currinp where posnr is initial.

delete it_currinp index sy-tabix.

endloop.

Cheers,

Will.

Former Member — Wed, 30 Jan 2008 05:04:50 GMT

Here, u r using Z FM, u have to check the code of that FM

Former Member — Wed, 30 Jan 2008 05:14:43 GMT

Anil,

This is the correct way of coding.

SORT : it_temp BY posnr.

it_currinp[] = it_temp[].

DELETE it_temp WHERE POSNT NE ''.

DELETE it_currinp WHERE POSNT EQ ''.

LOOP may reduce the performance of the program.

Don't forget to reward if useful...