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.

Input Tables
Product - Material Table
Product Code Material Code Request Order
P0001 M1011 5
P0001 M1010 2
P0002 M1009 1
P0002 M1011 3
P0005 M1012 10
P0005 M1011 30
Product Table
Product Code Product Price Currency
P0001 Shoe 75 EUR
P0002 Watch 300 EUR
P0003 Shirt 80 EUR
P0004 Shorts 20 EUR

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.

Interim Results (Product - Material Table and Product 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.

Expected Result
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