I have created a remote cube that looks to a simple R/3 view VBAK/VBAP.
In a query on this cube I select document date. on the VBAK there is a special index on document date.
It appears that my date variable is not included in the SQL statement that is executed on the sourcesystem. This means that on VBAK/VBAP always a full table scan occurs.
The query on the source system (as generated by executing my BW query) looks like this. (the document-date = AUDAT):
SELECT "MANDT" , "VBELN" , "POSNR" , "VBTYP" , "AUART" , "AUDAT" , "VKORG" , "VTWEG" , "SPART" , "VKGRP" , "VKBUR" , "NETWR" , "WAERK" , "NTGEW" , "GEWEI" , "KWMENG" , "VRKME" , "SHKZG" FROM "ZBW_2LIS11ITM" WHERE "MANDT" = :A0#
My question is: Is it normal that for a remote cube always full table scans are executed. This appears to me a waste of system resources. Or is it a bug?