on 05-30-2007 11:08 AM
Hi
i have a query regarding the sales order archival.
We want to archive the Sales Order irrespective of complete delivery or billing against that sales order. How to archive sales order and where this archival indicator ( OR anything which indicates that the perticular sales order has been archieved ) is stored at database level.
HI Sunraj,
Data Archiving a service provided by SAP NetWeaver removes mass data that the system no longer needs online, but which must still be accessible at a later date if required, from the database.
Step 1: Creating (the First) Archive Files
In step one, the write program creates an archive file. The data to be archived is then read from the database and is written to the archive file in the background. This process continues until one of following three events occurs:
1. All the data is written to an archive file
2. Archiving is not complete, but the archive file reaches the maximum size specified in archiving object-specific Customizing
3. The archiving is not yet finished, but the archive file contains the maximum number of data objects specified in Customizing.
If event 2 or 3 occurs, then archive management continues with the delete step (assuming that the following indicators are marked in archiving object-specific Customizing: Start Automatically and Delete Before Storage).
Step 2: Storing Archive Files
Once the write program has finished creating archive files, these can be stored.
There are several ways of storing archive files:
Storage Systems:
If a storage system is connected to mySAP Business Suite: At the end of a successful write job, a request is sent to this system to store the new archive files (provided the appropriate settings were made in Archiving Object-Specific Customizing. You can also store archive files manually at a later point if you do not want them to be stored automatically. Storage is carried out by the SAP Content Management Infrastructure (which contains the ArchiveLink/CMS interface).
HSM Systems
If you use an HSM system, it is sufficient to maintain the file name in Customizing (Transaction FILE). You do not then need to communicate with the storage system using the SAP Content Management Infrastructure, because the HSM system stores the files on suitable storage media according to access frequency and storage space.
Existing Storage Media
Once the delete program has processed the relevant archive file, you can manually copy archive files to tape.
Step 3: Running Delete Programs
After closing the first archive file, Archive Administration creates a new archive file and continues with the write process. If the settings were made accordingly in archiving-object-specific Customizing (see Settings for the Delete Program), a delete program is started automatically in parallel for the previously created archive file, to read the data in the archive file and then delete it from the database. This procedure guarantees that only data that has been correctly saved in the archive file is deleted from the database.
You can also schedule the delete program manually, for example, so that you can save the archive files before deletion, or because the next available time window is not sufficiently long to also include deletion. The following scenario may also be a reason to manually schedule the delete program:
You create an archive file by starting a write program. The data records are written to an archive file, but the system terminates processing before the delete program starts to run. In this case you must delete the archived data manually in a separate step.
If you do not carry out deletion until after the data has been stored, you can make a setting in Archiving Object-Specific Customizing so that the system will read archive files the from the storage system during deletion. In this way, you can detect errors in good time which might arise when transferring or saving the archive files in the storage system.
When the last archive file is closed, a delete program starts to run for this file. The graphic shows that several delete programs are running simultaneously for previously created archive files. Because, unlike the delete program, the write program does not generally carry out any transactions that change data in the transactions, the write program creates new archive files faster than they can be processed by the delete program. This decreases the total archiving runtime because the database is used more efficiently.
Sales order Archiving:
In Sara transaction you can select the number of the sales orders that you want to archive.
The archive procedure has two steps:
First - you run the preparation to the archive (here the documents steel in database, is just a test to know if the documents are ready to be archive, that means, they are completed)
Second - You run the archive process. Here, if you have a variant to eliminate the documents automatically, the documents disappear for the data base.
If your SAP version is ECC 6.0, the archive documents steel available in VA03, with the message, ' This document is been post by the archive '
SD Archiving:
SD archiving objects are:
SD_VBAK sales orders
RV_LIKP deliveries
SD_VBRK billing documents
FI_ACCRECV --- Customer master
Reward points pls.
Regards,
Govind.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi SunRaj,
I am Gaurav and am presently working on a archival project in my company for SD module. From your query I understand that you have already worked on this project earlier. I would be glad if you could please let me know the process you followed to Archive the data from your database.
Kindly send me the material you have regarding archival at gauravbatra777@yahoo.com
Thanks & Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Karin's right...Archiving a SO is not the best thing to do, the reason being many...one of them is; Customer's money will get blocked resulting him having less credit limit.
You must have noticed Sunraj that there is no seperate T.Code for viewing Archived SO & Deliveries but there is a seperate T.Code:VF07 for Billing Doc.
Regards,
N
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Sun.,
We archive the doccuments in T.code SARA
REWARD if helpfull
Thanks & Regards
Narayana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
In Sara transaction you can select the number of the sales orders that you want to archive.
The archive procedure has two steps:
First - you run the preparation to the archive (here the documents steel in database, is just a test to know if the documents are ready to be archive, that means, they are completed)
Second - You run the archive process. Here, if you have a variant to eliminate the documents automatically, the documents disappear for the data base.
If your SAP version is ECC 6.0, the archive documents steel available in VA03, with the message, ' This document is been post by the archive '
Hello,
I am not sure if your question has been answered or not, but a sales order will not be eligible for archiving unless it is business complete (the order has been delivered, the billing document is complete and the accounting document is in at least a "cleared" status).
Regards,
Karin Tillotson
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.