본문으로 건너뛰기
Workshop overview
Chapter 7 of 7
5 min

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

StageEvidenceNext decision
Connect sourcesVBAK, VBAP, MARA, MAKT, KNA1Compare customer and material context in one row.
Verify quality3,413 sales-master rows and 3,413 business keysAggregate without join duplication.
Explore the monthUSD 9,118,915.6 January net revenue and 11.35% assumed marginNarrow to the order level.
Choose an order18622, 93.21% monthly share, 18% discount, 10% marginReview commercial terms first.
Verify relationshipsDynamic Industries → 18622 → ZSER → 2017-01-13Confirm 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 18622 alone 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 order 18622'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_ASSUMPTION values.