# SAP S/4HANA Test Scenario Tracker

> Source: https://netray.co/tools/sap-s4hana-test-scenario-tracker
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Track integration and user acceptance test scenarios with pass rates and open defects per process area. Exports to Excel.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- SAP test manager
- SAP program manager
- Business process owner

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Scenario

**Key:** scenario

**Type:** text

#### Process area

**Key:** area

**Type:** select

**Options:**

- Order to cash
- Procure to pay
- Plan to produce
- Record to report
- Quality
- Maintenance
- Master data
- Interfaces

#### Test phase

**Key:** phase

**Type:** select

**Options:**

- SIT 1
- SIT 2
- UAT
- Regression

#### Planned cases

**Key:** planned

**Type:** number

**Format:** integer

#### Executed

**Key:** executed

**Type:** number

**Format:** integer

#### Passed

**Key:** passed

**Type:** number

**Format:** integer

#### Failed

**Key:** failed

**Type:** number

**Expr:** executed - passed

**Format:** integer

#### Pass rate

**Key:** pass_rate

**Type:** number

**Expr:** if(gt(executed,0), passed / executed * 100, 0)

**Format:** percent

#### Execution progress

**Key:** exec_rate

**Type:** number

**Expr:** if(gt(planned,0), executed / planned * 100, 0)

**Format:** percent

#### Open sev 1-2 defects

**Key:** sev12

**Type:** number

**Format:** integer

#### Lead tester

**Key:** tester

**Type:** text

**Rows:**

#### SIT 1

**Scenario:** Standard sales order to invoice

**Area:** Order to cash

**Planned:** 24

**Executed:** 24

**Passed:** 22

**Sev12:** 0

**Tester:** R. Mehta

#### SIT 1

**Scenario:** Purchase requisition to vendor payment

**Area:** Procure to pay

**Planned:** 30

**Executed:** 26

**Passed:** 23

**Sev12:** 1

**Tester:** L. Okafor

#### SIT 1

**Scenario:** Production order with backflush and confirmation

**Area:** Plan to produce

**Planned:** 36

**Executed:** 30

**Passed:** 24

**Sev12:** 2

**Tester:** J. Chen

#### SIT 1

**Scenario:** Month-end close with settlement

**Area:** Record to report

**Planned:** 18

**Executed:** 10

**Passed:** 8

**Sev12:** 1

**Tester:** S. Iyer

#### SIT 1

**Scenario:** Inbound EDI order via middleware

**Area:** Interfaces

**Planned:** 12

**Executed:** 12

**Passed:** 11

**Sev12:** 0

**Tester:** T. Novak

**Totals:**

#### Planned cases

**Key:** planned

**Agg:** sum

**Format:** integer

#### Executed cases

**Key:** executed

**Agg:** sum

**Format:** integer

#### Passed cases

**Key:** passed

**Agg:** sum

**Format:** integer

#### Open severity 1-2 defects

**Key:** sev12

**Agg:** sum

**Format:** integer

**Summary:**

#### Overall execution progress

**Key:** overall_exec

**Expr:** if(gt(sum_planned,0), sum_executed / sum_planned * 100, 0)

**Format:** percent

#### Overall pass rate

**Key:** overall_pass

**Expr:** if(gt(sum_executed,0), sum_passed / sum_executed * 100, 0)

**Format:** percent

**Notes:** Set exit criteria before testing starts, for example 100 percent of critical scenarios executed, 95 percent pass rate and no open severity 1 or 2 defects. Counts here are by test case, so one scenario row can hold several cases.

## Content

**Intro:** Testing is where most S/4HANA programs discover their real status. This tracker keeps execution, pass rate and critical defects per process area visible, without a heavy test tool.

**Sections:**

#### How to use the tracker

**Body:** Create one row per end-to-end scenario and test phase, with the planned number of cases. Testers update executed and passed counts daily. Failed cases, pass rate and execution progress calculate automatically. Add the number of open severity 1 and 2 defects from your defect tool. Export to Excel for the daily test stand-up.

**Bullets:**

- Update counts at the same time every day
- Track by end-to-end scenario, not by module
- Keep a separate row per test phase
- Link defect numbers in the exported file

#### Reading the numbers

**Body:** Execution progress shows how much testing is done, and pass rate shows quality of what was executed. High pass rate with low execution is not good news, because the hard scenarios are often last. Watch process areas with failed cases plus open high-severity defects, as they hold up exit. Compare progress to plan each day to catch slippage early.

#### Test phases for S/4HANA

**Body:** Typical programs run unit tests during build, then one or two rounds of integration testing, user acceptance testing and a regression round before cutover. Add performance and security tests, plus testing of interfaces, print forms and authorizations. Business users should run UAT using real master data and realistic volumes.

#### Common mistakes

**Body:** Teams skip negative tests, use clean demo data, and test only the happy path. Others do not retest after defect fixes or transports. Define exit criteria upfront and do not lower them under date pressure without a documented decision.

**Cta:** Netray can help generate test data and compare outputs between legacy and new systems, so regression checks run faster and with less manual effort.

**Faq:**

#### What are good exit criteria for SIT?

**Answer:** Common criteria are all critical scenarios executed, a pass rate of at least 95 percent, and no open severity 1 or 2 defects. Agree the exact thresholds in the test strategy before testing begins.

#### How is UAT different from SIT?

**Answer:** SIT checks that the integrated system works end to end, usually run by the project team. UAT is run by business users to confirm that the solution supports their real work.

#### Can I use this instead of a test management tool?

**Answer:** For small to mid-size programs, it can be enough. For hundreds of cases with traceability needs, use a test tool and keep this as a summary view.

#### Does it track individual defects?

**Answer:** No. It holds counts of open high-severity defects per area. Track detail in your defect tool.

## Search terms

sap test tracker excel, s4hana uat tracker, sap integration test scenarios template, sap test plan template excel, sap sit uat tracking, sap test case tracker

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json