Example: Inner Join
This scenario shows how the inner join merges the two input tables and returns values that match with the set join predicate.
|
|
Returns all values with corresponding matches based on the join predicates for product code “P0001” and “P0002”.
Product, Price and Currency which correspond to each Product Code will be distributed to each product code resulting in the below table.
| Product Code | Material Code | Request Order | Product | Price | Currency |
|---|---|---|---|---|---|
| P0001 | M1011 | 5 | Shoe | 75 | EUR |
| P0001 | M1010 | 2 | Shoe | 75 | EUR |
| P0002 | M1009 | 1 | Watch | 300 | EUR |
| P0002 | M1011 | 3 | Watch | 300 | EUR |
Since a formula has been declared in the subview of RULE2, SAP Profitability and Performance Management will perform it after the Inner Join has been run.
The system adds the field Payment Amount (Payment Amount = Request Order * Price) along with its value to the final output.
| Product Code | Material Code | Request Order | Product | Price | Currency | Payment Amount |
|---|---|---|---|---|---|---|
| P0001 | M1011 | 5 | Shoe | 75 | EUR | 375 |
| P0001 | M1010 | 2 | Shoe | 75 | EUR | 150 |
| P0002 | M1009 | 1 | Watch | 300 | EUR | 300 |
| P0002 | M1011 | 3 | Watch | 300 | EUR | 900 |