Explain what you solved and finish the Workshop
Summarize the cause of the sales change and the next verification step with evidence.
Question for this chapter
Can you explain the month-end review conclusion while separating evidence from assumptions?
Confirm the scope of the SAP analysis
This Workshop connects five SAP sources to set a month-end review order. Discounts, costs, and currency
that do not exist in the sources are marked TRAINING_ASSUMPTION; this flow does not confirm actual
profit or trigger customer action.
- Sales Master — 3,413 order-line rows and 3,413 business keys
- Monthly Information — USD 9,118,915.6 January 2017 net revenue and an 11.35% training-assumption margin
- Priority Order Review — order
18622, 93.21% monthly revenue share, 18% assumed discount, 10% assumed margin - Graph explorer — Dynamic Industries → order 18622 → ZSER → 2017-01-13
Complete the solution path
| Stage | Evidence | Next decision |
|---|---|---|
| Connect sources | VBAK, VBAP, MARA, MAKT, KNA1 | Compare customer and material context in one row. |
| Verify quality | 3,413 sales-master rows and 3,413 business keys | Aggregate without join duplication. |
| Explore the month | USD 9,118,915.6 January net revenue and 11.35% assumed margin | Narrow to the order level. |
| Choose an order | 18622, 93.21% monthly share, 18% discount, 10% margin | Review commercial terms first. |
| Verify relationships | Dynamic Industries → 18622 → ZSER → 2017-01-13 | Confirm one transaction context. |
State the final decision
We connected five SAP sources by order, material, and customer keys to build a 3,413-row sales master. January 2017 net revenue is about USD 9.11 million, but order
18622alone contributes 93.21% of that amount. Under the training assumptions, the order has an 18% discount and a 10% margin. We will not call the month broad demand growth. We will first review order18622's contract, discount, actual cost, and currency terms, and we will not confirm profit or take customer action until the assumed values have been replaced with source ERP facts.
Completion check
- I identified the role and join key of VBAK, VBAP, MARA, MAKT, and KNA1.
- I verified 3,413 Sales Master rows and 3,413 unique business keys.
- I verified January 2017 net revenue and the training-assumption margin.
- I verified order
18622's monthly share, discount, and margin. - I traced the customer-order-material-date path in the graph.
- I can explain the conclusion's limits by separating source facts from
TRAINING_ASSUMPTIONvalues.