I am developing a sales data analytic view of SAP ERP application. I need to get "Ship-To" customer at the header level of the document. I have created an attribute view of table VBPA with filters (on partner type and item number) to get the header level "Ship-To" customer. I have joined the attribute view to the data foundation with left outer join (cardinality 1:n). What I have observed in the visualize plan is that join is executed even for those queries that does not need "Ship-To" customer. Is there a way to prevent system from making unneeded joins at run time?