In SAP HANA Calculation Views, a temporal join is a specific property that allows for joining time-dependent data. This is typically used when a transactional table with a specific date needs to be joined with a master data table that has a validity period (e.g., VALIDFROM and VALIDTO columns). This temporal condition feature is explicitly supported for both Inner joins and Left Outer joins. The modeler can specify a temporal column from one table and a temporal interval from the other, and the engine will evaluate the join based on whether the date falls within the interval.

A. Text join: This is a specialized left outer join used specifically for retrieving language-dependent text descriptions. It does not support the temporal join property.

B. Referential join: This is an optimized inner join that relies on pre-existing referential integrity. While it is a type of inner join, it does not have the specific temporal property setting available.

1. SAP HANA Cloud

SAP HANA Database Modeling Guide for SAP Web IDE for SAP HANA: In the section "Defining Temporal Joins

" the documentation explicitly states

"You can define temporal joins for inner joins and left outer joins. A temporal join is used to join a transaction table with a master data table that has time-dependent attributes."

2. SAP HANA Cloud

SAP HANA Database Modeling Guide: In the section "Create Joins in Calculation Views

" under the subsection for join properties

it is detailed that the "Temporal" property can be configured for join types "Inner" and "Left Outer".