Delete statement

[former_member282968]

The statement below is going to work fine in ECC 6.0

DELETE IFINAL WHERE BELNR NOT IN MBLNR.

where MBLNR is the select option declared like below.

SELECT-OPTIONS : MBLNR FOR MSEG-MBLNR MODIF ID DT1.

But when the same code is copied in 4.6B, this will give a sytax error syaing

"Field "IN" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement".

If I do,

DELETE IFINAL WHERE NOT BELNR  IN MBLNR.

Syntax error wont come but is it the right replacement for this version?Will it work like NOT IN MBLNR?

What will be the equivalent statement for this in 4.6 B?

With thanks & regards,

[matt]

DELETE IFINAL WHERE NOT BELNR  IN MBLNR. will work in all ABAP versions. DELETE IFINAL WHERE BELNR NOT  IN MBLNR works only since 46c.

Their action is identical.

[former_member282968]

Thanks Matthew

[Former Member]

Hi,

Maybe this link will help.

http://scn.sap.com/thread/275711

Regards,

Jake