topic Re: Reg:Delete in Application Development and Automation Discussions

Reg:Delete

Former Member — Tue, 24 Oct 2006 09:26:15 GMT

Hi all,

I have retrived data from an DB table.From the retrieved entreis deleted entries where werks not in Plant on the screen.

for this i have used the code

delete itab where werks ne s_werks.

is this the corect code.Bcoz even though werks = s_werks the data from itab is gettin deleted.

here s_werks is a select-option field.

regards

Re: Reg:Delete

Former Member — Tue, 24 Oct 2006 09:28:20 GMT

Hi Ganesh,

It is wrong.

delete itab where werks not in s_werks. is correct.

Regards,

Ravi

Re: Reg:Delete

Former Member — Tue, 24 Oct 2006 09:29:10 GMT

hi Ganesh,

Declare it in this way in your select statement ..

i.e,

select *

where werks in s_werks

and delete statement should be

delete it_marc where werks not in s_werks.

Regards,

Santosh

Re: Reg:Delete

jayanthi_jayaraman — Tue, 24 Oct 2006 09:40:44 GMT

Hi,

If possible,it is better to take needed records.So if possible,

select the records from db table which is given in screen.

select * from marc into table itab where werks in s_werks.

Otherwise,the code should be

data itab type standard table of marc.

tables marc.

select-options s_werks for marc-werks.

select * from marc into table itab.

delete itab where not werks in s_werks.

sort itab by werks.

Kindly reward points by clicking the star on the left of reply,if it helps as per SDN policy.

Re: Reg:Delete

Former Member — Tue, 24 Oct 2006 09:47:47 GMT

Hi Ravi,

I have 2 db tables and based on particular conditions i am retriving data into these 2 internal tables.The selection-screen contains fields date,werks as a range.if i give only one valu in the date ie. 09/04/2006 the data preior to this date is also retrieved how does this happen.Plz clarify

regards

Re: Reg:Delete

Former Member — Tue, 24 Oct 2006 10:27:44 GMT

Hi,

delete itab where werks ne s_werks.

change to

delete itab where not werks in s_werks.

Regards

amole

Re: Reg:Delete

Former Member — Tue, 24 Oct 2006 10:34:06 GMT

Hi Ganesh,

Can you show the select statement?

If your select statement has something like this:

where date <= s_date-low.

Then it would get all the dates before that.

REgards,

ravi

Re: Reg:Delete

Former Member — Tue, 24 Oct 2006 11:05:37 GMT

No the select stm is not like tht it is as follows

select zchangedt zlocid matnr werks from db table into corresponding fields of itab2 for all entries in itab1 where ZCYLBARCD = ITAB1-BARCD.

IF SY-SUBRC = 0.

delete int_ITAB2 where not werks in s_werks[].

ENDIF.

Re: Reg:Delete

Former Member — Tue, 24 Oct 2006 11:09:22 GMT

Hi ganesh,

As you can see, the where clause itself doesn't filter the data based on the date you enter in the selection screen.

Just entering some date in the selection screen doesn't filter the data.YOur select should have the where condition based on that date as well.

select zchangedt zlocid matnr werks from db table into corresponding fields of itab2 for all entries in itab1 where ZCYLBARCD = ITAB1-BARCD

and zchangedt in s_date.

Make the highlighted change.

Regards,

ravi