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

Lesson 4 of 7

Data provisioning services

9 min

Listen to this lesson

0:00 / 7:32

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 typeWhat the requester getsLead time (Contoso service level)Example
Self-service golden dataReserved, documented records from a catalog, ready to useImmediate, by reserving in the catalogA fleet customer with credit limit and pricing, reserved for one tester for one day
RecipeFresh records created by a documented, preferably automated recipeWithin 2 working daysFifty sales-ready orders for CMC-ALT-100 with stock replenished in 171A
BespokeData designed with the requester for an unusual caseWithin 5 working days, agreed per requestIntercompany 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.

How a data request is served. Bespoke work that may recur becomes a recipe, so the next request is faster.
The Sign-Off Table · thesignofftable.com/academy/sap-tcoe-405

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.

Rare and complexBespoke design; document it in case it returns
Frequent and complexAutomate a recipe first; this is where data services pay
Rare and simpleA short checklist is enough
Frequent and simpleGolden data with reservation and nightly replenishment
Where each provisioning approach fits. Start automation with frequent, complex requests.
The Sign-Off Table · thesignofftable.com/academy/sap-tcoe-405

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.

CategoryContoso order-to-cash exampleWhere the value comes from
OrganizationalCompany code 1710, sales area 1710 / 10 / 00, plant 1710, shipping point 1710Fixed in the catalog
MasterCustomer Great Lakes Fleet Services, material CMC-ALT-100, price 240.00 USDGolden data, reserved
ConfigurationOrder type, open posting period, output setupChecked by the readiness check
TransactionalOrder quantity 50, requested delivery date, unrestricted stock in 171ARecipe 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?

Key points
  • 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. 1. What is the main reason to reserve golden data records?

  2. 2. What makes a data recipe complete?

  3. 3. According to SAP's documentation, what does the Test Data Management Agent in SAP Cloud ALM do?

  4. 4. Which requests should the data service automate first?