Skip to Content
author's profile photo Former Member
Former Member

How to read the data of VBRP from Archive database

Dear Friends,

I Have a requirement to retrive the data from the archive data base for the VBRP table.

Have created the a new archive info structure using the catalog SAP_SD_VBRK_002.

But I am a little confused about using the Archive info structure in retrieving.

I know about the 4 FM's that are used for retrieving the data from the archive but could not use the archive infostructure that I have created.

Pls help in find a way for retrieving those docs.

By the way, the amount of data that we are trying to retrive is unbelievbly huge...

Thanks for the help.

Phani

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2009 at 11:03 AM

    hi

    just chk out the demo programs SBOOKR and SBOOKRI_DB_AR_MULTIPLE.

    also chk out the documentations

    http://help.sap.com/saphelp_erp2004/helpdata/en/2a/fa04af493111d182b70000e829fbfe/frameset.htm

    http://help.sap.com/saphelp_erp2004/helpdata/en/8d/3e5e93462a11d189000000e8323d3a/frameset.htm

    hope this helps

    regards

    Aakash Banga

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Aakash,

      Have seen the Functions Modules earlier as well

      CALL FUNCTION 'ARCHIVE_OPEN_FOR_READ'

      CALL FUNCTION 'ARCHIVE_GET_NEXT_OBJECT'

      CALL FUNCTION 'ARCHIVE_GET_TABLE'

      CALL FUNCTION 'ARCHIVE_CLOSE_FILE'.

      But the real Problem is

      I have created a cutomised archive Info Structure to store the retrieved data. But I am not really sure if I can use these Function modules to retrive the data and put it in my Archive Info structure.

      I only want to retrieve selected feilds from the Archive Object SD_VBRK. (basically the selected fields belong to the VBRP table).

      And want to use these feilds later in my program for a lot of caluculations.

      Pls note that the data I will be taking out from the Archive database is quite huge..

      So I also need to consider the performance of the progarm that I am working on now.

      Pls suggest if there is any better way that we can retrieve the data.

      Thanks again for the help.

      regards

      Phani

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.