--- title: "Updating Usage Data from a CSV file" slug: "usage-csv" updated: 2026-05-27T09:21:11Z published: 2026-05-27T09:21:11Z canonical: "success.panaya.com/usage-csv" --- > ## Documentation Index > Fetch the complete documentation index at: https://success.panaya.com/llms.txt > Use this file to discover all available pages before exploring further. # Updating Usage Data from a CSV file Usage is used in several aspects of the Panaya solution and plays an important role in several activities, for example - - [Project scoping](/v1/docs/how-to-plan-the-corrections-cycle) - [Code cleanup](/v1/docs/s4code-project-plan) - [Priority level for Fiori progression tests](https://success.panaya.com/v1/docs/tests-and-recommended-unit-tests-priority-complexity#progression-tests-for-fiori) More information about usage levels can be found [here](/v1/docs/how-does-panaya-determine-usage). Usage is extracted during the [full ETL extraction](/v1/docs/how-to-extract-and-upload-your-custom-code) process or with a [usage only](/v1/docs/how-to-extract-usage-statistics-data-only) extraction. Panaya automatically extracts usage from the production system via RFC, but in some cases, it may not be possible to do this. To manually extract usage statistics from the production system, you need to access the production system, run transaction **ST03N** (R/3 Workload and Performance Statistics), and export the required information. Then, upload the usage file to Panaya. ## Extracting Transaction Usage Follow these steps to extract the **transaction** data for each month the system collects data - 1. Run transaction **ST03N** in production. 2. Choose **Expert Mode.** 3. Choose Month XX. 4. Under the Analysis View > Transaction profiles > **Standard.** 5. Change the Layout and include **only** the following columns - Report or Transaction name, Name of Background Job, and Number of Dialog Steps. ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-PC4VY1KA.png) 6. Choose the **Times** Tab. 7. Export the list to an Excel spreadsheet in CSV format (include the month and year in the file name for easy reference). Be sure to format the “Number of Dialog Steps” column to a **number**. The resulting file should look similar to this format: ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-0CLAV3ER.png) 8. Repeat steps 1-8 for each month. ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-5VFRXTMU.png) ## Extracting RFC Usage Follow the below steps to extract the **RFC** usage data for each month the system collects data - 1. Run transaction **ST03N** in production. 2. Choose **Expert Mode.** 3. Choose Month XX. 4. Under the Analysis View > RFC profiles > **RFC Server Profile.** 5. Choose the **Function Module** Tab. 6. Change the Layout and include **only** the following columns: Function Module and Number of RFC Calls. ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-SZJUV9OZ.png) 7. Export the list to an Excel spreadsheet in CSV format (include the month and year in the file name for easy reference). Be sure to format the “Number of RFC Calls ” column to a **number**. The resulting file should look similar to this format: ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-649LFU3N.png) 8. Repeat steps 1-8 for each month. ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-XHHWYL64.png) ## Uploading Usage to Panaya > You must upload at least one full ETL extraction prior to uploading the usage to Panaya. In the Panaya Configuration page, go to SAP Development → Object usage data update → Upload usage. ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-FRTNT01K.png) ![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-GV4J1P77.png) 1. Select the Panaya system you would like to upload the usage to. 2. Select the File usage type, either Transaction or RFC. 3. Select the month and year of the usage file, and pay attention that you enter the exact format, mm-yyyy. 4. Drop/paste or upload the usage file and click on Upload. > [!NOTE] > Good to Know! > > The uploaded usage will be processed with the next full custom code upload. > > See that only commas (,) and not other characters, such as semicolons, are separating columns. > > Verify the file is in saved in a CSV format, which can be opened successfully with an editor, such as Notepad. > > See that the columns are in the exact order as advised for each upload usage file type. ## Related - [Extracting Usage Only](/how-to-extract-usage-statistics-data-only.md) - [Usage Field for SAP](/how-does-panaya-determine-usage.md)