Home

ViewPoint for SAP Modules Utilities Version 2.1 User Manual

1. Table name Description KNBK Customer master bank data KNB1 Customer master company code KNB4 Behavior in payment KNB5 Dunning data KNKK Credit control area KNC1 Customers monthly debits and credits KNC3 Customers special general ledger monthly debits and credits Vendors Table name Description LFA1 Vendor master general LFAS EC taxes LFB1 Vendor master company code LFBK Vendor master bank data LFB5 Dunning data LFC1 Vendor monthly debits and credits LFC3 Vendor special general ledger monthly debits and credits G L accounts Table name Description SKA1 G L account master general SKB1 G L account master company code SKAT G L account master name GLTO G L accounts monthly debits and credits EMC ViewPoint for SAP Modules Utilities User Manual cal Year Reporter Table 13 Miscellaneous Table name Description T001 Company code table Atthe end of the backup process a detailed selection statistic is displayed as shown in Figure 39 3H 688 CAB ATOAN Backup masterdata ae Backup masterdata 1 Selection statistic from 24 11 1999 Amount vendor records general 95 Amount records vendor EU tax ref no o Amount records vendor bank data 76 Amount vendor records Company code 95 Amount records vendor Dunning data 4 Amount vendor records transaction fig 94 Amount records spec gen led vendor 3 Amount
2. tetee 16 Starting Archive Browser 18 Displaying Archiver Browser accessible tables 20 Selecttie tables nee 21 Database table PBS TAB_ARCHDEF 4 mme 26 Preselected tables intei un essen 27 Conversion Tool OVERVIEW ioc nseocatiraDi tecaebssasheseassaaciedeesiiads senti a pa i iai aD 32 Running the Conversion Tool sss 33 Starting the conversion 33 Editing conversion 37 Display Source and Target program sss 39 Customizing definitions sess 40 Special features em E 41 Client specified terere t metere ernst tens 41 Package SIZE Tucci ien dne test st tede cedes 41 EMC ViewPoint for SAP Modules Utilities User Manual Chapter 4 Chapter 5 Chapter 6 Chapter 7 UP ton TOWS 41 Group Dye en deese tides uei de 41 Aggregate functions 41 Like wise 41 Diener msn 41 Delete Adjacent Duplicated from iTAB 41 Bypassing Buffers eirese esse 41 DY OUI i nn sagt eet eerta de dessein mets ente ene 42 Transfer of key values or select options sss 42 Sample programs 43 Archive access tutorial SAP version 4 6c sss 44 Translation Tool Overvle Won NEM res 46 nc 46 Running the Translation Too 47 Check ADK OverviewW EEE siiis te
3. Transfer files to PC When extract stock is creation is complete files can be transferred from the UNIX or Windows NT server to a PC using ASCII mode ftp bin Using PC analysis Extract stocks can be processed by indicating a file format in an programs analysis program such as IEDA as shown in Figure 46 Bitte w hlen Sie eine Datei aus CActi_z 3 document_items ae Bitte wahlen Sie die gew nschte Vorgehensweise C Neue Dateien und Standard PC Formate Ye C Bestehende Datensatzbeschreibung auswahlen andern 5 CAProgramme IDEA Samples ve C Druckdatei importieren C ODBC Zugriff nutzen Figure 46 File format definition using IDEA Use a PC analysis program to check the extracted data factual consistency as shown in Figure 47 CL COCD DoC NO YEAR ITM PSTG_DA A G_L_ACCT ACCOUNT SHORT CURR_ AMOUNT ASSIGNMENT A 105 i00 1000 1400000152 2000 1 2000 05 31 0000113109 DteBk customer p DEM 0000008338479 108 i00 1000 1400000152 2000 2 2000 05 31 D 0000140000 Amadeus DEM 14000001522000 A07 100 1000 1400000153 2000 1 2000 05 31 S 0000113109 DteBk customer p DEM 0000002351552 108 i00 1000 1400000153 2000 2 2000 05 31 D 0000140000 COMPU Tech AG DEM 14000001532000 109 100 1000 1400000154 2000 1 2000 05 31 S 0000113109 DteBk customer p DEM 0000035368264 WO i00 1000 1400000154 2000 2 2000 05 31 D 0000140000 HTG Komponente DEM 14000001542000 Mi joo 1000 1400000155 2000
4. Analyzer Plus For example in an ORACLE database system the ABAP PBS ANA_ORACLE starts as shown in Figure 64 BOGE amm annon 708 PBS DB Analyzer Constr capacity run for oracie Figure 64 Selection mask for Oracle capacity construction 2 Enter information for the following fields Description capacity run Descriptive title for the analysis run Use analysis from SAPDBA Option for Oracle database system Details can be found in Oracle database on page 108 Create new analysis Option for Oracle database system Details can be found in Oracle database on page 108 Detailed analysis of CO records Carries out an exact analysis of the CO records when allocating CO tables such as COEP and COSS to the corresponding archiving objects Requires a long run time Not needed with archiving object CO_ITEM If unselected the corresponding CO tables are distributed to the archiving objects CO_COSTCTR and CO_ORDER Secured run Ina production system prevents an ABAP from getting into an endless loop when a SELECT COUNT command to a cluster table CDCLS is carried out The database tables for the document changes CDHDR and CDPOS are not split and appear in the evaluation with the size 0 If unselected after several hours the ABAP will eventually cancel with the error message SQL error 1555 at access Single table analysis Activates the analysis of si
5. Red displays when there is no access to the ViewPoint for SAP Qoo module Yellow displays when trying to access the ViewPoint for SAP archive eoe with an unsupported key field Green display when there is optimal access to the ViewPoint for SAP DOG module Field 1 Field 2 Field 3 Field 4 Displays the name of the key field used to access the ViewPoint for SAP archive Definition of the function keys F2 compares the source and the target program F6 allows the manual editing of the conversion F11 saves the result of the conversion under the name of the target program Editing conversion Each conversion can be edited manually to change the ViewPoint for SAP module option Running the Conversion Tool Conversion Tool For the key fields 1 to 4 type the field name the from to values and select option as shown in Figure 20 VBELN VBAK VBELN VBAK VBELN VE eso a Figure 20 Process conversion Press F11 to save the changes In the table overview the Select line is now marked with the status Modified conversion The performance display is not changed Press Shift F7 to prevent the select line from being converted The status symbol No conversion appears EMC ViewPoint for SAP Modules Utilities User Manual Conversion Tool Display Source and The Source and the Target programs both have current line numbers Target program of the Select command as shown
6. Package Size n Up to n rows Group by Aggregate functions Like Distinct Delete Adjacent Duplicated from iTAB Bypassing Buffer Conversion Tool This section explains why Select statements have not been converted or whose conversion was partly wrong Access to ViewPoint for SAP modules always depends on the client Remove this clause The Conversion Tool is immediately cancelled with the error message Source program not checkfree or unknown SQL statement in line 40 Remove the clause Package size n and the corresponding ENDSELECT command from the source program Not supported target program is not checkfree Not supported target program is not checkfree Aggregate functions like MAX MIN SUM COUNT AVG are not supported The program is not checkfree because loop does not support the statement Like The Select clause Distinct is supported by the Conversion Tool by deleting from the created internal table all multiple entries with the instruction Ensure that the table is sorted and that duplicate deletion always relates to the internal table primary key Not considered Special features Conversion Tool Sy Subrc The correction of the system variables Sy SuBRC is only integrated into the target program in case of a SEL ECT INTO TABLE Transfer of key P If in the WHERE statement of the SELECT command a direct value va
7. EMC ViewPoint for SAP Modules Utilities Version 2 1 User Manual P N 300 002 934 REV A03 EMC Corporation Corporate Headquarters Hopkinton MA 01748 9103 1 508 435 1000 www EMC com Copyright 2006 EMC Corporation All rights reserved Published December 2006 EMC believes the information in this publication is accurate as of its publication date The information is subject to change without notice THE INFORMATION IN THIS PUBLICATION IS PROVIDED AS IS EMC CORPORATION MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE Use copying and distribution of any EMC software described in this publication requires an applicable software license For the most up to date listing of EMC product names see EMC Corporation Trademarks on EMC com All other trademarks used herein are the property of their respective owners EH EMC ViewPoint for SAP Modules Utilities User Manual Preface Chapter 1 Chapter 2 Chapter 3 TULERUNT 7 ViewPoint for SAP Ulilities OVERVIEW utentes iioc eatin Dire Er Cr ee nee anne 12 Installation utilities ss 12 Compliance and auditing utilities 13 Database growth monitoring utility 13 Archive Browser OVervieWizioicebseiehaosn reci re Dra Ecol PH abe b Pa a cria 16 Slc
8. EN EMC ViewPoint for SAP Modules Utilities User Manual Archive Browser Selecting a table shared by ViewPoint for SAP modules reveals other index possibilities For example only one index for table EIKP can be selected with the ViewPoint for SAP CSD module displaying table EIKP as shown in Figure 15 Too many table fields for selection max 40 Choose the table fields for the selection conditions Sales document Number of foreign trade Delivering country Mode fTrnsprt Border Customs office ffice fDestination Customs office 1 Customs office Customs office Customs office Customs office Customs office B Mns of trsp border Means of transport Origin MT Border a TIL VEOBAX Figure 15 Selection fields list for CSD table EIKP ewn Preselected tables E Archive Browser List of tables Place the cursor in the table name field and press F4 or click selection to view the tables that archived data is accessible The selection of available tables appears as shown in Figure 16 Heiprequest for PBS Archive Browser amp Helprequest for PBS Archive Browser Table selection PBS Archive Browser Table Description multiple A016 Contract Item X 4019 Contract Header X A068 Outline Agreement Item Plant Dependent X 4081 Contract Conditions at Plant Level x 1082 Contract Conditions without Plant x ADRC Addresses central address admin AFFL Work order sequence AFFLD Order
9. Note Transaction YEAM contains administrative functions that should be made available to administrative personnel only The fiscal year reporter menu displays using transaction YEAR or YEAM as shown in Figure 34 e a eoe ONE 5500 OH 95 PBS Fiscalyearreporter Start menu YEAR YEAM For SAP versions 4 6 and later create a user and administrator activity group integrating the range menus PBS YEAM and PBS YEAR SAP standard documentation contains more details on creating activity groups Enter the activity group in the user master record as shown in Figure 35 so 08 O68 CHS Annan EN 9 Maintain User E SES C3 Ax fer 08 Reference user for additional rights 29 115 05 2002 31 12 9999 Activity group user master record ES EMC ViewPoint for SAP Modules Utilities User Manual Extracting fiscal year closing transaction data Figure 36 ViewPoint for SAP FYR uses archiving object YY_YR_yyyy where yyyy is fiscal year to copy all transactions belonging to a fiscal year regardless of status e g open or cleared to an SAP ADK file The archiving object is generated during run time if it does not yet exist This allows the complete display of all the posting material for any time such as a balance audit trail Note The creation of an ADK archive stock with object YY_YR_yyyy is separate from the archiving process for the archiving object FI DOCUMNT YY_YR_yyyy does not archive or del
10. monitoring utility Analyzer Plus This section describes the ViewPoint for SAP utilities useful for compliance and auditing purposes Fiscal Year Reporter is supplied as a separate transport and is a utility that helps manage the numerous fiscal year tasks that have to be carried out in the area of financial accounting at years end Data Retention Tool CDART is supplied as a separate transport and is a utility that helps create datasets from active and archived data in SAP certified format for external auditing purposes This section describes the ViewPoint for SAP utility used to monitor database size and health Analyzer Plus is supplied as a separate transport and is a utility that analyses archiving tables capacity analyzes the distribution of documents and executes an archiving check Overview ViewPoint for SAP Utilities ViewPoint for SAP Utilities EN EMC ViewPoint for SAP Modules Utilities User Manual 2 Archive Browser This chapter covers the ViewPoint for SAP Archive Browser and includes these topics ES 4n tomm 16 e Stare Archive Browsen 18 Displaying Archiver Browser accessible tables 20 e Selecting tables 21 Database table PBS TAB ARCIHDEF erret 26 Preselected tablas ansehen 27 Archive Browser EN Archive Browser Overview Objects Table 1 The ViewPoint for SAP Archive Browser is the EMC counterpart of the
11. only errors allmessages Figure 30 Check ADK initial screen 3 Select Execute to confirm your selections 5 EMC ViewPoint for SAP Modules Utilities User Manual Check ADK A sample results screen appears as shown in Figure 31 PBS Tool for checking PBS index files and SAP ADK files List Edit Goto System Help le Jeieee sHmumanaalna PBS Tool for checking PBS index files and SAP ADK files Check of PBS CPR files via table ADMI_RUN 05 12 2002 15 28 12 KRUEGER 013248 001 PBS CPR OK usr sap E46 SVS global RPP12052 ARCHIUE 28 11 2002 11 23 14 KRUEGER 013231 001 PBS CPR OK usr sap E46 SVS global RPP11283 ARCHIUE 28 11 2002 11 22 28 KRUEGER 013230 001 PBS CPR OK usr sap E46 SYS global RPP11282 ARCHIVE 28 11 2002 11 22 06 KRUEGER 013229 001 PBS CPR OK usr sap E46 SYS global RPP11281 ARCHIVE 28 11 2002 11 21 37 KRUEGER 013228 001 PBS CPR OK usr sap E46 SYS global RPP11280 ARCHIVE 12 11 2002 11 28 02 KRUEGER 013190 001 PBS CPR OK usr sap E46 SYS global RPP11123 ARCHIVE 17 07 2002 15 33 21 KRUEGER 012827 001 PBS CPR OK usr sap E46 SYS global RPPO7171 ARCHIUE Check of PBS CPR files via PBS admin table 013248 001 PBS CPR 05 12 2002 15 28 12 KRUEGER OK usr sap E46 SYS global RPP12052 ARCHIVE Check of PBS CPR files via activated indices LAUFTAB 012826 001PR_ORDER 17 07 2002 15 30 21 KRUEGER OK usr sap E46 SYS global RPPO7170 ARCHIVE 013189 001PR ORDER 12 11 2002 11 26 55 KRUEGER OK
12. 1 2000 05 31 S 0000113109 DteBk customer p DEM 0000008532264 M2 i00 1000 1400000155 2000 2 2000 05 21 D 0000140000 SudaTechGmbH DEM 64 14000001552000 313 i00 1000 1400000156 2000 1 2000 05 31 S 0000113109 DteBk customer p DEM 0000005311840 M14 J100 1000 1400000156 2000 2 2000 05 31 D 0000140000 CBD Computer Ba DEM 1 2 1 2 1 2 1 2 1 2 14000001562000 2000 05 31 S 0000113108 DteBk customer p DEM 562 120 82 0000056212092 2000 05 31 D 0000140000 Christal Clear DEM 562 120 92 14000001572000 2000 05 31 S 0000113108 DteBk customer p DEM 1 026 751 96 0000102675196 I 115 100 1000 1400000157 2000 118 100 1000 1400000157 2000 11 100 1000 1400000158 2000 118 100 1000 1400000158 2000 118 100 1000 1400000137 1995 120 100 1000 1400000137 1985 121 100 1000 1400000138 1995 122 100 1000 1400000138 1985 2000 05 31 D 0000140000 Lampen Markt GmbH DEM 1 026 751 96 14000001582000 1895 06 25 S 0000113108 DteBk checks recv DEM 6 33 19950625 1995 06 25 D 0000140000 Buy amp Fly Superma DEM 6 33 14000001371995 1995 06 26 S 0000113108 DteBk checks recv DEM 57 50 19950626 1995 06 26 D 0000140000 Buy amp Fly Superma DEM 57 50 14000001381995 1995 07 01 S 0000113108 DteBk checks recv DEM 63 25 19850701 1885 07 01 D 0000140000 Buv amp Flv Superma DEM 63 25 14000001391995 123 100 1000 14
13. 21 Initialization Capacity analysis Table 21 lists the two ABAP 4 programs used to perform the capacity analysis of archiving objects Capacity analysis ABAP 4 programs ABAP 4 program Description PBS ANA_AUFBAU Starts the analysis and stores the results in the database table PBS ANA_AR_LFN Within the capacity run the disk space occupancy of the tables allocated to the archiving objects is determined PBS ANA_KAPAZITAET Evaluates and displays the results by archiving object Before starting the first capacity analysis the ViewPoint for SAP Database Analyzer Plus database tables must be reconstructed in the SAP R 3 system by starting the ABAP PBS ANA_ERSTAUFBAU by copying the entries of the database table PBS ANA_AR_DEF into the table PBS ANA_AR_OBJ and supplementing it with the table names of the SOL database ABAP PBS ANA_ERSTAUFBAU is also used to delete all existing analyses Before starting an analysis for an AS 400 database refer to AS 400 database on page 108 Use this procedure to run the capacity analysis 1 Start the ABAP PBS ANA_AUFBAU Note Run the ABAP PBS ANA AUFBAU as a background process checking the progress of the run with the protocol entries of the own jobs Depending on the database system ABAP PBS ANA AUFBAU starts a corresponding ABAP for the construction of the capacity analysis EMC ViewPoint for SAP Modules Utilities User Manual
14. 4 1 1 CO KSTRG Kostentr ger Stammdaten und Bewegungsdaten 12 201 1 1 1 1 CO CCTR EP Kostenstelle Einzelposten 11 042 1 0 1 0 PM EQUI Equipmentstammdaten 10 931 15 0 1 0 CO COPC Archivierung Erzeugniskalkulationsdaten 8 648 0 8 0 8 PP WKC Arbeitspl tze 5 947 0 5 0 5 MM EINA Einkaufsinfos tze 5 585 0 5 0 55 FI_ACCRECV Debitorenstammdaten 3 102 0 3 0 3 OM CONTROL Bewegungsdaten der Q Pr fung 2 450 0 2 0 2 FI MONTHLY Verkehrszahlen von Debitor Kreditor Sachkonten 2 106 0 2 0 2 CO BASEOBJ COPC Bauteil 1 814 0 2 0 2 PM ORDER PM Auftrag 1 488 0 1 0 1 PS PROJECT Projektsystem Operative Strukturen 871 0 1 0 1 FI ACCPAYB Kreditorstammdaten 828 0 1 0 1 PM_IFLOT Technischer Platz Stammdaten 696 0 1 0 1 PP_ORDER Technischer Platz Stammdaten 683 0 1 0 1 FI SCHECK Vornumerierte Schecks 545 0 1 0 1 MM REBEL Materialwirtschaft Rechnungsbelege 494 0 0 0 0 MM SPSTOCK MM Sonderbest nde 428 0 0 0 0 MM ASMD Leistungsstamm 405 0 0 0 0 OM OMEL Qualit tsmeldung 339 0 0 0 0 RL TA MM WM Lagerverwaltung Transportauftr ge 156 0 0 0 0 MC SELVS LIS Gespeicherte Selektionsversionen 142 0 0 0 0 OM CHARACT QM Stammpr fmerkmale 134 0 0 0 0 PR ORDER Proze auftrag 133 0 0 0 0 CO_ML_ML1 Periodens tze des Material Ledger CKML1 84 0 0 0 0 BC_ARCHIVE Archivierung der Archivadministrationsdaten 78 0 0 0 0 EXAMPLE Beispielobjekt 62 0 0 0 0 SD_VBKA Kontakte 39 0 0 0 0 FILENAME Beispielobjekt f r die Archivierung 32 0 0 0 0 FI_BANKS Bankstammdaten 29 0 0 0 0 RL_TB M
15. 4 5 generate the export structures using PBS FYR LIS GENERATE each time the database tables change The export selection screen for export programs consists of three parts Delimitations to influence the scope of selection Selection of list layouts Output option on page 77 Delimits the logical database selection for each report Contains all fields displayed from the selected data volume Defined with SAP ALV ABAP List Viewer within an export program and stored under an own name several list variants are possible per export program in order to meet different requirements as shown in Figure 43 List layout Item list Variant IPBS XARI R List layout selection screen Follow this procedure to create a list for an export program 1 Click Display Print to generate the desired report Keep the selected data volume small for performance reasons 2 Select Options gt Layout gt change to define the scope of the list 3 Select Options gt Layout gt store to store the list variant Note Select Options gt Layout gt Layout administration gt Layout gt Transport to transfer the list from a test system into the production system EMC ViewPoint for SAP Modules Utilities User Manual Fiscal Year Reporter Output option Use the selection screen to display the dataset as an ALV list or to transfer the list to an export directory as shown in Figure 44 Output option Disp
16. 86 Double click a document for additional document details __ nH eae BAR anos HA Gm Write Program Archiving of Purchasing Documents eu Write Program Archiving of Purchasing Documents verview check indicator Write Program Archiving of Purchasing Documents Purch ord OTyp Item ICat Last trans Key date Item ITye Last Trans Deadline Material ShrtText PROS AN ER GA EO ON ie TI Te S 10 Ar 10 1920 21 22 2324 25 26 4p 414 0100 NB 1000 C E B BERLIN 8601 03 01 2000 88818 21 83 2008 20 01 2003 500 120 Diaminobenzene 50 00020 21 03 2008 20 01 2003 500 138 Pyridin CDE 50 00030 21 03 2000 20 01 2003 500 140 Hydrochloric Acid 50 Figure 86 Purchasing document selection results The ABAP for purchase orders is PBS ANA_ARCHIVE_MM_EKKO Forecast ViewPoint for SAP Analyzer Plus analyzes five archiving objects For more information contact EMC support 128 EMC ViewPoint for SAP Modules Utilities User Manual Capacity analysis examples PBS DB ANALYZER PLATTENPLATZBELEGUNG VON ARCHIVOBJEKTEN Zeit Kapazit t Lauf Nr 0001 vom 19 02 1998 1 086 618 KB Kapazit tsanalyse IDES vor Archivierung Kapazit t der selektierten Daten 113 586 KB Anteil Selektion am Lauf 10 Objekt Objektbezeichnung Tabelle Tabellenname SD_VBAK Verkauf sbelege VBAP Verkaufsbeleg Positionsdaten CKIS Positionen Einzelkalkulation Einzelnachweis Erz KEKO Erzeugniskalkulation Kopf VBEP Verkaufsbeleg Einteilun
17. 994 6 093 9 782 13 54 DR 995 298 478 0 66 KA 995 51 82 0 TT WL 997 221 355 0 49 WL ee 3 354 5 385 7 46 ZP 994 21 34 0 05 ZP 995 96 154 0 21 ZP 996 117 188 0 26 ZP 997 74 119 0 16 ZP kara 308 494 0 68 ae 44 987 72 225 100 00 Figure 93 Posted documents by type example Document distribution analysis examples 135 Analyzer Plus The document volume of company codes in different clients appears 136 PBS DB ANALYZER VERTEILUNG BUCHHALTUNGSBELEGE as shown in Figure 94 Selection Entry year 1995 1996 Formation of Pool 1 Posting year 2 Posting period 3 Company code 01 1990 12 1998 1 644 Datum 23 Figure 94 Lauf 0001 Beleggr e Byte BELEGVERTEILUNG IDES MANDT BUKRS 100 0001 100 1000 100 2000 100 2100 100 2200 100 3000 100 4000 100 4200 100 6000 100 US01 100 LELE 800 0001 800 1000 800 2000 800 2100 800 2200 800 3000 800 4000 800 4200 800 6000 800 US01 800 okck 810 1000 810 KEK 811 2100 811 KEK kkk kkkk DOERRSCHUCK 02 1998 PBS ANA BKPF Seite 1 Gr e KB Gr f e 2 0 00 51 746 35 78 4 169 2 88 51 0 04 6 0 00 15 490 10 71 368 0 25 2 0 00 77 0 05 321 0 22 72 232 49 95 2 0 00 52 739 35 18 4 169 2 88 51 0 04 6 0 00 15 490 20 7 368 0 25 2 0 00 77 0 05 321 0 22 72 225 49 95 39 0 03 39 0 03 114 0 08 114 0 08 144 609 100 00 EMC ViewPoint for SAP Modules Utilities User Manual D
18. Asset document header ANEP TXW_AD_POS Asset document item AFRU TXW_AFRU Order confirmation AFVC TXW_AFVC Order operation ANLE TXW_ANLE Asset origin from line items ANLK TXW_ANLK Asset origin from cost element ANLP TXW_ANLP Asset periodic sizes ANEA TXW_ANEA Shared values of attachment document Items VBRK TXW BI HD Billing document header Overview Data Retention Tool Table 18 CDART transaction data continued Original Segment structure DART Description VBRP TXW_BI_POS Billing document item BSET TXW_BSET Document segment tax data KONV TXW_CONDPR Pricing conditions billing documents COSP TXW_CO_COST_TOTALS Controlling object total cost COSS TXW CO COST TOTOLS Controlling object total cost COBK TXW CO HD CO document header COEP TXW CO POS CO document item COBK TXW CO SHD CO document header Secondary posting COEP TXW CO SPOS CO document item Secondary posting LIKP TXW DL HD Delivery document header LIPS TXW DL POS Delivery document item EIKP TXW EIKP Export Import header data EIPO TXW EIPO Export Import item data BKPF TXW FI HD FI document header BSIK TXW FI OP Open item FI BSIS TXW_FI_OP Open item FI BSID TXW_FI_OP Open item FI BSEG TXW_FI_POS FI document item MKPF TXW MM HD MM document header EKKO TXW MM POH MM order header EKPO TXW MM POP MM purchase order item MSEG TXW MM POS MM document item COFIS TXW RC POS FI C
19. Dialog table for order sequences AFFL AFFU Goods movements with errors from confirmations AFK Order header data PP orders AFPO Order item X AFPOD Order item dialog structure x AFRU Order completion contirmations AFRUD Dialog table for completion confirmations AFVC Operation within an order AFVGD Order Dialog table for Table AFYG order operation AFVU DB structure of the user fields of the operation AFVV DB structure of the quantities dates values in the operation AUFK Order master data BKPF Accounting Document Header X BSAD Accounting Secondary Index for Customers Cleared Items BSAK Accounting Secondary Index for Vendors Cleared Items BSAS Accounting Secondary Index for G L Accounts Cleared Items BSEG Accounting Document Segment X BSIS Accounting Secondary Index for G L Accounts CAUFY Generated Table for View CAUFY X C AUFVD Dialog structure for order headers and items X CDHDR Change document header X CDPOS Change document items X COBK CO Object Document header X COBRA Settlement Rule for rder Settlement COBRE Distribution Rules Settlement Rule Order Settlement COEP CO Object Line Items by Period X COYP Table Generated for View COVP x DOST Document to BOM Link EIKP Foreign Trade Export Import Header Data x EIPO Foreign Trade Export Import Item Data x EKAB Release Documentation X EKAN Vendor Address Purchasing Document EKBE History per Purchasing Document EKBZ History per Purchasing Document Delive
20. Management CWM HR Archiving Objects CHR Financial Accounting and Material Documents CFI Sales and Distribution CSD Table 8 lists the Check ADK objects Check ADK objects Object ViewPoint for SAP 4 x Description PROG PBS UTIL_CHECK_PBS_ADK Report ViewPoint Check ADK utility DEVC PBS UTIL Development Class PBS UTIL TRAN PBS CHECK_PBS_ADK Transaction ViewPoint Check ADK utility EMC ViewPoint for SAP Modules Utilities User Manual Running Check ADK Figure 28 Figure 29 Check ADK Follow this procedure to use the Check ADK utility 1 Start the Check ADK utility with transaction PBS CHECK PBS ADK as shown in Figure 28 List Edit Goto System Help lel Jmece cu aoa axa a ew s Menu of utilities of the PBS archiue add ons Q Copy transfer order Report PBS UTILTPO1 Q Convert select statement Report PBS UTIL CONUERT Q Call archive browser Report PBS UTIL_ARCHIVEBROWS Q Determine transport requests Transaction PBS UTIL Z9CP Call translation tool Report PBS UTIL TRANSLATE Call tool Check PBS ADK Report PBS UTIL_CHECK_PBS_ADK ViewPoint for SAP utilities releases 4 0 and 4 5 Or from the ViewPoint for SAP main menu using Utilities gt General tools Tool Check ViewPoint ADK as shown in Figure 29 Menu Edit Favorites Extras System Help le sdweeoe amsm I Ga Other menu amp B 2 va L Crea
21. SAP Data Browser which uses transaction SE16 The ViewPoint for SAP Archive Browser displays table entries table field values and text field values using the database archive or both as a data source The Archive Browser displays tables from these ViewPoint for SAP modules Financial Accounting and Material Documents CFI Sales and Distribution CSD Purchasing CMM Material Master Data Batches Special Stocks and BOMs CMT Controlling Line Items CCO Profit Center Line Items CPCA Plant Maintenance CPM Production Orders CPP Process Orders CPR Project Systems CPS Warehouse Management CWM Special Ledger CSL Custom IDK CUSTOM Table 1 lists the SAP R 3 objects included in the Archive Browser utility with a description of each object Archive Browser object descriptions Object Rel 3 x Rel 4 x Description PROG ZZCSBROW PBS UTIL_ARCHIVEBROWS Archive Browser FUGR 2007 PBS C007 Function group for Conversion objects FUGR ZZSB PBS SETB Function group Archive Browser AB EMC ViewPoint for SAP Modules Utilities User Manual Archive Browser Table 1 Archive Browser object descriptions continued Object Rel 3 x Rel 4 x Description FUGR N A PBS TAB_ARCHDEF Function group for DB table where all available ViewPoint for SAP modules transaction PBS SE16 their tables and indexes
22. The predefined year end closing programs of the Fiscal Year Reporter has a process flow as shown in Figure 33 Archive data R 3 Database FI DOCUMNT Document master record Begin balance item debit total items Begin bal mast rec t SIT debit total me 4 010 295 52 4714 515 387 32 1 010 235 52 171 515 387 32 Incl reconciliation 453 750 98 417 988 586 86 117 1988 586706 2 104 793 917 38 2 104 793 9197 98 ifference 9 95 No atererneces during tne reconciliation Year Document Master record o SB EB o mB x Figure 33 Fiscal Year Reporter process flow The Fiscal Year Reporter provides the following advantages for the SAP financial accounting business processes amp EMC ViewPoint for SAP Modules Utilities User Manual Freezing actual status of movement and master data at the end of the fiscal year Evaluation of fiscal year data after conversion of local currency values Complete independence from the development of the operative SAP tables Balances audit trail programs and quantity problems with sort volumes Easily integrates customer SAP programs with the Fiscal Year Reporter Overview Fiscal Year Reporter Fiscal Year Reporter Figure 34 Figure 35 Using Fiscal Year Reporter There are two Fiscal Year Reporter menus User transaction YEAR PBS YEAR Administrative transaction YEAM PBS YEAM
23. Where to Get Help EMC support product and licensing information can be obtained as follows EMC ViewPoint for SAP Modules Utilities User Manual EN Your Comments Product information For documentation release notes software updates or for information about EMC products licensing and service go to the EMC Powerlink website registration required at http Powerlink EMC com Technical support For technical support go to EMC Customer Service on Powerlink To open a service request through Powerlink you must have a valid support agreement Please contact your EMC sales representative for details about obtaining a valid support agreement or to answer any questions about your account Your suggestions will help us continue to improve the accuracy organization and overall quality of the user publications Please send your opinion of this guide to techpub_comments EMC com EMC ViewPoint for SAP Modules Utilities User Manual ViewPoint for SAP Utilities This chapter introduces the ViewPoint for SAP utilities and includes this topic KROITIEM A i deh es eb eS 12 ViewPoint for SAP Utilities EU ViewPoint for SAP Utilities Overview Installation utilities Initial installation Class Order The ViewPoint for SAP utilities can be grouped into three categories Installation utilities Compliance and auditing utilities on page 13 Database growth monito
24. are checked Running Check ADK MEME Check ADK Using SAP Object Use this procedure to check SAP ADK files exclusively using Check to Test ADK 1 Select SAP Object to Test in the Check ADK initial screen as shown in Figure 30 on page 54 2 Enter one archiving object A sample results screen appears as shown in Figure 32 PBS Tool for checking PBS index files and SAP ADK files List Edit Goto System Help Kam 9 eeoelomunmaeonanaumio PBS Tool for checking PBS index files and SAP ADK files Check of FI_DOCUMNT files via table ADMI_RUN 30 01 2003 14 46 01 STEFFEN 013363 001FI DOCUMNT OK usr sap E46 SYS 30 01 2003 13 58 35 STEFFEN 013360 001FI DOCUMNT OK usr sap E46 SYS 07 01 2003 13 31 56 STEFFEN 013272 001FI DOCUMNT FAIL usr sap E46 SYS 07 01 2003 13 31 00 STEFFEN 013271 001FI DOCUMNT OK usr sap E46 SYS 07 01 2003 13 29 12 STEFFEN 013270 001FI DOCUMNT OK usr sap E46 SYS 07 01 2003 13 10 58 STEFFEN 013269 001FI DOCUMNT OK usr sap E46 SYS 04 12 2002 11 14 27 KAPOUSOUZIS 013244 001FI_DOCUMNT OK usr sap E46 SYS 04 12 2002 10 57 50 KAPOUSOUZIS 013243 001FI DOCUMNT OK usr sap E46 SYS 02 12 2002 10 00 47 KAPOUSOUZIS 013238 001FI DOCUMNT OK usr sap E46 SYS 02 12 2002 09 59 34 KAPOUSOUZIS 013237 001FI_DOCUMNT OK usr sap E46 SYS 49 19 IAAI ma Eco 1r VADAIICAIIZTS 01222Cc 001rcT NANIIMNIT nv fae jaan IENA ICUS 7 Figure 32 Results screen for SAP obje
25. can be archiued oa Recurring sample or parked document Document still has open items 100000002 Document still has open items Log of FI Documents for Archiving f 1 1 1 i CoCde Select HE4 1 003 sunds OVR 10 25 Fl document selection results 126 EMC ViewPoint for SAP Modules Utilities User Manual Analyzer Plus Sales documents Sales documents are analyzed and listed according to archiving objects for orders invoices and delivery notes displaying results for each document as shown in Figure 85 Double click a document for more details for a sales document el 216 66 omm anna A om Archiving orders check relevance for archiving e Archiving orders check relevance for archiving 1 Messages if customizing tables are not maintained completely Overview check indicator gt Archiving orders check relevance for archiving Figure 85 Sales orders selection results The archivability checks carried out match the SAP archiving checks for orders invoices delivery notes as follows orders PBS ANA_ARCHIVE_SD_VBAK invoices PBS ANA_ARCHIVE_SD_VBRK delivery notes PBS ANA_ARCHIVE_RV_LIKP Archivability check 127 Analyzer Plus Purchasing The archivability check for purchase orders matches checks carried documents out by SAP displaying results for each document as shown in Figure
26. in Figure 21 Comparison source and target program Figure 21 Comparing Source and Target programs Running the Conversion Tool Conversion Tool Customizing definitions Figure 22 Use the Customizing sequence to access the ViewPoint for SAP modules ranking definition as shown in Figure 22 SAP hU eoe nmm nno 3 Determine sequence of PBS archive add ons presul Opt Deseo _T a CSD A Sales Document CRE e T CF Financial accounting D eco ouem Determine module sequence This definition is always valid when a database table used in a Select command is contained in several ViewPoint for SAP modules If the Source program contains for example the Select command SELECT FROM EIPO the Source program is converted for access to the invoices of the ViewPoint for SAP SD Module However the table EIPO can in addition to the invoices also exist in delivery notes and purchasing MM documents When converting a program for purchasing documents modify this sequence in a way so that the module MM receives ranking 1 with the rest having a lower ranking Tables STXH CDHDR require checking and defining sequential order Tables contained in multiple ViewPoint for SAP modules always have a status of Manual editing necessary EN EMC ViewPoint for SAP Modules Utilities User Manual Special features Client specified
27. program is ZZZDUMM Y You can Change Display Copy and Execute the Source and Target programs Use Copy to convert a Source program into a Target program other than ZZZDUMMY During the copy process change the default Target program name ZZZDUMMY to the desired program name 3 Start the conversion by clicking start converting as shown in Figure 18 V start converting Figure 18 Start converting The coding lines of the program YYCONV02 in this example are converted for the ViewPoint for SAP modules and can be stored in the program ZZZDUMMY by default 4 Cut and paste or use PC Download to enter the coding into the desired program EMC ViewPoint for SAP Modules Utilities User Manual Conversion Tool Viewing conversion An example of conversion results appears in table form with a table results line entered for each Select command found during the conversion as shown in Figure 19 Overview of the conversion in tabie fonn Figure 19 Conversion results The columns contain information on the conversion of the Select command Running the Conversion Tool Conversion Tool Status of the conversion St Table 4 lists definitions for the status symbols shown in the first column Table 4 Status table column definition Symbol Definition The Select was converted automatically and the Conversion Tool found all the ef necessary information for the conversion The Select could n
28. the following sort according to size criteria as shown in Figure 88 Formation of Pool Archiving object Sorting Size PBS DB ANALYZER PLATTENPLATZBELEGUNG VON ARCHIVOBJEKTEN Zeit 16 10 23 DOERRSCHUCK Kapazit t Lauf Nr 0001 vom 19 02 1998 1 086 618 KB Datum 20 02 1998 Kapazit tsanalyse IDES vor Archivierung Seite 1 Kapazit t der selektierten Daten B 1 086 618 KB Anteil Selektion am Lauf 100 Objekt Objektbezeichnung Summe KB Sel Ges FI DOCUMNT Finanzbuchhaltungsbelege 144 641 13 3 1 353 CO_ORDER Auftr ge mit Bewegungsdaten 138 780 12 8 12 8 CO_ALLO_ST Vollst ndig stornierte Belege Umlage Vert 118 075 10 9 10 9 PCA_OBJECT Summens tze und Einzelposten im EC PCA 94 101 8 7 8 7 IDOC Intermediate Document 87 755 8 1 8 1 SD VBAK Verkaufsbelege 60 027 55 5 5 CO_COSTCTR Kostenstelle alle Daten incl Stellenstamm 43 488 4 0 4 0 GLX OBJEKT Summens tze und Einzelposten im FI SL 41 440 3 8 3 8 CV_DRAW Summens tze und Einzelposten im FI SL 39 173 3 6 3 6 FLC OBJECT Summens tze und Einzelposten im FI LC 36 007 333 3 3 PM QMEL PM Meldungen 31 288 2 9 2 9 SD VBRK Fakturen 31 074 2 9 2 9 MM EKKO Einkaufsbelege 30 484 2 8 2 8 FI ACCOUNT Sachkontenstammdaten 29 956 2 8 2 8 RV LIKP Lieferungen 22 430 2 1 2 1 MM_MATBEL Materialwirtschaft Materialbelege 20 437 1 9 1 9 MM_MATNR MM Materialstamm 17 588 1 6 1 6 AM_ASSET Anlage Stammdaten Werte und Bewegungen 15 960 1 5 1 5 CATPROARCH CATT Protokoll Vorgang 12 306 1
29. usr sap E46 SYS global RPP11122 ARCHIVE 013247 001PR ORDER 05 12 2002 15 27 11 KRUEGER OK usr sap E46 SYS global RPP12051 ARCHIVE Check for not loaded PR_ORDER files 011985 001PR ORDER Run has been deleted 012826 001PR_ORDER 17 07 2002 15 30 21 KRUEGER OK usr sap E46 SYS global RPPO71 70 ARCHIVE 013189 001PR ORDER 12 11 2002 11 26 55 KRUEGER OK usr sap E46 SYS global RPP11122 ARCHIVE 013247 001PR_ORDER 05 12 2002 15 27 11 KRUEGER OK usr sap E46 SYS global RPP12051 ARCHIVE Figure 31 Results screen for the ViewPoint for SAP CPR module Table 9 lists the results definitions which are divided into several parts depending on the ViewPoint for SAP module Note FAIL displays if an ADK file cannot be accessed Table 9 Results screen definitions Screen area Definition Check of the ViewPoint ADK files All available ViewPoint for SAP index files for one with table ADMI RUN module are checked Check of the ViewPoint ADK files All activated ViewPoint for SAP index files for one with PBS ADMIN table module are checked Load Admin table Check of the ViewPoint ADK files Comments entered in the SAP original ADK files with the COMMENTS entry CPP are checked if a ViewPoint for SAP index exists and CHR Modules Check of the SAP ADK files for SAP ADK files processed in individual load runs are activated indices LAUFTAB checked remaining modules Check for not loaded ADK files All remaining ADK files
30. 000 288 462 0 45 1995 05 3000 56 90 0 09 1995 05 4000 2 3 0 00 1995 05 4200 2 3 0 00 1995 05 REFR 1 462 2 347 2 28 1996 0 3000 152 244 0 24 1996 10 wo 3 902 6 265 6 09 1996 1 1000 3 744 6 011 5 85 1996 44 2000 274 440 0 43 1996 1 3000 294 472 0 46 1996 11 iiid 4 312 6 923 6 73 1996 12 1000 3 240 5 202 5 06 1996 2 2000 272 437 0 42 1996 12 3000 170 273 0 27 1996 2 4000 4 6 0 01 1996 12 EEK 3 686 5 918 5 76 1996 EEK 55 535 89 160 86 72 EEE REER 64 043 102 819 100 00 Figure 92 Document volume example EMC ViewPoint for SAP Modules Utilities User Manual Analyzer Plus The number of posted documents by document type and year for client 800 appears as shown in Figure 93 Selection Client 800 Formation of Pool 1 Document type 2 Posting year PBS DB ANALYZER VERTEILUNG BUCHHALTUNGSBELEGE DOERRSCHUCK Lauf 0001 01 1990 12 1998 Datum 23 02 1998 PBS ANA BKPF Beleggr e Byte 1 644 BELEGVERTEILUNG IDES Seite 1 BLART JAHR Anzahl Gr e KB Gr f e AA 1994 130 209 0 29 AA 995 166 267 0 37 AA 996 24 39 0 05 AA 997 182 292 0 40 AA eee 502 806 1 12 AB 1994 13 21 0 03 AB 995 267 429 0 59 AB 996 108 173 0 24 AB 1997 25 40 0 06 AB REDS 413 663 0 92 AF 994 339 544 0 75 AF 995 722 1 159 1 60 AF 996 1 363 2 188 3 03 AF 997 172 276 0 38 AF RER 2 596 4 168 5 77 AN 1994 T 2 0 00 AN 995 T 2 0 00 AN EEE 2 3 0 00 DA 995 L 2 0 00 DA 996 2 3 0 00 DA REDS 3 5 0 01 DG 996 2 3 0 00 DG eee 2 3 0 00 DR
31. 00000138 1995 124 100 1000 1400000138 1985 Figure 47 Data display in IDEA EMC ViewPoint for SAP Modules Utilities User Manual Extracting data Financial accounting Asset accounting Fiscal Year Reporter The following ViewPoint for SAP reports can help meet legal requirements for extracted data The default ViewPoint for SAP selection can be extended if required The overview of the export programs lists the database tables from which the data can be extracted T003 Document type T003T Document type name T007A Tax key T007S Tax code name T001 Company code TGSBT Business area name TBSL Posting key TBSLT Posting key name TABW Transaction types of the asset accounting TABWA Transaction types Depreciation areas TABWG Transaction types groups TABWH Name asset transaction type groups TABWK AM transaction types for posting of proportional values and depreciation TABWR Name of asset history sheet group TABWT Transaction type texts of asset accounting TABWU special treatment of retirement TAPRFT Text table for investment profile TAPRE Investment measure profile for asset under construction and depreciation simulation Use the ViewPoint for SAP menu General table data to access these tables Fiscal Year Reporter audit access Fiscal Year Reporter Figure 48 Figure 49 Generate the export program using Export of general table data by indicating the tab
32. 18 Auchivahility check E 126 Capacity analysis examples ecce tne rerit rre exe tptre cere 129 Document distribution analysis examples 133 Analyzer Plus 103 Analyzer Plus Overview Capacity analysis Document distribution analysis Use ViewPoint for SAP Database Analyzer Plus to examine an SAP R 3 system to determine How much disk space is occupied by each module Which module requires the most disk space How much the SAP R 3 database increases monthly and yearly Size of the financial accounting monthly document volume Those archiving objects for which archiving is useful Average size of a purchasing document What table is archived with what archiving object What ViewPoint for SAP archiving modules are needed Database Analyzer Plus consists of three essential functions Analyze the capacity occupied by database tables Analyze the distribution of documents for selected SAP modules Execute an archiving check for selected SAP modules The capacity analysis executes an analysis of the tables used by the archiving objects and stores the results for evaluation in the database Optionally a detailed analysis of CO tables such as COEP COSS and COSP can be done depending on if archiving was done with or without the archiving object CO ITEM If CO ITEM was used for archiving a detailed evaluation is not necessary since the corresponding tables
33. 2 800 000 12 246 395 5 83 800 1000 see 2 938 4 717 69 62 800 2000 01 3 5 0 07 800 2000 02 2 3 0 05 800 3000 10 99 159 2 35 800 3000 23 231 371 5 47 800 3000 12 61 98 1 45 800 3000 ne 841 1 350 19 93 800 4000 05 T 2 0 02 800 4000 10 68 109 1 61 800 4000 11 39 63 0 92 800 4000 108 173 2 56 800 4200 05 1 2 0 02 800 4200 1 2 0 02 800 US01 11 128 206 3 03 800 USO1 se 128 206 3 03 800 EERE 4 220 6 775 100 00 Tee 4 220 6 775 100 00 Figure 91 Posted documents example Document distribution analysis examples 133 Analyzer Plus 134 Document volume periods from 1995 to 1996 appears with corresponding company codes for all clients as shown in Figure 92 Selection Entry year 1995 1996 Formation of Pool 1 Posting year 2 Posting period 3 Company code PBS DB ANALYZER VERTEILUNG BUCHHALTUNGSBELEGE DOERRSCHUCK Lauf 0001 01 1990 12 1998 Datum 23 02 1998 PBS ANA BKPF Beleggr e Byte 1 644 BELEGVERTEILUNG IDES Seite 1 JAHR PERIOD BUKRS Anzahl Gr e KB Gr e 1995 01 1000 324 520 0 51 1995 01 2000 6 10 0 01 1995 01 3000 722 1 159 1 43 1995 01 RE 1 052 1 689 1 64 1995 02 1000 212 340 0 33 1995 02 2000 4 6 0 01 1995 02 3000 42 67 0 07 1995 02 EEK 258 414 0 40 1995 03 1000 94 151 0 15 1995 03 3000 36 58 0 06 1995 03 ewe 130 209 0 20 1995 04 1000 100 161 0 16 1995 04 2000 2 3 0 00 1995 04 3000 22 35 0 03 1995 04 eese 124 199 0 19 1995 05 1000 1 114 1 788 1 74 1995 05 2
34. 2 direct data access Allows the tax authority to request the taxpayer or a third party to execute read only access indirect access and evaluate the data using the evaluation functionality of the data processing system Access 3 Z3 data by transferring data on data carriers Allows the tax authority to request a data extract of business records which is returned to the taxpayer or deleted after the external audit is complete Access is limited to data for financial accounting asset accounting and payroll accounting Relevant data in other areas of the data processing system is qualified by the taxpayer for sales purchase order material and invoice verification documents R 3 audit requirements are met using Z1 and Z2 access To support Z3 audit access data extraction use DART Data Retention Tool explained in Chapter 7 Data Retention Tool Fiscal Year Reporter audit access Fiscal Year Reporter Fiscal Year Reporter Table 14 lists details for each audit access strategy Table 14 ViewPoint for SAP access types Access type ViewPoint for SAP module support Features Zi Modules CCO CCU CFI CHR CMM CMT CPCA CPM Data access to archive and DB CPP CPR CSD CSL CWM Dialog transactions FI standard reporting Customer specific reporting ViewPoint long term archiving concept 22 Fiscal Year Reporter Data access to archive and DB DB Dialog transactions FI standard reporting Cu
35. 5 KB in the system The size of a document is 2 122 bytes The archiving object has a 100 portion in the selection and a 9 portion in the total capacity EMC ViewPoint for SAP Modules Utilities User Manual Figure 72 Analyzer Plus The size of table BSEG is 61 631 KB which is 41 6 of the selected data and 3 7 of the total capacity as shown in Figure 72 t Sel X Tot Size KB Sel Tot Accounting Document Segment Accounting Secondary Index for G L Accounts BKPF Accounting Document Header BSET Tax Data Document Segment Object archiving Note If the size of a table is displayed in brackets the table could not be assigned to an archiving object The size of the table for the first archiving object displays The remaining archiving object values appear in brackets for which the table is available and whose value is not added to the total size of the object Capacity analysis 113 Analyzer Plus An overview of analyzed tables displays if Single table evaluation was selected as shown in Figure 73 el CHOBE CAR anna fA om PBS DB Analyzer Disk space occupancy of arch objects Time 16615291 HEMMING Run number 0026 from 10 01 2003 1 647 478 KB Date 21 01 2003 YYCSANAK Test Page 1 Size of selected data 148 095 KB Portion of total size B 9 Object Name of object Table Name of database table BSAK nn accounting Secondary Index for Vendors Cleared BF D
36. 6 801FI DOCUMNT 960412 001F1_DOCUMNT 900494 001F1_DOCUMNT 960496 001F1_DOCUMNT 880643 801FI DOCUMNT 880705 001FI DOCUMNT Fiscal year 1995 Only reconc Doc Master rec Reconciliation and backup X 35 870 Documents read 3 283 docs selected 3 283 docs written 14 262 document items selected 14 262 document items written YY YR 1995 1995 900889 001YY YR 1995 R100FI1124199911241423348 A Ccode Curry Year Begin balance item debit total items credit total items m Begin bal mast rec debit total mc credit total mc D 1800 DEM 1995 4 711 250 19 11 735 103 21 15 436 117 88 4 711 250 19 11 735 103 21 15 436 117 88 Difference 9 08 9 00 8 08 K 1800 DEM 1995 251 643 29 5 173 971 10 5 076 078 79 251 643 29 5 173 971 10 5 076 078 79 Difference 9 00 9 00 9 00 S 1800 DEM 1995 698 874 600 71 588 874 608 71 808 874 600 71 508 874 609 71 Difference 8 00 9 00 No differences during the reconciliation Sell ab I D Tina 100 Pal sunas Tins Figure 37 Reconciliation results for saved transaction data Use YEAM Transaction data Delete to delete erroneous extract stock Note If transaction data is deleted after conversion from local currency to Euro data is lost ES EMC ViewPoint for SAP Modules Utilities User Manual Extract master data at fiscal year closing Figure 38 Table 10 Fiscal Year Reporter Master data such as customers
37. 99 Figure 58 Manual index construction screen Select archive Allows manual selection of archiving runs created with transaction SARA for SAP archive objects Click SAP to archive the corresponding SAP archiving runs displayed which were created from the entered date Archiving ViewPoint for SAP modules data Data Retention Tool Figure 59 Selecting the requested SAP archiving runs allows the system to check if the run was loaded into the ViewPoint for SAP archive as shown in Figure 59 Financial accounting documents 12 2002 Lang Kurztexte 100 11 2002 GJ 2000 Beleg 100000 11 2002 GJ 1999 Beleg 100000 11 2002 GJ 1998 Beleg 100000 2002 GJ 1997 10 2002 Umsetzung Kontenpla 10 2002 Umsetzung Kontenpla 10 2002 Test Belege 188 1994 10 2002 Test Belege 100 1994 L1 DJ DJ D1 DJ D1 D N w oboooooomsa ooooowmmmo gt e System messages Load automatically from Processes all documents from the selected date without individually selecting each SAP archive SAP archives already completed are not indexed to the ViewPoint for SAP archive a second time This function automates the load runs and can be scheduled as a background job by using a selection variant Delete old run Select Run to display a list of previous load runs for selection and deletion or delete all SAP archiving runs for the selected ViewPoint for SAP module Process all documents Selecting ensures that all documents in th
38. ABAP PBS ANA KAPAZITAET VGL to compare two analysis runs such as comparing data increase within a period of time or data decrease after archiving Database analysis evaluation on page 110 has information about Selections fields and Options for creating a second analysis for comparison purposes The result of a comparison analysis appears as shown in Figure 76 An increase in capacity means a loss of disk space and is displayed as a negative value highlighted in blue s vH eae DaB anas mm 98 PBS DB Analyzer Evaluation capacity document comparison two runs PBS DB Analyzer Disk space occupancy Time 14 54 86 HEMMING 1 Vergleich zweier Analysel ufe Date 14 01 2003 PBS ANA KAPAZITAET VGL 0026 18 81 2003 Test 1 647 478 148 095 KB 9 8025 22 11 2002 Aufbau nach Archivierung mit Einzeltabell 1 704 524 121 686 KB 7 Differenz der L ufe 57 046 26 409 KB Object Table Name of database table FI DOCUMNT BSEG Accounting Document Segment BSIS Accounting Secondary Index for G L Accounts BKPF accounting Document Header BSET Tax Data Document Segment BSAD Accounting Secondary Index for Customers Clear BSAS Accounting Secondary Index for G L Accounts C1 BSIM Secondary Index Documents for Material BSAK Accounting Secondary Index for Vendors Cleared BFOD 4 FI Subsequent BA PC Adjustment Customer Items BSID Accounting Secondary Index for Customers BFOK_A FI subsequent BA PC a
39. ANA AS400 the database table DBSTATTDB4 must be updated with transaction DB02 and the initialization started with Refresh data update data statistic Note An SAP correction order must be imported if the program cancels Program PBS ANA RARCCOAI corrects the distribution of CO records when an analysis is constructed by SAP program RARCCOAT and stores the result under the next higher run number allowing determination of the description of the run The single table analysis enables you to analyze tables independent from an archiving object when updating table PBS ANA TAB DEF with transaction SE11 108 EMC ViewPoint for SAP Modules Utilities User Manual Analyzer Plus Enter the name of the table in field TABLENAME leaving field SQLTAB empty as shown in Figure 65 Table PBS ANA TAB DEF insert Figure 65 Update of table with transaction SE11 Execute a new initialization with ABAP PBS ANA ERSTAUFBAU Selecting and keep previous analyses keeps the previous analysis During the next capacity run the implemented tables are also analyzed as shown in Figure 66 Figure 66 Implementation table analysis Capacity analysis ELE Analyzer Plus Database analysis Evaluate an analysis run with the ABAP PBS ANA_KAPAZITAET evaluation The database analysis for archiving object FI DOCUMNT is shown in Figure 67 iil 2189 eae 888 5645 Om 08 PBS DB Analyzer PLUS Evaluation capacity documen
40. FI Subsequent BA PC Adjustment Customer Items BSID Accounting Secondary Index for Customers BFOK_A FI subsequent BA PC adjustment Vendor items BFIT A0 FI Subseq BA PC Adjustmnt Zero Bal Postings for BSIK Accounting Secondary Index for Vendors Index for Vendor Validation of Double Documents BSEC One Time Account Data Document Segment RF048 Subseq BA PC Adjustmnt Index Distributn Vector BSED Bill of Exchange Fields Document Segment STXL STXD SAPscript text file lines COPOS Change document items STXH STXD SAPscript text file header BYOR Intercompany posting procedures BF D AB FI Subseg BA PC Adjustmnt Valuatn Diffrnce in C BFOK_AB FI subseq BA PC adjustmnt Valuatn difference in BF R Versions for Resetting Cleared Items BSEGC Document Data on Payment Card Payments Index table for customer bills of exchange used Index table for customer bills of exchange used CDHDR Change document header STXB SAPscript Texts in non SAPscript format TTXI External tax interface index file TTXY External tax interface tax information WITH ITEM Witholding tax info per W tax type and FI line i PBS ANA AR TMP 188 TRANSP AFKO 1 128 TRANSP AP_ORD_PRE 1 128 VIEW gt AFKO ATAB 145 960 POOL DOKCLU 993 296 CLUSTER DOKTL 993 296 CLUSTER gt DOKCLU RFBLG 75 160 CLUSTER T8047 145 968 POOL gt ATAB VBAK 563 TRANSP Figure 73 Table analysis overview This alphabetical list displays table class For ex
41. FI Subsequent BA PC Adjustment Customer Items 1 398 au EL BSID Accounting Secondary Index for Customers 937 8 8 0 1 BFOK_A FI subsequent BA PC adjustment Vendor items 535 8751 8 0 BFIT A8 FI Subseq BA PC Adjustmnt Zero Bal Postings for 465 0 4 0 0 BSIK Accounting Secondary Index for Vendors 452 8 4 8 0 BSIP Index for Vendor Validation of Double Documents 234 8 2 8 8 Result of the capacity analysis Capacity analysis EUS Analyzer Plus Figure 69 Figure 70 Figure 71 Analysis details appear at the top of the screen as shown in Figure 69 PBS DB Analyzerr Disk space occupancy of arch objects Run number 0002 from 29 03 2000 3 097 306 KB Kapazitaetslauf oh CO Details Capacity run details The disk occupancies values originated from capacity run 0002 from 29 03 2000 created with program PBS ANA_AUFBAU with a total capacity of 3 097 306 KB and stored under the description Capacity analysis ID4 with CO details The evaluation of the analysis started on 07 04 2000 at 14 57 15 by user DOERRSCHUCK as shown in Figure 70 Time peel DOERRSCHUCK Date 07 04 2000 YYCSANAK Page 1 Analysis evaluation A total of 452 126 KB was selected which is 1576 of the total capacity of 3 097 306 KB of run 0001 as shown in Figure 71 Size of selected data 3 452 126 KB Portion of total size a UE Evaluation Archiving object FI DOCUMNT has a total of 71 476 documents entries in table BKPF with a total size of 148 09
42. M WM Lagerverwaltung Transportbedarfe 28 0 0 0 0 PPPI ARCH Proze auftrag DB Archivieren 18 0 0 0 0 CO ML IDX Indexeintr ge Belege zum Material Material Ledg 257 0 0 0 0 CA KBLX Interne RW Belege Mittelreserv Festpreise 13 0 0 0 0 PS TEXT Projektsystem PS Texte 10 0 0 0 0 SD VTTK SD Transporte 10 0 0 0 0 PI PLAN Planungsrezept 3 0 0 0 0 PP PLAN Arbeitspl ne 1 0 0 0 0 Figure 88 Archiving objects example 130 EMC ViewPoint for SAP Modules Utilities User Manual Analyzer Plus The output using the size of the archive table NAST appears with the distribution of the archiving objects as shown in Figure 89 Selection Archive table NAST Formation of Pos None Sorting Size Options Zero values details PBS DB ANALYZER PLATTENPLATZBELEGUNG VON ARCHIVOBJEKTEN Zeit 16 11 55 DOERRSCHUCK Kapazit t Lauf Nr 0001 vom 19 02 1998 1 086 618 KB Datum 20 02 1998 Kapazit tsanalyse IDES vor Archivierung Seite HE Kapazit t der selektierten Daten 8 841 KB Anteil Selektion am Lauf 1 Tabelle Object Bezeichnung Gr fe KB Sel Ges NAST SD VBRK Nachrichtenstatus 2 433 27 5 0 2 NAST SD VBAK Nachrichtenstatus 2 405 27 2 0 2 NAST MM EKKO Nachrichtenstatus 2 316 26 2 0 2 NAST RV_LIKP Nachrichtenstatus 1 683 19 0 0 2 NAST SD_VBKA Nachrichtenstatus 3 0 0 0 0 NAST SD_VTTK Nachrichtenstatus 2 0 0 0 0 Figure 89 Archive table example Capacity analysis examples 131 Analyzer Plus The
43. MC ViewPoint for SAP Modules Utilities User Manual Fiscal Year Reporter Table 16 Export programs continued Program name PBS FYR LIS Description Variable Logical Database Table F Description GLACC G L account list PBS YSF SKA1 _A G L account master in general master data SKB1 _B G L account master company code SKAT _T G L account text SKC1A 1 transaction figures local currency SKC1C 3 transaction figures foreign currency ASSET asset list ADA ANLAV A asset in general master data ANLV _V insurance data ANLZ _Z value dated asset assignments ANLB _B depreciation parameter ANLCV C assets value fields REFERENCE general table contents a Field extension indicator Figure 42 The reports can be generated using Fiscal Year Reporter gt Reporting gt Data export as shown in Figure 42 7 3 PBS Fiscal Year Reporter 7 CX Reporting ma IPBSIYRO2 Periodic processing 7 amp Data export 7 C3 Document data O PBS YR30 Document line items O IPBSIYR36 Asset documents line items 7 C3 Master data O IPBSIYR31 Customer O PBS YR32 Vendor ID JPBS YR33 GIL account Fiscal Year Reporter data export menu Fiscal Year Reporter audit access Fiscal Year Reporter Export selection screen Delimitations to influence the scope of selection Selection of list layouts Figure 43 Note For SAP releases 4 0 and
44. O settlement item EMC ViewPoint for SAP Modules Utilities User Manual Data Retention Tool Table 18 CDART transaction data continued Original Segment structure DART Description VBAK TXW SD HD Sales document header VBAP TXW SD POS Sales document item VBPA TXW SD PRT SD Partner VBKD TXW VBKD Sales document sales data Overview Data Retention Tool Using CDART ViewPoint for SAP CDART module provides the necessary definitions to archive data Creating the CDART Follow this procedure to create an SAP Easy Access menu for Easy Access menu CDART 1 From the ViewPoint for SAP CDART module area menu PBS DART generate e an activity group 4 6B arole 4 6C as shown in Figure 52 SAP Easy Access BE Z Other menu 682 v L Create role Figure 52 Create a role 2 Choose the name of the activity group or role from within the View Point namespace For example PBS DART 3 Click Transfer menus from area menus to transfer the ViewPoint for SAP CDART module range menu 4 Indicate the corresponding ViewPoint for SAP menu name For example PBS DART 5 Click Yes to the system query for the resolution of the range menu 6 Integrate the role activity group into the user master transaction SU01 EN EMC ViewPoint for SAP Modules Utilities User Manual Figure 53 Figure 54 The Easy Access menu displays within the user menu as show
45. PBS ANA_VERTEILUNG Before starting the first document distribution analysis the ViewPoint for SAP Database Analyzer Plus database tables must be reconstructed in the SAP R 3 system by starting the ABAP PBS ANA_ERSTAUFBAU by copying the entries of the database table PBS ANA_AR_DEF into the table PBS ANA AR OBJ and supplementing it with the table names of the SOL database ABAP PBS ANA ERSTAUFBAU is also used to delete all existing analyses Use this procedure to run the document distribution analysis 1 Start the ABAP PBS ANA VERTEILUNG Note Run the ABAP PBS ANA VERTEILUNG as a background process checking the progress of the run with the protocol entries of the own jobs Depending on the database system ABAP PBS ANA VERTEILUNG starts a corresponding ABAP for the construction of the capacity analysis EMC ViewPoint for SAP Modules Utilities User Manual Figure 77 Analyzer Plus The document distribution selection screen appears as shown in Figure 77 Document Distribution before archiving 12 2003 ak M a M Document distribution selection screen 2 Enter information for the following fields Name document run Descriptive title for the analysis run From entry period year Enter the beginning month and year for analysis To entry period year Enter the ending month and year for analysis Module list area Select the modules to be included in the analysis run
46. SAP environment and SAP authorization no longer works Inthe file system of the target computer c Inthe file system of the application server d usr sap Protect exported data against unauthorized access Fiscal Year Reporter audit access Fiscal Year Reporter Export programs Table 16 lists those programs which support the export of data from the SAP system using ViewPoint for SAP FYR Asset accounting data is not selected with the ViewPoint for SAP archive but using SAP Table 16 Export programs Program name PBS FYR LIS Description Variable Logical Database Table F Description ITEM item list PBS YBF BKPF _K document header BSEG _G document item BSET _T tax line BSED _D bill of exchange line BSEC _C CPD line ITEM ASSET asset item list ADA ANEK K document header ANEPV document item VENDOR vendor list PBS YKF LFA1 _A vendor master in general master data LFAS _T EU taxes LFB1 B vendor master company code LFB5 M reminder data LFC1 _1 transaction figures LFC3 _3 special general ledger transactions CUSTOMER customer list PBS YDF KNA1 _A customer master in general master data KNAS _T EU taxes KNKA _L credit limit KNB1 B customer master company code KNB4 _Z payment history KNB5 _M reminder data KNC1 _1 transaction figures KNC3 3 special general ledger transactions E
47. SSET Asset master data values and movements IH Index Construction screen Table 20 lists the traffic light definitions that help determine whether it is necessary to generate indices for each corresponding archiving object Traffic light status definitions Data Retention Tool Color Definition Red The archiving object is not archived Yellow Index generation is incomplete and must be generated for objects Green All existing archive data is indexed 3 Click on a line with a yellow status Archiving ViewPoint for SAP modules data Data Retention Tool The index generation screen displays so the missing index generation can be completed resulting in the color definition changing to green Note CDART data extraction should only be carried out when all traffic lights are green or red 4 Clickthe i function key for additional index information A popup displays the table fields for that archiving object 5 Use transaction SE16 and enter the table PBS DART INDEX to display all available indices Manual entry Use the menu item Utilities gt generate index directly to manually enter the archiving object EN EMC ViewPoint for SAP Modules Utilities User Manual Data Retention Tool The manual index construction screen displays as shown in Figure 58 without the traffic lights to show indices status Generation program CDART Archive 61 11 2004 9 999 9
48. The analysis data is stored in database tables PBS ANA BE LEN and PBS ANA_BE_TXT under a sequential run number and can be analyzed as described next in Analyze document distribution on page 120 Document distribution analysis Analyzer Plus Analyze document Table 22 lists the ABAP 4 programs used for the document distribution distribution analysis Table 22 ABAP 4 area analysis Program Area PBS ANA_BKPF Document distribution financial accounting BKPF PBS ANA_VBUK Document distribution sales VBUK PBS ANA_EKKO Document distribution purchasing EKKO PBS ANA_COBK Document distribution cost accounting COBK PBS ANA_COEP Document distribution COEP PBS ANA_AUFK Document distribution order PBS ANA_MKPF Document distribution material document PBS ANA_MARA Document distribution material record The following example follows the document distribution analysis for financial accounting with the program PBS ANA_BKPF EMC ViewPoint for SAP Modules Utilities User Manual Figure 78 Selections Sort by Analyzer Plus Starting PBS ANA_BKPF displays the financial accounting selection screen as shown in Figure 78 es Client Company code Calendar year Document type Document analysis run no Client Company code Calendar year Document type Calendar period Financial accounting docume
49. alance Audit Trail from the Document File PBS YYUMSVOD Advance Return for Tax on Sales Purchases Reports with customer database YDF IPBS YYDSLDOO Customer Balances in Local Currency Reports with vendor database YKF IPBS YYKSLDOD Vendor Balances in Local Currency R Reports with g 1 account database YSF PBS YYBILAOD Balance Sheet P L IPBS YYSSLDOO G L Account Balances Logical database 1PBS SAPDBYBF Document database PBS Fiscal Year Reporter PBS SAPDBYDF Customer database PBS Fiscal Year Reporter PBS SAPDBYKF vendor database PBS Fiscal Year Reporter PBS SAPDBYSF g l account database PBS Fiscal Year Reporter Fiscal Year Reporting selection screen The balance audit trail programs YYHABU01 and YYKKBUOI available up to release 4 6 have an improved sort technique Note Programs YYKKBU01 and YYHABUO use the same temporary sort path Do not run them simultaneously as background processes EMC ViewPoint for SAP Modules Utilities User Manual Fiscal Year Reporter audit access Audit access strategies ViewPoint for SAP FYR provides the following audit access types Access 1 Z1 indirect data access Allows a tax authority read only access to stored data for the audit period including the master data and links data excluding remote queries online access The read only access covers reading filtering and sorting data using the evaluation functionality of the data processing system Access 2 Z
50. altung Transportbedarfe 28 0 0 0 0 SD VTTK SD Transporte 10 0 0 0 0 VTTK Anz 8 Byte 1 243 SD COND Konditionss tze der Preisfindung 7 0 0 0 0 KONH Anz 13 726 Byte 1 RL_LINV MM WM Lagerverwaltung Inventurz hls tze Histori 6 0 0 0 0 MM INVBEL Materialwirtschaft Inventurbelege 4 0 0 0 0 FM BELEG Obligo Ist Einzelposten Finanzbudgetmanagement 0 0 0 0 0 FM BEL CA Obligo Ist Einzelposten Finanzmittelrechnung 0 0 0 0 0 RL LINKP MM WM Lagerverwaltung Inventuraufnahmebelege 0 0 0 0 0 RL LUBU MM WM Lagerverwaltung Umbuchungsanweisungen 0 0 0 0 0 Figure 90 Document size example 132 EMC ViewPoint for SAP Modules Utilities User Manual Analyzer Plus An overview of the number of posted documents for each period appears using company code client 800 as shown in Figure 91 Selection Client 800 entry year 1995 Formation of Pool 1 Client 2 Company code 3 Posting period PBS DB ANALYZER VERTEILUNG BUCHHALTUNGSBELEGE DOERRSCHUCK Lauf 0001 01 1990 12 1998 Datum 23 02 1998 PBS ANA BKPF Beleggr e Byte 1 644 BELEGVERTEILUNG IDES Seite a MANDT BUKRS PERIOD Anzahl Gr e KB Gr e 800 0001 06 I 2 0 02 800 0001 1 2 0 02 800 000 01 162 260 3 84 800 000 02 106 170 2 51 800 000 03 47 75 T dist 800 000 04 50 80 1 18 800 000 05 557 894 13 20 800 000 06 776 1 246 18 39 800 000 07 351 564 8 32 800 000 08 181 291 4 29 800 000 09 206 331 4 88 800 000 10 137 220 3 25 800 000 IX 119 191 2 8
51. ample the table AP ORD PRE is a view which is assigned to table AFKO The sizes of both tables are the same BIN EMC ViewPoint for SAP Modules Utilities User Manual Analyzer Plus Double click on a table to show the corresponding archiving objects For example the entry VBAK shows that the table is assigned to the archiving object SD_VBAK as shown in Figure 74 SD_VBAK Figure 74 Table archiving assignation The result of a capacity analysis without details is appears as shown in Figure 75 g 1H 888 Bas eoa m OB PBS DB Analyzer PLUS Evaluation capacity document a PBS DB Analyzer Disk space occupancy of arch objects Time 16 10 49 HEMMING Run number 8825 from 22 11 2802 1 704 524 KB Date 21 81 2003 YYCSANAK Aufbau nach Archivierung mit Einzeltabellenanalyse Page 1 Size of selected data 2 1 704 524 KB Portion of total size 2 Figure 75 Capacity analysis without details Capacity analysis 115 Analyzer Plus Comparison analysis Figure 76 ViewPoint for SAP modules are marked in red with the names of the archiving object for which they can be used displayed in the line below ViewPoint for SAP modules used with multiple archiving objects display multiple times Note ViewPoint for SAP module names are associated with the object on the line directly below Objects without a ViewPoint for SAP module displayed directly above are not assigned to any ViewPoint for SAP module Use the
52. are included in this object The ViewPoint for SAP module for each archiving object checked can be displayed in the evaluation revealing which ViewPoint for SAP modules are relevant Single tables can be added for analysis during the next capacity run The results are displayed separately in the analysis and the archiving objects belonging to that table can be displayed Document distribution analysis provides information on the temporal distribution of the entered documents defined by any selection and grouping criteria The client and period are available as grouping criteria with other module dependent features available EMC ViewPoint for SAP Modules Utilities User Manual Archiving check Analyzer Plus such as company code and document type in the ViewPoint for SAP FI module A distribution analysis assigns documents according to the time they were entered by determining the number of existing documents by period Combined with the archiving check the distribution analysis also ensures successful archiving for selected SAP modules The archiving check determines if documents can be archived After the document distribution analysis check documents of a certain period the archiving check examines existing documents for archivability or displays the reason the document is not ready for archive This analysis is also available for selected SAP modules Overview 105 Analyzer Plus Capacity analysis Table
53. ays Running the Translation Tool EN Translation Tool EN EMC ViewPoint for SAP Modules Utilities User Manual 4 Check ADK The ViewPoint for SAP Check ADK utility is supplied as part of the ViewPoint for SAP modules utilities and does not need any other ViewPoint for SAP transports to be previously imported The Check ADK runs with the basis programs of SAP AG D 69190 Walldorf Baden system R 3 releases 4 0 4 5 4 6 R 3 Enterprise correction levels a to c This chapter includes these topics ROTE rome ts ss cen DX EID ID M dE 52 Ronning Check ADR iiaueo sene nonne ae iratus 53 Check ADK EN Check ADK Overview Table 8 The ViewPoint for SAP Check ADK utility serves as an error analysis tool in case of access problems to ViewPoint for SAP index files or SAP archive files The Check ADK transport does not require another ViewPoint for SAP transport and can be run independently of any type and number of installed ViewPoint for SAP modules The Check ADK Utility checks the following ViewPoint for SAP modules Production Orders CPP Controlling Line Items CCO Plant Maintenance CPM Material Master Data Batches Special Stocks and BOMs CMT Process Orders CPR Costing Based Profitability Analysis CCOPA Master Data Changes CCU Purchasing CMM CO Orders COO CO Line Items CPCA Project Systems CPS Line Items in FI SL CSL Warehouse
54. bles Figure 4 Table 2 Follow this procedure to select ViewPoint for SAP module tables using Archive Browser 1 Make entries in the Archive Browser initial screen fields as shown in Figure 4 and defined in Table 2 2 Click Enter v 1H 888 PBS Archive Browser initial Screen g D cr HH Archive Browser initial screen Archive Browser screen field definitions Archive Browser Field Definition Table name Enter the table name Note This procedure uses table BKPF from the Financial Accounting and Material Documents CFI module as an example Selecting tables Archive Browser Table 2 Figure 5 Archive Browser screen field definitions continued Field Definition Archive Enter the name of the ViewPoint for SAP module if the table exists in several ViewPoint for SAP modules Option This field is used to query CSD module tables for orders delivery notes invoices etc 1 Arch Db 2 Db 3 Archive Enter whether the tables should be displayed from the Database and archives 1 Database only 2 calls SAP Data Browser transaction SE16 Archives only 3 of the previously selected table Note If a table is available in the different module archives you have to delimit exactly For example the table CDHDR is available in the CFI CMM and CSD modules The table BKPF index screen appears as shown in Figure 5 Di
55. ct FI DOCUMNT 56 EMC ViewPoint for SAP Modules Utilities User Manual 5 Class Order ViewPoint for SAP Class Order is an administrative tool for use with Development Class PBS ORDER This chapter includes these topics Class Order Class Order Overview ViewPoint for SAP Class Order applies to the following ViewPoint for SAP modules Project Systems CPS Production Orders CPP Plant Maintenance CPM Process Orders CPR As these modules functionalities are closely related there is also a close relationship between program sources The ViewPoint for SAP Class Order module was created to handle any version management issues EMC ViewPoint for SAP Modules Utilities User Manual Class Order Development Class PBS ORDER Class Order addresses rare situations where installing different modules with partly overlapping objects may cause an older transport to overwrite newer objects in a related transport by combining those objects into one module transport These objects are integrated in the Development Class PBS ORDER The development class PBS ORDER is not a full ViewPoint for SAP module It is a part of the ViewPoint for SAP modules CPP CPM CPR and CPS Import of the development class PBS ORDER when using one these modules When using more than one of these modules import the development class PBS ORDER only once Since the Development Class PBS ORDER corrects any
56. customer records general 113 Amount records customer credit limit 24 Amount records vendor EU tax ref no a Amount records customer bank data 33 Amount customer records Company Code 113 Amount records customer payment struc 71 Amount records customer Dunning data 81 Amount records customer credit data 54 Amount customer records transact fig 113 Amout records spec gen led customer 9 Amount records g l acc general n Amount records g l acc texts 718 Amount records g l acc Company Code 718 Aomunt reocords g l acc transact fig 718 Selected company codes CC from FY to FY 1800 1995 Figure 39 Selection result for saved master data Extract master data at fiscal year closing 6 Fiscal Year Reporter Fiscal Year Reporting Figure 40 Direct accesses to saved master data in logical databases can be done as follows vendors YKF customers YDF G Laccounts YSF ViewPoint for SAP predefined fiscal year closing programs are called using transaction YEAR Reporting as shown in Figure 40 AD e a gd 888 DAR nonas ra gm gt PBS Fiscal year reporting amp Select PBS Fiscal year reporting 24 11 1999 Report Description O Reports with document database YBF IPBS YYAUSZOD Statements for Customers Vendors 6 L Accounts PBS YYBELJO0 Compact Document Journal IPBS YYHABUOT General Ledger from the Document File IPBS YYKKBUBT pen Item Account B
57. d 4 5 EN EMC ViewPoint for SAP Modules Utilities User Manual Archive Browser 3 Role IPBSIPBS PBS archive add ons gt CJ Accounting D 1 Logistics D CJ Human resources D Master record changes 7 C3 Utilities 2 C3 General tools XD Archive browser O Conversion select command Research transport Translation tool gt 3 PBS database analyzer Figure 2 ViewPoint for SAP utilities release 4 6 Starting Archive Browser EN Archive Browser Figure 3 Displaying Archiver Browser accessible tables To display the list of Archive Browser accessible tables for use with transaction PBS SE16 place the cursor in the table name field of the initial screen of the Archive Browser and press F4 or click Enter The list of available tables appears as shown in Figure 3 4016 Contract Item 4019 Contract Header A068 Outline Agreement Item Plant Dependent 4081 Contract Conditions at Plant Level 4082 Contract Conditions without Plant ADRC Addresses central address admin AFFL Work order sequence AFFLD Order Dialog table for order sequences AFFL AFFW Goods movements with errors from confirmations AFKO Order header data PP orders AFPO Order item AFPOD Order item dialog structure AFRU Order completion confirmations AFRUD Dialog table for completion confirmations AFVC Operation
58. determination of the document size for the archiving objects appears from the applications SD MM and FI using the following criteria as shown in Figure 90 Selection Application SD MM FI Formation of Pool Archiving object Sorting Size Options Determine document size zero values PBS DB ANALYZER PLATTENPLATZBELEGUNG VON ARCHIVOBJEKTEN Zeit 16 13 49 DOERRSCHUCK Kapazit t Lauf Nr 0001 vom 19 02 1998 1 086 618 KB Datum 20 02 1998 Kapazit tsanalyse IDES vor Archivierung Seite 1 Kapazit t der selektierten Daten 402 483 KB Anteil Selektion am Lauf 37 Objekt Objektbezeichnung Summe KB Sel Ges FI_DOCUMNT Finanzbuchhaltungsbelege 144 641 35 9 1373 BKPF Anz 90 074 Byte 1 644 SD VBAK Verkaufsbelege 60 027 14 9 5 5 VBAK Anz 10 041 Byte 6 122 FLC OBJECT Summens tze und Einzelposten im FI LC 36 007 8 9 353 SD VBRK Fakturen 31 074 7 7 2 9 VBRK Anz 10 155 Byte 35133 MM EKKO Einkaufsbelege 30 484 7 6 2 8 EKKO Anz 9 669 Byte 3 228 FI ACCOUNT Sachkontenstammdaten 29 956 7 4 2 8 SKA1 Anz 47 149 Byte 651 RV LIKP Lieferungen 22 430 5 6 2 1 LIKP Anz 7 024 Byte 3 270 MM MATBEL Materialwirtschaft Materialbelege 20 437 5 1 1 9 MM MATNR MM Materialstamm 17 588 4 4 1 6 MARA Anz 2 810 Byte 6 409 MM EINA Einkaufsinfos tze 5 585 1 4 0 5 EINA Anz 2 217 Byte 2 579 SD VBKA Kontakte 39 0 0 0 0 VBKA Anz 12 Byte 3 287 FI BANKS Bankstammdaten 29 0 0 0 0 RL TB MM WM Lagerverw
59. djustment Vendor items BFIT A8 FI Subseq BA PC Adjustmnt zero Bal Postings for BSIK Accounting Secondary Index for Vendors BSIP Index for Vendor Validation of Double Documents BSEC One Time Account Data Document Segment RFO48 Subseq BA PC Adjustmnt Index Distributn Vector BSED Bill of Exchange Fields Document Segment STXL STXD SAPscript text file lines COPOS Change document items STXH STXD SAPscript text file header BVOR Intercompany posting procedures BFO D AB FI Subseq BA PC Adjustmnt Valuatn Diffrnce in C BF K AB FI subseq BA PC adjustmnt Valuatn difference in BFO_A_RA Versions for Resetting Cleared Items BSEGC Document Data on Payment Card Payments BSIU Index table for customer bills of exchange used moo Comparison analysis results EMC ViewPoint for SAP Modules Utilities User Manual Analyzer Plus Capacity analysis The displayed total capacity is the sum of all archivable tables An display index created on the database level is not analyzed unless it is a Microsoft SOL database index table Otherwise index table size is about 50 of the total capacity Movement data and master data not allocated to an archiving object is not included in the capacity analysis Capacity analysis 117 Analyzer Plus Document distribution analysis Initialization Database analysis This section describes how to analyze document distribution using the ABAP 4 program
60. ds for this table are displayed in this selection screen 4g eae num anna Hm 9m PBS Archive Browser Tabie BKPF Selection Screen amp Eh El Number ofentries Figure 7 Selection screen for table BKPF 5 Enter the field delimiters Enter delimiters for the index fields and for the primary index in particular Without entries the query runs through all data records resulting in long run time depending on data volume If the primary index is not delimited and error message appears as shown in Figure 8 amp Please go on delimiting selection Figure 8 Error message for primary key with no delimitation The index fields with delimiters appears as shown in Figure 9 1H CGO BAR SoS am au PBS Archive Browser Tabelle BKPF Selektionsbild Q amp BL EM Anzahl Eintr ge fof a TS 760007010 FE Figure 9 Table BKPF delimiters 6 Click Enter 24 EMC ViewPoint for SAP Modules Utilities User Manual Archive Browser The query results for the example delimiters displays as shown in Figure 10 PBS Archive Browser Tabelie BKPF 4 Treffer UM r M A s E ES G HI Tabelle BKPF Angezeigte Felder 10 von 69 Feststehende F hrungsspalten Listbreite 0080 8188801881 1996 8188881882 1996 8188881883 1995 8100001004 1996 Figure 10 Query results with delimiters Column A is marked with an asterisk for archived documents and is empty for documents still available in t
61. e SAP archiving run are indexed Process sequential number range Specify the range of documents to be processed Executing several runs with a limited number of documents allows for best processing time and job handling Note For SAP release 4 6 and prior extend the paging area in the system profile for the sorting of indexes if the process run terminates with the error message SYSTEM NO MORE PAGING For SAP releases after 4 6 a directory is assigned for sorting with the system parameter DIR SORTTMP that can be extended in a 32 bit operating system to avoid any sorting problems Archives already processed are neither automatically recognized nor is a check carried out if intervals overlap EMC ViewPoint for SAP Modules Utilities User Manual Figure 60 Postprocessing programs Archive tool Data Retention Tool Merge In CDART the index is kept in ADK files which requires a new ADK number for each run of the index generation program New archive is active for each new index compilation and Merge with archive is active with the previous ADK run number for the subsequent merge as shown in Figure 60 Merge O Merge with archi 8 Run amp new archive 9 Merge with archi 28008 Run O new archive Above Before the Ist run Below Proposal for merge run To reduce runtimes use new archive to create a second index stock that is not merged with the first The CDART reading routines read
62. e analysis evaluation 110 Comparison analysis 116 Capacity analysis display 117 Document distribution analysis sss 118 InitialiZatiOn eerte rates 118 Database anal ysis ecce perierit tate 118 Analyze document distribution sss 120 Branching to the archivability check 123 Comments on the document distribution 123 Archivability check eese tetti teniente kno 126 Checking archivability sss 126 Financial accounting documents 126 Sales documents tenies 127 Purchasing documents 128 honleto M 128 Capacity analysis examples sse 129 Document distribution analysis examples 133 EMC ViewPoint for SAP Modules Utilities User Manual Audience Preface As part of an effort to improve and enhance the performance and capabilities of its product lines EMC periodically releases revisions of its hardware and software Therefore some functions described in this document may not be supported by all versions of the software or hardware currently in use For the most up to date information on product features refer to your product release notes If a product does not function properly or does not function as described in this document please contact your EMC representative This document is part of the ViewPoint for SAP doc
63. e executing the CDART extraction This index points to the location of the archive data Follow this procedure to generate the module index for CDART 1 Start the index generation using menu option Utilities gt Generate index archive data or transaction PBS DART SETUP The index generation menu displays as shown in Figure 56 Index Cust Index Generation HIGG EE AB EL Generate PBS archive add on CDART index archive data Figure 56 Index generation menu The indices are stored in the archiving object PBS DART Note The path assigned to the archiving object must be stored in the file system and there must be enough disk space to write the indices to disk as described in Archiving object PBS DART on page 93 Each indexed SAP ADK file requires an additional 5 percent of disk space more than needed by the physical ADK file 2 Select menu option Index gt Index Generation EMC ViewPoint for SAP Modules Utilities User Manual Figure 57 Table 20 The Index Construction screen appears as shown in Figure 57 Index Construction a a FI Financial Accounting D FI DOCUMNT Financial Accounting Documents Hi SD Sales and Distribution D eeg Rv LIKP Deliveries Hi D e o sb vBAK Sales Documents Hi D eco SD_YERK Billing Documents HH MM Materials Management D eoe MM_EKKO Purchasing Documents HH D eco MM MATBEL Materials management Material documents HH AM Asset Accounting D eco 1M A
64. ear Reporter documents and master data To use an own program to select the transactions of a fiscal year according to the posting period and all items cleared in this fiscal year change the logical database from BRF to YBF Add to the own program the following statement after START OF SELECTION to deactivate the check on the posting period in the logical database GJ ONLY space ViewPoint for SAP reads sequential versions of master data similar to SAP Use this database to process only master data with no documents selected as there is no secondary index link between the customer and the ADK file YY YR yyyy This database does not correspond to the SAP standard database DDF because customer master data of Fiscal Year Reporter only is processed Use this database to process only master data with no documents selected as there is no secondary index link between the vendor and the ADK file YY YR yyyy This database does not correspond to the SAP standard database KDF as only the vendor master data of the Fiscal Year Reporter are processed Use this database to process only master data with no documents selected as there is no secondary index link between G L and the ADK file YY YR yyyy This database does not correspond to the SAP standard database SDF as only the G L account master data of the Fiscal Year Reporter is processed Aaministration Fiscal Year Reporter Master data direct access Change extract stock descrip
65. eat ne B Lc taxbase amount FE Taches amount B Lo taxamount B Amount E Transaction I conditon record no FE VAT registration no B County ofdesinat E Supphing country EMC ViewPoint for SAP Modules Utilities User Manual Bassen Kol mn i Epe cpze Access types Z1 and Z2 delimitations Data format Table 15 lists the SAP AIS format structure Fiscal Year Reporter Table 15 SAP AIS format Line type Number Characteristic value Header 1 Field name 2 Description 3 Field description 4 Data type C N PI 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 l 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 5 Field length 6 Number decimal places 7 Currency code or quantity indicator F W M E 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 8 Special field types R C P M R rank statistics C counter statistics P percentage statistics M mean value statistics Data line 9 Data records Safety After the export the data leaves the
66. en into account during the extract Document types are displayed for selection in the extract program after settings are selected For CDART use transaction data gt additional transaction data gt data reloaded from archives to set extract archive data via ViewPoint After all DART definitions are complete the extracts can be created using Utilities Extract data Select Extract archive data via ViewPoint to automatically select the archive data in the index of ViewPoint for SAP module and transfer it to the extract stock Archiving ViewPoint for SAP modules data 101 Data Retention Tool Further processing of Use Information system to start the DART extract browser to view the extract and check extracted data as shown in Figure 63 PBS CDART Extract data Companycode 2004 PostngPa os eis 99009 000 o o UEM LEM KK K E K IS ISI ELT E PBS DART 12200 Directory se PRS_DART ip PBS DART 12 2004 Figure 63 Data extract browser Export view data from the extracts for auditing using Z3 access To evaluate CDART extracts outside the SAP system on a PC refer to the ViewPoint for SAP IDA module Independent DART Access a separate module 102 EMC ViewPoint for SAP Modules Utilities User Manual 8 Analyzer Plus This chapter includes these topics 99999 KEITEN S e reich eb iate aT a d E 104 Capacity anal 106 Document distribution analysis c remm 1
67. entries Single stocks can be deleted if several stocks exist for a fiscal year because of splitting by company code Use Delete master data to delete fiscal year and company code compressed master data from the table YVKZ for SAP version 4 x PBS YVKZ Use Activate reporting to copy SAP programs using logical database BRF to the Fiscal Year Reporter database YBF Use Balance audit trail gt Delete sortfile to delete the sortfiles created in the temporary sort directory if the balance audit trail tools YYHABU01 or YYKKBUOI are cancelled during processing This re initializes the path for the temporary sortfiles EN EMC ViewPoint for SAP Modules Utilities User Manual Master data Transaction data Logical database SAPDBYBF document database SAPDBYDF customer database ViewPoint for SAP Fiscal Year Reporter database SAPDBYSF G L accounts database Fiscal Year Reporter For each fiscal year a Master data list appears showing those company codes for which a data backup has been carried out using Fiscal Year Reporter For each fiscal year a Transaction data list appears showing which backup runs have completed A fiscal year is listed several times if a backup was run for each company code Click Protocol to display all delimitations used for the backup run Choose one of these logical databases to access the data stock of the Fiscal Year Reporter SAPDBYBF reads sequential versions of saved Fiscal Y
68. erce eg 83 Master data direct access ceeeeseseesseesenenensnennensnnenennnennnnn nennen nenne 84 Change extract stock description 84 Display reconciliation differences sssss 84 Clear archive file name ss 84 Manually create an archiving object 84 Data Retention Tool uui 86 SAP DART data flow 86 CDART transaction data 87 Using CDANRT nere repertoire tte 90 Creating the CDART Easy Access menu 90 Customer specific fields 92 Data Source ie ine hear 92 Archiving object PBS DART sese 93 Archiving ViewPoint for SAP modules data 94 Postprocessing programs 99 Archive tool u no de ee me t beoe ard 99 Deletion tool tisane 100 Iouis A 101 Analyzer Plus Bridal M 104 Capacity analysis encres enmienda 104 Document distribution analysis 104 Atchiving check aetate neon menia niei 105 Capacity arialysis cseee teet enr ir iR re eoe reete diues 106 Initializationi codes amd ee eiecit 106 Capacity analysis 106 EMC ViewPoint for SAP Modules Utilities User Manual EM Oracle database eec etit tian 108 Informix database sis scies 108 AIS A00 database anna 108 Correction of capacity commitment SAP 4 0 108 Single table analysis 108 Databas
69. ete database documents Use YEAM gt Transaction data gt Save to create the transaction data stock at the end of the fiscal year as shown in Figure 36 2 98 eee anb S555 mg 9m Backup transaction data in reconcilation per company code amp amp lt E Home 1 B is qe Document number to Technical settings 7 Use database Use archive Selections Fiecalysar 1998 Validation Only recone DacMaster rec e Reconciliation and backup LI Description of Backup Fiscal year 1998 24 11 1999 STEFFEN Selection screen to save transaction data Note A fiscal year stock can only be created if the posting periods of the fiscal year are marked closed Multiple stocks can be created for a fiscal year if each extract stock is given a unique name for reporting purposes Run the Fiscal Year Recorder in the background unless the run is for testing purposes Extracting fiscal year closing transaction data Fiscal Year Reporter Fiscal Year Reporter At the end of each extract run the delimitations and the reconciliation results are printed in detail as shown in Figure 37 Spool Request 0000011405 1H eee BAR unon MA om Spool Request 0000011405 B3 ee Hex Number of list lines Backup transaction data in reconcilation per company code Company code IEQ1000 Use database x Use archive x Sel SAP Archive 000368 001F1_DOCUNNT 000368 002FI DOCUMNT 88037
70. extraction from a predefined volume That data is then stored in external data media or on a file server for compliance purposes Data views can be made available to the tax authority in the event of an audit The ViewPoint for SAP CDART module extends the SAP DART functionality so that the SAP ADK files DART extract runs are integrated avoiding temporary reloading of archive data into the database The data access is executed through indices generated with the CDART Tool Database performance improves since permanent storage capacity is not provided for extract stocks until they are used EMC ViewPoint for SAP Modules Utilities User Manual Data Retention Tool The stocks are created on demand following the ViewPoint for SAP CDART module data flow as shown in Figure 51 SAP Database Jotine Data Data medium PBS nm Extract Archive Index Transaction data pad Transaction data eus ADK Archive Development Kit Master data Master data Flat file Figure 51 ViewPoint for SAP CDART module data flow CDART transaction Table 18 gives an overview of transaction data affected by archiving data and extracted from the archive using CDART All other segments have master data transaction figures or are not affected by archiving Table 18 CDART transaction data Original Segment structure DART Description ANEK TXW_AD_HD
71. fferent PBS indices are available for selected table Please choose one of them Table Key 1 Key 2 Key 3 Key 4 bl vRRBHX Table BKPF index screen EMC ViewPoint for SAP Modules Utilities User Manual Archive Browser 3 Select an index combination Include as many fields as possible for later selection and index sequential data reading thereby shortening query run time Note When there is only one index for a table within the selection of a ViewPoint for SAP module the field selection list displays For example selecting the indexes BUKRS and BELNR generates a display in which both index fields are marked and can t be deselected However you can select additional search fields as shown in Figure 6 Choose the table fields for the selection conditions 4 Too many table fields for selection max 40 Company code Document number Fiscal year Document type Document date Posting date Posting period Entry date Time of entry Changed on Last update Translation date User name Transaction code Cross co code no fo a i vBBBaOx a z Hi Figure 6 Example of selected and potential index field combinations 4 Click Enter to confirm the entries Selecting tables Archive Browser The selection screen with the selected indexes appears as shown in Figure 7 The index fields and possible additional fiel
72. gsdaten VBAK Verkaufsbeleg Kopfdaten VBPA Vertriebsbeleg Partner KONV Konditionen Vorgangsdaten VBFA Vertriebsbelegflu CDPOS nderungsbelegpositionen NAST Nachrichtenstatus STXH STXD SAPscript Text Datei Header CKIT Texte zu CKIS CMFP Speicherstruktur f r die gesammelten Fehler VBKD Verkaufsbeleg Kaufm nnische Daten VAPMA Vertriebsindex Auftragspositionen zu Material VBUK Vertriebsbeleg Kopfstatus und Verwaltungsdaten KEPH Herstellkostenelemente der Erzeugniskalkulation VAKPA Vertriebsindex Auftr ge zu Partnerrollen VBUP Vertriebsbeleg Positionsstatus CDHDR nderungsbelegkopf SD_COND Konditionss tze der Preisfindung KONM Konditionen Mengenstaffel 1 dimensional KONW Konditionen Wertstaffel 1 dimensional Figure 87 Sales module example The output of all archiving objects belonging to the sales module appears using the following selection criteria as shown in Figure 87 Selection Application SD Formation of Pool Archiving object Sorting Size Options Details 16 06 26 Datum 20 02 19 Summe Gr e Capacity analysis examples DOERRSCHUC 98 DORPRPRPRPRFPRPRENNNWWWAERADAN mn de Gu Re ke TR 1e a Gel SE a Um ae OS A TS UJ XO P IN N UO 0 O Oo H N P Ul UI H H c 0 K ooooooo000000000o0o0o0o0u SAS ASS ee SO A SA A Ni OPPREBPEPEPENNNNWWAKBKROAD YU Analyzer Plus Analyzer Plus The output of all archiving objects appears using
73. have been stored PROG ZZABHELP PBS AB_HELPRQ Help Request for AB PROG ZZABCODE N A Code generation for AB PROG N A PBS TAB_ARCHDEF Delete table entries of PBS TAB_ARCHDEF with TAB_TYPE EQ SPACE TABL N A PBS TAB_ARCHDEF DB table where all available ViewPoint for SAP modules transaction PBS SE 16 their tables and indexes have been stored TABU N A PBS TAB_ARCHDEF Entries for ViewPoint for modules their tables and indexes TRAN Z716 PBS SE16 Start transaction Overview Archive Browser Starting Archive Browser Follow this procedure to start ViewPoint Archive Browser 1 Execute transaction PBS SE16 release 4 0 and later or ZZ16 release 3 x and prior or navigate through the ViewPoint menu via PBS EMC release 4 0 and later or YPBS release 3 x and prior 2 In the ViewPoint for SAP menu select Utilities gt General tools gt Archive Browser The utilities menu screen appears as shown in Figure 1 or Figure 2 on page 19 X alaHeee Baum anaa A 9m Menu of utilities of the PBS archive add ons a Menu of utilities of the PBS archive add ons Copy transfer order Report PBS UTILTP81 Convert select statement Report PBS UTIL CONVERT Call archive browser Report PBS UTIL ARCHIVEBROUS Determine transport requests Transaction PBS UTIL_Z9CP Call translation tool Report PBS UTIL TRANSLATE Figure 1 ViewPoint for SAP utilities releases 4 0 an
74. he database Note To view the data in the ALV display first display the data using SE16 and then switch to the ALV display Selecting tables 25 Archive Browser Database table PBS TAB ARCHDEF The Archive Browser displays tables and their contents accessible with the function module PBS SELECT INTO TABLE when created in the database table PBS TAB_ARCHDEF This table structure and contents are delivered as objects of the Archive Browser transport as shown in Figure 11 Data Browser Table PBS TAB ARCHDEF Select Entries s cam BR Aw ausa mes 709 ER T TYPEPBS ARCTAB NAMESCHI scH2 os SCH4 OPT TAB_SCHI TAB_SCH2 TAB_SCHS Mi TAB_SCH4 COEP COEP COEP COEP COEP COEP COEP BKPF BKPF BKPF BKPF BKPF BKPF MSEG MSEG MSEG MSEG MSEG MSEG MSEG Figure 11 Extract of table PBS TAB_ARCHDEF contents The field TAB_TYPE defines if the table is delivered from SAP TAB TYPE 1 customer specific TAB TYPE 2 EMC ViewPoint for SAP Modules Utilities User Manual MSEG MSEG MSEG Preselected tables Figure 12 Some tables for example table EIKP in the ViewPoint for SAP MM module can be accessed with index fields that are not in the table structure as shown in Figure 12 Different PBS
75. he layout in which the fields to be extracted were not defined do not exist or were not stored when the layout was created PC analysis programs terminate with the message SAP AIS file is invalid during the transfer of export files from UNIX Windows NT to PC if the transfer was executed in BINARY instead of ASCII mode For SAP version 4 0 4 5 regenerate the export structures with the program PBS FYR LIS GENERATE to eliminate wildcard characters if the export structures do not fit to the data table structures Fiscal Year Reporter audit access EN Fiscal Year Reporter Administration Use the menu transaction YEAM or YEAR for administrative tasks Note These tasks should be available to administrative personnel only Table 17 lists the transactions to add to the user profile for the user department and the administrator Table 17 YEAR Release Administrator User department 3 x Y YEAR YR02 YR06 YR07 YR11 4 X PBS Y PBS YEAR PBS YR02 PBS YRO06 PBS YR07 PBS YR11 Delete transaction data Delete master data Activate reporting Balance audit trail cancelled during processing The transaction YEAM should be made available to administrators only to modify data material To delete master data use transaction S ARCHIV F authorization for object FI DOCUMNT with 01 create Use Delete transaction data to delete fiscal year ADK files and all corresponding administration
76. how the logical file name is composed Note Be sure to update previously created stocks while changing logical physical file names Use program YYCFOBJC version 4 0 PBS YYCFOBJC to manually create an archiving object without having to wait until the archiving object is automatically created after transaction data is stored for one fiscal year EM EMC ViewPoint for SAP Modules Utilities User Manual Data Retention Tool This chapter includes these topics w OVEN O nennen 86 e Uaine CHART ee 90 Archiving ViewPoint for SAP modules data 94 Data Retention Tool EN Data Retention Tool Overview SAP DART data flow Figure 50 ViewPoint for SAP CDART data flow The SAP Data Retention Tool DART or SAP Z3 scenario facilitates compliance with tax authority requests for data extraction of business records The SAP DART is an alternative solution to SAP BW SAP queries and ABAP reports in the SAP environment following the SAP DART data flow as shown in Figure 50 SAP Database C Dons baia Data medium Temporary p b EH Extract Retrieval Table Tr tion dat ansaction data E Transcation data SAP Lo o e Archive Master data Master data ADK Flat file Archive Development Kit SAP DART data flow SAP DART is included in the SAP standard installation and enables data
77. indices are available for selected table Please choose one of them Table Key 1 Key 2 Key 3 Key 4 Table EIKP index fields None of the indicated index fields in this example EBELN LIFNR and MATNR of table EIKP is a field in this table structure Preselected tables Archive Browser Archive Browser Selecting the document number as an index field for a selection adds it to the table structure as shown in Figure 13 Too many table fields for selection max 40 a e Choose the table fields for the selection conditions Purchasing document Number of foreign trade Delivering country Mode fTrnsprt Border a a Customs office ffice fDestination Customs office 1 Customs office Customs office Customs office Customs office Customs office 6 Mns of trsp border Means of transport Origin MT Border nem PIL BEEN ERA x Figure 13 Table EIKP selection fields list The checkbox for the selected index field EBELN is marked automatically because the selection has to be made for at least one or more index fields Note Option 1 access to archive and database data cannot be used for tables that include index fields that were added automatically You can access only the database or the archive data for these tables or the Option 1 parameter error message appears as shown in Figure 14 e Only PBS parameter 2 or3 are possib for this table Figure 14 Option 1 error message
78. int for SAP 3 x Description PROG PBS UTIL CONVERT SAPMYCON Conversion Tool PROG PBS UTIL CONV DUMMY ZZZDUMMY Dummy program FUGR PBS UTIL CONVERT ZARC Function group for archive access TRAN PBS UTIL CONVERT YCON Start transaction EMC ViewPoint for SAP Modules Utilities User Manual Conversion Tool Running the Conversion Tool Follow the procedures in this section to convert an ABAP 4 program for use with a ViewPoint for SAP module Note The procedures in this section use YYCONV02 as an example program to help explain the conversion done by the Conversion Tool Starting the Follow this procedure to start the conversion conversion 1 Start the ViewPoint for SAP Conversion Tool with transaction PBS UTIL CONVERT version 4 x or YCON version 3 x or from the ViewPoint for SAP main menu using Utilities gt General tools Conversion Select Command The Conversion Tool window appears as shown in Figure 17 sjag CG CABANE Conversion Tool Customizing YYCONVO2 GJ zzouwwv Z2 se i Qj testprogram for select conversion version 8 version 7 created 30 11 1999 DOERRSCHUCK created 17 01 2000 DOERRSCHUCK modified 30 11 1999 DOERRSCHUCK modified 26 01 2000 DOERRSCHUCK v start converting Figure 17 Conversion Tool window 2 Indicate Source and Target program Running the Conversion Tool Conversion Tool Note The default Target
79. is started and the selected archive data is displayed in a list EMC ViewPoint for SAP Modules Utilities User Manual 3 Translation Tool The ViewPoint for SAP Translation Tool is supplied as part of the ViewPoint for SAP modules utilities This chapter includes these topics Translation Tool Translation Tool Overview The ViewPoint for SAP Translation Tool translates text elements and dynpros of SAP standard objects to the text elements and dynpros of the corresponding ViewPoint for SAP object in any language maintaining the texts of reports function groups logical databases and transactions program elements Note The Translation Tool translates SAP texts in the chosen language only Texts in other languages will not be affected Be sure of the program elements selected for translation because existing text in the chosen language is overwritten Contact EMC Support for more information Delivery Table 6 lists the Translation Tool objects Table 6 ViewPoint for SAP Translation Tool object descriptions Object ViewPoint for SASP 3 x ViewPoint for SAP 4 x Description PROG ZZTRANSL PBS UTIL_TRANSLATE Translation Tool TRAN ZTRA PBS UTIL_TRANSL Start transaction TABL ZZUTILTRAN PBS UTIL_TRANSL Table EMC ViewPoint for SAP Modules Utilities User Manual Translation Tool Running the Translation Tool Follow this procedure to translate text elements for use with a Vie
80. ities User Manual Analyzer Plus Table 24 Cost Center Line Items selection criteria continued Selection Criteria Object type OV Operation PR PSP element VB Sales document item Document distribution analysis 125 Analyzer Plus Checking archivability Financial accounting documents Figure 84 Archivability check The archivability check utility checks the archived status for archiving objects FILDOCUMNT financial accounting documents SD_VBAK orders RV_LIKP delivery notes SD_VBRK invoices and MM_EKKO purchase orders and provides information about documents not archived The archiving check of archiving objects FI DOCUMNT SD_VBAK SD VBRK RV LIKP and MM EKKO provides information about the transaction data in the SAP system and if that data fulfills the criteria for an archiving run after all business related procedures are complete The ABAP PBS ANA ARCHIVE FI DOCUMNT provides an overview of all financial accounting documents for the delimited period and displays the reason if a document cannot be archived Double click a document for more details of an accounting document as shown in Figure 84 Fe Fl Archiving Program for Documents LEE List Edit Goto System Help Wall lee x 5 m mee ee Q Log of FI Documents for Archiving t 4700000000 Document can be archived 4900000000 Document still has open items 200000000 Document
81. lay Print Export to file SAP Audit Export option Dataset ar_items Directory Ipbsicfi z3 Figure 44 Output option Note Process large selection volumes in the background Before the data export executes the system checks whether The indicated directory exists and can be written to The indicated file name already exists If the file already exists choose whether to overwrite the existing file or select another file name At the end of each export transaction an export statistic is exported and displayed as shown in Figure 45 Variable account statement customers FI Export log file 14 05 2002 16 13 58 Output path Ipbsicfi z3 Output file ar items Amount selected customer items ag Amount written customer itens 89 1808 DEN 4 936 515 24 6 719 681 99 Figure 45 Export statistic Export file size The size of an export file depends on the number of items selected and the number of criteria on the selection list which displays the list layout changes Determine disk space as follows number items x line width of the layout 2000 bytes header record SAP AIS Authorization Authorization is required concept To execute reports Fiscal Year Reporter audit access Fiscal Year Reporter Use the ViewPoint menu for transactions beginning with PBS YR View accounts company code business areas etc Use transaction SE16 Display table contents
82. le name as shown in Figure 48 Variable table statement for table TBSLT o Table select options Language 1 9 to Posting key to Special G L ind to List layout Item list Variant PBS XTAB Number of entries 1 000 Output option Display Print 6 Export to file SAP Audit O lel els Export option Dataset Directory fpbsicfi z3 Generate table export Create the layout list for export as shown in Figure 49 g 1H 6668 BAR 808997 Variable table statement om Variable table statement for table Single table TBSLT Tablepool FI T003 Tablepool AA TABW Tablepool MM T038 UUE Output option Display Print LJ Exportto file SAP Audit 2 Export option Directory Generate table extract EMC ViewPoint for SAP Modules Utilities User Manual ALV layout definitions Single line lists File path default Data export terminates PC analysis program terminates List output contains wildcard characters Fiscal Year Reporter Right click technical field names to switch between the field name and technical field name if selection fields display several times when defining a list layout When using one list variant for the data export only a single line is listed Define a default value in the user master for the file path with the parameter ID gt PBS FYR LIS PATH The data export terminates with the message Variant was not found if t
83. lues or select entry and a select option are found the SELECT option is transferred options The direct value entry is then checked with the loop EMC ViewPoint for SAP Modules Utilities User Manual Sample programs Figure 23 The sample programs as shown in Figure 23 are meant for Conversion Tool testing purposes only fl fn in dbwa into table itab into corresponding table itab fl fn into table itab fl fn appending table itab fl tn into corresponding table itab appending table itab appending corresponding fields of table itab in dbwa in zvbak fl fl T Tables in different or options no PBS table EIFO different modules and key fields STXH differ dules and key fields without WHERE iving allocation v a ranking VBUK different options one clear module VBFA table with rrect key field VBFA table with wrong key field COEP access via different ss via different t by converted 01 CLIENT SPECIFIED GROUF BY INCLUDE PACKAGE SIZE n EXTERNER PERFORM SUM COUNT AVG CALL FUNCTION x UP TO n ROWS ooo ooo BAUR clause UNNR IN DD SEL AND VBELN from KNAL 03 from VEAP vvcowvos rertormance test IN ETWEEN Eo no key field no Where clause no table Read order items via orders to the customer VAKPA 01 VAKPA WHERE KUNNR IN DD SEL AND VBELN IN DD BEL 02 SINGLE from KNAL 03 from VEAP Example program of customer Include Perform and Call F
84. n This is automatic if during index generation post processing Delete initial run was activated 100 EMC ViewPoint for SAP Modules Utilities User Manual Extract Disk space requirement DART version Settings Create an extract Data Retention Tool Delete archive via selection list Select to display an overview of all generated index runs and delete load runs from this list This is useful when recreating indices Note Index records are physically deleted Once deleted generation runs for the archiving object must be repeated The extraction program executes only one archive access for each document for performance reasons temporarily storing additional tables for later processing and deletion The DART path used in the extraction program has to have enough disk space Disk space size can be determined using the ViewPoint for SAP Configuration gt File size worksheet Since disk space for temporary files has to be added during the extraction from the archive take twice the value defined using the worksheet to provide for the generation of the extract stock The full capacity is not required but represents an upper limit The ViewPoint for SAP CDART module version must match the SAP DART version or there might be dictionary objects missing Use transaction SE11 to verify the SAP DART version Use settings for data extracts to set extract setting such as file name file size and document types tak
85. n in Figure 53 Role PBS DART The CDART menu is essentially the same as the SAP DART menu as shown in Figure 54 The ViewPoint for SAP specific transactions are Extract data Generate index archive data and Check FI control totals All other menu options call the original SAP DART programs 7 3 Role JPBSIDART 2 3 PBS CDART 7 C3 Utilities I Extract data X Delete data extracts W Combine data extracts I Rebuild data extracts Generate index archive data CX Information system Data extract browser ID Data extract views 7 Extras I Display extract log I Dislay View log XD Check Fl control totals XD Check all FI control totals Check data check sums Q N qm Generate background job C3 Configuration W Data extracts X Data segments Q File size worksheet I Define data extract views CDART menu Using CDART Data Retention Tool Data Retention Tool Customer specific fields Data source The list of extraction fields is user definable and is updated in the data dictionary SAP original type extraction fields automatically transfer to the ViewPoint for SAP CDART module Other fields such as amounts are transferred using PBS DART EXIT SAPLTXW2 001 and PBS DART EXIT SAPLTXW2 002 All customer modifications in SAP DART can be transferred to ViewPoint for SAP Update customer modifications when updating ViewPoint for SAP if necessary Use the menu option generate index archive data c
86. nancial accounting document distribution values These document distribution values originate from capacity run number 0084 created with program PBS ANA VERTEILUNG and was constructed from period 01 year 1950 to period 12 year 2002 The average size of a document is 2 122 bytes which originated from the last capacity analysis The run was stored with description TEST EMC ViewPoint for SAP Modules Utilities User Manual Figure 81 Branching to the archivability check Figure 82 Figure 83 Comments on the document distribution Analyzer Plus Client 100 and company code 1000 contain a total of 2 8175 financial accounting documents occupying a capacity of 58 386 KB as shown in Figure 81 Client company code details It is possible to check the archivability of documents in a certain period from within the distribution analysis by double clicking the desired line of data if option Document analysis was selected as shown in Figure 82 180 300 1999 AB a7 0 00 100 300 1999 08 0 00 1808 300 1999 AB xs 8 81 Document analysis Only documents belonging to the current client can be analyzed for archivability The result of the check displays information as shown in Figure 83 5300 1999 27 08 1999 18888088802 Document can be archived 5308 1999 27 08 1998 100000003 Document still has open items Archive detail log For the documents of client 100 company code S300 year 1999 documen
87. ngle tables as described in Single table analysis on page 108 The data is stored in the database tables PBS ANA_AR_LFN and PBS ANA AR TXT under a sequential number run no and can be evaluated with the program PBS ANA_KAPAZITAET described in Single table analysis on page 108 Capacity analysis 107 Analyzer Plus Oracle database Informix database AS 400 database Correction of capacity commitment SAP 4 0 Single table analysis From SAP release 4 0 choose one of the following Use analysis from SAPDBA The size of the database table is taken from the last analysis run with SAPDBA Create analysis again The size of the database tables is determined again Tables marked in the system table DBSTATC trans DB21 in field Active with R or N cannot be analyzed These tables are displayed in the job protocol during the analysis construction To integrate these tables in the analysis the value entered in field KAP MAX is used in table PBS ANA AR OBJ In an Informix database it is not possible to determine the exact tables size as the fill level of the different pages is not known Two different types of analysis are offered Number of lines line size Provides nearly exact table size without compression Used pages Indicates the size of pages used of each table on the database server Before starting the analysis in an AS 400 environment with the ABAP PBS
88. nt distribution selection screen Client Enter the beginning and ending client number Company code Enter the beginning and ending company code Calendar year Enter the beginning and ending year Document type Enter the beginning and ending document type number Document analysis run number Enter the sequential document analysis run number Assign a number from 1 to 5 to each sort criteria To suppress a sort criterion leave that field blank Ensure entered numbers are sequential and start with 1 Doc analys Enables later archivability analysis for BKPF VBUK EKKO COBK and COEP Download results Downloads analysis results locally Document distribution analysis 121 Analyzer Plus A document distribution for financial accounting documents appears as shown in Figure 79 a 2H CGA BAR nonno HE PBS DB Analyzer Evaluation document splitting BKPF e PBS DB Analyzer Distribution acc documents HEMMING Run 0001 01 1993 12 2082 Date 14 01 2003 Beleggr e Byte 2 122 Run date 03 05 2002 BELEGVERTEILUNG E46 De me wm a e p pne 188 2000 1995 Dz 188 2000 1995 DZ Figure 79 Document distribution financial accounting Financial accounting document distribution values appear as shown in Figure 80 PBS DB Analyzer Distribution acc documents HEMMING Run 8084 01 1950 12 2802 Date 21 01 2003 Doc Size Byte 2 122 Run date 62 12 2002 TEST Page 1 Figure 80 Fi
89. ocument volume by type example
90. of resources attributes pools Boolean expressions buttons DQL statements keywords clauses environment variables filenames functions utilities URLs pathnames filenames directory names computer names links groups service keys file systems notifications Bold Used in running nonprocedural text for Names of commands daemons options programs processes services applications utilities kernels notifications system call man pages Used in procedures for Names of interface elements such as names of windows dialog boxes buttons fields and menus What user specifically selects clicks presses or types Italic Used in all text including procedures for Fulltitles of publications referenced in text Emphasis for example a new term Variables Courier Used for System output such as an error message or script URLs complete paths filenames prompts and syntax when shown outside of running text Courier bold Used for Specific user input such as commands Courier italic Used in procedures for Variables on command line e User input variables lt gt Angle brackets enclose parameter or variable values supplied by the user Square brackets enclose optional values l Vertical bar indicates alternate selections the bar means or Braces indicate content that you must specify that is x or y or z Ellipses indicate nonessential information omitted from the example
91. ot be converted because the table is not supported by ViewPoint for SAP The table is either a system table or a master records table X The conversion has later modifications N An external program call was found in the source program Include Perform or Call ES Single Select lines excluded from the conversion display this symbol lo Manual editing is necessary because during the conversion no key field was a found for access to the ViewPoint for SAP module or the database table can exist in several ViewPoint for SAP archives Sequential number CurNo The sequential number assigned to each Select command Line Row The line number of the Select command in the Source program Module The name of the ViewPoint for SAP module addressed by the Select command Option The option required for access to some ViewPoint for SAP modules For example in the ViewPoint for SAP CSD module this option is used to determine if the access is to be made to orders A delivery notes L or invoices F The ViewPoint for SAP CFI and CMM modules have no options EMC ViewPoint for SAP Modules Utilities User Manual Conversion Tool Table The dictionary table addressed by the Select command FROM statement Performance The performance of access to the ViewPoint for SAP module Table 5 lists performance symbol definitions Table 5 Performance symbol definitions Symbol Definition
92. potential overlapping and overwriting object issues import the ViewPoint for SAP module transports and the Development Class PBS ORDER transport in any order Development Class PBS ORDER EA Class Order EN EMC ViewPoint for SAP Modules Utilities User Manual 6 Fiscal Year Reporter This chapter includes these topics 999999 WEITET aea i eene b ainda ROTE bd 62 Using Fiscal Year Reporter use akan 64 Extracting fiscal year closing transaction data 65 Extract master data at fiscal year closing 67 Fiscal Year Reporting accio ae 70 Fiscal Year Rep rter yudit wer 71 RMS AMONT era 82 Fiscal Year Reporter Fiscal Year Reporter Overview At the end of a fiscal year numerous financial accounting tasks must be completed such as reconciliation and documenting posting material With Fiscal Year Reporter such tasks are carried out independently of the everyday business of the SAP system As soon as the fiscal year is completed all documents and transaction figures for the fiscal period including the corresponding master data information are saved outside the SAP tables Document information is saved in ADK format under a user defined archiving object while the master record information is stored in compressed form in a SAP cluster table During the generation process of the fiscal year stock the transaction figures are reconciled with the transactions of the period on company code level
93. ring utility on page 13 The latest ViewPoint for SAP transport version information is in the EMC ViewPoint for SAP Release Notes Complete ViewPoint for SAP transport installation information is in the EMC ViewPoint for SAP Software Suite Installation Manual The latest ViewPoint for SAP documentation is on EMC Powerlink This section describes the ViewPoint for SAP utilities used during installation The following utilities are supplied as a single transport installed during the initial installation of ViewPoint for SAP Archive Browser Archive Browser is a utility that displays table entries and the corresponding table and text field values Conversion Tool Conversion Tool is a utility used to adjust simple ABAP 4 programs to archiving purposes Translation Tool Translation Tool is a utility that translates standard SAP objects text elements and dynpros into the user s native language for use by ViewPoint for SAP to display corresponding objects text elements and dynpros Check ADK Check ADK is a utility that is an error analysis tool used in case of access problems to ViewPoint for SAP index files or SAP archive files Class Order is supplied as a separate transport and is a utility that helps manage the installation of technically related archive modules EN EMC ViewPoint for SAP Modules Utilities User Manual Compliance and auditing utilities Fiscal Year Reporter Data Retention Tool Database growth
94. ry Costs EKES Vendor Confirmations EKET Scheduling Agreement Schedule Lines Figure 16 List of available database tables EMC ViewPoint for SAP Modules Utilities User Manual 2 Conversion Tool This chapter addresses the administrative adjustment of ViewPoint for SAP modules using the ViewPoint for SAP Conversion Tool The Conversion Tool is supplied as part of the ViewPoint for SAP modules utilities This chapter includes these topics DIENEN 32 Running the Conversion Tl une 33 e Special Telf eaae tensa ae 41 Beam lS PS RMS ea 43 Archive access tutorial SAP version 4 6c sess 44 Conversion Tool Conversion Tool Overview Table 3 The ViewPoint for SAP Conversion Tool adjusts ABAP 4 programs by searching for Select commands using a ViewPoint for SAP module The ViewPoint for SAP Conversion Tool converts Select command structures into a Loop structure Note Check converted Select and Loop commands during and after the conversion You cannot adjust each Select command for each archive module The ViewPoint for SAP Conversion Tool works with the following ViewPoint for SAP modules Controlling Line Items CCO Financial Accounting and Material Documents CFI Purchasing CMM Sales and Distribution CSD Table 3 lists the Conversion Tool objects ViewPoint for SAP Conversion Tool object descriptions Object ViewPoint for SAP 4 x ViewPo
95. sbass a etta asses eee teneas EASE 52 R nning Check ADK tette ensure eelised ei irie 53 Using SAP Object to Test 56 Class Order iussus MET T PU Uu 58 Development Class PBS ORDER ee 59 Fiscal Year Reporter OVERVIEW strass 62 Using Fiscal Year Reporter reete 64 Extracting fiscal year closing transaction data 65 Extract master data at fiscal year closing ssus 67 Fiscal Year Reporting assiette arg e Dep 70 Fiscal Year Reporter audit access 7 Audit access strategies 71 Access types Z1 and 22 72 Data format ciento diete diii reas 73 erui qM 73 BEXpOttprOBrams c nente ni neon os niter bad riens 74 Export selection screen ssassn i A E E s 76 Export file size ass statisti catene hte i eres 77 EMC ViewPoint for SAP Modules Utilities User Manual Chapter 8 Chapter 9 Authorization concept 77 Transfer files to PC 78 Using PC analysis programs 78 Extracting data 79 Admiristralon s itoseites bietet eie tie err tor a exire hes 82 Delete transaction data 82 Delete master data ccccccccccsccssecssscesssecscssesessecesseceeeesseeseeees 82 Activate TepOrHng iion mined cae i ates 82 Balance audit trail cancelled during processing 82 Master d at PR neni nih reb sise 83 Transaction data e eer ce er ee rere de 83 Logical database aecenas ti
96. several index stocks in parallel For example start a new index stock once a year The index generation program starts two post processing programs both of which can be started manually from the Utilities menu Create management indices Writes control records into the database needed for generated indices access Delete previous run Deletes ADK files not containing current index sets Use Utilities gt Archive Tool to view the index after the index generation run with its post processing programs completes Archiving ViewPoint for SAP modules data EN Data Retention Tool Figure 61 Deletion tool Figure 62 The data is now available for CDART extraction as shown in Figure 61 Display contents PBS archive add on CDART EE 1 12 a Archive tool selection screen Index Number Choose the index Press F4 to get the index number description Index list Choose the desired index from a list Job protocols Displays the job logs Start at key Enter the index key to start from higher index numbers Use Utilities gt Delete index to delete index records as shown in Figure 62 Deletion of PBS DART archiving runs for experts only Delete PBS load runs for CDART Keep only the most current runt SD VBAK 28008 Delete archive via selection list Deletion tool selection screen Keep only the most current run Select to delete all runs selected with Ru
97. several objects Mode select one Text elements Text elements of the selected objects will be processed Screen painter Dynpros Screen painter Dynpros of the selected objects will be processed All Both text elements and screen painter Dynpros of the selected objects will be processed SETB SAPMS38L Direct choice of objects EMC ViewPoint for SAP Modules Utilities User Manual Select IPBS SETB FUGR PES SAPMS38L PROG Translation Tool 2 Press Execute in the initial screen A list displays three types of objects objects the tool has found an original name objects where no original name was found objects where no clear original name was found 3 Double click the objects for which an original name has been found as shown in Figure 27 or select them using the checkbox You can also select and deselect all found objects using Shift F1 and Shift F2 3 3g eae GHB anna mg OB Translationtool nn T3 mE PBS NAME SAP NAME OBJECT TYPE C PBS SAPMY130 SAPMY138 PROG PBS SAPMV134 SAPMV138 PROG C 4PBS RV134016 N RY134016 PROG L 4PBS SaPLV130 SAPLV138 FUGR LC PBS SAPLV148 SAPLY14A FUGR Not found 7PBS SAPMVI3A J1 PBS SAPMV13A K1 PBS SAPMV13A L1 PBS SAPMV13A M1 Figure 27 Selection of objects 4 Press Execute All selected text elements are copied from the original program to the ViewPoint for SAP program and a report of changes displ
98. stomer specific reporting ViewPoint long term archiving concept Z3 ViewPoint for SAP CDART DART extracts from archive and DB CFI Module and Fiscal Year Reporter ADK files without DB reloading process Data export via variable ABAP extract Access types Z1 Delimit the selection for each field from the document header table and Z2 BKPF the document item table BSEG and the tax line table BSET For a tax check the documents to be checked can be selected and evaluated as shown in Figure 41 Q m m ER A Advance Return for Tax on Sales Purchas a 1H eee BAR Company code Document number Fiscal year dehrchivesDatabase 2 Db 3 Arch 1 Advance Retum for Tax on Sales Purchases I arni s Rent choose an2404 a0t1 pacur General selections Posting date Reference number Fiscal month Further selectons Posting parameters Output contri Tax on salesipurchasss code Business place V Select outout tax Selectinput tac Only for repeat run Date of tax return Figure 41 Don selected tens TESTER a OB Company code ij Document it number m B Fiscal year v BEG B Line item iD B Clearing vate B Clearing date E Clearing document B Posting key B Accounttwe RE Special GIL ind B Sp cil trans ipe B Trat special ot ind A Dehilirect ing BSET vme es ok IE es e s eno Ls 78 B Taccode oft account B Groupindicator IE Debiter
99. t Application Archive object Database table Run number Group by Archive object J Database table Sort Size e Name Archiving with CO ITEM Determine document size Show zero values Show database tables Single table evaluation Show PBS module Figure 67 Evaluation screen Selections Enter data selection criteria and output layout in the Selections area of the Evaluation screen Application Enter the application name s such as SD FI MM PP Archiving object Enter the archiving object name s such as MM_EKKO FI DOCUMNT RV_LIKP Database table Enter the database table name s such as EKKO BKPF VBRK LIKP Run number Enter the run number Options Enter selections in the Options section of the Evaluation screen Group by Select to create a list grouped by Archiving object or Database table 110 EMC ViewPoint for SAP Modules Utilities User Manual Figure 68 Analyzer Plus Sort Select to sort the grouping by Size or Name Archiving with CO ITEM Determines if archiving object CO ITEM is included in the analysis if the capacity analysis was started with the option Detailed analysis of the CO records explained on page 107 Left unselected the CO tables of archiving object CO ITEM are distributed to the corresponding archiving objects especially when using the ViewPoint for SAP CCO module Determine document size De
100. t type AB of period 08 the archivability check shows that one of the associated documents has open items and cannot be archived The distribution of documents according to period and year uses entry date of the corresponding database table except for the distribution of COEP records This table does not contain an entry date and uses the fields year and period instead Document distribution analysis 123 Analyzer Plus Sales documents using PBS ANA_VBUK Table 23 Cost center line items using PBS ANA_COEP Table 24 Table 23 lists the selection criteria for sales document objects Sales document selection criteria Selection Criteria Application A Orders L Delivery notes F Invoices The the first two digits of field COEP OBJNR are an important criterion for archiving cost center line items with CO_ITEM Depending on the language used these two digits are substituted with a three digit abbreviation This allocation is defined in dictionary table TBOOI Table 24 lists the two digits definitions Cost Center Line Items selection criteria Selection Criteria Object type AO Reconciliation object BP Business process EO Result object HP Cost object IA IB IC IG IM IV Real estate management KL Cost center activity type KS Cost center NP Net plan NV Network activity OP Order item OR Order 124 EMC ViewPoint for SAP Modules Util
101. te role C3 Favorites ES SAP menu H O Accounting t Logistics H O Human resources H O Master data changes BG Utilities H O PBS Database Analyzer PLUS Sag General tools PBS SE16 Archive browser PBS UTIL_CONVERT Conversion select command PBS UTIL Z8CP Research transport PBS UTIL TRANSL Translation tool PBS CHECK_PBS_ADK Tool Check PBS ADK H O PBS Database Analyzer ViewPoint for SAP utilities menu release 4 6 Running Check ADK Check ADK The Check ADK initial screen appears 2 Select one or more ViewPoint for SAP modules as shown in Figure 30 Also choose between only errors for a quick ADK check all messages for a complete ADK check Note For information on selecting SAP Object to Test proceed to Using SAP Object to Test on page 56 PBS Tool for checking PBS index files and SAP ADK files Program Edit Goto System Help el Jaese HR anaa nm eo SAP Object to Test PP ORDER PBS Obejct to Test 4 PBS archive add on CCO PBS archive add on CCOPA PBS archive add on CCU PBS archive add on CFI PBS archive add on CHR PBS archive add on CMM PBS archive add on CMT PBS archive add on COO PBS archive add on CPCA PBS archive add on CPM PBS archive add on CPP PBS archive add on CPR PBS archive add on CPS PBS archive add on CSD PBS archive add on CSL PBS archive add on CWM ME E MN UN M eee eee m Protocol
102. termines the average size for certain documents Show zero values Select to display zero values Show database tables Select to display details of database tables Single table evaluation Displays the capacity of single tables Show VPT module Select to display the ViewPoint for SAP module Download results Download the results locally The result after the selection of program PBS ANA KAPAZITAET appear as shown in Figure 68 AN 21H 888 CAB 8045 fF om PBS DB Analyzer PLUS Evaluation capacity document a PBS DB Analyzer Disk space occupancy of arch objects Time 16 12 39 HEMMING Run number 0025 from 22 11 2002 1 704 524 KB Date 21 01 2003 YYCSANAK Aufbau nach Archivierung mit Einzeltabellenanalyse Page 1 Size of selected data E 121 686 KB Portion of total size 7 Object Name of object Total KB Sel 3 Table Name of database table Size KB Sel Tot FI DOCUMNT Financial accounting documents BSEG Accounting Document Segment 39 979 32 9 2nd BSIS Accounting Secondary Index for G L Accounts 30 882 25 4 1 8 BKPF Accounting Document Header 18 886 15750 be BSAD Accounting Secondary Index for Customers Clear 9 341 7 7 0 5 BSET Tax Data Document Segment 8 630 zi gro BSAS Accounting Secondary Index for G L Accounts C1 3 618 3 0 0 2 BSIM Secondary Index Documents for Material 32353 2 8 rires BSAK Accounting Secondary Index for Vendors Cleared 22554 pal 0 1 BFOD_A
103. tion Display reconciliation differences Clear archive file name Manually create an archiving object Use transaction YEAR YEAM gt Tools gt Tutorial gt Read master data to start the tool YYCFVKZA version 4 x PBS YYCFVKZA to directly access Fiscal Year Reporter master data Alternately use an external call to program YYCFVKZ3 version 4 x PBS YYCFVKZ3 to directly access Fiscal Year Reporter master data Use transaction SARA to display the created backup stock after entering the archiving object YY_YR_yyyy yyyy fiscal year Double click the management line to change the description of the extract stock with function key F5 Use transaction YEAR YEAM gt Transaction data gt Manage to display the run protocol stored in a management table for each extract run of the Fiscal Year Reporter Select a management line and press F5 The last line in an entry shows if there were differences in the reconciliation If logical file names are not clear existing archive stocks of the Fiscal Year Reporter are overtyped Create clear names by entering the variable lt TIME gt into the file name For example use the definition of the logical file name ARCHIVE_DATA_FILEI A logical file name exists for each fiscal year archiving object yy yr xxxx where xxxx fiscal year View this logical file name with transaction SARA or AOBJ Use transaction File Definition logical file name independent of client to view
104. umentation set and is intended for use by the ViewPoint for SAP modules utilities administrator Readers of this document are expected to be familiar with the following topics ViewPoint for SAP modules installation and usage SAP generic installation tools and programs EMC ViewPoint for SAP Modules Utilities User Manual Related Documentation Conventions Used in This Guide N A Related documents include Introductory EMC ViewPoint for SAP Release Notes Installation EMC ViewPoint for SAP Software Suite Installation Manual Administrative EMC ViewPoint for SAP Modules Administration Manual User EMC ViewPoint for SAP Modules Utilities User Manual EMC uses the following conventions for special notices Note note presents information that is important but not hazard related CAUTION A caution contains information essential to avoid data loss or damage to the system or equipment The caution may apply to hardware or software IMPORTANT An important notice contains information essential to operation of the software The important notice applies only to software EMC ViewPoint for SAP Modules Utilities User Manual Typographical Conventions EMC uses the following type style conventions in this guide Normal Used in running nonprocedural text for Names of interface elements such as names of windows dialog boxes buttons fields and menus Names
105. unction Example program of customer SELECT FOR ALL ENTRIES DER BY artiy in small letters From invoice check revaluation Conversion Tool testing programs Sample programs Conversion Tool Archive access tutorial SAP version 4 6c Figure 24 ABAP Editor Execute Manual ABAP 4 programs with ViewPoint for SAP archive access are provided if an automatic adjustment cannot be made with the ViewPoint for SAP Conversion Tool From SAP version 4 6c ViewPoint for SAP has archive access tutorials which enable application developers to provide customer specific programs with ViewPoint for SAP archive access Executable example programs are provided for each installed ViewPoint for SAP module Their coding can be processed and executed with the ABAP workbench Call the function under General tools as shown in Figure 24 V 3 PBS archive add ons gt O Accounting gt I Logistics gt J Human resources gt J Master record changes v Ji Utilities s CX O Archive browser O Conversion select command 2 Research transport 2 Archive access tutorial Translation tool Tool Check PBS ADK C2 Default value PBS data source General tools functions Or use transaction PBS UTIL_ACCESS ARC Click ABAP Editor to start the editor and display sample programs Breakpoints can be set to execute the programs or the relevant coding can be marked to transfer it into the customer program The sample program
106. ustomizing data source to set the archive data imported using the existing ViewPoint for SAP modules or using the CDART archive indices as shown in Figure 55 Customizing CDART Figure 55 CDART data source selection Table 19 lists the module indices that can be used with CDART to extract document types Table 19 CDART extracted document types Module Module name Type CFI Financial accounting documents FI DOCUMNT CFI Material documents MM MATBEL CSD Sales documents SD VBAK CSD Deliveries RV LIKP CSD Billing documents SD VBRK CMM Orders MM EKKO EMC ViewPoint for SAP Modules Utilities User Manual Data Retention Tool Indices must be built directly in the CDART to extract other document types Note Indices for all archiving objects must be built in CDART to extract other document types such as CO cost totals Archiving object Indices are stored through the archiving object PBS DART PBS DART Transaction SARA assigns a logical file name with Customizing gt archiving object specific customizing ARCHIVE DATA FILE is set during the ViewPoint installation the value for which must be changed so that the path is created in the file system and read write authorization exists at the operating system level Using CDART Data Retention Tool Archiving ViewPoint for SAP modules data An index must be created for each ViewPoint for SAP module used befor
107. vendors and GA L account information can also be extracted with transaction data using YEAM gt Master data gt Save as shown in Figure 38 211H 888 DAR SU BA 8 Backup masterdata Q 4 H Backup master data per year end closingiCrcy switch Company code O to e Fiscal year 1995 Validation Selection screen to save master data Master data is stored in compressed form in the cluster file YVKZ or PBS YVKZ for version 4 x and later Make the first data backup covering several fiscal years Subsequent data backups should be done after the closing of each fiscal year Yearly backups result in a long term archive Use Validation to check if selected company codes and fiscal years are valid Fiscal years can only be saved once unless the existing fiscal year is deleted from the backup file YVKZ or PBS YVKZ for version 4 x and later Note If transaction data is deleted after conversion from local currency to Euro data is lost Run the Fiscal Year Recorder in the background unless the run is for testing purposes Table 10 Table 11 on page 68 Table 12 on page 68 and Table 13 on page 69 list the backup tables created Customers Table name Description KNA1 Customer master general KNAS EC taxes KNKA Credit limit Extract master data at fiscal year closing Fiscal Year Reporter Table 10 Table 11 Table 12 Customers continued
108. wPoint for SAP module 1 Start the ViewPoint for SAP Conversion Tool with transaction PBS UTIL TRANSL version 4 0 and after or ZTRA version 3 1 and prior The Translation Tool window appears as shown in Figure 25 Figure 25 Translation Tool window Running the Translation Tool Translation Tool Table 7 Figure 26 Table 7 lists the initial screen fields definitions Translation Tool initial screen fields Field Definition Target language Select the language s into which you want to translate Enter transport request optional when using Direct choose of objects Enter the desired transport request to translate all existing programs PROG function groups FUGR logical databases LDBA and transactions TRAN of the transport The Translation Tool attempts to find the original name of the program element with the given ViewPoint for SAP program name Selecting multiple transport requests could impede performance of the Translation Tool Already translated objects also Select to overwrite existing text elements of the selected objects already in the target language Direct choose of objects optional when entering a transport request Enter the original program name matching a ViewPoint for SAP program when there are few elements to edit or no original program name can be found as shown in Figure 26 Be sure of the order of the select options when selecting
109. within an order AFVGD Order Dialog table for Table AFYG order operation AFVU DB structure of the user fields of the operation AFVV DB structure of the quantities dates values in the operation AUFK Order master data BKPF Accounting Document Header BSAD Accounting Secondary Index for Customers Cleared Items BSAK Accounting Secondary Index for Vendors Cleared Items BSAS Accounting Secondary Index for G L Accounts Cleared Items BSEG Accounting Document Segment BSIS Accounting Secondary Index for G L Accounts CAUFY Generated Table for View CAUFV CAUFVD Dialog structure for order headers and items CDHDR Change document header CDPOS Change document items COBK CO Object Document header COBRA Settlement Rule for Order Settlement COBRB Distribution Rules Settlement Rule Order Settlement COEP CO Object Line Items by Period cove Table Generated for View COYP DOST Document to BOM Link EIKP Foreign Trade Export Import Header Data EIPO Foreign Trade Export Import Item Data EKAB Release Documentation EKAN Vendor Address Purchasing Document EKBE History per Purchasing Document EKBZ History per Purchasing Document Delivery Costs EKES Vendor Confirmations EKET Scheduling Agreement Schedule Lines EKKN Account Assignment in Purchasing Document EKKO Purchasing Document Header EKPA Partner Roles in Purchasing Archive Browser accessible tables EN EMC ViewPoint for SAP Modules Utilities User Manual Selecting ta

ViewPoint for SAP Modules Utilities Version 2.1 User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents