Question:
Hi,
Can you please tell me, how to delete all entries from transperant table using ABAP program?
Thanks in advance
Answer:
You don't know any solution? (There are several.)
What about pressing F1 on the most obvious keywourd which comes into mind?
Just to get you started.
(And hopefully you are NOT talking about a SAP standard table.)
Answer:
DELETE ! I think delete is the keyword here !
(what did I win?)
trea
_________________
I'm not tense, just terribly alert.
Answer:
use abap help with delete command.
delete from dtab where...
Answer:
use abap help with delete command.
delete from dtab where...
Now that is a real valuable addition to this thread
_________________
Oscar.
Answer:
ummm Delete OK
DELETE XXX FROM TABLE INT_YYYY
Tiger babu(Jubail SA)
Answer:
Thanks for your response. I read the help, but want to find easy way to delete all entries without using WHERE clause...
DELETE from XYZ where XXXX ne ' '.
Answer:
Thanks for your response. I read the help, but want to find easy way to delete all entries without using WHERE clause...
DELETE from XYZ where XXXX ne ' '.
I've no idea how easy you want it to be .. it is one liner syntax to delete all entries .. btw, if you're on Enterprise .. you can left out the where syntax..
Answer:
By the fastest method, in my experience, is to use the delete using direct access:
DELETE table FROM TABLE itab.
The itab should contain all the keys (including mandt).
The next best method is to use is:
DELETE FROM table CLIENT SPECIFIED WHERE mandt = sy-mandt.
Don't take my word for it, test these method yourself. It's rare that you will ever use the first method unless you are originally inserting the records in the first place. I've used when creating a temp file in which to join on instead of using the 'FOR ALL ENTRIES OF' clause. In this case I inserted the records, ran my SQL extract , then deleted them using method 1.
Dr Sidewalk
_________________
"In the middle of difficulty lies opportunity" - Albert Einstein
"Money isn't everything in life, unless you don't have it". David King
"Fail to plan, plan to fail"
"Success is a journey, not a destination."
Answer:
Thanks Dr. Sidewalk for your reply. I think I have to use WHERE clasue to delete all entries.
Thanks,
ABAP Short Dump