Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 4 of 6

Test data ideas and SAP master data rules

16 min

Listen to this lesson

0:00 / 5:15

This course discusses ACCELQ by name. Matt Angerer, who runs The Sign-Off Table, works at ACCELQ. Disclosure

AI is good at the combinatorial part of test data: listing equivalence classes, boundaries and combinations faster than a person can type them. It is bad at the part SAP testers spend their days on: knowing whether a given supplier, material and organizational unit actually fit together in a specific client. So split the job. Let AI propose; let the test client decide.

What to ask for

TechniquePrompt forContoso example
Equivalence partitionsValid and invalid classes for each inputPO net value: up to $25,000; over $25,000; zero; negative
Boundary valuesValues on each side of every threshold$10,000.00 and $10,000.01 for purchase requisition release; $25,000.00 and $25,000.01 for PO approval
Pairwise combinationsA small set covering every pair of values across inputsPlant 1710 or 1720 × material CMC-RTR-200 or CMC-STA-300 × value class × purchasing group
Data statesRecords in each status the process can meetA blocked supplier, a material not extended to the plant, a closed posting period
RolesUsers with and without the needed authorizationsA buyer who can create but not approve; an approver for a different purchasing group

Classic test design techniques make good prompts for data ideas.

Ask for the reasoning, not just the values: "for each row, name the class or boundary it represents." That makes review fast, because the reviewer checks the logic once and the values follow. ISTQB's generative AI syllabus makes the same point about evaluating AI results: you need a way to judge output, not just receive it.

Validate against SAP master data rules

Every proposed row must survive contact with the test client. In SAP, data has dependencies an AI model can't see: a supplier needs purchasing organization data before you can order from it, a material must be extended to the plant and valuation area, a price needs a purchasing info record or a manual condition, and a posting needs an open period. The data owner checks each row against these rules in CMQ client 100 before any tester relies on it.

The master data a purchase order test needs; an AI-proposed row is valid only if every link exists in the test client.
The Sign-Off Table · thesignofftable.com/academy/sap-aiq-203
  1. ProposeAI lists classes, boundaries and combinations with the reason for each row
  2. MapEach row is mapped to real records: supplier, material, plant, prices, users
  3. Check in CMQThe data owner confirms each record exists and fits: extensions, info records, open period, roles
  4. Fill gapsMissing records are created through the agreed data process, not ad hoc by testers
  5. FreezeThe validated data plan is versioned with the test cases it serves
  6. RefreshAfter each client refresh, the plan is rechecked before execution
From AI ideas to a test data plan testers can rely on.
The Sign-Off Table · thesignofftable.com/academy/sap-aiq-203

SAP is moving in the same direction. Its Test Data Management Agent in Cloud ALM, an Early Adopter Care feature at the time of writing, reads the instruction text of manual test cases and returns the business objects and field parameters each test needs, such as the data for a purchase order test, grouped by category, as a basis for sourcing data. It answers "what data does this test need?"; whether that data exists and fits in your client is still a check someone has to make.

What would you do?

An approved AI assistant proposes 24 data rows for the PO approval tests. Six rows use material CMC-STA-300 with purchasing organization 1710 and plant 1720 Chicago. A tester wants to start execution tomorrow with all 24 rows. What should Wei, as the data owner, do?

Key points
  • Let AI propose equivalence classes, boundaries, combinations, data states and roles, with the reason for each row.
  • Validate every row in the test client against SAP master data dependencies: extensions, info records, open periods and roles.
  • Version the validated data plan with its test cases and recheck it after every client refresh.
  • Prompt with synthetic or masked values only; never with production data.

Check your understanding · not graded

Lesson check

  1. 1. Why ask the AI to state the class or boundary behind each proposed data row?

  2. 2. An AI-proposed row uses supplier Lakeside Components with purchasing organization 1720. What must the data owner check?

  3. 3. What does SAP document the Test Data Management Agent as doing?

  4. 4. Which values may go into an AI prompt for test data ideas?