DELETE tx_vbrk WHERE fkart NOT IN r_fkart.

[Former Member]

Could you pls let me know what is the exact meaning for the below code.

DELETE tx_vbrk WHERE fkart NOT IN r_fkart.

Akshtha.

[Former Member · Accepted solution]

Hi ,

Here r_fkart might be Ranges. So here he has specified a Range of Fkart values. Here the statement says to Delete the records whose Fkart values are not equal to the Values entered. Means there are 1,2,3,4,5 Fkart values in the r_fkart field If u give 2,3 then it will delete 1,4,5 and records.

Rewards if useful.

Thanks,

Murthy

[former_member386202]

Hi,

Definately r_fkart has multiple values

It will delete the record from inetrnal table where value of fkart is not present in r_fkart.

Regrds,

Prashant

[Former Member]

Hi,

Delete records from internal table other than the values in r_Fkart.

regards,

Santosh Thorat