In FM CRM_PRODUCT_SALES_READ_API, when reading sales org dependent product data, it checks sales area bundle customizing to see if we need an alternative distribution channel to get product data:
In CRM Fiori there is one standard application called Customer report, where you can consume the HANA query view modeled in HANA studio, taking one example below: