delete enteries in a table SAP

65 pts.
Tags:
SAP
SAP Tables
how can i delete an entery in an standard table without using the access key because in my senerio a excise invoice was cancelled and again it was cancelled and the relavent billing is not getting cancelled and no accounting doc. was generaated soo i wanted it to be deted from tables VBRK VBRP please help me Regrads, nitin

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello Nitin,

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

Regards
Sid

Hello Nitin,

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.

Regards,
Kevin

Hi,

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.

Thanks,
vh

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.

Regrads,
Nitin

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.

Regards JG

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 9982220222
    HI TO EDIT TABLE PLS FOLLOW THE STEP BELOW ENTER TCODE SE16N GIVE TABLE NAME INADDRESS BAR ENTER GIVE &SAP_EDIT IN TCODE AREA ENTER NOW GIVE FUNCTIONAL REQ TERM NOW EXCUTE
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following