How to delete record from table control in BDC?

[Former Member]

Hello friends,

I am running a BDC program to delete records.

I have file with following records and i got these records into t_itab.

Material	Plant	Start date	End date	Cost
MQ100001	S001	09/01/2008	09/31/2008	55.00
MQ100004	S002	09/01/2008	09/31/2008	56.00
MQ100008	S003	09/01/2008	09/31/2008	57.00

Now, I have BDC transaction in which table control screen which contains following structure.

MQ100001	S001	09/01/2008	09/31/2008	55.00
MQ100002	S002	09/01/2008	09/31/2008	56.00
MQ100004	S003	09/01/2008	09/31/2008	47.00	
MQ100005	S004	09/01/2008	09/31/2008	25.00
MQ100006	S012	09/01/2008	09/31/2008	76.00
MQ100007	S033	09/01/2008	09/31/2008	17.00
MQ100008	S011	09/01/2008	09/31/2008	95.00
MQ100009	S002	09/01/2008	09/31/2008	46.00

I have recorded from SHDB in which first record will be delete.

So, when i loop through t_itab,instead of deleting MQ100001,MQ100004 and MQ100008 from BDC screen,

it is deleting MQ100001,MQ100002 and MQ100004 (first record for each process ).

Which i don't want to.

Is there any facility in BDC to put records on top which i want to delete?

Please guide me.

Regards,

RH

[Former Member]

Check if there is a FIND / FILTER button, you can use that and select the line..

like in ME21N the item overview have that kind of feature

Edited by: Etrafanob on Sep 17, 2008 1:56 PM

Edited by: Etrafanob on Sep 17, 2008 1:56 PM

[former_member70391]

Hi,

While doing recording check for Filter button available for the table control, if it available then do the recording for the same.

Once it is done while passing the data from internal table put the value into Filter field.

Hope it resolves your issue.

Thanks & Regards.

Nagaraj Kalbavi

[Former Member]

Thanks