Home

Administration

1. e ACL Services Ltd Vancouver BC Canada hitp www acl com en default asp e AUDICON GmbH 70565 Stuttgart http www audicon net e ID EA http www caseware com fsh asp Safety After the export the data leaves the SAP environment The SAP authorization con cept no longer works in the file system of the target computer c in the file system of the application server d usr sap Protect the data against unauthorized access PBS software PBS archive add on CPCA Administration 30 4 2 Description data access Description of selection interface In general the selection screen of the export programs consists of three parts Part 1 Delimitations to influence the scope of selection In this part the delimitation possibilities are provided from the logical databases which are assigned to each report Part 2 Selection of list layouts 154P Standard Display with Reference Doc No 254P Standard display wiprofit center doc no voaeuuvex Diagram 13 Selection of list layouts A list layout contains all fields that are to be displayed from the selected data vol ume The list can be defined via SAP ALV ABAP List Viewer within an export program and can be stored under an own name Several list variants are possible per export program in order to meet different requirements One list definition each is supplied with the PBS standard Please see the standard documentation for more informa
2. eration process is split automatically into different runs in case of very large index acquisitions This can result in an extremely longer runtime in specific cases The program PBS CPCA_REQ avoids the disadvantages that were mentioned above by saving the indices with a synchronous update task in a DB table first Then in the next step they are read in a sorted way and as usual written in a new ADK file with the ADK index stock The DB table is deleted again after the index generation In case of a large index acquisition the program runs more stable as the ABAP ex tract cannot overflow and the job cannot be cancelled due to this The index gen eration is also tolerant towards cancellations If the temporary index generation cancels in the database the indices that have been created until then are main tained The index generation is started again Only the ADK index write process must not be canceled PBSG software PBS archive add on CPCA You can see all relevant transactions in the area menu PBS CPCA_DBS The transaction PBS CPC004 starts the index generation via program PBS CPCA_REQ The transaction PBS CPCO6 calls up the Administration Board of CPCA chapter 3 1 2 The transactions in the section Temporary Index of the area menu are of second ary importance These transactions are used to manage the index setup via pro gram PBS CPCA_REQ Since the management data only has a temporary validi ty the transactions
3. SAP archive Select manually Select automatically If the radio button Select manually is active a window is displayed when the re quest screen is confirmed showing a list of all available SAP line items that were created on or after the date that you specified see Diagram 6 PBS ca software PBS archive add on CPCA Administration 15 Data from the SAP archive je Select manually SAP archive from 01 01 1990 Archive Administration Select Files for Read Program Archiving object EC_PCA_ITM File Status w 1000 H1020 1996 031541 001 D Delete Completed 031541 002 m Delete Completed 031541 003 m Delete Completed M 0316541 004 E Delete Completed Diagram 6 Proposal list of SAP PCA archives for which you can generate indices Now choose those SAP archives PCA_OBJECT EC_PCA_ITM that you wish to index If an SAP archive file has already been indexed in the previous run the pro gram recognizes it and displays a warning It is not possible for identical line items to be indexed several times All SAP PCA archives that have been created on or after the entered data are se lected in automatic mode without the list being shown PCA archives that have al ready been indexed during this period are not selected here Control index generation Max no of files per run Temporary sort area size If the number of archive files or the size of the archive file
4. parameters as can be seen in Diagram 10 If this is not wanted select the option Hide 123 Parameter in transaction PBS CPCA_TRSTI The definitions regarding the 123 parameters are valid for all reports PBS ca software PBS archive add on CPCA Administration 26 IA CEGA GHB Baae SAP R 3 Diagram 10 Entry of PBS parameters when branching into transaction PBS KE5Z or PBS KE5Y Generated Report Painter reports can be started with transaction GR55 or via the SAP menu as displayed in Diagram 11 3 Accounting gt OJ Financial Accounting gt CI Treasury 3 Controlling p I Cost Element Accounting _ Cost Center Accounting Internal Orders Actvit Hased Costing Product Cost Controlling Waster Data J Planning Actual Postings 4 Information System 3 Reports for Profit Center Accounting 34 Interactive Reporting T S_ALR_ 87009689 Profit Center PlaniActualfvariance a S ALR 87013326 Prot Center Group PlanvActualMariance rl 2 ALAR OTA aad 2 Prafit Cantar Carmnaricnn PlantfietiialAsart Diagram 11 Generated Report Painter reports PBS ca software PBS archive add on CPCA Administration 27 3 5 Convert Report Groups Using the transaction PBS CPCARGCV you can convert report groups which are based on the library 8A3 and the table GLPCT The converted report groups ena ble you to read Profit Center line items from the database and or the CPCA ar chive During conve
5. ATTRIB is used to make Customizing settings Customizing can be transported to other systems using a TABU entry for table PBS CPCA_ATTRIB The Customizing settings are explained below e PBS CPCA LDR Wait for jobs Various jobs for index generation are started by program PBS CPCA_LDR3 Q In the first step PBS CPCA_LDR3 passes on control to program PBS CPCA_LOAD_ CONTROL which gener ates the other jobs PBS CPCA_LDR3 can therefore be ended directly In some cases you have a subsequent job which is dependent on the end of in dex generation For this reason program PBS CPCA_LDR3 waits for all index generation jobs If you do not have any dependent subsequent jobs you do not need option PBS CPCA_LDR Wait for jobs e PBS CPCA LDR Status message if program waits for jobs As a rule the parameter should not be selected It is only used to determine which job the program is waiting for during processing e Build index for RBUKRS In rare cases it is possible that the standard in dex is too slow if selection takes place via the company code because e g the selection does not use the account number or profit center If this is the case for you select option Build index for RBUKRS If an index stock already ex ists the index must be completely recreated Caution If the index stock is very large regeneration can take a very long time If you decide to recreate a new index see chapter 3 1 9 3 1 7 Creation of long t
6. Efa oo a The indices can be accessed by the user when an index area is acti vated chapter 3 1 5 Deactivating the index area means that the indices can no longer be accessed f The loading log for a run displays information about the processed archives and indices T Deleting an index area results in the deletion of all dependent table content and the physical files amp The content of an index area is displayed using the archiving tool chapter 3 2 G Index generation means that ADK files are indexed The indices are also stored in ADK files chapter 3 1 3 PBS ca software 3 1 3 The Index generation program PBS CPCA_ LDR3 The PBS archive add on CPCA enables you to make profit center line items from archive for online processing To do this you construct the required indices from the SAP archive files using the index generation program PBS CPCA_LDR3 amp Index generation archive add on CPCA Profit Center G gt Ee Data from the SAP archive Select manually SAP archive fom 01 01 1990 O Select automatically SAP archive fram 01 01 1990 Control index generation I Max no of files per run 999 Temporary sort area size 1024 ME Diagram 5 Selection screen of the index generation program PBS CPCA_LDR3 In the following section the various delimitation options and the effects that they have when loading the line items into the PBS archive add on CPCA are explained Data from the
7. FI CSD CMM CCO etc All PBS archive add ons have in common that they can be easily installed in the SAP R 3 system via the SAP transport utilities tp and SAINT For installation details of the PBS archive add ons please see the specific installation manual manual part A This administration manual was written to make construction and administration of the PBS archive add on CPCA as easy as possible At first data archiving with transaction SARA is discussed the second topic is the PBS index construction from the SAP archive files The modular user manual of each PBS archive add on is composed of partial man uals Part A Installation Part B Administration Archive Construction and Maintenance Part C Application Programs Transactions Part D Migration Support R 2 gt R 3 if available There are additional manuals for the PBS utilities Conversion Tool Archive Browser Translation Tool Should you have questions regarding the installation of the PBS archive add ons or if you have problems when installing the software please call directly the Service Hotline of PBS Software GmbH Phone 49 6251 174 110 Fax 49 6251 174 174 Email hotline pbs software com Release Compatibility The PBS archive add on CPCA discussed in this manual runs with the basis programs of SAP SE Release 4 0 4 5 4 6 R 3 Enterprise SAP ERP 2004 SAP ERP 6 0 PBS software PBS archive add on CPCA Ad
8. PBS a software CPCA the PBS archive add on for Profit Center line items Manual Part B Administration Compatible with SAP R 3 4 x SAP ERP 2004 SAP ERP 6 0 SAP Certified Powered by SAP NetWeaver April 14 2015 PBS archive add on CPCA Administration 2 1999 2015 PBS Software GmbH Schwanheimer Strasse 144a 64625 Bensheim Germany Phone 49 6251 1740 Fax 49 6251 174 174 Email info pbs software com Internet www pbs software com a PBS archive add ons is a registered trademark of PBS Software GmbH Bensheim SAP R 3 SAP ERP SAP NetWeaver ABAP and others are registered trademarks of SAP SE in Germany and in several other countries Acrobat Reader is a registered trademark of Adobe Systems Incorporated PBS ca software PBS archive add on CPCA Administration 3 Introduction to the PBS ILM Concept Information Lifecycle Management Information Lifecycle Management ILM means the administration of information related to the time when it is used taking into account its total costs and compli ance A conclusive efficient ILM concept must as a result control data growth manage retention rules and also ensure compliant data storage Furthermore an easy access to archived data is decisive and for example its transfer during inter nal and external audits PBS ILM Concept PBS software provides existing SAP customers extensive solutions to put i
9. PBS archiving objects After the indices have been constructed successfully the archived line items are available for online processing and can be easily evaluated using the PBS transac tion The PBS transaction corresponds to the SAP transaction from a functional point of view but can read and display both the data resident in the R 3 database as well as the archived data from the PBS archive add on Because the data that is located in the archive add on can no longer be changed a regular data back up of the archive is not necessary The SAP archive file that is generated during the next reorganization of the database can be added to the ex isting index using the index generation program PBS CPCA_LDR3 The index PBS software PBS archive add on CPCA Administration 11 generation program is started via the main menu PBS PBS or the menu PBS CPCA gt CI Favorites 4 SAP menu gt C List display gt C Report Painter oS Archive gt C Additional Tools Diagram 1 Calling the index generation program up to Release 4 7 gt CI Favorites 4 SAP menu gt C List display gt C ReportPainter gt C Data export a Archive f PASCPCO Load admin table fA IPRSICPCOS Archive tools Diagram 2 Calling the Administration Board from SAP ERP 2004 PBS software PBS archive add on CPCA Administration 12 PCA data is located in the R 3 database in transparent tables SAP arch
10. are not explained in detail In the following the parameters for program PBS CPCA_REQ are described PBS CPCA Index Generation DB Sorting e Archiving object Arch data Archiving Session to m Archiving date to o gt hax doc age years Check if archived data has been deleted from the database Control of the index generation Number of parallel processes 5 Scheduling Server Comment Fostprocess prog After successtul setup the following processes Shall be started automatically v Create administration indices 7 Delete previous run Diagram 8 Program PBS CPCA_REQ e Archiving object Possible entries are EC_PCA_ITM or PCA_OBJECT e Archiving Session An ADK document number If the selection is left blank all archive files are processed that have not been indexed yet e Archiving date corresponds to the date of the document number in transac tion SARA PBS ca software Administration 21 PBS archive add on CPCA Administration 22 e Max doc age Only ADK documents are used for the index generation that do not exceed the maximum document age If the field is left blank all docu ments will be used e Check if archived data has been deleted from the database If the option is selected according to the archive administration transaction SARA in complete archiving runs will not be taken into account An archiving run is in complete if the archived data is
11. ata for extract and SORT is counted the corresponding part of disk space is required For exam ple if you carry out 5 index generation runs with 20 megabytes each for an archive file of 100 megabytes instead of a large index generation run 3 gigabytes should be sufficient for extract and SORT PBS software PBS archive add on CPCA Administration 25 3 4 Report Painter reports In the generated Profit Center invoice reports you can go to transactions KE5Z and KE5Y If you wish to go to the corresponding PBS transactions call transaction PBS CPCA_TRSTI from 4 0B and change the transaction references by clicking the PBS checkbox To change all entries press function key F9 G Sr se lv I OSE CHH HH45 A OB Report Painter calling of PBS line item reports Ame lt Report Painter Reports a F 01GLPCR 3A PCA001 gt C Transactions lt FR Line item reports PBS Line item reports O Show 123 Parameter Hide 123 Parameter Default 1 GA iPBSIKE5SZ Profit Center Actual Line Items PBS CA iPBS KESY Profit Center Plan Line Items PBS 1 01GLPCR 8A PCA001G gt CI Transactions lt E Line item reports U KESZ Profit Center Actual Line Items W KESY Profit Center Plan Line Items PBS v C O1GLPCR 84 PCADD2 Diagram 9 Transaction PBS CPCA_TRSTI Within branching of a generated report into the PBS version of the line item reports a dialog is displayed to enter the 123
12. der to construct and use the PBS archive add on CPCA data archiving must have been completed successfully using SAP tools and access to the archive files created in this way must also be supported 2 4 NAI Compatibility The PBS archive add on CPCA is NAI compatible in the SAP releases R 3 4 7 and ERP 6 0 If you have the PBS Nearline Analytic Infrastructure installed on your sys tem the process of ADK index generation chapter 3 1 to 3 3 can be replaced by the PBS NAI Index Administration Board The NAI index generation takes place centrally for all PBS archive add ons through the NAI Index Administration Board For more details on the index administration please refer to the documentation e nal_index_administrator doc PBSG software PBS archive add on CPCA Administration 9 2 4 1 Extension of NAI index structure The PBS archive add on CPCA defines the NAI index structure and its fields How ever it is possible to create your own index structures and to extend them with re spect to the PBS index structure For more details read the documentation for the PBS NAI Index Administration Board chapter 6 3 2 4 2 Analysis with transaction PBS NAL QUERY Because the NAI index structure PBS NPNA_GLPCA also contains the amount fields TSL HSL KSL and MSL the indices can be analyzed using transaction PBS NAlL QUERY Sums can be created and displayed in compressed form De tails for PBS NAlL QUERY are described in the docum
13. entation e_ nai_administrator doc chapter 6 PBS software PBS archive add on CPCA Administration 10 3 Construction of the PBS archive add on CPCA 3 1 Actual Line Items and Plan Line Items 3 1 1 Procedure In order to archive the actual and plan line items the SAP archiving tool is first used to remove the data from the R 3 database The tool is started via the transac tion SARA The archiving is object oriented Up to Release 4 5 the archiving object for the actual and plan line items is PCA OBJECT From Release 4 6 it is EC_PCA_ITM The archived data is written into sequential files outside the data base by the SAP archiving program The reorganized data can only be evaluated sequentially The reduced load that this result in for the R 3 database can be measured using the PBS Database Ana lyzer The index generation program imports the SAP archive files and generates various indices The indices are stored in a separate archiving object in SAP ADK format the same as the archived line items The physical directory or the files in which this data is located results from the logi cal path that was assigned to the archiving object PBS CPCA via transaction AOBJ The archiving object is delivered with the logical standard path ARCHIVE _DATA_FILE which is also used for the initial archiving objects PCA_OBJECT or EC_PCA_ITM However we recommend that a separate logical path is defined in archive object customizing for
14. erm Indices The runtime of the index generation program increases with an increasing number of profit center line items in the CPCA archive If the runtime has reached an un bearable level e g more than 10 h it is possible to transform the currently active main index with the help of program PBS CPCA FILE see section 3 1 5 into a so called long term index and to start with the creation of a new main index in the next index generation run It is called via the Administration Board from release SAP ERP 2004 chapter 3 1 2 All parameters are defined as defaults in the Ad ministration Board PBS a software PBS archive add on CPCA Administration 19 The current main index and all active long term indices are always considered dur ing the read accesses As the indices are stored in the ADK format you have the possibility to remove all older long term indices which are less often frequented from storage into an optical archive Transform into long term indices If you set this parameter the current main archive will be deactivated and the long term archive will be activated Activate Deactivate long term indices These two parameters enable you to activate or deactivate long term indices De activated indices are not taken into account in the PCA line item selection PBS software PBS archive add on CPCA Administration 20 3 1 8 The index generation program PBS PBS CPCA_LDR9 Alternatively you can
15. file Transfer to PC in text format a Gace AS k Fokdeiad sition 7 laL f J A PC analysis tool ex Winldea Diagram 12 Concept for exporting data PBS ca software PBS archive add on CPCA Administration 29 Data format The SAP AIS format has the following structure Line o F Characteristic value eee Header pa Description o O ps fie description 2 3 4 data type C N P I D T F C text N numeric text on the left filled with zero P packed number digits field length 2 1 This is the SAP internal type The format digits digits is used in the data records Example Type P length 7 decimal places 2 leads to the output 12345678901 23 integer D date with format DD MM YYYY T time with format HH MM SS F floating point number pI fie tong fe number decimal places 7 Currency code or quantity indicator F W M E oP A currency unit field always comes after a currency field A unit of measure field always comes after a quantity field F currency W currency unit M quantity E unit of measure Special field types R C P M PP R rank statistics C counter statistics P percentage statis tics M mean value statistics line In general The field delimiter is a TAB hex code x 09 The interface format is agreed between SAP SE and the following suppliers of revi sion software for external and internal auditors
16. ickly and easily access your archived data even after data archiving during your day to day business The unrestricted data access Is realized by an intelligent indexing concept It extends the SAP ar chive infrastructure components and integrates itself optimally with SAP archiving Archive data that has been indexed can still be provided after a release upgrade immediately without restrictions and without migration effort The PBS archive in dex is stored in sequential files of the SAP file system in the same way as the SAP archive data Afterwards you can access the archive data online via the familiar PBS software PBS archive add on CPCA Administration 4 transactions The SAP user can display the data from the SAP database and the archive data simultaneously via the PBS archive add on index For the user it seems as though the archived data is still in the SAP database The deep integration of the PBS transactions also enables direct navigation to sub sequent and previous documents both within the indexed SAP module as well as to linked documents from other SAP modules This applies not only for resident but also without restrictions for archived data The benefit for the user increases the more PBS archive add ons are used The potential benefits of the ILM concept raises substantially if you take into ac count the savings that result from the SAP mirror systems There are usually at least two of them meaning that the saved d
17. isk storage can be tripled by performing data archiving Thus time is saved for the data backup PBS software PBS archive add on CPCA Administration 5 Table of Contents 1 Introduction 6 2 Overview of the PBS archive add on CPCA 7 2 1 Object Names 7 2 2 Delivered Menus 8 2 3 Basic Information about the PBS archive add on CPCA 8 2 4 NAI Compatibility 8 2 4 1 Extension of NAI index structure 9 2 4 2 Analysis with transaction PBS NAI_QUERY 9 3 Construction of the PBS archive add on CPCA 10 3 1 Actual Line Items and Plan Line Items 10 3 1 1 Procedure 10 3 1 2 The Administration Board under SAP ERP 2004 13 3 1 3 The Index generation program PBS CPCA_LDR3 14 3 1 4 Index Generation 16 3 1 5 Index Activation 17 3 1 6 Customizing 18 3 1 7 Creation of long term Indices 18 3 1 8 The index generation program PBS PBS CPCA_LDR9 20 3 1 9 The index generation program PBS CPCA_REQ from SAP ERP 6 0 20 3 2 Archive Utilities 23 3 3 Disk Space Requirement 24 3 4 Report Painter reports 25 3 5 Convert Report Groups 27 4 Data Export 28 4 1 In general 28 4 2 Description data access 30 PBSG software PBS archive add on CPCA Administration 6 1 Introduction The PBS archive add ons are constructed in modular form and cover the applica tion modules Fl SD MM CO etc with a special program package for exactly this application You can easily see from the name which PBS archive add on belongs to which SAP module C
18. itself is very large then the system resources are often not sufficient to set up all indices in a single gen eration run In this case the setup has to be executed in several steps With the setting Max no of files per run you can define the number of archive files that should be processed per generation run With the setting Temporary sort area size you can define the number of archive files at runtime As a size reference the size of the sorting area which is provided in the selected application server is used This setting is useful if the disk space for the sorting area is not very large In addi tion if you use this setting a large archive file can be processed in several steps whereby the interval limits of each partial step at runtime are determined PBSG software PBS archive add on CPCA Administration 16 Note The size of the sort area provided in the setting Temporary sort area size applies both for the temporary extract file as well as for the temporary sort file that are cre ated during the index generation run The directory for the extract file is defined us ing the parameter DIR_EXTRACT The directory for the sort file is defined using the parameter DIR_ SORTTMP Both parameters can be displayed and changed in the system profile in transaction RZ10 Both parameters often show the same di rectory so that the partition in which the directory is located must exhibit approxi mately double the free dis
19. iving program for the object PCA_OBJECT EC_PCA_ITM The archive files of the line items cannot be evaluated using the SAP transactions Using the PBS archiving technique you can quickly and easily make available your archived data for online processing again PBS transactions Load program of the read both archived PBS archive data as well as add on Data of the PBS archive resident data add on is stored on magnetic disks outside the database Evaluations are possible using transactions Diagram 3 Illustration showing the procedure when constructing the PBS archive add on PBS g software PBS archive add on CPCA Administration 13 3 1 2 The Administration Board under SAP ERP 2004 From SAP ERP 2004 the PBS index is managed with the Administration Board All programs and tools necessary for building maintaining and analyzing the indices can be controlled directly via this cockpit Gi alaB eae cun onoamnma gom Administration Board CPCA 1 Main index asne vasa Sa _ Main indices Long timeind Inactive indices Index createdon ADK status PBS status Oldest archi 030848 21 07 2005 KISSEL O G Complete O Main index active 30 08 2004 Diagram 4 Administration Board The following table describes the individual functions which can also be executed via the menu m The main index is converted into a long term index chapter 3 1 7
20. k space of the value that has been specified in the set ting Temporary sort area size 3 1 4 Index Generation lt is recommended to process as many archive files as possible in one run due to the fact that the index generation is split via program control in several steps as described in chapter 3 1 3 The index generation program submits the control to a control program that then creates several separate index generation runs One temporary index file that has not been merged with the respective predecessor is created per run All temporary index files are only consolidated with the old run for the main index at the end of this process As the consolidation process takes a long time it is clear why the index generation should be split via program control If it were to be split manually the consolidation would take place after each run After successful consolidation the temporary index files and the old run are deleted The index is then automatically activated If an index generation procedure is terminated the temporary index files that have been created up to this point and the old run are retained At restart the index generation program commences from the last run to be completed or recognizes which archive files have already been processed PBS software PBS archive add on CPCA Administration 17 3 1 5 Index Activation The index is activated using the program PBS CPCA_FILE The indices are usual ly activated auto
21. le Import Assistent l i x Bitte wahlen Sie eine Datei aus Bitte wahlen Ste die gewunechte Vorgehenswelse Neue Dateien und Standard PC Formate C Bestehende Datensatzbeschreibung auswahlen andem C ProgrammeS IDEAS amples aoe Druckdatei importieren C ODBCuoriff nutzen f SAPZAIS Importdatei f Andere Diagram 16 Definition of the file format in this example in the PC program Idea With the PC analysis program you have many possibilities to check the extracted data whether they are factually consistent PBS ca software PBS archive add on CPCA Administration 33 Recommendations for the data export e Default value file path You can define a default value in the user master for the file path via the parameter ID PBS CPCA_LIS_ PATH e Termination data export with the message Variant was not found The layout in which the fields to be extracted were defined does not exist or it was not stored when the layout was created e Termination PC analysis program during import of the SAP stock with the message SAP AIS file is invalid During the transfer of the export files from the Unix Windows NT environment into the PC environment the transfer was executed in the ASCII mode instead of the BINARY mode by error or an ASCII conversion was not executed under AS400 e Termination during dialog processing with message MOVE TO LIT NOTALLOWED NODATA A field variant is used that has more
22. matically after the index generation so that no further steps are re quired Using the program PBS CPCA_FILE indices can also be deactivated or converted to a long term index chapter 3 1 7 The program is called via the menu Load admin table up to Release 4 7 From Release SAP ERP 2004 you can go to index activation via the Administration Board chapter 3 1 2 where all parame ters are defined as defaults Index activation archive add on CPCA Profit Center gt Select run for index setup Process main index iUse lastrun O Select run manually select list O Deactivate main index O Transform into lg term ind Process long term indices activate long term indices Select list O Deactivate long term indices Select list Diagram 7 Selection screen for the activation of indices Use last run Setting this parameter results in the last run that was performed being automatical ly used for the generation of the indices Select run manually You can use the parameter Select run manually to reactivate a previous run at any time in order to generate the corresponding administration indices PBSG software PBS archive add on CPCA Administration 18 Deactivate main archive This parameter enables you to delete the current indices without having to activate the indices for another index generation run at the same time The index files are not deleted 3 1 6 Customizing Program PBS CPCA_
23. ministration 7 2 Overview of the PBS ar chive add on CPCA 2 1 Object Names As already explained in the installation manual part A from release 4 0 PBS Software GmbH has its own namespace The names of the programs and objects described in this manual originate exclusively from this namespace Table 1 Object names 1 or PBS PBS_ 45 in release 4 5 PBSG software PBS archive add on CPCA Administration 8 2 2 Delivered Menus A global menu for all products and utilities of PBS Software GmbH and menu spe cifically for the add on CPCA is delivered with the PBS archive add on For Releases 4 0 to 4 5 the global menu is started via the transaction PBS PBS Afterwards a button is displayed that starts the menu From Release 4 6 the glob al menu can be incorporated in the appropriate activity group 4 6B or roles from 4 6C and started from there The menu for the PBS archive add on CPCA can be started for the Release 4 0 to 4 5 via the transaction PBS CPCA or from the global menu From Release 4 6 this can be started by incorporating the menu PBS CPCA in the activity group 4 6B or roles from 4 60 All programs described in this handbook are included in the menu 2 3 Basic Information about the PBS archive add on CPCA The administrative task of the PBS archive add on is to construct and activate the PBS index and to analyze the archive with the tools provided in the event of any problems In or
24. nto practice the requirements that were described above for a stringent and successful ILM concept PBS is considered as an expert for complex integrated data access es to archived and database data and meanwhile also to data that is located on decommissioned SAP systems In addition to classical SAP data archiving SAP BW specific nearline storage is also supported PBS archive add ons PBS archive add ons always rely on SAP archiving having been carried out suc cessfully This is the basis for a permanently high performing SAP system In prin ciple you can indeed retain posted documents in the SAP database for a very long time due to a large database capacity Depending on the document volume this may result however in massive performance losses and sooner or later heavily increasing operation costs The daily backup becomes difficult for large data stocks for example A convenient display and evaluation of archived transaction data as the SAP user is used to for database data can often only be carried out in a very restricted manner using SAP standard means depending on the application module This is particularly the case for large archive data stocks The PBS archive add ons can be used here They can be provided for nearly all SAP modules and release levels and start with a C for Complete in their description For example PBS archive add on CCOPA for the SAP module COPA Using the PBS archive add ons you can qu
25. ory exists b it can be written into the indicated directory c the indicated file name already exists If this is the case the final user can de cide whether the existing file can be overwritten or whether another file name should be chosen At the end of each export transaction an export statistic is exported Export log file 28 07 2005 14 05 34 Output path fpbs cpca Output file Test _ 20050728 140534 Record count 188 Diagram 15 Export log Size of the export file The size of an export file depends on the number of items to be selected and the width of the selection list You will get this information when you display or change a layout In principle the disk space can be determined as follows number items X line width of the layout 2000 bytes header record SAP AIS PBS ca software PBS archive add on CPCA Administration 32 The file size of the program is limited to 650 MB to enable the transfer of data ona CD If the data volume to be selected is larger subsequent files are created with name extensions Vxxxx xxxx Sequence number Transfer of files into the PC environment If the creation of the extract stock is completed the files from the Unix Windows NT server into the PC environment can be transferred in the ASCII mode ftp gt asc Further processing in the PC analysis programs The extract stocks can be further processed by indicating a file format in the usual analysis programs availab
26. ree stor age capacity in order to set up the archive The disk space capacity to be provided depends on the number of line items which should be stored in the archive You should reserve about 100 bytes per line item including secondary index You have to reserve additional temporary disk space for extract as well as for SORT during an index generation run However it could be the case that the parti tion reserved is not sufficient The following example shows how to determine the necessary disk space 20 MB PCA archive data corresponds to about 400 000 ar chived line items due to a very good compression rate during archiving of over 10 1 Extract files are not compressed Therefore each line item corresponds to about 2 2 kilobytes for the extract 6 indices whereby an extract file of about 900 megabytes is created for 20 megabytes archive data Not sorted and sorted extract files correspond to a total requirement of about 1800 megabytes In addition the temporary SORT file created by the SORT should require about 1100 megabytes This means that you should consider at least 3 gigabytes disk space for extract and SORT for an archive file of 20 megabytes with about 400 000 line items during an index generation run In an extreme case an archive file of 100 megabytes or more requires a very high disk space capacity To avoid such a data volume you can split a large index gen eration run into several smaller runs As only the access to archive d
27. rting a report group different reports are created The conver sion has to be executed in each system in which you wish to carry out the report group By setting the checkbox Overwrite programs the generated programs of al ready converted report groups are overwritten without any warning Start the converted report groups with transaction PBS CPCARGEX PBS software PBS archive add on CPCA 4 Data Export 4 1 In general Administration 28 As basis serves the transactions PBS CPC05Z2 and PBS CPCO5Y that selects the data via logical databases from the SAP system and the PBS index and ex ports it directly into a sequential file in the Unix Windows NT environment You can define the fields to be exported via the ABAP list viewer SAP ALV The created file can be processed by a PC analysis program after the transfer in the PC envi ronment The usual SAP standard format AIS Audit Information System was se lected as data format z Line1 f Line2 f Line3 E oo PBS Archive data Line 1 Hidden fields Col content pn gomans Mataba g Document number Posting date Document date laccount type laccount G account account short text Posting key Tax code Line width GAL acct short text Net due date GIL account Document type Line item ID Tax code Clearing date G L account Clearing date Group indicator Posting period amp 7 DR sequential data
28. still not deleted from the database e Number of parallel processes To speed up the index generation the index generation process can be divided into several batch processes The main process runs until all parallel processes are completed Comment A free form text can be entered here which can later be found in the index administration e Create administration indices The ADK index will be activated e Delete previous run If available the previous run will be deleted This pa rameter should always be selected since the new index always contains the previous run PBS software PBS archive add on CPCA Administration 23 3 2 Archive Utilities The following ABAP 4 reports are available for testing the PBS archive add on CPCA Report PBS CPCA_SCAN This report enables a technical view into the PBS archive add on CPCA In particu lar it is possible to see the statistics of both the current and all previous index gen eration runs Reports PBS CPCA_INDEX PBS CPCA_INDEX2 PBS CPCA_INDEX3 These reports enable the PBS archive add on to be read with different delimita tions Report PBS CPCA_DELR This report enables one or more PBS index files to be deleted PBS software PBS archive add on CPCA Administration 24 3 3 Disk Space Requirement The PBS archive add on for the profit center line items is set up in database independent file systems The system administrator s task is to reserve f
29. than 1020 bytes or more than 90 columns Such variants are only allowed for data export and cannot be used in the dialog PBS software
30. tion about the SAP ALV functions To create a list for an export program execute first the report in the dialog with the option Display Print see below When doing this the data volume to be selected should be kept small Then you can define the scope of the list via the function keys Options gt Layout gt change The list variant can be stored via Options gt Layout gt store If the list is defined in a test system and should then be transferred into the production system transfer the layout into a transport request via Options gt Layout gt Layout administration gt Layout gt Transport PBS ca software PBS archive add on CPCA Administration 31 Note In general the width of a list is limited due to the number of bytes or number of col umns This means you usually cannot select all fields at the same time in one list definition Therefore a field selection has to be made Part 3 Output option Output option DisplayiPrint O Export to file SAP Audit 6 Add date time to file name Export option File name Test Directory fpbsicpcal Diagram 14 Output option In general you can decide in the selection screen whether the selected dataset should be displayed as ALV list or transferred into the indicated export directory If there is a large selection volume the process should be made in the background During the data export before the execution is made it is checked whether a the indicated direct
31. use the index generation program PBS CPCA_LDR39 instead of the index generation program PBS CPCA_LDR3 The operation is identical to the original The index generation program PBS CPCA_LDRg9 only differs in sort ing the newly added indices via external files with a separate merge algorithm in stead of using an extract SORT A possible limit of 2 gigabytes is considered The temporary SORT files are written in a directory which is determined by the pro file variable DIR_SORTTMP in analogy to the index generation program PBS CPCA_LDRS8 Enough disk space should be considered for this See details in chapter 3 3 There is also an option in the index generation program PBS CPCA_LDR9 which enables you to select another directory without changing the system variable DIR_SORTTMP The user has to create a text file naming DIR_SORTTMP in the directory which is determined by the system variable DIR HOME This text file has to contain one line with the complete path of the selected directory Then the index generation program PBS CPCA_LDR9 uses this directory to store the SORT files 3 1 9 The index generation program PBS CPCA_ REQ from SAP ERP 6 0 Memory space is needed in order to sort the indices in the programs PBS CPCA_LDR Thus there is no capacity load on the database It often occurs that not enough memory space can be provided in the file system To keep the memory space requirement within the limits that can be provided the index gen

Administration

Contents

Download Pdf Manuals

Related Search

Related Contents