PBS archive add on CISU - Handbuch Teil B
Contents
1. 4 1801100000000000000107 2004 01 188110000000000000007 1 811 HH HH HH 200401 1001100000000000 200401 8822595911131 5231231230008 DDD 188118888080808gBBEEEEH f dddHH2288031231238888288040110225858280051288888844CET DIAMAMTID 1001100000000000 f d ddHE288031231238888288401102258582808051288885731CET DIAMAMTID PBS ca software Administration 41 PBS archive add on CISU for SAP IS U CCS Administration 42 5 Transactions of the PBS archive add on CISU 5 1 Tabular Overview The transactions of the PBS archive add on are explained in detail in manual part C User manual This chapter only provides a general overview Transactions Description ral 6c Display Installation PBS EA55 Display rate category PBS EA22B Enhanceddisplay billing documents 22222 PBS EC E DispayMoveln2. CISU Secondary indices CISU PBS ca software PBS archive add CISU for SAP IS U CCS Administration 22 Archiving session 000668 Number of objects 27 PBS EISU HEAD Header structure of secondary indi PBS CISU LAUF Table af runs PBS archive add LOG Log table structure for CISU IPBS CISU 223 704 Secondary indices CISU Constr PBS archive add on CISU successfully completed 099618 PBS CISU Deleted 1 Entries in RUN read 1 Entries in ADMI RUM deleted ADMI FILES 888818 BB88618 881 PBS CISU Deleted usr sap SU4 8YS global RBC11238 171854 DIAMANTIDI Deleted 1 Entries in amp DMI FILES read 1 Entries in ADMI RUM deleted 1 Files deleted Table PBS LGCISUFILE 22B Entries for run 000618 removed Archiv 000669 deaktiviert ADMIFILES 00669 gadgess dggT PBS CISU 18 01 2006 09 42 45 ARCH IDX 1004000101 0000003634 008001 ARCH IDX 10040001010000004634 008001 ARCH IDX 1OG40081 810800005834 000001 ARCH IDX 1 g4gdg81818800885534 000001 ARCH IDX 100409001010000007634 000901 000001 000091 001150 PRDO CL 000618 23 11 2805 DIBMAMTIDIS 098001 0900133 98115 _ 000618 23 11 2005 DIBMAMTIDIS 098001 000223 98115 _ 000618 23 11 2005 DIAMANTIOIS 098001 HdBdg225 HgBTISU PRDDO CL 000618 23 11 2005 DIABMAMTIDIS 058001 000240 98115 _ 000618 23 11 2005 DIBMAMTIDIS 098001 HBHgBg244 HEBTISU PRDDO CL 000618 23 11 2005 D
3. Archiving object of archiving object PBS ca software PBS archive add CISU for SAP IS U CCS Administration 13 Long term indices 27 aterm indices i E B Fi Diagram 3 Administration Board Long term indices additional fields Comment Descriptive text for the archive is defined in the tables PBS CISU RUN and Admi Run Batch with a checkmark archive can only be processed with a back ground job without a checkmark online processing is possible User group Only the user group defined here is allowed to process the ar chive Maintenance table of user groups PBS CFICA USER You can also access the maintenance table for the user group via the icon PBS ca software 14 PBS archive add CISU for SAP IS U CCS Administration 3 1 The Load Program PBS Main Archive Setup CAR fe Qe Administration Board CISU 6 Main indices amp E ER gt E es ei e Main indices Lg term indices Index createdon User status PBS status Oldest archive file Recent archive file Archiving object 7 88712 18 04 2006 DIAMANTDIS 1804 2006 DUMANTDE OOQ Main index active Main index active OOQ Complete Complete aR Bs Ev Generation program CISU ISU_PRDOCL 81 84 2886 81 84 2888
4. vil m Archiving tool Index Overview 5 U index archive data Test program Single access Test pragram Interval Advanced archiving software for SAP solutions You can enter index number key from which the index starts and the number to be displayed eae numb Test interval selection 10881 Diagram 27 Test Interval Selection PBS ca software 5 archive add CISU for SAP IS U CCS Administration 38 If Read documents is not selected an overview is displayed Diagram 28 Overview of Indices System Help e ul rr im ct If Read documents is selected you branch to a detailed view from which you reach the detailed display of the tables individual field display using forward navi gation software PBS archive add CISU for SAP IS U CCS Administration 39 16 6 SAB He Test interval selection e Test interval selection 1 10001 ERCH BELNR 881800888001 000000000000 10000100000009120000110000851582010009281776000001 4812002051120030506200305252003051 02003 10090010000000010010100000000002003061520030615 0000000000000000 X X DBERCHY 100001000000001 1 200205112003050600000000000000000021E6 0 KWH E6 U
5. software
6. PBS CISU TSRD ABL 1 BN Interval access Index Settlement document numbers Access to settlement document headers PBS CISU TSRD ABH E BN Single access Index Settlement document numbers PBS CISU TSRD 1 BN Interval access Index Settlement document numbers PBS CISU TSRD ABH E GP Single access Index Business partner PBS CISU TSRD GP Interval access Index Business partner PBS CISU TSRD ABH E VK Single access Index Contract accounts PBS CISU TSRD ABH I VK Interval access Index Contract accounts PBS CISU TSRD ABH E V Single access Index Contracts PBS CISU TSRD I V Interval access Index Contracts PBS CISU TSRD ABH E ED Single access Index Creation date PBS CISU TSRD ED Interval access Index Creation date Access to budget billing plans PBS CISU TSRD AP E AN Single access Index Budget billing plan numbers PBS CISU TSRD AP AN Interval access Index Budget billing plan numbers PBS CISU TSRD AP E GP Single access Index Business partner PBS CISU TSRD AP I GP Interval access Index Business partner PBS CISU TSRD AP E VK Single access Index Contract accounts PBS CISU TSRD AP I VK Interval access Index Contract accounts PBS CISU TSRD AP E V Single access Index Contracts PBS CISU TSRD AP 1 V Interval access Index Contracts E PBS ca software PBS archive add CISU for SAP IS U CCS Administration 45 Single access print documents via print docum
7. Run Document select Process all documents Process sequential number range from m 9 999 999 Merge with archive new archive Pastpracess prag The following pracs are started automatically Create management indices Diagram 4 PBS software 00745 16 042006 DIAMANTIDIS Q Complete 60 Main mdexacive 342246 08122008 80 PROFV 0743 804 2006 DANANTIDIS 600 Complete 000 Wainindexacive 06012005 2907246 0701205 2007205 euez 737 18 04 2006 DANANTIDIS 600 Complete 000 Mainindexacive 01022000 03206 _ PBS archive add CISU for SAP IS U CCS Administration 15 v aH eoe mme mm on Index Construction IS Industry Solutions gt 150 PR FV 15 0 Archiving EDM Profile Values D ISU_PROOCL 15 0 Archiving Print Document Line Item D ISU_PRDOCH IS U Archiving Print Docmt Header D 00o ISU_BILLZ 15 U Archiving Billing line item gt ISU_BILL 15 0 archiving billing document header gt ISL EP 15 0 Archiving Budget Billing Plan Diagram 5 Select archive nmm m Generation program CISU ISU_PRDOCL Archive 81 88 2885 01 01 1900 PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 16 Here you can select the archiving runs of the SAP archiving object 50 PRDOCL that have been created i
8. 15 0 Archiving EDM Profile Values EEE E E HE PBS ca software PBS archive add CISU for SAP IS U CCS The system displays detailed information on the selected ADK files You can dis play details on the document by double clicking on the table Goto system Help eae anan Read ADK File 20 Read ADK File rchiweKey 000625 00115U_PROFVY 10011000000000000000F EPR FVAL 30 EPR FVAL EPR FVAL 30 30 30 EPR F AL 30 30 30 EPR FVAL EPR FVALSTAT EPR FVERSHEAD EPR FVERSHEAD 18811888080808gBBEOEEHHO 20021221 20041 1881188808080808gBBEOEEHG 200401 PERERA RS 180110000000000000007 2 10 11 0 00 0000 0000 072 4 10444 4 4 180110000000000000007 204
9. 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 CISU as easy as possible At first data archiving with transaction SARA is discussed the second topic is the construction of the PBS ar chive add on CISU from the SAP archive files The modular user manual of each PBS archive add on is composed of partial manuals Part A Installation Part B Administration Archive Construction and Maintenance Part C Application Programs Transactions 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 CISU discussed in this manual runs with the basis pro grams of SAP AG D 69190 Walldorf Baden IS U CCS releases 4 64 PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 7 2 Overview of the PBS archive add on CISU 2 1 Nomenclature
10. tables 0 Diagram 15 Indices of the Archiving Object Billing Document Headers ISU BILL PBS ca software 28 PBS archive add on CISU for SAP IS U CCS Administration PBS archive add on CISU for SAP IS U CCS Administration 29 The index in the left column indicates the highest index of this group In our example these are the billing document numbers You can display the list of all the indices in this group by clicking on the entries eoe nam E Display contents PBS archive add on CISU Cn CH Am 63 SN tus oma Ch c3 3 Diagram 16 List of Document Numbers Click on an index to reach the next display level Here the system displays a list of all the tables that contain information on the index E 1H HA Gm Display contents PBS archive add on CISU i Table Table short contents 100001 2 17432 1 2 1 1 amp 8mgg1adgagggg2umumgttog1tdumumgggdmdt7280838515268H838515 100001000000020 1 200301012003051280000000000880090021 ETAXERCH 100001 000000020EXTR_ARCH 2003 12 20030615 Number af tables 4 Diagram 17 List of Tables PBS ca software PBS archive add CISU for SAP IS U CCS Administration 30 Now select one of the tables by doub
11. 10000000226 Contract Account Document Number BEEBE Billing line item for billing documents UMWLFONR 000002 01 Consecutive number of conversion INCLUDE 01 Consecutive number of conversion UMW ART P 000031 10 6760664000000 Conversion Factor UMWGRUND C BEBBET 5 Conversion reason MASS 000003 KWH Unit af Measurement v UMWMEMBGE P 000017 2 959 Places hefare decimal paint in conversion quantity P 000014 B td ddBddBgdBgdBgBBOES Places after decimal point in conversion quantity PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 47 Interval Access of Print Documents Via Business Partner Report PBS CISU TSRD DBH GP BHR FH om interval access Business partner Diagram 35 Interval Access of Print Document Numbers Business Partners Enter business partner number from to to display a list of all archived print docu ments for this business partner in the respective tables PBS a software PBS archive add CISU for SAP IS U CCS Administration 48 e eoe anna Eom Interval access Business partner Diagram 36 Table View You can navigate to the detailed display by double clicking on the entry PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 49 List Edit Goto SHS El ee Table ERDO M
12. ANDT 090003 1010 Client 000012 10000007929 Number of print document 000004 09001 Consecutive number of outsorting INCLUDE 0000 0001 Consecutive number of outsorting VALIDAT 000010 Name af invoicing validation MANDUTS 000009 45 Reason for manual autsorting in invoicing FREI D 000009 00 00 0000 Document Release Date FRET VON D 000012 Name of user who released the document DEVIATION P 000015 b DD Deviatian SIMULATION 000002 Indicator billing simulation OUTCOUNT M 000002 99 Number af manual outsortings to be carried out yet 000081 Documents outsorted in invoicing OUT SORT x Documents utsarted in Bill Printing RELEASE 000001 Background release of document Diagram 37 Detailed Display 6 2 PBS Conversion Tool If you use own reports which also access archived data PBS has developed a util ity called the Conversion Tool This tool searches for the select commands in an ABAP 4 program and adapts them for the archive accesses using PBS function modules You can find more information in the manual on the Conversion Tool 6 3 PBS Archive Browser The transaction PBS SE16 is available in the Archive Browser Like in the stan dard transaction SE16 you can display any table however the PBS transaction also reads the archived data in these tables You can find more information in the manual on the Archive Browser PBS ca
13. B 6 E6 ERCH BELNR O aa 10000100000000220000110001 06104201001091555600001 78322002051120030506200305252003051 02003 10090010000000020010100000000012003061520030615 0000000000000000 X X DBERCHY 100001000000002 1 200205112003050600000000000000000021E6 0 KWH E6 UB 6 ESR ZEAE Fa Ee ne 7 188001000000003209001100882203720100892511880080012792082051128030588208305252003851082883 888018908000080300101000000008022003061520030515 0000000000000000 X X DBERCHY 108801008000003 1 200205112003050600000000000000000021E6 0 KWH EG UB LN E6 MAUI ERDHSHEUNR ac 188801000000004280001118008086965201008894282780080028582082051128038512288305252003851082883 1000010000000040010100000000032003061520030615 0000000000000000 X X DBERCHY 100001000000004 1 2009205112003051200000000000000000021 6 0 KWH EG UB LN EG Diagram 29 Overview of Tables PBS a software PBS archive add on CISU for SAP IS U CCS Administration 40 4 2 Reading the SAP Archiving Run The program PBS CISU reads the SAP archiving files Select Print tables to display all documents in all tables 14 aft Read ADK File Archive 81 12 2885 81 11 2885 Diagram 30 Selection Screen PBS CISU TADK Select one or more archiving runs
14. CISU area is combined in the archiving object PBS CISU and the complete CFICA area in the archiving ob ject PBS CFICA PBS ca software PBS archive add CISU for SAP IS U CCS Administration 25 3 2 Menu Edit ist Edit Check Generate System Help Move main index gt long term index Cti Shit F1 9 99 09 81 211 Admi Index Activation Ctrl Shift F5 D Deactivate index Ctrl Shift F6 Ma Delete index Ctrl Shift F PBS status Oldest archive file Recent archive file Archiving object 18 04 2006 IANANTIDIS 660 Complete 600 Main index active 88741 18 04 2006 DIAMANTIDIS 07 01 2005 07 02 2006 ISU BILL 88748 18 04 2006 DIAMANTIDIS Q Complete Main index active 07 01 2005 29 07 2005 ISU BILLZ 88737 18 04 2006 DIAMANTIDIS Q Complete Main index active 01 02 2005 09 03 2006 ISU BBP Diagram 13 You can activate and deactivate the PBS main and long term archives via the menu options Edit Index activation or Edit Deactivate index for the selected ar un zs This function can also be selected using the icons chive The display transactions and the programming interfaces read both data from the active main archive as well as from all active long term archives Main and long term archives can be activated or deactivated individually with the selection pa rameters by executing the transaction An explicit activation of an archive is only requir
15. IAMANTIOIS Diagram 11 Log of Archiving Run PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 23 Indices for run 000671 success constructed RUN without ADMI RUN ADMI RUN without CISU RUN Number of main or long term archives 090000 Error in ISU LAUF without ADMI RUN Consistency CISU LAUF and CISU RUM Consistency CISU RUM and CISU LAUF Number of entries archiving abject and DE Number of entries archiving abject and DB 00162 90162 Consistency GISU_LAUF archiving object and DB Consistency GISU_LAUF DB and archiving object Archive consistent Diagram 12 Log of Messages PBS ca software PBS archive add CISU for SAP IS U CCS Administration 24 Data Backup Data backup of the created files is recommended after each setup of the PBS ar chive add on but is not absolutely essential as the load program can be restarted Name of archive files and paths We recommend assigning path name and file name of the ADK files separately ac cording to the archiving object can be maintained using the transaction FILE A path name and a file name should be chosen for each archiving object in whose description the archiving object name is contained You should assign your own path name and your own file name for the PBS index files for the CISU and the CFICA part respectively Distribution according to the SAP archiving objects is not possible as the complete
16. In this manual we use the term Archiving completely in the SAP sense Processes controlled by SAP programs such as the checking of documents regarding their ar chivability the writing of these documents to sequential archive files and the re moving of the documents from the database are collectively called Archiving The archiving is controlled centrally by the SAP transaction SARA With the PBS archive add on CISU PBS now provides a program package which allows the user to access the SAP archive files in online operation as if they had never been archived Also in order to completely relieve the database from index data the documents on the SAP archive files are read by our load programs and transferred into the file system completely with all necessary index information This process is called Loading and Setup of the PBS archive add on CISU PBS ca software PBS archive add CISU for SAP IS U CCS Administration 8 2 2 Navigation The delivery of the PBS archive add on CISU contains range menus PBS PBS main menu of the PBS modules and PBS CISU From these menus you have to generate now roles which then can be integrated into the user master You can also create a role directly from the Easy Access menu gt 65 Otermenu amp Bh 7 w _ 8 Create role Diagram 1 SAP Easy Access Menu You are free to choose the name of the role the name can also be within the PBS naming area A PB
17. LLZ Billing document lines ISU BILL Billing document headers ISU BBP Budget billing plans ISU EABL Meter reading results ISU BCONT Business partner contacts ISU FACTS Installation facts ISU SETTLB Settlement documents ISU SWTDOC Switch documents ISU PROFV Profile values INV REMADV Bill Payment Advice Note INV TRANSF Transfer Table for Bill Data to ISU EORDER Waste disposal orders ISU ROUTE Display routes The SAP archiving program is executed in transaction SARA Standard archiving is not described in this manual The status of the archive files for the individual archiving runs can be determined in transaction SARA The deletion run of SAP archiving must be successfully exe cuted in order for documents to be displayed correctly and for the purposes of re porting via the PBS archive add on The archiving object PBS CISU which is managed in the standard SAP tables in the same way as all other SAP archiving objects is also delivered with the PBS ar chive add on CISU The PBS indices setup for all archiving objects that are considered by PBS is man aged in the tables ADMI RUN and ADMI FILES under the object name PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 10 PBS CISU For example a document number is defined in table ADMI FILES for each PBS indexing run of an archiving object The next free document number is determined from table ARCH NUM PBS Main Archive and Long Term Arch
18. MAN P 20051201 E P He HE dq BIB RSI ANZ DSN 0000 ANZ VON P 1 ARGHLIST 5 PRD CLUOOGB UOUbBB5 BB1ISU PRD LCL AUTOMAT P DOCUMENT P 000618 HANDLE r H_LIST 5 LOESCH LOESLIST 5 MANUELL FP amp NUR BEL P OBJECT P F_INDEX X F_NOINF X Ra vBART A X Diagram 20 PBS Load Log PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 32 Run Overview You can see information on the PBS indexing run jobs by selecting the radio button Run overview nme Display contents PBS archive add on CISU Diagram 21 PBS Run Overview The system displays a list of all runs for the selected index number G Display contents 5 archive add CISU Runs realized up to now 000944 0053150 BILL 25 11 2005 000001 00544 002150 BILL 23 11 2005 000001 000544 001150 BILL 25 11 2005 009004 000454 001150 BILL 23 11 2005 000001 00296 001150 BILL 23 11 2005 000001 Db 4 001150 BILL 23 11 2005 000001 00101 58 001150 BILL 23 11 2005 900061 000103 001ISU_BILL 23 11 2005 Diagram 22 PBS Run Overview PBS ca software PBS archive add CISU for SAP IS U CCS Administration 33 Index Overview PBS CISU INDEX SCAN The menu item ndex Overview offers an overview of all indices of the individual archiving objects You can also call
19. PBS software CISU PBS archive add on for IS U CCS Manual Part B Administration Compatible with S U CC S Release 4 64 S U CCS Release 4 72 S U CCS Release 6 0 April 2010 PBS archive add on CISU for SAP IS U CCS Administration 2 2006 PBS Software GmbH Schwanheimer Strasse 144a 64625 Bensheim Germany Phone 49 6251 1740 49 6251 174 174 eMail info pbs software com Internet www pbs software com PBS archive add ons is a registered trademark of PBS Softwareberatung Dipl Math Gunther Reichling Bensheim SAP R 3 R 2 ABAP 4 are registered trademarks of SAP AG Walldorf Baden Acrobat Reader is a registered trademark of Adobe Systems Incorporated PBS ca software PBS archive add CISU for SAP IS U CCS Administration 3 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 into practice the requirements that were described above for a stringent and success
20. PBS ECS7E jDispayMoveOut o Z Manu monit meter reading results PBS ESWIMONO Display switch documents J PBSINMON Bilreceipt monitoring Display Device Information Record Profile values PBS EEDMSETTLDISP Displaysettlement document 222 JPBS S IEO3 Display equipment 0 02 A PBSIS IQQ3 Display material serialnumber _ PBS EWAORDER Waste disposal orders 22222 Routes 22020 22222 EXP Extractorincomingbils PBS CISU EXAL PBS CISU EXAL Variable extractor meter rea docum PBS CISU EXKK PBS CISU EXKK Variable extractor contr account doc PBS ca software PBS archive add CISU for SAP IS U CCS Administration 43 6 PBS Utilities 6 1 Archive Access Tutorial In transaction PBS UTIL ACCESS ARC you can display and execute example programs of access to the PBS archive via the various indices sq B CO CHR mueossitsa Tutorial Access on archived data xv gt m 57 PBS archive add on for v Q IS UICCS CISU 52 Q Print document lines Index print doc number Print document header 7 Index print doc number E PBS archive add ons Index contract acc Index creation date Archive access tutorial Index posting date y Index billing document lines Index billing document num Index billing document header Index billing d
21. S range menu is then transferred by pressing the function key Transfer menus from range menus by indicating the corresponding PBS menu name During the transfer the system query for the resolution of the range menu is to be answered with yes The role group created this way can now be integrated in the corresponding user master We recommend to allocate global role PBS PBS to the administrators and the special function menu PBS CISU to the end users Reference user for additianal rights _ 2 Please see the current SAP standard documentation for more details on the tion of roles PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 9 2 3 Basic Information on the PBS archive add on CISU The administrative activity of PBS archive add ons is to set up and activate the PBS main and long term archive and to analyze them in the event of problems us ing the tools supplied The structure and usage of the PBS archive add on CISU always requires success ful data archiving with SAP tools and access to the archive data created using these From 4 0B this access can also be implemented via an optical archive sys tem with Archive Link The status of the archive file must always be set to acces sible The PBS archive add on CISU uses archiving runs of the archiving objects ISU PRDOCL Print document lines ISU PRDOCH Print document headers ISU BI
22. add on CISU is used the SAP archive info structures do not need to be filled First of all they occupy unnecessary disk space in the database and secondly the PBS software provides extensive functionality for the search and display of archived data so that it is not necessary to use the SAP standards in this case PBS ca software PBS archive add CISU for SAP IS U CCS Administration 11 3 CISU Administration Board Transaction PBS CISU ABO calls up the central PBS archive administration menu All PBS indices of the archiving objects included in CISU are managed here Main Indices Administration Board CISU 6 Main indices EH y 1 E CT q E n E Diagram 2 Administration Board Main indices Index Document number of PBS archiving run Created on Creation date of PBS archive PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 12 User Creator of PBS archive ADK status SAP status of archive PBS status PBS status of archive Meaning of the traffic lights colors for the PBS status green all archive files are indexed yellow archive files exist but not all indices are generated red no archive files available Oldest archive file date on which the first file of this archive was created Latest archive file date on which the latest file of this archive was created
23. 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 transactions The SAP user can display the data from the SAP database and the PBS ca software PBS archive add CISU for SAP IS U CCS Administration 4 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 disk storage can be tripled by performing data archiving Thus t
24. ed if you do not tick the checkbox Create management indices in the load run or you deactivate the archive in advance A table of contents is written in table PBS CISU FILE when a main or a long term archive is activated Access to archived data is only possible if this directory is set up Deactivation deletes entries from this table You can manage the access to main and long term archives with the menu options Edit Move main index long term index or Edit Move long term index main index PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 26 Move main index long term index During the load run only the main archive is ever updated If the generation pro gram runtimes are too long or if you intend to maintain the indices in different areas for example separately according to years you can convert the updated main ar chive into a long term archive using the menu option Edit Move main index gt long term index You reduce the merge runs of the main archive with this move A long term archive is characterized by the fact that it can no longer be changed Af ter having converted it a new main archive is started if the setup procedure is con tinued A main archive can also be converted into a long term archive using the Icon Move long term index gt main index Using the menu option Edit Move long term index gt main index you can recon vert each long term archive into a mai
25. ent number Report PBS CISU TSRD DBH E BN Sh SHH OD on om _ Single access Print document numbers PBS General Selection Non Aeversed Documents Documentnumber El n 8 Print document na Business partner Contract Account Posting date Reversal Dac Document simulated Mat released Collective bill acct Creation reason Official dac na 12db a 2 4 32a Maximum of hits Diagram 32 Single Access Print Document Numbers with PBS F4 Help Enter an archived print document number to display all tables in which this docu ment number exists PBS software PBS archive add CISU for SAP IS U CCS Administration 46 List Edit Goto System Help DHE nins Single access Print document numbers a Single access Print document numbers 100010000000226000005601 7 FERRE OK WHER RRR RARER RR E 10001 0000000226000000 PA A O AERP 1090071000000022600200070000065000000006 1000100000002 2600710007 000006490000000 A 1888188888B8g225 03 ddB B B55188BBBEBEBUFKEK CEGOEO 00000651 10001 000000022620030630200307162003071 6 2003063020030630 A xEUR Diagram 33 Table View Double click on a line to display details of the document in the table concerned List Edit Goto System Help 24145 eee 288 p 9 Table DBERDU Diagram 34 Detailed Display MANDT Bgagags 100 Client OPBEL 000012
26. ete index active Complete Main index active 00741 18 04 2006 DIAMANTIDIS G Complete Main index active 190748 18 04 2005 DIAMANTIDIS Complete index active _ 69737 18 04 2006 DIAMANTIDIS Complete Main index active Diagram 14 The Archiving tool offers information for each index number on Index list Job logs Run overview PBS ca software which described below Index List amp gam Display contents PBS archive add on CISU The index list for the index concerned appears here depending on the selected in dex number 10001 in this example m Display contents PBS archive add CISU Index Seq Mo Arch file OTTset 001000081 033 000001 000617 001 FBS CISU B B12 0010000020651 000001 Bdaagas1r agat PBS CISU M 532 0010000030896 000001 gadget agd1 PBS CISU 28 436 0091000011742 000001 00061 agd81 PBS CISU 39 502 001000027017 000081 000617 001 CISU 50 417 0010009033785 000001 00061 01 CISU 62 068 0010060049071 000001 000617 001 FBS CISU om 0010000635997 000001 000617 001 CISU 95 181 0010000822382 000001 00061 ag81 PBS CISU 9 11 0010001601911 000081 Bdaage1r agd81 PBS CISU 108 414 001000122362 000001 Hager 001 CISU 128 012 0091000129820 000001 00061 01 CISU 131 720 05000000005 000001 HOGG agat PBS CISU 143 185 Total no index
27. ful ILM concept PBS is considered as an expert for complex integrated data ac cesses 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 Bl 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 quickly and easily access your archived data even after data archiving during your day to
28. ime is saved for the data backup PBS ca software PBS archive add CISU for SAP IS U CCS Table of Contents 1 Introduction 2 Overview of the PBS archive add on CISU 2 1 Nomenclature 2 2 Navigation 2 9 Basic Information on the PBS archive add on CISU PBS Main Archive and Long Term Archive SAP Archive Info Structures 3 CISU Administration Board 3 1 The Load Program PBS Main Archive Setup First PBS Load Run Data Backup Name of archive files and paths 3 2 Menu Edit 4 Archive Utilities 4 1 Reading the PBS Archive Archiving Tool PBS CISU SCAN Index Overview PBS CISU INDEX SCAN Test Program Single Access PBS CISU TSEL Test Program Interval PBS CISU TSRD 4 2 Reading the SAP Archiving Run 5 Transactions of the PBS archive add on CISU 5 1 Tabular Overview 6 PBS Utilities 6 1 Archive Access Tutorial 6 2 PBS Conversion Tool 6 3 PBS Archive Browser PBS ca software Administration OO ON N OD 11 14 19 24 24 25 27 27 27 33 35 37 40 42 42 43 43 49 49 5 PBS archive add on CISU for SAP IS U CCS Administration 1 Introduction The PBS archive add ons are constructed in modular form and cover the applica tion modules Fl SD MM CO CISU etc with a special program package for ex actly this application You can easily see from the name which PBS archive add on belongs to which SAP module CFI CISU CSD CMM CCO etc All PBS archive add
29. istration 20 Further log information includes selections and time statistics see Diagram 8 ta ble statistics Diagram 9 archive file Diagram 10 archiving run Diagram 11 and messages Diagram 12 Delimitatians ABAR_AUT P 19000101 ABAR_MAN P 20051201 ALL_BEL P 5 zie 117 AN DSN P 0000 AN VON P 1 ARGHLIST 5 PRD LLHHEHBBrZHEB5 HWETISU PRB LCL AUTOMAT P DOCUMENT P 000618 HANDLE P D H_LIST LOESLIST 5 MANUELL P amp MIR BEL P OBJECT P_INDEX P 3 P_NOINP P 3 R3 VBART P X MRG Ee X MEM Time statistic start af processing 8 42 42 Start af sorting 18 42 44 End of sorting 18 42 44 End af processing 09 43 54 Diagram 8 Log of Selections and Time Statistics PBS ca software PBS archive add CISU for SAP IS U CCS Table statistics Administration 21 Wo objects read ju Mo objects processed 38 Table records read DBERDL 14 DBERDLE 24 Index written read IndexTab 40001 DBERDBZ PBEL 273 rad fea FAS 24 Statistics of archived objects Diagram 9 Log of Table Statistics Archive Tile Number of objects 22 Size in 2348 Number PBS CISU HEAD FBS CISU LAUF 48 PBS LCISU 06 FBS CISU SEKI 288 223 rog Diagram 10 Log of Archive File Description Header structure af secondary indi Table of runs PBS archive add C Log table structure
30. ive The generated SAP archiving runs are read and filed in the file system of the appli cation server for the purposes of efficient access to secondary indices via the PBS load program PBS CISU LOAD These secondary indices refer to the archived SAP files Table PBS CISU INDEX contains the data on which indices are set up from which tables The indices form the main PBS archive and can be transferred if necessary to the long term archive split by fiscal year for example The runtimes of the new load runs are reduced by storing the indices in the long term archive as the time required for merging the indices depends on the quantity of indices al ready in the main archive The long term archive can also be stored on other me dia such as tape The disk space that is required on a permanent basis is thus re duced The indices of newly archived data is merged with the indices in the main archive by the CISU load program and new and old indices are thus sorted consistently again The indices in the long term archive remain unaffected by this SAP Archive Info Structures The SAP archive information system AS is used for retrieval in the data archives Search and display is carried out using archive information structures some of which are delivered as standard by SAP but which can also be defined by users and filled with archive data The archive info structures are filled in the deletion phase of the archiving process If the PBS archive
31. le Access or in 5 8 program PBS CISU TSEL Utilities Archiving tool Index Overview Gener Test pragram Single access Test program Interval _ SU index archive data Advanced archiving software for SAP solutions You can enter the index number and the key You can select the relevant tables of the archiving object by pressing the button Proposal PBS a software PBS archive add CISU for SAP IS U CCS Administration 36 Diagram 24 Test Individual Selection n pmo oS Lm rjv Diagram 25 Tables of the Archiving Object Billing Document Headers The system displays an overview of all tables in which this index is stored Z IH eoe OAR ma OF Test single selection Test single selection 1 DBERCHV 100001000000001 1 200205112003050600000000000000000021 KWH ERCHC 1000010000000010010100000000002003061520030615 000000000000 Diagram 26 Tables of the Archiving Object Billing Document Headers PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 37 Here too you can forward navigate to the detailed display of the index in the re spective table Test Program Interval PBS CISU TSRD This transaction offers interval access to indices and can be called via the menu item Utilities Test Program Interval or in SE38 program PBS CISU Utilities
32. le clicking on it to reach the last display level which is the detailed view of the index with all the field information Job Logs You can see information on the PBS index runs by selecting the radio button Job logs SAH anaes Display contents PBS archive add on CISU D Diagram 18 Job Logs per Index Number The system first displays an overview of all PBS indexing runs Diagram 19 PBS Indexing Runs CAR suus EB Display contents PBS archive add on CISU e Index Seg 0 Arch file Offset 000001 000001 00617 02001 CISU 899 412 Total no index tables Double click on the run number to see load log with information on the selected PBS a software PBS archive add CISU for SAP IS U CCS Administration 31 SAP archive files selections for the load run a time statistic and the tables and in dices concerned Bm Display contents PBS archive add CISU 3 c x3 er Loading 10g for rur 000002 This is run number Objects for selection screen 1000 BIBSIEIET ISU_PRDOCL selected for deletion selected archive files 20151 PRD CLEBBBB5 OBHS5B H d811ISU L ESCH ON DSN 0000 AUT 19000161 AUTOMAT ABAR_MAN 20051201 MANUELL X LL BEL X BEL VON 1 BIS 9999999 _MR5 if DOCUMENT 000618 X Delimitatians ABAR_AUT P 19000101 ABAR_
33. n archive and thus include it again in the merge runs also possible via the icon Delete index You can completely delete main and long term indices using the menu option Edit Delete index which means that all dependent table contents and physical files are deleted Active indices must be deactivated first before they can be deleted Delet ing PBS indices should be used less frequently as the reconstruction of the PBS indices requires a very long time for large archive volumes This function can also be called up using the icon PBS ca software PBS archive add on CISU for SAP IS U CCS Administration 27 4 Archive Utilities 4 1 Reading the PBS Archive Archiving Tool PBS CISU_SCAN The Archiving tool which you can call up via menu Check Archivtool or in transac tion PBS CISU_SCAN or via program PBS CISU_SCAN shows the contents of the PBS archive add on CISU in a technical view In addition the system also dis plays further information on archive setup This functionality you can also reach using the icon e List Edit Check Generate System Help ivl Log Ctrl F 4 _ Archiving tool Administ 3 95 43 23 A ain indices ap Single access Index Overview Mo J Range access Cirl F g Main indi s Index createdon User ADK status PBS status Complete index active Compl
34. n transaction SARA which you can use to create the indi ces of the PBS archive add on CISU for the print document lines All the respective SAP archiving runs that have been created since the date entered are displayed Diagram 6 Archiving Runs of the Archiving Object ISU PRDOCL Archive Management Choose Files to Read opcs 15 0 Archiving Print Document Line Item 18 01 2006 Now select those SAP archiving runs that you want to load into your PBS archive The system checks whether this run has already been loaded and issues an error message if applicable Load automatically from Select this parameter if you want to archive all billing document headers from a particular point in time without making an individual selection of billing document header archives If these include SAP archives that you have archived in a previ ous run they are not accepted into the PBS archive again The parameter Max number phys files indicates the maximum number of SAP ADK files that should be processed This function is used to automate the load runs and can be scheduled as a back ground job using a selection variant Delete old run If you have already executed several load runs and want to delete one or more of these you can display a list of the load runs that have been executed to date by selecting the button Run You can now mark specific load runs and delete them The IS U archives to be deleted are then di
35. oad runs need to be executed and you do not wish to access the archive during this time PBS ca software PBS archive add on CISU for SAP IS U CCS First PBS Load Run Administration Once you have made all the required entries in the selection screen of the load re port PBS CISU LOAD the selection screen can be saved as a selection variant and started as a background process The PBS archive add on CISU needs to be set up for each client Parallel operation of the load program is not permitted and is technically prevented After successful execution the program PBS CISU LOAD displays the following log Edit Goto System Help eoe nmm er Generation program CISU This is run number 000002 OBJECT selected for selected SAP LOESCH ON DSN ABAR ALT AUTOMAT ABAR Delimitatians ABAR_AUT P ABAR_MAN MeL mel F ANZ BIS ANZ DSN ANZ VON ARCHLIST 5 AUTOMAT DOCUMENT HANDLE H_LIST 5 LOESCH F LOESLIST 5 MANUELL F MUR_BEL F OBJECT P P_INDEA ISU_PROOCL deletion archive Tiles 8150 _ 000667000667 001 1SU_PRDOCL 19000101 20051201 X X 1 9999999 X 080615 X 1800011 20051281 X 9999999 1 ISU _PRDDLDLBDDBB7ZB DDBB7 001150 PRDO LL 00061 8 X TSU_PROOCL X Diagram 7 Log of Load Program PBS CISU LOAD PBS ca software 19 PBS archive add on CISU for SAP IS U CCS Admin
36. ocument num Index business part Index contract acc Index contr Index creation date Index budget billing pl Index bud bill pl num Index business part Index contract acc Index contr 52 Q Contract account CFICA SOFTWARE gt Q documents Fl MKKDOC 4 Diagram 31 Menu Tree Structure Archive Access PBS ca software PBS archive add CISU for SAP IS U GC5 1 Administration 44 The individual reports Access to print document lines PBS CISU TSRD DBL E BN Single access Index Print document numbers PBS CISU TSRD DBL 1 BN Interval access Index Print document numbers Access to print document headers PBS CISU TSRD DBH E BN Single access Index Print document numbers PBS CISU TSRD DBH 1 BN Interval access Index Print document numbers PBS CISU TSRD DBH E Single access Index Business partner PBS CISU TSRD DBH 1 GP Interval access Index Business partner PBS CISU TSRD DBH E VK Single access Index Contract accounts PBS CISU TSRD DBH 1 VK Interval access Index Contract accounts PBS CISU TSRD DBH E ED Single access Index Creation date PBS CISU TSRD DBH 1 ED Interval access Index Creation date PBS CISU TSRD DBH E BD Single access Index Posting date PBS CISU TSRD DBH 1 BD Interval access Index Posting date Access to settlement document lines PBS CISU TSRD ABL E BN Single access Index Settlement document numbers
37. or SAP IS U CCS Administration 18 The block Merge is used only to provide information on the merge process Merge with archive If you select this button the new archive is merged with the existing archive e Merge with archive new archive Postpracess prag The following pracs are started automatically Create management indices New archive If however you wish to create a new archive that must not be merged with the ex isting archive select the option new archive Before the program runs the first time the button new archive is selected In the following runs the newly written index is merged with the existing index The button Merge with archive is selected and the document number of the ADK file of the archiving object for the merge process is shown If you select the parameter Create management indices in the block Postproc ess prog the management entries are automatically written to table PBS CISU_FILE This function should always be active as the archive data for the created indices is immediately accessible when the management table is automati cally updated after the index generation program has terminated If the parameter is not selected the management table has to be manually updated after the indexing run by executing report PBS CISU FILE transaction PBS CISU FILE option Activate main archive This variant of indexing can be advantageous for the runtime if several l
38. splayed You can remove complete SAP archiving runs from the PBS archive add on using this method Document select amp Process all dacuments A Process sequential number range 9 999 999 Process all documents from receipt PBS ca software PBS archive add CISU for SAP IS U CCS Administration 17 In general the switch Process all documents should be activated This ensures that all documents that are contained in the SAP archiving run arrive in the PBS ar chive add on Process sequential number range from 1 to 9 999 999 If the Paging area in the system profile for sorting the indices is set too low it might be advisable to execute several runs with a limited number of documents instead of processing all the documents at the same time In this case select the second op tion Process sequential number range and enter the documents you wish to proc ess in the following two fields If for example you want to process 100 000 docu ments per run enter 1 to 100 000 in the first run and enter 100 001 to 200 000 in the second run Before using this method you should first attempt to load the com plete SAP archiving run by increasing the paging area Caution You can switch off automatic recognition by the program to check whether a selected SAP archive has already been processed using the inter val selection Interval overlaps are not checked either PBS ca software PBS archive add on CISU f
39. up this overview in transaction PBS CISU_INDEX_SCAN or in SE38 program PBS CISU_INDEX_SCAN Utilities Acn CHB meos Index Overview z 5U index archive data Test program Single access Test program Interval Advanced archiving software for SAP solutions All the archiving objects adapted by PBS together with their indices are displayed sorted by index number PBS a software PBS archive add CISU for SAP IS U CCS Administration 34 Edit Goto Sy Eg Bee IDE R Index Overview CE EN 10001 ISU_BILL ERCH BELNR 10002 ISU_BILL ERCH YERTRAG 10003 ISU_BILL ERCH GPARTNER 10004 ISU_BILL 10005 ISU_BILL ERCH ERDAT 10006 ISU_BILL ERLH BELHR 11001 ISU_BILL ERCHC OFEEL 20001 ISU_BILLZ DBERLEH BELME ISU ERDR OPBEL 30003 ISU PRDUCH ERDK PARTNER 4 ISU PRDO CH ERDK VEDNMT 30005 ISU PRD CH ERDK ERDAT ISU PRDO CH ERDK BUDAT 31001 150 ERDB INV PBEL 40001 ISU_PROOCL DBERDZ PBEL Diagram 23 PBS Index Overview PBS ca software PBS archive add CISU for SAP IS U CCS Administration 35 Navigate forwards to call up the detailed display of the selected index Test Program Single Access PBS CISU TSEL This transaction offers direct single access to indices and can be called up via the menu item Utilities Test Program Sing
Download Pdf Manuals
Related Search