cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to read table data associated with archive object CRM_IBASE?

gopalkrishna_baliga
Participant
0 Kudos
220

Hi Experts,

    I am trying to archive ibase related data in Sap CRM.

    For this I have used the archive object CRM_IBASE.

    This archive object has many tables like IBIB, IBIB, IBST etc,

    I have used tocode SARA to archive one ibase data. It successfully completed with green color satus and delete completed. 

gopalkrishna_baliga_0-1738316796073.png

    However if I search for my ibase archived data in the ZARIXCR29 table i don't find my data. Why is this so? My requirement is to read the archived data and put that into a excel file.

For this i have used the code as below:

SELECT SINGLE FROM admi_files INTO wa_admi_files WHERE document docn.

SELECT FROM zarixcr29 INTO CORRESPONDING FIELDS OF TABLE lt_archivekeys
             WHERE archivekey wa_admi_files-archiv_key.

LOOP AT lt_archivekeys INTO la_archivekeys.

*Read information from archive
  CALL FUNCTION 'ARCHIVE_READ_OBJECT'
    EXPORTING
      object         = arobj  "'CRM_IBASE' 
      archivkey      = la_archivekeys-archivekey
      offset         = la_archivekeys-archiveofs
    IMPORTING
      archive_handle = ls_handle
    EXCEPTIONS
      OTHERS         1.

CALL FUNCTION 'ARCHIVE_GET_TABLE'
      EXPORTING
        archive_handle          = ls_handle
        record_structure        = 'IBIB' "'IBIB'
        all_records_of_object   = 'X'
        automatic_conversion    = 'X'
      TABLES
        table                   = lt_ibib "lt_ibib "Header data
      EXCEPTIONS
        end_of_object           = 1
        internal_error          = 2
        wrong_access_to_archive = 3
        OTHERS                  4.

ENDLOOP.

  However i am not getting any data from any tables like IBIB or IBIN, etc using the FM ARCHIVE_GET_TABLE. What am i doing wrong? 

  What i need to do to read the table data? 

  Please help!

Thanks

Gopal

Accepted Solutions (0)

Answers (0)