Skip to Content

housekeeping for table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 23, 2012 at 12:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded