Community
Technology Blog Posts by SAP
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

New options to import manual Test Cases into SAP Cloud ALM

reiner_markheiser
Product and Topic Expert
Product and Topic Expert
‎2025 Apr 24 12:29 PM
4,637

Options to import manual Test Cases into SAP Cloud ALM

1. Prepare import of Test Cases using a template spreadsheet

Uploading Manual Test Cases made easy. Creating and uploading manual test cases to your project can be accomplished by using a spreadsheet. Here’s a simple guide to get you started:

Step-by-Step Guide

Prepare Your Spreadsheet

  1. Get the Template: Start by downloading the template available in the Test Preparation app. You can find it by clicking on the ‘Upload’ icon:

    reiner_markheiser_0-1745994620432.png

    In the pop-up select 'template' to download th template spreadsheet:

    reiner_markheiser_1-1745994746999.png 

  2. Follow the Guidelines: Keep your file within the 5 MB size limit and under 10,000 rows. Don’t add extra sheets or columns, and maintain the given column titles and order. No images should be added. 

  3. Fill in Your Data: Enter each test case in the predefined columns:

    • Test Case Name: Title of your case.
    • Test Case Status: Options are ‘In Preparation’ and ‘Prepared’.
    • Test Case Priority: Select from ‘Low’, ‘Medium’, ‘High’, and ‘Very High’.
    • Test Case References: Include links formatted like [Link Text](url); multiple entries should be separated by a line break.
    • Test Case Owner: Input owner’s email. (If user with provided mail address does not exist, 'Former Member' is displayed in the General Information tab, as soon a user with the provided mail address is available the real name is displayed)
    • Tag: Add existing tags or tag groups; separate multiple tags with a line break. (Tag groups must be created in advance using the Tag Management app)
    • Activity Title(*): To add an activity to the test case, enter an activity title. Add a new line for each new activity.
    • Activity Target Name / Activity Target URL: To include a link to the relevant application for an activity, provide the app name and a URL.
    • Action Title (*):  Add one action per row. To add multiple actions for an activity, repeat the activity title for each action. You don't need to repeat any of the other columns.
    • Action Instructions (*): Describe the action in more detail.
    • Action Expected Result: Describe the expected behavior of the application if the corresponding instructions are carried out.

  4. Save your spreadsheet file in Office Open XML format (XLSX).

2. Get Best Practice Test Cases for S/4HANA

There are 2 options to download Best Practice Test Cases:

  1. Via Signavio Process Navigator in SAP for Me: https://me.sap.com/processnavigator/HomePage
    Navigate via tile Solution Scenario or Solution Processes, select the relevant Solution Scenario for S/4HANA:
    reiner_markheiser_0-1745934976004.png

    Select relevant Solution Process:
    reiner_markheiser_1-1745937588063.png

    Download Test Case to your local PC:

    reiner_markheiser_2-1745937665871.png

     

  2. Via Procceses app in SAP Cloud ALM:
    reiner_markheiser_3-1745938000417.png

     

     

Optional: adjust spreadsheet file before upload

As most best practice test cases are quite large you might want drop optional activities or to split them into several pieces.

Cleanup optional activities

To do so you can open the spreadsheet in Excel and select the rows for the activities / actions to be deleted:

reiner_markheiser_0-1762269529521.png

Make sure to keep the header row and then delete selected rows and save.

Split best practice test case into several pieces

Check the column 'Activity Title*' and for the 1st occurence of the relevant activity enter the test case name using a meaningful naming convention in the column 'Test Case Name*' :

reiner_markheiser_2-1762270552867.png

and save.

 

3. Upload Test Cases into SAP Cloud ALM

Who Can Upload?

To upload test cases, you need to be assigned one of the following roles in your project:

  • Project Administrator
  • Project Lead
  • Project Member

Upload the Spreadsheet

  1. Open Upload Tool: Go back to the Test Preparation app and click on the ‘Upload’ icon.
  2. Select Scope:  Select the scope for which you want to upload the test cases.
  3. Select File: Choose Browse icon and select the spreadsheet file containing your test cases.

    select file.jpg

      

  4. Complete Upload: Click 'Upload', and follow the on-screen instructions. If there are errors, some may need fixing for a successful upload. If you only see warnings, you can proceed.

What Happens Next?

Once uploaded successfully, the test cases are added to your project and scope. You can now start utilizing them in

  1. Test Preparation assigning them to Solution Process, Requirements, User Stories, Process Hierarchy Nodes etc.  
  2. Test Plan assigning test cases that are executed in specific test cycles, helping you run your testing activities in iterations or in various departments. (see also blog post Advanced Test Orchestration using Test Plans and tester assignment in SAP Cloud ALM and Simplifying Test Management in SAP Cloud ALM: Introducing Simple Test Case Sequences)
  3. Test Execution you can execute the test cases that have been prepared in the Test Preparation app.
3 Comments