cancel
Showing results for 
Search instead for 
Did you mean: 

To do a Data Volume Analysis (application related) of SAP system

Former Member
0 Kudos

We want to get a Data Volume Analysis of our SAP system.

It is about application related.

We searched in system menu, but did't find relevant tcode to get it.

What we want is as the version below:

Data Volume Analysis

Procurement (Materials Management) Count Comments

Active Raw Materials

Active Semi finished Materials

Active Finished Goods Materials

Active consumable Materials

Average New Raw Materials

Average New Finished Goods

Active Vendor Masters

New Vendors Masters / Month

Number of Info records

Active Source Lists

Average Purchase Documents / Month

Average Purchase Document lines / Month

Average Goods Receipts from Purchasing / Month

Average Vendor Invoices Processed / Month

Average Number of Vendor Returns/ Month

Frequency of Cycle Counts/Inventory Adjustments

Warehouse Management Count Comments

Number of Warehouses

Number of Bins within Warehouse

Number of Storage Types within Warehouse

Average Number of warehouse movements/Transactions

Commercial (Sales & Distribution) Count Comments

Active Customers

Average New Customers / Month

Average Sales Orders / Month

Average Sales Items / Month

Average Deliveries / Month

Average Delivery Lines / Month

Average Billing Documents / Month

Average Billing Document items / Month

Manufacturing (Production Planning) Count Comments

Average Production orders Cable / Month

Average number of Operations within Production order for Cable

Average Monthly CKM, FKM

Average production orders H&E / Month

Average number of Operations within Production order for H&E

Finance & Controlling Count Comments

Number of Fixed Assets

How can we get this Data Volume Analysis (application related)?

Anyone experienced please kindly give advice.

Regards,

Allen

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

may I know for what purpose you wish to do Data Volume Analysis ? For Data archiving purpose ?

Our functional usually use tcode TAANA to do Table Analysis before doing data archiving for certain archiving objects. It will allows you to count number of record and estimate volume of specific data since data is stored on table level.

here is description of TAANA taken directly from SAP :

Use

You can use the table analysis program to analyze how table entries are distributed across specific fields. A table analysis counts the table entries and assigns the number of found entries to the selected field values (for example organizational units, time periods). You can select the fields using analysis variants.

Activities

Performing a Table Analysis

You can call up the table analysis function via transaction TAANA. Choose Table Analysis ->Perform Check. Enter the table name. From the F4 help list for field Analysis Variant choose at least one variant, or create a new one.

The analysis variant DEFAULT is offered for every table. If you cannot find an analysis variant that fits your requirements you can create an ad hoc variant. It is not saved in the database and is, therefore, only available for the analysis you are currently scheduling.

You can also create a traditional variant. It is saved in the database and can be reused.

For performance reasons, we recommend that you analyze large tables in the background, not online. The table you selected for the analysis is displayed in the left screen area.

Displaying a Table Analysis

To display a table analysis, select the analysis in the left screen area via double click. The analyses are sorted according to the name of the analysis variant and creation date.

Deleting a Table Analysis

To delete already created table analyses select the corresponding analysis in the left screen area and choose Table Analysis ->Delete.

Monitoring the Database Space Used by the Table Analyses

To delete or refresh analyses based on specific criteria, choose Utilities -> Reorganize analyses.... We recommend using this function regularly, because the results of all table analyses are saved in database tables (ARDB_STAT0 to ARDB_STAT2) and can take up a lot of space.

You can find out how much space already created analyses are taking up in table ARDB_STAT2, using analysis variants TAANA_ANALYSE_BY_OBJ_1 and TAANA_ANALYSE_BY_DATE_1. The used space statistic contains information about the number of table rows in table ARDB_STAT2. This table contains the largest part of the information about the analyses that have been performed.

The analysis variant TAANA_ANALYSE_BY_OBJ_1 shows used space according to table and analysis variant, the variant TAANA_ANALYSE_BY_DATE_1 shows the used space based on the month and year during which the table analysis was performed.

Creating Analysis Variants

To create and edit analysis variants choose Environment ->Analysis Variants.

Creating Virtual Fields

To create or edit virtual fields, choose Environment -> Virtual Fields.

hope it help you.

rgds,

Alfonsus Guritno.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Allen,

As rightly said by Alfonsus, you can use transaction TAANA for your requirement. Find out the right table to be analyzed for your requirements, find the fields which needs to be analyzed and run the analysis using TAANA.

For e.g. if I have to find out the document distribution of Financial Accounting documents over the years and to different company codes, I would do an analysis on table BKPF, which is the header for FI documents, on fields BUKRS and GJAHR.

If you are doing different kind of analysis on the same table, put in all the required fields, run the analysis and export the results to excel and use pivot tables to get your analysis.

Hope this helps,

Naveen