How to read the data of VBRP from Archive database

[Former Member]

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

[Former Member]

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

[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