Archiving of PCL4 table data to Content Server

Details :

Archiving Object HR: Long-Term Documents ( PA_LDOC) can be used to archive or delete long term documents from the creation of change documents for infotypes from PA(personnel administration),TM(time management) and AP(applicant management). 

Procedure :

Step 1:

1. Run the Tcode : SARA and Click on customization for Technical Settings for the archiving object.

2. Make the selection accordingly to the requirement, ie. doestn't schedule the delete Job,copy the archived file to content server.

Step 2 :

1. Run the Tcode : SARA and enter the Archiving Object PA_LDOC to archive the Long Term documents.

2. Now write the archiving for the Long term document by giving Variant name and click on edit.

3. Now give and select the appropraite date and options to archive your data and provide the description under attributes and SAVE.

4. Now provide the start date and time to schedule the archiving job and spool parameter.

5. Monitor the write Job from SM37 wait for the job to finish.

6. Now move the created archive file to content server. 

7. Select the Archive session file to move it to content server.

8. Provide the Job start date and time and schedule the Job and monitor it from SM37.

9. Now the delete the data by using the same archiving object.

10. Now select the archive session files, job schedule date and time and sppol parameter to start the Job and execute.

11. Monitor the Job from SM37.

Archiving of SAP WorkFlow Item to Content Server

 Detail:

The system archivine all data except runtime data that belongs to work item.Once archived data 

can only be used to display and cannot be reloaded to table again.You can only archive completed workflow items and its dependent.Along with it you can archive log data,workflow manager data and work item attachment.

Workitem that can be archive that have following statues.

Completed (Executon of Workitem Completed)

Logically Deleted (Cancelled item no longer useful)

Your SAP work flow and its related tables are SWZAIRET,SWZAIENTRY,SWZAI,SWWWIRET,SWWWIHEAD,SWWWIDEADL,SWWWIAGENT,SWWLOGPARA,SWWLOGHIST,SWWEI,SWWCNTPADD,SWWCNTP0,SWW_WI2OBJ,SWW_CONTOB,SWW_CONT,SWPSTEPLOG,SWPNODELOG,SWPNODE,SWPCMPCONT,SWP_NODEWI,SWP_JOIN,SWP_HEADER,SWFGPROLEINST

Procedure :

Step 1:

1. Create the Content Repository in Tcode: Oac0 and Save

Step 2:

1. Run Tcode : SARA with Archiving object WORKITEM.

2. Click on Customizing to perform Archiving Object Specific Customization.

3. Click on Technical Setting for Further Configuration and configure accordingly to your requirement.In this I have not choosen the option to start the job to move the archiving to content server and delete the archive file.

Step 3:

1. Check the no. of entries available of  SWWWIHEAD have status Completed / Cancelled by specifying the date.

2. Run Tcode : SARA with Archiving object WORKITEM.

3. Write the Workflow to Archive

4. Now Create the Write Variant and click Edit.

5. Select for all Selection Screen and Provide the Workflow creation date and provide the description under attribute and SAVE.

6. Maintain the Job execution date and and spool parameter and execute.

7. Monitor the Archiving Write Job from SM37.

8. After sucessful Job finish, Click on Storage System , then Archive Files.

9. Select the session files and Job Start date and time and Execute it as background.

10. Store Trigger Job can be monitor from SM37 

11. After the Job is finished , we can run the delete for the that created archive session.

12. Selcet the Session Files, set the job scedule and spool parameter and execute.

13. Monitor the deletion job from SM37.

To read the archive data of the session it can be either done with GOS menu or from tcode SARI --> Archive Explorer --> Archiving Object -"WORKITEM" , Archive Infostructure - "SAP_O_2_WI_001".

System Refresh Plan and Activity

Table Export and Import Using Brtools (Brspace) for SAP systems

 Problem:

How to take backup of SAP Tables using brtools in Oracle.

Solution:

Table Export --

oracle > brspace -p init<SID>.sap -u / -c force -f tbexport -p 10 -l expdp -t "HTTPURLLOC,USR02,RFCDES" -u /oracle/<SID>/sapreorg -f

Table Import --

oracle > brspace -p init<SID>.sap -u / -c force -f tbimport -y tables -p 10 -a replace -t "HTTPURLLOC,USR02,RFCDES" -o SAPSR3 -x "/oracle/<SID>/sapreorg/sfiuvudl.edd/expdat.dmp,/oracle/<SID>/sapreorg/sfiuvudl.edd/expdat01.dmp" -f

Note:

Ensure you have successful DB backup before import activity.

Maintain the variants for the deletion program first

 Error:

Maintain the variants for the deletion program first while performing archive writing.

Solution 1 :

1. Transaction code SARA-> Input archiving object, click on 'Customizing' button -> Execute 'Technical Settings' under 'Archiving Object-Specific Customizing'.

2. Change customizing setting from 'Start Automatically' to 'Not Scheduled

Solution 2 :

Maintain variant for archive deletion job before starting archive writing job.