Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Retriveing MM archived data

Former Member

‎2008 Feb 08 11:01 AM

0 Likes
895

Hi All,

Im supposed to write a program that retrieves data (specified through select) from all the MM tables (MARA, MARC, MARD ect).

After recieveing this data, I need to compare if the Material Number and Vendor Number details exist in table EINA. If the material data does not exits in EINA, I need to be able to check if any archived information exists for this particular material.

Im aware of the SAP AS (Archive Information System). I have read a few OOS notes and I appreciate that I will be working with Archived Objects and Field Catalogs ect.. But, Im struggling to find a simple example to illistrate this. SOmeone has recommended Transaction Code ME1A. This is helpful, but there are quite a few Enhancements that make it complicated!

Has anyone been here before?

Please let me know.

Max Point will be rewarded.

Christiaan

Hi All,

Im supposed to write a program that retrieves data (specified through select) from all the MM tables (MARA, MARC, MARD ect).

After recieveing this data, I need to compare if the Material Number and Vendor Number details exist in table EINA. If the material data does not exits in EINA, I need to be able to check if any archived information exists for this particular material.

Im aware of the SAP AS (Archive Information System). I have read a few OOS notes and I appreciate that I will be working with Archived Objects and Field Catalogs ect.. But, Im struggling to find a simple example to illistrate this. SOmeone has recommended Transaction Code ME1A. This is helpful, but there are quite a few Enhancements that make it complicated!

Has anyone been here before?

Please let me know.

Max Point will be rewarded.

Christiaan

Reply
4 REPLIES 4
Read only

Former Member

‎2008 Feb 08 11:47 AM

0 Likes
829

praise be to the 'someone' who introduced you to ME1A. you can check on that transaction in case you are reading archived data directly from a flat-file.

but you also mention SAP AIS, so let me explain the difference here:

ME1A reads archived data from a flatfile which HAS to be on the filesystem or one of your application servers or a shared (global) filesystem. this has two negative aspects:

- you have to read sequentially through the file and in case you have a lot of different files (and to make things worse: a lot of big files) this will be so performant that you will like to scream after 2 minutes. so for performance-reasons: skip it.

- second is: if the company you're working at is using an external system to store the files after the deletion run you won't find them in the filesystem any longer and to restore them from the external archiving system just for one run of your program ...

so what you would WANT to do is this: setup an archive info structure using transactions SARI/J - or better still, have your basis team do that. fill that structure with every archive you have run and make sure that they will be filled in future runs (again: your basis team will do that). make sure in that structure that you have vendor, material, plant and info record indicator as a key-field in that structure.

so this 'structure' is actually a table you can see in SE11 and the content of wich you can edit in SE16N thus enabling you to read in that table and if you have a hit there - bingo - the data have been archived.

Read only

Former Member
In response to Former Member

‎2008 Feb 08 11:56 AM

0 Likes
829

Thank you!

How helpful you are. Fantastic advice on giving the Basis team something to do. (:

But the thing is... I still have to CODE all of this (retieval) in my program.. I have checked the Code behind ME1A and some of it looks logical, and some are just darn confusing. Do you happen to know a link with some source code examples?

Many many tks

C

Read only

Former Member
In response to Former Member

‎2008 Feb 08 12:28 PM

0 Likes
829

forget about ME1A!!!

use the AIS-structure created with SARI/J by your basis team () as described above, you can read it with a select (single) like any other table you are reading.

so mostly you have to do what ME1L or ME1M do and add the reading AIS-structure bit ... this should not be a challenge for you (having studied ME1A).

Read only

Former Member
In response to Former Member

‎2008 Feb 14 8:24 AM

0 Likes
829

Hi there,

I didnt thank you the other day for your advice.

I managed to see that SAP creates a transparent table for the Info Structure you create. Therefore you only need to do selects...

Tthis worked fine, but guess what?? After all of this it was decided that it would no longer be used and i had to remove the code....

Oh well, now ill know in future.

Tks again.

C