Data in SAP related to a single business object e.g. SALES ORDER could be stored in up to 15 tables. Doing joins every time to get data about single business entity is error prone and CPU demanding.

All the joins which depends on purely SAP Architecture[doesn’t depends on business logic] and all the data cleaning / data validation

Only created/modified records are loaded on within regular jobs. [Full/partial recovery – as well possible]

Depends on the SAP Modules deployed/used – the list of be varied​. Here are the examples of Business entity[Silver Layer] mapping to SAP Tables[Bronze Layer] :​