topic Re: dlete from db table in Application Development and Automation Discussions

dlete from db table

Former Member — Wed, 05 Nov 2008 07:43:24 GMT

hi gurus,

how can i delete records from database table from work area which is not compatable i.e, the work area has not all the fields of db table.

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 07:46:53 GMT

for deleting records from Db table u can directly do it via sm30 or se 11. no need for work area to delete DB table.

if this is not the answer u r lookinf for then elaborate ur question.

Re: dlete from db table

h_senden2 — Wed, 05 Nov 2008 07:47:37 GMT

DELETE FROM table WHERE condition.

where the condition is the primary key for instance

regards,

Hans

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 07:48:37 GMT

HI Venu,

Yes you can but, The primary key for the line to be deleted is taken from the explicitly specified work area wa. The key values are read from left to right according to the structure of the primary key of the database table.

Thanks,

Chidanand

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 09:02:21 GMT

Actually my requirement is i have values for four fields in work area using that i can delete the records from db table

if i use 'delete db from wa' it says incomptable becouse wa has only 4 fields

how i can i delete the records from db table

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 09:04:46 GMT

First and Foremost...

PLEASE mention if its a standard table or a Custom table who's entries you want deleted.

Surprising, even those who replied to your query did not bother finding this out .

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 09:27:20 GMT

I need to delete from database table

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 09:28:53 GMT

Sweet!!

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 09:35:40 GMT

Hi,

write the following code in se38.

DELETE FROM table WHERE condition.

where condition u have to give the primary key.

Thanks & regards.

Y.R.Prem Kumar

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 10:12:40 GMT

If the WA and table have different structure, then you need to read the table using the wa fields. Using the WA from read

you can delete the table.

or if you are deleting inside the loop,do like this way

LOOP ITAB into wa_itab.

get the sy-tabix.

check wa_itab 4 fields with your wa 4 fields.

if sy-subrc = 0.

delete itab using the tabix.

endloop.

Regards,

Re: dlete from db table

Former Member — Wed, 05 Nov 2008 10:16:35 GMT

Hello,

Please take care while deleting a entry from a DBASE table that the primary key in your work area and dbase table should match as Chidanand has mentioned earlier.

If a maintanence view exist for the table then better delete the entry from there.

Thanks,

Jayant