280 likes | 886 Views
SAP R/3 Data Archiving with PBS as Retrieval Method. Patrick Beekman 23 May 2002. Agenda. Ü Data Archiving in SAP R/3 Ü PBS archive add ons TM Ü Project steps. Data archiving in SAP R/3. Ü Data Archiving in SAP R/3 Ü PBS archive add ons TM Ü Project steps. Archiving Benefits.
E N D
SAP R/3 Data Archiving with PBS as Retrieval Method Patrick Beekman 23 May 2002
Agenda ÜData Archiving in SAP R/3 ÜPBS archive add onsTM ÜProject steps
Data archiving in SAP R/3 ÜData Archiving in SAP R/3 ÜPBS archive add onsTM ÜProject steps
Archiving Benefits Why archive data in SAP systems? • r Improve system performance • § Reduction of database size • § Faster backup and recovery • § Faster release upgrade • r Improve use of resources • § Reduced hardware costs • § Reduced administration costs • JShorter system response times
use PBS for retrieval Data retrieval with display transactions R/3 database ADK archiving program 1: archive to ADK files ADK deletion program 2: delete from R/3 DB SAP archive files SAP Archiving Processes using ADK
Display and evaluation functionality of • archived data identical to data base data. • More agressive Archiving Method • Modular program packages corresponding to major SAP modules (FI, SD, MM, CO, ...). • Standardized ready-to-use solutions as „add-on“ software for SAP R/3. • CSP certified by SAP AG Benefit from PBS archive add onsTM
Agenda ÜData Archiving in SAP R/3 ÜPBS archive add onsTM ÜProject steps
Additional PBS parameter CSD Display Transaction /PBS/VA05
CSD Display Transaction /PBS/VA05 Indicator for access via PBS archive add on
/PBS/VA03 - Display Order PBS Indicator
PBS Indicator /PBS/VA03 - Document Flow
Navigation to Archived FI-Record PBS Indicator
Access to original document (facsimile) via Viewer /PBS/VA03 - Display Original Doc.
Data stored in compressed archive and index files Integrated display trans- actions and reports ABAP interface including direct and sequential archive access routines Quick and comfortable online access to archive and R/3 database data SAP R/3 System + PBS PBS + ADK R/3 Database ADK ADK PBS index R/3 file system PBS archive add ons - Basics
PBS load program 3 3 2 2 1 1 PBS + ADK PBS index PBS display transactions R/3 Database Setup of an PBS Archive Index PBS index and SAP archive files
Ext. Archive System SAP R/3 System + PBS ADK files in the archive system Archive server PBS + ADK R/3 Database ADK ADK PBS index Direct data access via ArchiveLink R/3 file system PBS Integration with ArchiveLink
ABAP interface for PBS archive access PBS Conversion Tool converted ABAP ZZEXAMPLE_PBS automatic extension of the SQL instructions by PBS archive accesses PBS + ADK ADK ADK PBS index PBS index R/3 Database R/3 Database PBS Conversion Tool Customer ABAP ZZEXAMPLE
Random access to archived data (via PBS index) Integrated transaction retrieval: Simultaneous display/ evaluation of R/3 database data AND archived data. High DB performance by early archiving opportunity. Direct access to archived facsimiles via ArchiveLink. SAP Data Archiving & PBS archive add ons PBS archive add ons enhance SAP data archiving with comfortable and high performance data access
Agenda ÜData Archiving in SAP R/3 ÜPBS archive add onsTM ÜProject steps
Project Steps • Analysis • Design and Conception • Test • Implementation GO-LIVE
Project steps • Analysis R/3 Database Analysis Off-site analysis Kick-off meeting • Propose Archive Objects to process • R/3 Database growth simulation • Tables outside archive object scope • Archive Object review
Design and Conception: Goals of the design phase • Develop an concrete archiving concept for creating and managing archive files • Create an implementation plan • Create a long term archiving plan Analysis from a business point of view: • Process analysis as prerequisite for determining the residence times • Define the dependencies between the archiving objects, based on documentation AND process analysis • Define the read-access requirements from the business viewpoint.
Test Phase • Archiving under realistic test conditions, datasets should be as similar possible to the production system. • Create user process description for access to archived data • Train the end users
Implementation GO-LIVE • Execute data archiving in production system • - Transports/Customizing • - Agreement from system administrators and user • - Job Monitoring • Communicate results of production archiving to user departments • Post processing • - Table space reorganization where required • - Index reorganization • - Update the database statistics • - Backup archive files • - Check data objects, which could not be archived
? QUESTIONS The End