Join function in SAP PAPM join the results of other two functions, there are different join categories that are the following:
– Inner join This join type returns all rows when there is at least one predicate match in the rule above and this rule.
–Left outer join This join type returns all rows from the rule above, and the columns and rows from this rule, where the predicates match.
–Cross join This join type returns the cartesian product of the rule above and this rule. and
–Union all This join behaves in the same way as a union, but duplicate records are not removed.
–Full outer join: This join type returns all (matched or unmatched) rows from both the rule above and this rule.
-Lookup: Looks up fields and fills them in the first non-lookup rule above where the predicates match. At least one field needs to be defined as a lookup field.
-Lookup Auto Predicate: Looks up fields and fills them in the first non-lookup rule where all common fields match those of the input function which is set on the Rule tab (this means, Field 1 of Rule 1 = Field 1 of Rule 2). At least one field needs to be defined as a lookup field.
Source SAP PAPM
