Transcript SAP R/3 Data Archiving with PBS Retrieval Methods

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
J
Shorter system response times
SAP Archiving Processes using ADK
use PBS
for retrieval
Data retrieval with
display transactions
1: archive to ADK files
R/3
database
ADK archiving
program
ADK deletion
program
2: delete from R/3 DB
SAP archive files
Benefit from PBS archive add onsTM
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
Agenda

Data Archiving in SAP R/3

PBS archive add onsTM

Project steps
PBS Functionality – Live Demo
CSD Display Transaction /PBS/VA05
Additional
PBS parameter
CSD Display Transaction /PBS/VA05
Indicator for access
via
PBS archive add on
/PBS/VA03 - Display Order
PBS Indicator
/PBS/VA03 - Document Flow
PBS Indicator
Navigation to Archived FI-Record
PBS Indicator
/PBS/VA03 - Display Original Doc.
Access to original
document (facsimile)
via Viewer
PBS archive add ons - Basics
SAP R/3 System + PBS
Data stored in compressed
archive and index files
Integrated display transactions and reports
PBS + ADK
R/3
Database
ADK
PBS index
ADK
R/3 file system
ABAP interface including
direct and sequential archive
access routines
Quick and comfortable
online access to archive
and R/3 database data
Setup of an PBS Archive Index
3
2
PBS
load program
1
PBS + ADK
3
2
PBS index
R/3
Database
1
PBS index and
SAP archive files
PBS display
transactions
PBS Integration with ArchiveLink
SAP R/3 System + PBS
PBS + ADK
R/3
Database
Ext. Archive System
Archive server
ADK files in the
archive system
ADK
ADK
PBS index
R/3 file system
Direct data access
via ArchiveLink
PBS Conversion Tool
ABAP interface for PBS archive access
Customer
ABAP
ZZEXAMPLE
PBS Conversion
Tool
converted
ABAP
ZZEXAMPLE_PBS
automatic
extension of the
SQL instructions by
PBS archive accesses
R/3
Database
PBS + ADK
R/3
Database
PBS
PBSindex
index
ADK
ADK
SAP Data Archiving & PBS archive add ons
PBS archive add ons enhance SAP data archiving with
comfortable and high performance data access
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.
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
1. 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
The End
QUESTIONS