Indicates whether to include extra join columns on each table.

Data Type

bool

Default Value

false

Remarks

Some tools may require an ON condition (or generate them automatically) based on foreign key references. By setting this property to True, every table will include a foreign key reference to the other tables. These columns do not return any data and are not useful for anything other than passing as ON conditions to perform JOINs upon.

The SAP Business Warehouse data model does not directly expose any columns that join the objects in the model. Therefore, JOINs can be executed without an ON condition specified.