Skip to Content
0
Former Member
Jan 05, 2009 at 02:48 PM

Remote cube: bad performance of query in source system

47 Views

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?