housekeeping for table

[Former Member]

Hi All,

Can anyone provide me links or notes to do housekeeping for the table EDIDS.We have 17miliion records in the  production sytem.I have read the SAP note 706478 , but methods of housekeeping is not explicitly given.Kindly provide me your help at the earliest

Regards

Ram

[paul_power]

Hello Ram,

Use SAP notes 706478, 40088 for deleting old entries from this table.

Do you start the archiving by using the transaction SARA?
Are the entries deleted from the tables EDIDC / EDID4?

Please read following backgroung information on how IDocs are stored on
database level:
An IDoc consists of

  EDIDC   (IDoc control record)    [unique - exactly one per IDoc]
      > stored in EDIDC table

  EDIDD   (IDoc data records   > segments etc.)    [many records]
      > structure only

         >   >4.0: stored in EDID4 table   > cluster EDI40 on database

  EDIDS   (IDoc status records)                    [many records]

So an existing IDoc has to have all three parts but at least a valid
control record (EDIDC).
If the EDIDC records doesn't exists anymore you can delete the cluster
records on database using database functionality (unfortunately this
is not possible from the SAP system).

As an example this could look like the SQL statement below:

    DELETE FROM SAPR3.EDI40 WHERE MANDT = '100' and DOCNUM =
    '0000000000236012' and COUNTER = '000'

Please note that the leading zeros are mandatory!

In case you do have EDIDC records for these IDoc numbers you can delete
these IDocs by using the transaction WE11.

The report RSETESTD (transaction WE11) has been originally set up for
the deletion of test IDoc´s, without the need of checking the status of
the IDoc´s to be deleted. So if you use this report, all IDoc´s will
be deleted, irrespective of the status.

Hope this helps.

Regards,

Paul