Datasphere remote table to BW/4HANA 2.0 CompositeProvider returns "No data".

[mcalucin]

Using the Datasphere connection with "SAP BW" connecting to a BW/4HANA 2.0 system, I created a remote table to a CompositeProvider. I loaded a snapshot of the data, but when I went to Data Viewer, it came up with "No data".

I can see from Eclipse that the CompositeProvider has data in it.

I did an authorization trace on the BW/4HANA system -- no errors.

I checked ST22 -- no errors.

I checked SM37, and found the following which says "NO data in ts_x_info" and No data available,

What checked SAP Notes and couldn't find anything.

Appreciate any help on this.

Thanks,

Regards,

Mel Calucin

[amlan_dhow]

Hi,

there might be multiple different reasons for this. But if there are special characters in the source code, it might cause no data load in DSP. You may refer the SAP Note 2124759 and also parameter IGNORE_CONVERSION_ERRORS = 'X' in table ODQADMIN needs to be set.