In general: A Text Join clarifies and simplifies the join defintion (the resulting SQL join itself is technically a left outer join)
Further: There might be also checks on required cardinality for performance optimization as well as UI specific outputs, where the language is automatically set when performing the join but language is not returned in the resulting data set. It might also try to keep a developer from falsly choosing an INNER JOIN for joining text tables with value tables, if the join type Text Join was not an option, resulting in missing values when descriptions are not maintained.
So yes, you can do the same join with both join-types, but SAP has defined the Text Join for more specific tasks and requirements then the more general Left Outer Join.
Optimizing join columns is supported only for left outer joins with cardinality 1:1 or N:1, textjoins with cardinality 1:1 or N:1, right outer joins with cardinality 1:1 or 1:N, and referential joins.
siba.pkd21 , does this 'solve' your question or do you still have doubts? I assume you at least know when to use which? Let me know if there is more clarity necessary.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.