topic Re: delete data from my DB TABLE in Application Development and Automation Discussions

delete data from my DB TABLE

Former Member — Tue, 19 Dec 2006 14:28:18 GMT

Hallow I build a table in se11 that I can put on her data from my itab how can I clean the table before I put a new data. I try with delete but its not working and refresh given me an error that I have not a header line . what can I do. Thankes

DELETE yhr_ex_mushlach.

LOOP AT itab1.

SPLIT itab1 AT ',' INTO:

itab-id_number

itab-rama

itab-hagbla1

itab-date_start_hagbl

itab-date_stop_hagbla.

IF itab-id_number > 0 .

w_length = STRLEN( itab-id_number ).

w_length = w_length - 1.

itab-pernr = itab-id_number+0(w_length).

ELSE.

itab-pernr = 0.

ENDIF.

APPEND itab.

ENDLOOP.

loop at itab.

modify yhr_table_muslah from itab.

end loop.

Re: delete data from my DB TABLE

rahulkavuri — Tue, 19 Dec 2006 14:35:07 GMT

hi i think u want to clear the Z TABLE and again enter new data into it...

Just follow this sample code....

DELETE FROM ZTABLE WHERE ACCNO <> 1.

just identify a key field which will never be equal to a value, in the above statement ACCNO will never be equal to the value '1', so it will be cleared

award points if found helpful, this worked fine in my case

Re: delete data from my DB TABLE

Former Member — Tue, 19 Dec 2006 14:37:25 GMT

I am assuming ITAB is of the same structure of YHR_TABLE_MUSLAH.

If that is the case, do this

modify yhr_table_muslah from table itab.

Regards,

Ravi

Re: delete data from my DB TABLE

Former Member — Tue, 19 Dec 2006 14:41:52 GMT

HI RAVI I TRY IT BUT ITS NOT WORKING REGARDS

Re: delete data from my DB TABLE

Former Member — Tue, 19 Dec 2006 14:41:58 GMT

HI RAVI I TRY IT BUT ITS NOT WORKING THIS WHAY REGARDS

Re: delete data from my DB TABLE

Former Member — Tue, 19 Dec 2006 14:45:01 GMT

Do you have a COMMIT after the MODIFY statement?

Is it throwing a error?

Regards,

Ravi

Re: delete data from my DB TABLE

rahulkavuri — Tue, 19 Dec 2006 14:48:38 GMT

DELETE yhr_ex_mushlach where PRIMARYKEY <> SPACE.

this will erase the whole Z TABLE.

This should work if u want to just clear the Z TABLE.

If u want to insert data into the same table yhr_ex_mushlach then u can use this statement

modify yhr_table_muslah from itab.

Re: delete data from my DB TABLE

Former Member — Tue, 19 Dec 2006 14:53:48 GMT

hi ravi no i dont have commit and it dont bring err but when i get a new file that i wont to put in yhr_table_muslh the table is full with old data

Re: delete data from my DB TABLE

Former Member — Tue, 19 Dec 2006 15:33:07 GMT

try this code.

DELETE from yhr_ex_mushlach.

LOOP AT itab1.

SPLIT itab1 AT ',' INTO:

itab-id_number

itab-rama

itab-hagbla1

itab-date_start_hagbl

itab-date_stop_hagbla.

IF itab-id_number > 0 .

w_length = STRLEN( itab-id_number ).

w_length = w_length - 1.

itab-pernr = itab-id_number+0(w_length).

ELSE.

itab-pernr = 0.

ENDIF.

APPEND itab.

ENDLOOP.

before doing this sort the itab by the primary keys in your database table and delete itab by comparing the primary keys,

DELETE ADJACENT DUPLICATES FROM itab comparing <fields>

INSERT yhr_table_muslah FROM TABLE itab.

or you can use ths also

update yhr_table_muslah FROM TABLE itab.

Hope this will solve u r problem.

Thanks n regards