Deletion of entries from A580 table

[sanjay_deshpande4]

HI All,

Kindly guide whetehr its advisable to delete entries from A580 as this is standard table?

If yes how to delete?

Is there any BAPI available for this?

Thnaks.

[former_member182915]

Hi ,

As this table is important one as this is used for Access sequence finding in Sales.

I hope you enter data to this table through SPRO , so i think if you remove from table by using SPRO or standard tcode it will update respective table , instead direct delete from Table.

[sanjay_deshpande4]

Table is getting updated from VK11.

Kindly guide further.

[sanjay_deshpande4]

I just want to delete some entries from aforesaid A580 table without affecting consistancy.

Kindly guide further.

[JL23]

when you define the condition type then you are actually defining whether a deletion will be a hard deletion from the data base or just setting the deletion indicator.

This is usually decided based on the legal and internal audit requirements.

And if the records are still there with a deletion indicator then you need to use data archiving process to write it into an archive (where it still can be accessed and reviewed from auditors and retained for several years based on the legal requirements) and delete it physically from the tables.

Why don't you want to make an exception to any other data, or do you also delete purchase orders or sales orders from the tables?

[JL23]

It is a price condition table and obsolete records have to be archived using the object SD_COND

This object is not as easy as other archiving objects, nobody must maintain price conditions during the time of archiving  otherwise this can create inconsistencies and even deletion of records that you did not want to be archived.

[sanjay_deshpande4]

I just want to delete some entries from aforesaid A580 table without affecting consistancy.

Kindly guide further.

[michael_kozlowski]

You can use trx SE16N (in Debug-Mode SET gd-edit & gd-sapedit TO 'X') to edit A580 table if you absolutely sure about keep consistency!

[JL23]

I hope that in a well secured production environment nobody will have this authority, maybe only through a firefighter role.

[sanjay_deshpande4]

Hi All,

WHen i did where used on table and key fielsd, I am not finding any programm or table or structure found.

Does that mean there are no dependancies?

Kindly guide.

[JL23]

Just use SE16 to display what you see in A580, and then compare it with the data maintained through VK11, this alone should already give you the impression that A580 does not stand alone. For example, do you see the prices in A580?

In the transaction DB15 you can see all tables belonging to an archive object, so you would  need to take care about all of them to avoid creating inconsistencies.

[michael_kozlowski]

Although no dependencies found by the system you can not be sure that there really are no dependencies.

Be aware!

[Former Member]

Hi

Please try report RV12A002

Regards

[sanjay_deshpande4]

Can this report be used to delete specific entries of database?

Kindly guide.

[JL23]

this report deletes the entire table from the system.

You should always double check e.g. in help.sap.com and support.sap.com and SCN if you could get more information on such thrown in report names