Lesson 4 of 6
Test data ideas and SAP master data rules
16 min
Listen to this lesson
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
| Technique | Prompt for | Contoso example |
|---|---|---|
| Equivalence partitions | Valid and invalid classes for each input | PO net value: up to $25,000; over $25,000; zero; negative |
| Boundary values | Values 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 combinations | A small set covering every pair of values across inputs | Plant 1710 or 1720 × material CMC-RTR-200 or CMC-STA-300 × value class × purchasing group |
| Data states | Records in each status the process can meet | A blocked supplier, a material not extended to the plant, a closed posting period |
| Roles | Users with and without the needed authorizations | A 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.
- ProposeAI lists classes, boundaries and combinations with the reason for each row
- MapEach row is mapped to real records: supplier, material, plant, prices, users
- Check in CMQThe data owner confirms each record exists and fits: extensions, info records, open period, roles
- Fill gapsMissing records are created through the agreed data process, not ad hoc by testers
- FreezeThe validated data plan is versioned with the test cases it serves
- RefreshAfter each client refresh, the plan is rechecked before execution
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?
- 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. Why ask the AI to state the class or boundary behind each proposed data row?
2. An AI-proposed row uses supplier Lakeside Components with purchasing organization 1720. What must the data owner check?
3. What does SAP document the Test Data Management Agent as doing?
4. Which values may go into an AI prompt for test data ideas?