Lesson 4 of 7
Data provisioning services
9 min
Listen to this lesson
A refreshed environment has data, but not necessarily the data a test needs. An order-to-cash test for Contoso needs a customer in sales area 1710 / 10 / 00 with a credit limit and valid pricing, unrestricted stock of CMC-ALT-100 in storage location 171A, an open posting period and a working output setup. A procure-to-pay test needs Lakeside Components with a valid purchasing info record and a purchase order above $25,000 to trigger approval. Data provisioning is the service that gets those records to the tester or the automation run, on time and unused.
Three request types
| Request type | What the requester gets | Lead time (Contoso service level) | Example |
|---|---|---|---|
| Self-service golden data | Reserved, documented records from a catalog, ready to use | Immediate, by reserving in the catalog | A fleet customer with credit limit and pricing, reserved for one tester for one day |
| Recipe | Fresh records created by a documented, preferably automated recipe | Within 2 working days | Fifty sales-ready orders for CMC-ALT-100 with stock replenished in 171A |
| Bespoke | Data designed with the requester for an unusual case | Within 5 working days, agreed per request | Intercompany sale through company code 1810 with third-party item CMC-BRK-500 |
Contoso's data request types. The two-working-day level for standard order-to-cash data matches the service level in sap-tst-401.
The point of the three types is to push demand down the table. Every bespoke request that recurs should become a recipe, and every recipe whose output is reused should feed the golden catalog. A data service that only takes bespoke requests is a help desk; one that turns requests into reusable assets gets cheaper every quarter.
Golden data and reservation
Golden data is a small set of master records whose settings are documented and protected: customers, materials, suppliers, pricing and credit settings that tests can rely on. In SAP the danger is consumption. A goods issue consumes stock, a billing document changes credit exposure, a payment clears open items. Two testers using the same customer on the same day can each break the other's test. Contoso solved this with reservation: each golden record carries an owner and a reservation window in the catalog, and automated runs get their own records, never shared with manual testers.
Golden data also needs replenishment. Contoso runs a nightly job in CMR and CMQ that tops up stock of CMC-ALT-100 in 171A and of CMC-RTR-200 in Detroit to fixed levels, releases expired credit blocks on golden customers, and checks that pricing conditions are valid for the next 90 days. Replenishment is cheaper than investigating a failed test every morning.
Recipes
A data recipe is a documented way to create the data one test needs, from the organizational units down to the transactional starting point. Write it first as a checklist, then automate it with whatever the TCoE uses for automation, or with SAP's own APIs and mass tools where they fit. Each recipe states its prerequisites, its outputs (the record numbers it creates, so tests can pick them up), and its cleanup. A recipe that produces "some customer" without returning the customer number is not finished.
Knowing what data a test needs
Most data requests fail because nobody wrote down what the test needs. Make data requirements part of every test case: organizational units, master data, configuration prerequisites and transactional starting points. ISO/IEC/IEEE 29119-3 has a document for this, the test data requirements, and a matching test data readiness report that records whether each requirement was met. SAP is starting to help here. In SAP Cloud ALM, the Test Data Management Agent is a Joule capability that reads the instruction text of a manual test case and returns the S/4HANA organizational units, master data, configuration and transactional fields it needs, grouped by category. It is currently part of an SAP Early Adopter Care program, and SAP's documentation states that it does not create or provision data: the example values it shows are SAP reference defaults, and the tester still sources the real records. Treat it as a way to draft data requirements, not as a provisioning service.
| Category | Contoso order-to-cash example | Where the value comes from |
|---|---|---|
| Organizational | Company code 1710, sales area 1710 / 10 / 00, plant 1710, shipping point 1710 | Fixed in the catalog |
| Master | Customer Great Lakes Fleet Services, material CMC-ALT-100, price 240.00 USD | Golden data, reserved |
| Configuration | Order type, open posting period, output setup | Checked by the readiness check |
| Transactional | Order quantity 50, requested delivery date, unrestricted stock in 171A | Recipe creates and replenishes |
Data requirements for one test, in the four categories SAP Cloud ALM's agent also uses. Write them in every test case.
What would you do?
Automated regression runs and manual UAT testers both use golden customer Great Lakes Fleet Services in CMR. Several automated runs fail overnight on credit blocks caused by manual tests. What is the best fix?
- Offer three request types (golden data, recipe, bespoke) and push demand toward reusable assets.
- Protect golden data with reservation and nightly replenishment; never share records between automation and manual testers.
- A recipe documents prerequisites, outputs with record numbers, and cleanup, and is automated when demand is frequent.
- Write data requirements into every test case; SAP Cloud ALM's Test Data Management Agent (Early Adopter Care) can draft them but does not provision data.
Check your understanding · not graded
Lesson check
1. What is the main reason to reserve golden data records?
2. What makes a data recipe complete?
3. According to SAP's documentation, what does the Test Data Management Agent in SAP Cloud ALM do?
4. Which requests should the data service automate first?