Along with the other respondents, I would not do a direct delete of any data from SAP unless a customer table.
The table VBRK is an esential part of Invoice data and is related to a great many other tables.
If you use transaction DB15, you will see that this table can be archived using the SD_VBRK archiving object.
You can also see a list of the tables used by the SD_VBRK archive object, and this may well suprise you.
The archiving object will allow you to archive and delete data based on a single document, range of documents etc.
Though, this answer is based on the presumption that you have Archiving already configured.
Hope this helps
I unfortunately do not have an answer to your questions but instead I would like to offer you a word of caution when considering direct updates to SAP tables. In general if SAP does not provide a means to delete an object it is most likely intentional. All updates to SAP tables should be done via transactions or BAPIs otherwise you risk running into data integrity issues. Unless it is specifically stated in an OSS note to delete the entry, I would seek an alternative means to resolve your issue. Perhaps a quick search on the SAP Service Marketplace might be helpful. If all else fails you should raise a Customer Message with SAP.
I hope this helps.
Actually there are two main cases
- If these tables are standard tables, you must use BAPI, CALL TRANSACTION (or BTC) or any valid access given by SAP
- If these tables are customer tables, you may use the DELETE statement, but insure yourself the coherence of the database (don’t delete an header leaving poor orphan items behind…) look for foreign key in where-used.
Hi all ,
Thank you for our suggestions but I have found one solution to this as go to t-code se16n
give the table name in address bar now give &sap_edit and excute it now we i’ll be able to detelte or modify the data here with out effecting other t-codes data.
Hi Nitin and others
As Nitin said, you can maintain in txn SE16N (or in SE16->Create new entries). In some tables it shows all entries. In some it may just show you the screen to add. For some you may not be able to do this action (e.g. T006). It depends on the table’s maintenance dialog that has been generated at that time. You can add/change/delete entries. Of course you can not modify the key of an existing entry. You can achieve such change by delete and add.
As the others have said, you need to take care about the change you are making. The importance of the table determines the caution you need to take. If you are sure about what you are doing, go ahead. Else simply ASK an expert or a second opinion!!! It is worth doing that than move the change to production, suffer from consequences and repent.