topic Re: Remove NE and add delete statement. in Application Development and Automation Discussions

Remove NE and add delete statement.

Former Member — Mon, 24 Nov 2008 06:10:10 GMT

Hi All,

I have the following selection Query,

SELECT prueflos vcode vbewertung .

FROM qave INTO TABLE i_qave

FOR ALL ENTRIES IN i_qasr

WHERE prueflos = i_qasr-prueflos

AND vbewertung NE ' '.

I want to remove the NE and implement same using delete statement.

Thanks,

Debrup.

Re: Remove NE and add delete statement.

Former Member — Mon, 24 Nov 2008 06:12:54 GMT

if i_qasr is not initial.

SELECT prueflos vcode vbewertung 
FROM qave INTO TABLE i_qave
FOR ALL ENTRIES IN i_qasr
WHERE prueflos = i_qasr-prueflos. 

delete i_qave where vbewertung  EQ ' '.
endif.

Re: Remove NE and add delete statement.

former_member386202 — Mon, 24 Nov 2008 06:14:16 GMT

Hi,

After select statement use delete statement.

Refer below code.

SELECT prueflos vcode vbewertung .

FROM qave INTO TABLE i_qave

FOR ALL ENTRIES IN i_qasr

WHERE prueflos = i_qasr-prueflos.

delete i_qasr where vbewertung eq ' '.

Regards,

Prashant

Re: Remove NE and add delete statement.

GauthamV — Mon, 24 Nov 2008 06:14:24 GMT

hi,

use this.


loop at i_qave.

if i_qave-vbewertung = ' '. 

delete i_qave.

endloop.

Re: Remove NE and add delete statement.

Former Member — Mon, 24 Nov 2008 06:15:43 GMT

HI.

Refer this code.

if i_qasr is not initial.

SELECT prueflos vcode vbewertung .

FROM qave INTO TABLE i_qave

FOR ALL ENTRIES IN i_qasr

WHERE prueflos = i_qasr-prueflos.

endif.

if i_qave is not initial.

delete i_qave where vbewertung EQ ' '.

endif.

Regards.

Jay

Re: Remove NE and add delete statement.

Former Member — Mon, 24 Nov 2008 06:16:41 GMT

Hi all,

Thanks a lot for the answers, my doubt is resolved now.

Thanks,

Debrup.

Re: Remove NE and add delete statement.

Former Member — Mon, 24 Nov 2008 06:17:44 GMT

Hi,

SELECT prueflos vcode vbewertung .

FROM qave INTO TABLE i_qave

FOR ALL ENTRIES IN i_qasr

WHERE prueflos = i_qasr-prueflos.

AND vbewertung NE ' '.

If not i_qasr[] is initial.

delete i_qasr where vbewertung ne ' '.

endif

Re: Remove NE and add delete statement.

Former Member — Mon, 24 Nov 2008 06:36:34 GMT

Hi Debrup,

Try using this.

SELECT prueflos vcode vbewertung .

FROM qave INTO TABLE i_qave

FOR ALL ENTRIES IN i_qasr

WHERE prueflos = i_qasr-prueflos.

Loop at i_qave.

if i_qave-fvbewertung <> space.

delete i_qave.

endif.

endloop.

Thanks & Regards

Ruchi Tiwari