# SAP Integration Test Case Matrix Worksheet > Source: https://netray.co/tools/sap-integration-test-case-matrix-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable test matrix for SAP interface testing, with scenario, expected result, pass flag and defect count rolled up to a pass rate. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP test lead - SAP integration developer - Business tester ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Test case **Key:** tc **Type:** text #### Interface **Key:** interface **Type:** text #### Scenario **Key:** scenario **Type:** text #### Input data **Key:** input **Type:** text #### Expected result **Key:** expected **Type:** text #### Status **Key:** status **Type:** select **Options:** - Not run - Passed - Failed - Blocked #### Passed (1 or 0) **Key:** passed **Type:** number #### Open defects **Key:** defects **Type:** number #### Tester **Key:** tester **Type:** text #### Run date **Key:** run_date **Type:** date **Rows:** **Tc:** TC-01 **Interface:** IF-001 Orders **Scenario:** Valid order, one line **Input:** ORDERS05, known customer and material **Expected:** Sales order created, IDoc status 53 **Status:** Passed **Passed:** 1 **Defects:** 0 **Tester:** A. Mehta **Run date:** 2026-10-12 **Tc:** TC-02 **Interface:** IF-001 Orders **Scenario:** Unknown material **Input:** ORDERS05 with material not in plant **Expected:** IDoc status 51 with clear message **Status:** Passed **Passed:** 1 **Defects:** 0 **Tester:** A. Mehta **Run date:** 2026-10-12 **Tc:** TC-03 **Interface:** IF-001 Orders **Scenario:** Duplicate PO number **Input:** Same PO sent twice **Expected:** Second order rejected or flagged **Status:** Failed **Passed:** 0 **Defects:** 1 **Tester:** A. Mehta **Run date:** 2026-10-13 **Tc:** TC-04 **Interface:** IF-002 Ship notice **Scenario:** Partial delivery **Input:** Delivery with 2 of 3 lines picked **Expected:** DESADV with two lines, correct quantities **Status:** Passed **Passed:** 1 **Defects:** 0 **Tester:** R. Singh **Run date:** 2026-10-14 **Tc:** TC-05 **Interface:** IF-002 Ship notice **Scenario:** Partner port unavailable **Input:** Disable RFC destination **Expected:** Status 02, retry works after restore **Status:** Not run **Passed:** 0 **Defects:** 0 **Tc:** TC-06 **Interface:** IF-004 Confirmations **Scenario:** Over-confirmation **Input:** Quantity above order quantity **Expected:** Rejected with message, no posting **Status:** Blocked **Passed:** 0 **Defects:** 1 **Tester:** R. Singh **Run date:** 2026-10-15 **Totals:** #### Test cases **Key:** tc **Agg:** count #### Passed **Key:** passed **Agg:** sum **Format:** integer #### Open defects **Key:** defects **Agg:** sum **Format:** integer **Summary:** #### Pass rate **Key:** pass_rate **Expr:** sum_passed / count * 100 **Format:** percent **Primary:** true #### Cases not passed **Key:** remaining **Expr:** count - sum_passed **Format:** integer **Notes:** Set Passed to 1 when the status is Passed, otherwise 0, so the pass rate updates. Cover happy path, bad data, duplicates, volume and connection failure for every interface. ## Content **Intro:** Interface testing fails when only the happy path is checked. This matrix gives you a simple place to list scenarios, expected results and outcomes, and gets a pass rate you can report at the test exit meeting. **Sections:** #### How to use the matrix **Body:** List each interface and write scenarios in plain language. Fill the input column with what you will send, such as a message type, a key field value or a file name, and the expected result with both the technical outcome and the business outcome. For example, status 53 on the IDoc and a sales order with the correct partner functions. Mark the status after the run and set the Passed flag to 1 for passes. The summary rolls up pass rate and cases not passed. Export to Excel for the test report or attach the PDF to the release approval. **Bullets:** - Write the expected technical and business result - Record tester and date for audit - Link defects to the case number #### Scenarios every interface needs **Body:** Beyond a successful message, include the cases that usually break in production. Send a message with a missing mandatory field, an unknown master record and a closed posting period. Send the same message twice to confirm duplicate handling. Send a large message and a burst of messages to see work process behaviour. Stop the receiver or the RFC destination and confirm that statuses and retries behave as expected. Test the monitoring: does the failure appear where support looks, such as WE02, BD87 or the middleware monitor, and does an alert fire? #### Reading the pass rate **Body:** A pass rate is only as good as the case list. One hundred percent on five easy cases means little. Look at which categories are covered and at blocked cases, which often hide integration problems with the other system. Set an exit rule before testing starts, for example all critical interface cases passed and no open severity 1 or 2 defects. Use the defects column to see which interface carries the risk, and retest after each fix rather than assuming it works. **Bullets:** - Agree exit criteria before testing - Treat blocked cases as open risk - Retest after every fix **Cta:** Netray can help build repeatable regression tests for IDoc and API interfaces that run against a copy of your system before each upgrade. **Faq:** #### How do I test an inbound IDoc without the partner? **Answer:** Use transaction WE19 to create a test IDoc from an existing one or from scratch, edit the data and send it through inbound processing. It is the standard way to simulate a partner message in a test client. #### How many test cases are enough? **Answer:** It depends on risk. A simple outbound notice may need five to ten cases, a complex inbound order interface many more. Cover each message variant, each error path and each partner with different mapping. #### Should performance tests be in this matrix? **Answer:** Include at least one volume and burst case per critical interface, with the volume stated in the input column. Full load testing may need a separate plan and tooling. #### Why is there a separate Passed flag? **Answer:** The status column is a label, and the worksheet cannot sum labels. A numeric flag lets the summary compute the pass rate automatically. ## Search terms sap integration test cases, idoc test case template, sap interface testing excel, sap uat test matrix, sap integration test plan, interface test script template, we19 test cases --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json