The MultiProvider does not represent physical tables, but is defined as a view on other InfoProviders like InfoCubes, DataStore Objects, InfoObjects, …
It is also represented as a dimensional model, and the InfoObjects inside this model are mapped to the physical InfoProviders. It is a best practice to always build your queries on a MultiProvider, for reasons of extensibility and re-usability.