pbs database analyzer plus - · pdf fileized, depending on the archiving with or without the...

PBS Database Analyzer

PLUS - Manual-

Compatible to SAP R/3

- Release 4.0 - Release 4.5 - Release 4.6

- Enterprise - IS-U

- ECC 5.0

Dezember 12, 2005

PBS Database Analyzer PLUS for SAP R/3 - Manual - 2

© 1999 - 2005 PBS Software GmbH Schwanheimer Strasse 144a 64625 Bensheim, Germany Phone: +49 - 6251 - 174 0 Fax: +49 - 6251 - 174 174 email: [email protected] Internet: www.pbs-software.com

PBS archive add ons® is a registered trademark of PBS Softwareberatung Dipl.- Math. Günther Reichling, Bensheim.

SAP, R/3, R/2, ABAP/4 are registered trademarks of SAP AG, Walldorf/Baden.

Acrobat Reader is a registered trademark of Adobe Sy ms Incorporated. ste

MS SQL Server is a registered trademark of Microsoft.

Software GmbH


Table of Contents 1. Introduction 5

2. The PBS Database Analyzer PLUS 6 2.1. Overview of the Functionality of the PBS Database Analyzer PLUS 7

3. Installation 8 3.1. Object Names of the PBS Database Analyzer PLUS 8 3.2. Supplied Menus 9 3.3. Installation under AS/400 10 3.4. Installation under Microsoft SQL-Server 11 3.5. Adaptation to Customer-Specific Archiving Objects and Tables 12

4. The Capacity Analysis of the Database 13 4.1. Initialization 13 4.2. The Capacity Analysis 14 4.3. Comments on Oracle Database 16 4.4. Comments on Informix Database 17 4.5. Comments on AS/400 Database 18 4.6. Single Table Analysis 19 4.7. Evaluation of the Database Analysis 20 4.8. Comparison Analysis 28 4.9. Comments on the Capacity Analysis 30

5. Analysis of the Document Distribution 31 5.1. Initialization 31 5.2. The Database Analysis 32 5.3. Analyze Document Distribution 34 5.4. Branching to the Archivability Check 38 5.5. Comments on the Document Distribution 39

6. Archivability Check 41 6.1. Check of the Archivability 41 6.2. Financial Accounting Documents 42 6.3. Sales Documents 43 6.4. Purchasing Documents 45 6.5. Forecast 46

7. Annex: 47

Software GmbH


7.1. Examples for the Capacity Analysis 47 7.2. Examples for the Analysis of the Document Distribution 51

Software GmbH


1. Introduction

The modular manuals of PBS Software GmbH for the PBS Database Analyzer PLUS are composed of the partial manuals:

- Part A: Installation (in general)

- Part B: Manual Database Analyzer PLUS

The present manual is part B, describing the administrative tasks like layout of the analysis and evaluation.

Should you have questions or problems regarding the PBS archive add ons please call directly the Service Hotline of PBS Software GmbH:

Phone: +49 - 6251 - 174 110

Fax: +49 - 6251 - 174 174

email: [email protected]

Release Compatibility

The PBS Database Analyzer PLUS discussed in this manual 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, IS-U, correction levels a to z.

At present, the database systems Oracle, Informix, ADABAS, DB2, DB400 and MS SQL Server 7 are supported.

Software GmbH


2. The PBS Database Analyzer PLUS

How much disk space is occupied by a certain module, for example FI?

Which module requires most of the disk space?

How much increases our R/3 database in one month - in one year?

How large is the monthly document volume in the financial accounting?

For which archiving objects is the archiving useful?

How big is an average purchasing document?

Which table is archived with which archiving object?

Which PBS archive add ons do I need?

If SAP R/3 systems have been productive for some time you will have to find the answers to the questions above. For this reason, PBS Software GmbH has devel-oped the utility package PBS Database Analyzer PLUS.

The PBS Database Analyzer PLUS consists of three essential functions. On the one hand, this program analyses the capacity occupied by the archiving tables and, on the other hand, the distribution of documents for the selected SAP mod-ules. Furthermore, you can execute an archiving check (for all selected SAP mod-ules).

At present, for the capacity commitment 900 tables in 100 archiving objects (these values depend on the releases) are used for the analysis and the results are stored in a database table for later evaluations according to different criteria. Also the allo-cation of a table according to several archiving objects is considered. The utility adds the determined capacity completely to an archiving object or splits it accord-ing to a defined system.

The analysis of the document distribution provides information on the temporal dis-tribution of the entered documents. The user can define any selection and grouping criteria he needs. In principle, the client and the period are available as grouping criteria. Depending on the module further features are available, for example the company code and the document type in the financial accounting.

Running the archiving check you can find out if documents can be archived. That enables you to ensure that the archiving can be made with the best possible result.

Software GmbH


With the document distribution you are able to check documents of a certain period and evaluate them in a well-structured way.

2.1. Overview of the Functionality of the PBS Database Analyzer PLUS

The PBS Database Analyzer PLUS is a utility that supports you in your archiving strategy. Basis was the previous PBS products Database Analyzer and Database Inspector which were enhanced and improved in many areas.

The PBS Database Analyzer PLUS is composed of three functions:

• It executes a capacity analysis of the tables used by the archiving objects and stores the results for a later evaluation in the database. Optionally, a detailed analysis of CO tables (e.g. COEP, COSS, COSP...) can be real-ized, depending on the archiving with or without the archiving object CO_ITEM (if CO_ITEM should be used for archiving, a detailed evaluation is not necessary since the corresponding tables are included in this ob-ject). The PBS module for each archiving object which should be checked can be displayed in the evaluation. At a glance you can find out which PBS ar-chive add ons are relevant for you. Customers often want to check the increase of single tables independent from an archiving object. Therefore, single tables can be added and con-sidered in the evaluation during the next capacity run. The results are dis-played separately in the evaluation and the archiving objects belonging to that table can be displayed by a mouse click.

• A distribution analysis makes it possible to assign documents according to the time they were entered by determining the number of existing docu-ments by period and then can be evaluated in a clearly structured way. Along with the archiving check the distribution analysis is an excellent tool to ensure a successful archiving. This analysis is available for some se-lected SAP modules.

• The archiving check enables you to check existing documents if they can be archived. If that is not the case, the reason is displayed. This way it is easy for you to get the conditions for a successful archiving. This analysis is also available for some selected SAP modules.

Software GmbH


3. Installation

3.1. Object Names of the PBS Database Analyzer PLUS

As already explained in the installation manual (part A), PBS Software GmbH has an own naming area from release 4.0. The programs and objects described in this manual have only names of this namespace. Please see the text file log.txt for a complete list of all objects which are supplied with the transport (see installation manual).

Note: The installation of the PBS namespace has to be performed before the instal-lation of the PBS DB Analyzer PLUS. Installation of PBS utilities is not necessary.

Object Rel. 4.x Description

Program /PBS/ANA_ERSTAUFBAU Initialization of analysis tables

Program /PBS/ANA_AUFBAU Construction of analysis runs

Program /PBS/ANA_VERTEILUNG Construction of document distri-bution runs

Program /PBS/ANA_KAPAZITAET Evaluation capacity commitment

Program /PBS/ANA_KAPAZITAET_VGL Comparison of two capacity commitments

Program /PBS/ANA_BKPF Evaluation FI documents

Program /PBS/ANA_COBK Evaluation CO document header

Program /PBS/ANA_COEP Evaluation CO line item

Program /PBS/ANA_EKKO Evaluation MM document

Program /PBS/ANA_VBUK Evaluation SD document

Program /PBS/ANA_AUFK Evaluation Purchase Order

Program /PBS/ANA_MKPF Evaluation Material Document

Program /PBS/ANA_MARA Evaluation Material Record

Program /PBS/ANA_ARCHVIE_MM_EKKO Check MM_EKKO

Program /PBS/ANA_ARCHIVE_FI_DOCUMNT Check FI_DOCUMNT

Program /PBS/ANA_ARCHIVE_SD_VBAK Check SD_VBAK

Program /PBS/ANA_ARCHIVE_SD_VBRK Check SD_VBRK

Software GmbH


Program /PBS/ANA_ARCHIVE_RV_LIKP Check RV_LIKP

Transaction /PBS/ANA_PLUS Area menu Database Analyzer PLUS

3.2. Supplied Menus The menu for the PBS Database Analyzer PLUS can be started via transaction /PBS/ANA_PLUS or from the global menu.

All programs described in this manual can be called from the menu.

Software GmbH


3.3. Installation under AS/400 In case of very large tables, the display can be too small by factor 1024 under AS/400. Please see SAP OSS message 0163308.

Software GmbH


3.4. Installation under Microsoft SQL-Server

If you use Microsoft SQL Server as database system from version 7, all patches regarding the MS-SQL Server 7.0 and the database monitor tool DB02 must have been imported. This applies for all SAP releases 3.x and for 4.0B, OSS notes: 98711, 91703 and 139945.

Software GmbH


3.5. Adaptation to Customer-Specific Archiving Objects and Tables

In some cases it is necessary that customer-specific archiving objects or tables are added to the Database Analyzer PLUS. We explain such procedure with the exam-ple of the generated archiving objects for operating concern S471.

The following archiving objects are generated:

COPA1_S471 = COPA costing-based, operating concern S471 COPA2_S471 = COPA account-based, operating concern S471

The account-based archiving object COPA2_S471 archives the same tables like object COPA2_S001. It is not possible to differentiate the operating concerns; the-refore they cannot be integrated into the Database Analyzer PLUS.

The costing-based archiving object COPA1_S471 archives, among others, the generated tables CE1S001, CE2S001, CE3S001 (see transaction DB15). They have to be added to the Database Analyzer PLUS.

For this purpose, you use transaction SE16 to enter the entries into table /PBS/ANA_AR_DEF. You only have to indicate the archiving object (OBJECT) and the database table (SON).

OBJECT SON

COPA1_S471 CE1S471

COPA1_S471 CE2S471

COPA1_S471 CE3S471

COPA1_S471 CEALE47

After the entry, program /PBS/ANA_ERSTAUFBAU must be started with option „...and keep previous analyses“. Thus, during the next analysis run these tables are considered as well in the Database Analyzer PLUS.

Software GmbH


4. The Capacity Analysis of the Database

The following chapter describes how the capacity analysis of archiving objects is carried out. For this purpose two ABAP/4 programs are needed. The program /PBS/ANA_AUFBAU starts the analysis and stores the results in the database ta-ble /PBS/ANA_AR_LFN. Within the capacity run the disk space occupancy of the tables allocated to the archiving objects is determined. These results are evaluated with the program /PBS/ANA_KAPAZITAET and can be displayed clearly according to archiving objects.

4.1. Initialization Before the first capacity or document distribution analysis can be made the data-base tables of the Database Analyzer PLUS have to be constructed again in the R/3 system by starting the ABAP /PBS/ANA_ERSTAUFBAU.

This ABAP copies the entries of the database table /PBS/ANA_AR_DEF into the table /PBS/ANA_AR_OBJ, supplementing it by the table names of the SQL data-base and by further controlling information.

This program can also be used to delete all existing analyses.

Software GmbH


4.2. The Capacity Analysis Attention: See the following chapters for detailed information regarding the data-base systems.

Diagram 1: Selection mask for capacity construction under ORACLE

Depending on the database system, the ABAP /PBS/ANA_AUFBAU starts a cor-responding ABAP for the construction of the capacity analysis. If you use, for ex-ample, an ORACLE database system, the ABAP /PBS/ANA_ORACLE is chosen. The following information can be entered:

Description: Free text for description of analysis run

Analysis run from SAPDBA or Determine size from DDic: Option for Oracle da-tabase system. For more details, please see chapter 4.3.

Detailed analysis of CO records: This option carries out a more exact analysis of the CO records to allocate the CO tables like COEP, COSS among others exactly to the corresponding archiving objects. However, this option requires a long run time.

If you intend to use archiving object CO_ITEM you can do without this option.

If this option has not been selected the corresponding CO tables are distributed to the archiving objects CO_COSTCTR and CO_ORDER.

Software GmbH


Secured run: In a productive system it is possible that an ABAP gets into an end-less loop when a SELECT-COUNT command to a cluster table (CDCLS) is carried out. The ABAP is then cancelled with the error message "SQL error 1555 at access ..." after several hours.

The secured run prevents this SELECT, however, with this option the database ta-bles for the document changes (CDHDR and CDPOS) are not split and appear in the evaluation with the size 0.

Single table analysis: This option activates the analysis of single tables. The pro-cedure how tables can be transferred to the single table evaluation is described in chapter 3.7.

We recommend to run the ABAP /PBS/ANA_ AUFBAU in the background process where you can check the progress of the run via the protocol entries of the own jobs.

Having carried out the analysis the data determined is stored in the database ta-bles /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 (see chapter 4.6).

Software GmbH


4.3. Comments on Oracle Database From SAP rel. 4.0, you can decide - when constructing the capacity commitment under Oracle – if the database tables are analyzed again or if the statistic data of the analysis run with SAPDBA / BRCONNECT is to be used or whether the size is to be determined from the DataDictionary.

Use analysis from SAPDBA

The size of the database table is taken from the last analysis run with SAPDBA / BRCONNECT (ANALYZE TABLE).

If a table size has changed (e.g. because of a successful archive run), it might be necessary to update the table statistics to enable the PBS DB Ana-lyzer PLUS calculating the correct size.

Determine size from DDic

Note: This option replaces the option “recreate analysis” of the previous versions of the PBS DB Analyzer PLUS.

The PBS DB Analyzer PLUS can use statistics information which were created be-fore to calculate the size of a table. Under some circumstances however, no statis-tic is available, which can be evaluated currently or for this purpose (see OSS hints 588668 and 554031). This option determines the size of the table from the size and number of the data records.

Attention: To determine the number of data records a SELECT-COUNT is carried out. Under some circumstances this might lead to significantly longer runtimes. The results from the analysis differ from the analyisis determined by the statistics, es-pecially for tables which are stored in compressed form, because this is not taken into account. Thus you should always determine the table size by statistics, if pos-sible.

Software GmbH


4.4. Comments on Informix Database In an Informix database, it is not possible to determine the exact size of the differ-ent tables, as the fill level of the different pages is not known. Two different types are offered for the analysis of the database tables:

Number of lines * line size: provides nearly exactly the table size without com-pression

Used pages: indicates the size of pages used of each table on the database server.

Software GmbH


4.5. Comments on AS/400 Database Before the database analysis in an AS-400 environment can be started via the ABAP /PBS/ANA_AS400, at first, the database table DBSTATTDB4 must be up-dated. This is carried out via transaction DB02 and the start by pressing the button "Refresh data" (update data statistic).

Should the program be cancelled during this process a SAP correction order must be imported.

Software GmbH


4.6. Single Table Analysis The single table analysis enables you to analyze tables independent from an ar-chiving object. For this purpose, you have to update table /PBS/ANA_TAB_DEF with transaction SE11. You only have to enter the name of the table in field TABLENAME, the field SQLTAB should remain empty.

Diagram 2: Update of table with transaction SE11

Then, a new initialization should be executed with ABAP /PBS/ANA_ERSTAUFBAU as described in chapter 2.5. If you select option „...and keep previous analyses“, the previous evaluations remain.

During the next capacity run, the implemented tables are also analyzed.

Software GmbH


4.7. Evaluation of the Database Analysis

In order to evaluate the analysis runs created in chapter 4.2 the ABAP /PBS/ANA_KAPAZITAET is used (see Diagram 3). The database analysis for ar-chiving object FI_DOCUMNT is described there.

Diagram 3: Selection screen: Evaluation of the database analysis

Software GmbH


The result of a capacity analysis without details is displayed in the following:

Diagram 4: Capacity analysis without details displayed with the PBS module

The lines marked in green are the names of the PBS archive add on which can be used for the archiving object(s) displayed in the line(s) below. A line marked in red introduces an archiving object not supported by PBS.

Software GmbH


The following criteria for the data to be selected and the layout of the output can be entered here:

Application: SD, FI, MM, PP, ... Archiving object: MM_EKKO, FI_DOCUMNT, RV_LIKP ... Archive table: EKKO, BKPF, VBRK, LIKP ... Capacity run no.: 0001, 0002 ...

Two different list variants are selected by using the option "Grouping according to archiving object" or "No grouping". Within this grouping the sorting can be made according to Name or Size. Also the display of the Zero values and the De-tails (tables) can be controlled there.

Via option Archive with CO_ITEM you determine if archiving object CO_ITEM is considered during the analysis. If you switch off this option, the CO tables of archiv-ing object CO_ITEM are distributed to the corresponding archiving objects. This is especially relevant when you use the PBS archive add on CCO. Precondition for the distribution is that the construction of the capacity analysis was started with the option „Detailed analysis of the CO records“.

Via Determine document size, you can determine the average size of a document for certain documents.

The capacity of the single tables is displayed with option Single table evaluation.

Software GmbH


If desired further information can be displayed. You can select between the date when the statistic was built the last time and the number of lines in the table.

Diagram 5 shows the result after the selection of program /PBS/ANA_KAPAZITAET.

Diagram 5: Result of the capacity commitment

Software GmbH


The following characteristics are important:

The values of the disk occupancies are originated from capacity run no. 0002 of 29.03.2000 which has been created with program /PBS/ANA_AUFBAU. During this construction the result was a total capacity of 3.097.306 KB. The run was stored with the description Capacity analysis ID4 with CO details.

The evaluation of the analysis was started on 07.04.2000 at 14:57:15 o'clock by user DOERRSCHUCK.

For the evaluation a total of 452.126 KB was selected, this is 15% of the total ca-pacity (3.097.306 KB) of run 0001.

Archiving object FI_DOCUMNT has a total of 71.476 documents (entries in table BKPF) with a total size of 148.095 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.0% portion in the total capacity.

The size of table BSEG is 61.631 KB, which is 41,6 % of the selected data and 3,7 % of the total capacity.

Note: In some cases, the size of a table is displayed in brackets. That means that a clear assignment of the table to any archiving object was not possible. The Data-base Analyzer PLUS displays the size of the table for the first archiving object. The value appears in brackets for the remaining archiving objects in which the table is available and whose value is not added to the total size of the object.

Software GmbH


If you select option Single table evaluation, an overview of analyzed tables is ad-ditionally displayed.

Software GmbH


Software GmbH


The list is sorted according to the ABC and furthermore, displays the table class. The reason is the following:

The table DOKTL is a cluster table which is assigned to table cluster DOKCLU. The sizes of both tables are the same.

In addition to the capacity display you can determine the corresponding archiving objects by a double-click. A double-click on the entry VBAK shows that the table is assigned to the archiving object SD_VBAK.

Software GmbH


4.8. Comparison Analysis ABAP /PBS/ANA_KAPAZITAET_VGL allows the comfortable comparison of two analysis runs. For example, you can determine the increase of data within a period or the decrease of data after archiving.

We have already discussed the delimitations in chapter 4.7. In addition, for the comparison a second analysis run must be indicated. The result of a comparison analysis is shown in Diagram 7. An increase in the capacity means a loss of disk space and therefore is displayed with a negative sign in blue.

Diagram 6: Selection mask of the comparison analysis

Software GmbH


Diagram 7: Result of the comparison analysis

Software GmbH


4.9. Comments on the Capacity Analysis

The displayed total capacity is the sum of all tables which can be archived. The in-dices created on the database level are not considered. For the size of the index tables you can assume about 50 % of the indicated total capacity.

Movement data and master data not allocated to an archiving object is not consid-ered in the capacity analysis.

The table sizes, for example as shown in transaction DB02, can differ from those shown in the PBS DB Analyzer PLUS. Please note that possibly the size could be distributed to several archiving objects. Depending on the database system, spe-cific information (e.g. average free space in blocks) will be evaluated that might have impact on the displayed size, too.

Software GmbH


5. Analysis of the Document Distribution

The following chapter describes how the analysis for the document distribution is carried out. For this purpose we use ABAP/4 program /PBS/ANA_VERTEILUNG for the construction of the analysis and the programs described in chapter 5.3 for the evaluation.

5.1. Initialization Before you can carry out the first capacity or document distribution analysis the da-tabase tables of the Database Analyzer PLUS must be constructed in the R/3 sys-tem. To do this, please start ABAP /PBS/ANA_ERSTAUFBAU.

This ABAP copies the entries of database table /PBS/ANA_AR_DEF into table /PBS/ANA_AR_OBJ, adding to them the table names of the SQL database and more controlling information.

This program can also be used to delete all existing analyses.

Software GmbH


5.2. The Database Analysis ABAP /PBS/ANA_VERTEILUNG starts the analysis of the document distribution (see Diagram 7). The following information has to be entered:

Description: free text for the description of the analysis run.

from entry period - year and to entry period - year: this option allows you to re-strict the analysis for a better performance.

In addition, you can delimit also the areas of the analysis (accounting, sales, pur-chasing and cost accounting).

Diagram 8: Selection mask document distribution

Software GmbH


We recommend to run the ABAP in the background process where you can check the progress of the run via the protocol entries of the own jobs.

Having carried out the analysis the data which has been determined is stored in database tables /PBS/ANA_BE_LFN and /PBS/ANA_BE_TXT under a sequential number (run no.) and can be analyzed (see chapter 5.3).

Software GmbH


5.3. Analyze Document Distribution The document analysis constructed with program /PBS/ANA_VERTEILUNG for the selected areas can now be evaluated. The following allocation between the ABAP/4 programs and the areas to be analyzed apply:

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

In the following we only discuss the document distribution for the financial account-ing with the program /PBS/ANA_BKPF. The handling is analogue for the other ar-eas. Please see chapter 5.5.

Software GmbH


Diagram 9: Selection mask document distribution financial accounting

The financial accounting documents can be selected according to client, entry year, company code, document type and document analysis run no.

For the construction of the output list the indications in the section "Sort" are im-portant. The numbers 1 - 5 are the sorting sequence and at the same time the se-quence of the formation of pools. Should you want to suppress a sort criterion you have to delete the number in the corresponding field. However, please take care that the entered numbers are sequential and start with 1.

If you mark the button document analysis, you can branch to a line in the archiv-ability analysis by a double-click during the evaluation. Currently, this can only be done for BKPF, VBUK, EKKO and COBK. To avoid long run times, you can limit the analysis to 100 documents.

Software GmbH


The following diagram shows a document distribution for financial accounting docu-ments.

Diagram 10: Document distribution financial accounting

Software GmbH


The following characteristics are important:

The values of the document distribution are originated from capacity run no. 0084 which has been created with program /PBS/ANA_VERTEILUNG. The document distribution was constructed from period 01, year 1950 to period 12, year 2002. The average size of a document is 2.122 bytes. This value is originated from the last capacity analysis. The run was stored with description TEST.

Client 100 and company code 1000 contain a total of 2.8175 FI documents, occu-pying a capacity of 58.386 KB.

Software GmbH


5.4. Branching to the Archivability Check

It is possible to check the documents of a certain period within the evaluation of a distribution analysis whether they can be archived. Select one line which describes the number of documents of a period and double-click. The option "Document analysis" should be selected before.

Please note that only those documents can be analyzed on their archivability, which belong to the current client. The result of the check is then displayed and contains the following information among other:

The documents of client 100, company code S300, year 1999, document type AB of period 08. The archivability check results that one of the two documents has open items and therefore, it cannot be archived. The first document can be ar-chived.

Software GmbH


5.5. Comments on the Document Distribution

For the distribution of the documents according to period and year the entry date of the corresponding database table is used. The only exception is the distribution of the COEP records. As this table does not contain an entry date the fields year and period must be used.

For the selection criteria the following specialties are valid:

Sales documents: /PBS/ANA_VBUK

Via the selection criterion application the following sales document objects can be selected:

Sel.Crit Application A Orders L Delivery notes F Invoices

Cost center line items: /PBS/ANA_COEP

An important criterion for the archiving of cost center line items with CO_ITEM is the field COEP-OBJNR. For the selection of the CO_ITEM records the first two dig-its of field OBJNR are relevant. Depending on the language which has been used these two digits are substituted by a three-digit abbreviation which depends on the language. This allocation is defined in dictionary table TBO01.

Software GmbH


For the document distribution the analysis tool only considers these two digits which have the following meaning:

Sel. Crit. Object type AO Reconciliation object BP Business process EK Product costing 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 OV Operation PR PSP element VB Sales document item

Software GmbH


6. Archivability Check The archivability check of the PBS Database Analyzer PLUS analyzes the archiv-ability for selected archiving objects. This is important if documents which are within the period of the archiving run are not archived. The utility provides clear in-formation on the reasons why the documents are not archived.

At present the archiving objects FI_DOCUMNT, SD_VBAK, RV_LIKP, SD_VBRK and MM_EKKO are supported.

6.1. Check of the Archivability Again and again the question arises if the transaction data in the SAP system fulfill the criteria for an archiving run after the business-related procedures have been completed. After an archiving run at the latest, only having moderate success in reducing the load on the database tables, an analysis of the data material is nec-essary. These requirements are fulfilled by the inspection tools for the archiving ob-jects FI_DOCUMNT (financial accounting documents), SD_VBAK (orders), SD_VBRK (invoices), RV_LIKP (delivery notes) and MM_EKKO (purchase orders).

Software GmbH


6.2. Financial Accounting Documents The ABAP /PBS/ANA_ARCHIVE_FI_DOCUMNT provides an overview of all documents for the delimited period. For each document the reason is displayed why the document cannot be archived. From the single display, you can then branch off into the display of the accounting document.

Diagram 11: Selection result FI documents

Software GmbH


6.3. Sales Documents The documents of the SD module are analyzed, split according to the archiving ob-jects for orders, invoices and delivery notes. They are provided in a list so that the inspection results can be displayed for each document, allowing you to branch off easily to the document. The archivability checks which have been carried out are analogue to the checks of the original SAP archiving programs for orders, invoices, delivery notes.

Program for orders: /PBS/ANA_ARCHIVE_SD_VBAK

invoices: /PBS/ANA_ARCHIVE_SD_VBRK

delivery notes: /PBS/ANA_ARCHIVE_RV_LIKP

Software GmbH


Diagram 12: Selection result SD sales orders

Software GmbH


6.4. Purchasing Documents Also in case of the purchase orders the checks are carried out analogue to the SAP standard. For each document, the reasons are displayed why a document cannot be archived. In addition, you can branch off to the single document display.

Program for purchase orders: /PBS/ANA_ARCHIVE_MM_EKKO

Diagram 13: Selection result purchasing documents

Software GmbH


6.5. Forecast At present, the PBS Database Analyzer PLUS considers five archiving objects.

Depending on the feedback from our customers, the tool is extended successively, updates being provided free of charge within a support services agreement.

Software GmbH


7. Annex:

7.1. Examples for the Capacity Analysis Output of all archiving objects belonging to the application SD, formed in pools according to application and sorted according to size.

Selection: Application =' SD'

Formation of Pool: Archiving object Sorting: Size Options: Details ------------------------------------------------------------------------------------------------- | PBS DB ANALYZER: PLATTENPLATZBELEGUNG VON ARCHIVOBJEKTEN Zeit 16:06:26 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 : 113.586 KB | | Anteil Selektion am Lauf : 10 % | ------------------------------------------------------------------------------------------------- | Objekt Objektbezeichnung | Summe (KB) | Sel (%) Ges (%) | | Tabelle Tabellenname | Größe (KB) | Sel (%) Ges (%) | ------------------------------------------------------------------------------------------------- | SD_VBAK Verkaufsbelege | 60.027 | 52,8 5,5 | | VBAP Verkaufsbeleg: Positionsdaten | 7.729 | 6,8 0,7 | | CKIS Positionen Einzelkalkulation/Einzelnachweis Erz. | 6.922 | 6,1 0,6 | | KEKO Erzeugniskalkulation - Kopf | 6.762 | 6,0 0,6 | | VBEP Verkaufsbeleg: Einteilungsdaten | 4.666 | 4,1 0,4 | | VBAK Verkaufsbeleg: Kopfdaten | 4.017 | 3,5 0,4 | | VBPA Vertriebsbeleg: Partner | 3.993 | 3,5 0,4 | | KONV Konditionen (Vorgangsdaten) | 3.466 | 3,1 0,3 | | VBFA Vertriebsbelegfluß | 3.211 | 2,8 0,3 | | CDPOS Änderungsbelegpositionen | 2.468 | 2,2 0,2 | | NAST Nachrichtenstatus | 2.405 | 2,1 0,2 | | STXH STXD SAPscript Text-Datei Header | 1.853 | 1,6 0,2 | | CKIT Texte zu CKIS | 1.812 | 1,6 0,2 | | CMFP Speicherstruktur für die gesammelten Fehler | 1.512 | 1,3 0,1 | | VBKD Verkaufsbeleg: Kaufmännische Daten | 1.509 | 1,3 0,1 | | VAPMA Vertriebsindex: Auftragspositionen zu Material | 1.368 | 1,2 0,1 | | VBUK Vertriebsbeleg: Kopfstatus und Verwaltungsdaten | 1.364 | 1,2 0,1 | | KEPH Herstellkostenelemente der Erzeugniskalkulation | 1.257 | 1,1 0,1 | | VAKPA Vertriebsindex: Aufträge zu Partnerrollen | 1.167 | 1,0 0,1 | | VBUP Vertriebsbeleg: Positionsstatus | 1.022 | 0,9 0,1 | | CDHDR Änderungsbelegkopf | 393 | 0,3 0,0 | . . . | SD_COND Konditionssätze der Preisfindung | 7 | 0,0 0,0 | | KONM Konditionen (Mengenstaffel 1-dimensional) | 5 | 0,0 0,0 | | KONW Konditionen (Wertstaffel 1-dimensional) | 2 | 0,0 0,0 | -------------------------------------------------------------------------------------------------

Software GmbH


Output of all archiving objects sorted according to size

Selection:

Formation of Pool: Archiving object Sorting: Size Options: ------------------------------------------------------------------------------------------------- | 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 : 1.086.618 KB | | Anteil Selektion am Lauf : 100 % | ------------------------------------------------------------------------------------------------- | Objekt Objektbezeichnung | Summe (KB) | Sel (%) Ges (%) | ------------------------------------------------------------------------------------------------- | FI_DOCUMNT Finanzbuchhaltungsbelege | 144.641 | 13,3 13,3 | | 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 | 5,5 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 | 3,3 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,1 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 | 1,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,5 | | FI_ACCRECV Debitorenstammdaten | 3.102 | 0,3 0,3 | | QM_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 | | QM_QMEL 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 | | QM_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 MM-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 | 17 | 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 | -------------------------------------------------------------------------------------------------

Software GmbH


Size of the archive table NAST and display of the distribution to the archiving objects.

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 1 | ------------------------------------------------------------------------------------------------- | Kapazität der selektierten Daten : 8.841 KB | | Anteil Selektion am Lauf : 1 % | ------------------------------------------------------------------------------------------------- | Tabelle Object Bezeichnung | Größe (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 | -------------------------------------------------------------------------------------------------

Software GmbH


Determination of the document size for the archiving objects from the applications SD, MM, FI:

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 13,3 | | 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 3,3 | | SD_VBRK Fakturen | 31.074 | 7,7 2,9 | | VBRK Anz.: 10.155 Byte: 3.133 | | | | 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 Lagerverwaltung: 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 | -------------------------------------------------------------------------------------------------

Software GmbH


7.2. Examples for the Analysis of the Document Distribution (financial accounting)

Overview of the number of the posted documents for each period and company code for the client 800.

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 1 | ------------------------------------------------------------------------------ | MANDT BUKRS PERIOD | Anzahl | Größe (KB) | Größe % | ------------------------------------------------------------------------------ | 800 0001 06 | 1 | 2 | 0,02 | ------------------------------------------------------------------------------ | 800 0001 ** | 1 | 2 | 0,02 | ------------------------------------------------------------------------------ | 800 1000 01 | 162 | 260 | 3,84 | | 800 1000 02 | 106 | 170 | 2,51 | | 800 1000 03 | 47 | 75 | 1,11 | | 800 1000 04 | 50 | 80 | 1,18 | | 800 1000 05 | 557 | 894 | 13,20 | | 800 1000 06 | 776 | 1.246 | 18,39 | | 800 1000 07 | 351 | 564 | 8,32 | | 800 1000 08 | 181 | 291 | 4,29 | | 800 1000 09 | 206 | 331 | 4,88 | | 800 1000 10 | 137 | 220 | 3,25 | | 800 1000 11 | 119 | 191 | 2,82 | | 800 1000 12 | 246 | 395 | 5,83 | ------------------------------------------------------------------------------ | 800 1000 ** | 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 11 | 231 | 371 | 5,47 | | 800 3000 12 | 61 | 98 | 1,45 | ------------------------------------------------------------------------------ | 800 3000 ** | 841 | 1.350 | 19,93 | ------------------------------------------------------------------------------ | 800 4000 05 | 1 | 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 US01 ** | 128 | 206 | 3,03 | ------------------------------------------------------------------------------ | 800 **** ** | 4.220 | 6.775 | 100,00 | ------------------------------------------------------------------------------ | *** **** ** | 4.220 | 6.775 | 100,00 | ------------------------------------------------------------------------------

Software GmbH


Document volume in the different periods of the years 1995 and 1996 with the corresponding company codes for all clients

Selection: Entry year 1995 - 1996

Formation of Pool: 1. Posting year, 2. Posting period, 3. Company co-de

------------------------------------------------------------------------------ | 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,13 | ------------------------------------------------------------------------------ | 1995 01 **** | 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 **** | 258 | 414 | 0,40 | ------------------------------------------------------------------------------ | 1995 03 1000 | 94 | 151 | 0,15 | | 1995 03 3000 | 36 | 58 | 0,06 | ------------------------------------------------------------------------------ | 1995 03 **** | 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 **** | 124 | 199 | 0,19 | ------------------------------------------------------------------------------ | 1995 05 1000 | 1.114 | 1.788 | 1,74 | | 1995 05 2000 | 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 **** | 1.462 | 2.347 | 2,28 | ------------------------------------------------------------------------------ . . . | 1996 10 3000 | 152 | 244 | 0,24 | ------------------------------------------------------------------------------ | 1996 10 **** | 3.902 | 6.265 | 6,09 | ------------------------------------------------------------------------------ | 1996 11 1000 | 3.744 | 6.011 | 5,85 | | 1996 11 2000 | 274 | 440 | 0,43 | | 1996 11 3000 | 294 | 472 | 0,46 | ------------------------------------------------------------------------------ | 1996 11 **** | 4.312 | 6.923 | 6,73 | ------------------------------------------------------------------------------ | 1996 12 1000 | 3.240 | 5.202 | 5,06 | | 1996 12 2000 | 272 | 437 | 0,42 | | 1996 12 3000 | 170 | 273 | 0,27 | | 1996 12 4000 | 4 | 6 | 0,01 | ------------------------------------------------------------------------------ | 1996 12 **** | 3.686 | 5.918 | 5,76 | ------------------------------------------------------------------------------ | 1996 ** **** | 55.535 | 89.160 | 86,72 | ------------------------------------------------------------------------------ | **** ** **** | 64.043 | 102.819 | 100,00 | ------------------------------------------------------------------------------

Software GmbH


Number of the posted documents according to document type and year for the client 800

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öße % | ------------------------------------------------------------------------------ | AA 1994 | 130 | 209 | 0,29 | | AA 1995 | 166 | 267 | 0,37 | | AA 1996 | 24 | 39 | 0,05 | | AA 1997 | 182 | 292 | 0,40 | ------------------------------------------------------------------------------ | AA **** | 502 | 806 | 1,12 | ------------------------------------------------------------------------------ | AB 1994 | 13 | 21 | 0,03 | | AB 1995 | 267 | 429 | 0,59 | | AB 1996 | 108 | 173 | 0,24 | | AB 1997 | 25 | 40 | 0,06 | ------------------------------------------------------------------------------ | AB **** | 413 | 663 | 0,92 | ------------------------------------------------------------------------------ | AF 1994 | 339 | 544 | 0,75 | | AF 1995 | 722 | 1.159 | 1,60 | | AF 1996 | 1.363 | 2.188 | 3,03 | | AF 1997 | 172 | 276 | 0,38 | ------------------------------------------------------------------------------ | AF **** | 2.596 | 4.168 | 5,77 | ------------------------------------------------------------------------------ | AN 1994 | 1 | 2 | 0,00 | | AN 1995 | 1 | 2 | 0,00 | ------------------------------------------------------------------------------ | AN **** | 2 | 3 | 0,00 | ------------------------------------------------------------------------------ | DA 1995 | 1 | 2 | 0,00 | | DA 1996 | 2 | 3 | 0,00 | ------------------------------------------------------------------------------ | DA **** | 3 | 5 | 0,01 | ------------------------------------------------------------------------------ | DG 1996 | 2 | 3 | 0,00 | ------------------------------------------------------------------------------ | DG **** | 2 | 3 | 0,00 | ------------------------------------------------------------------------------ | DR 1994 | 6.093 | 9.782 | 13,54 | | DR 1995 | 298 | 478 | 0,66 | | KA 1995 | 51 | 82 | 0,11 | . . . | WL 1997 | 221 | 355 | 0,49 | ------------------------------------------------------------------------------ | WL **** | 3.354 | 5.385 | 7,46 | ------------------------------------------------------------------------------ | ZP 1994 | 21 | 34 | 0,05 | | ZP 1995 | 96 | 154 | 0,21 | | ZP 1996 | 117 | 188 | 0,26 | | ZP 1997 | 74 | 119 | 0,16 | ------------------------------------------------------------------------------ | ZP **** | 308 | 494 | 0,68 | ------------------------------------------------------------------------------ | ** **** | 44.987 | 72.225 | 100,00 | ------------------------------------------------------------------------------

Software GmbH


Software GmbH

Document volume of the company codes in the different clients

Selection: Entry year 1995 - 1996

Formation of Pool: 1. Posting year, 2. Posting period, 3. Company co-de

------------------------------------------------------------------------------ | 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 | ------------------------------------------------------------------------------ | MANDT BUKRS | Anzahl | Größe (KB) | Größe % | ------------------------------------------------------------------------------ | 100 0001 | 1 | 2 | 0,00 | | 100 1000 | 32.231 | 51.746 | 35,78 | | 100 2000 | 2.597 | 4.169 | 2,88 | | 100 2100 | 32 | 51 | 0,04 | | 100 2200 | 4 | 6 | 0,00 | | 100 3000 | 9.648 | 15.490 | 10,71 | | 100 4000 | 229 | 368 | 0,25 | | 100 4200 | 1 | 2 | 0,00 | | 100 6000 | 48 | 77 | 0,05 | | 100 US01 | 200 | 321 | 0,22 | ------------------------------------------------------------------------------ | 100 **** | 44.991 | 72.232 | 49,95 | ------------------------------------------------------------------------------ | 800 0001 | 1 | 2 | 0,00 | | 800 1000 | 32.227 | 51.739 | 35,78 | | 800 2000 | 2.597 | 4.169 | 2,88 | | 800 2100 | 32 | 51 | 0,04 | | 800 2200 | 4 | 6 | 0,00 | | 800 3000 | 9.648 | 15.490 | 10,71 | | 800 4000 | 229 | 368 | 0,25 | | 800 4200 | 1 | 2 | 0,00 | | 800 6000 | 48 | 77 | 0,05 | | 800 US01 | 200 | 321 | 0,22 | ------------------------------------------------------------------------------ | 800 **** | 44.987 | 72.225 | 49,95 | ------------------------------------------------------------------------------ | 810 1000 | 24 | 39 | 0,03 | ------------------------------------------------------------------------------ | 810 **** | 24 | 39 | 0,03 | ------------------------------------------------------------------------------ | 811 2100 | 71 | 114 | 0,08 | ------------------------------------------------------------------------------ | 811 **** | 71 | 114 | 0,08 | ------------------------------------------------------------------------------ | *** **** | 90.073 | 144.609 | 100,00 | ------------------------------------------------------------------------------