BDC Problem

Former Member — Fri, 16 Nov 2007 06:57:51 GMT

Hi Gurus,

I just want to ask on whats the use of the code below.

DELETE it_sales_details WHERE NOT delno IN s_dr.

DELETE it_sales_details WHERE NOT mtsnr IN s_mblnr.

DELETE it_sales_details WHERE NOT budat IN s_budat.

DELETE it_sales_details WHERE NOT matnr IN s_matnr.

DELETE it_return_details WHERE NOT delno IN s_dr.

DELETE it_return_details WHERE NOT mtsnr IN s_mblnr.

DELETE it_return_details WHERE NOT budat IN s_budat.

DELETE it_return_details WHERE NOT matnr IN s_matnr.

Thanks in advance.

Gerald

Re: BDC Problem

Former Member — Fri, 16 Nov 2007 07:00:22 GMT

Hi this code is getting the data of Sales Orders and Returns from Database.

AFter getting the data into internal table, they wrote code to DELETE the internal table data where it is not matching with SELECTION-SCREEN data.

That's why they are using select-options values in DELETE using NOT IN S_* statements.

So finally the tables will have data which is valid based on the Selection-SCreen data.