Remove NE and add delete statement.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi all,

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

Thanks,

Debrup.

[former_member386202]

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

[GauthamV]

hi,

use this.

loop at i_qave.

if i_qave-vbewertung = ' '. 

delete i_qave.

endloop.

[Former Member]

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

[Former Member]

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

[Former Member]

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