The inner join in SAP PAPM displays only data that has the same join conditions on both sides.
Example:
Input Tables
Input 1: Product Table
| Product Code | Product | Price | Unit |
| P0001 | Shoe | 75.00 | EUR |
| P0002 | Watch | 300.00 | EUR |
| P0003 | Shirt | 80.00 | EUR |
| P0004 | Shorts | 20.00 | EUR |
Input 2 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 |
Results
| Product Code | Material Code | #request order | Product | Price | Unit |
| P0001 | M1011 | 5 | Shoe | 75.00 | EUR |
| P0001 | M1010 | 2 | Shoe | 75.00 | EUR |
| P0002 | M1009 | 1 | Watch | 300.00 | EUR |
| P0002 | M1011 | 3 | Watch | 300.00 | EUR |
Set up in SAP
Rules Tab
| Rule | Input description | State | Rule Type | Level | Input |
| Rule 1 | Product Table | Default (Active) | From | 0 | Product Table |
| Rule 2 | Material Table | Default (Active) | Inner join | 0 | Material Table |
Join predicates Tab
For Rules 2
| Left Rule | Left field | Comparison | Right Rule | Right Field |
| RULE | PROD_COD | Equal | RULE2 | PROD_COD |
Source SAP PAPM
