topic Re: Delete statement in Application Development and Automation Discussions

Delete statement

former_member282968 — Tue, 22 May 2012 06:26:47 GMT

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 — Tue, 22 May 2012 06:29:22 GMT

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 — Tue, 22 May 2012 06:45:07 GMT

Thanks Matthew

Former Member — Tue, 22 May 2012 06:55:43 GMT

Hi,

Maybe this link will help.

Regards,

Jake