Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue pulling data from SAP Z-Tables

Hi All,

I am trying to pull data from Z tables in SAP (ECC 6.0). Although, i can pull data from some Z Tables, there are quite a few for which i cant get the data in QlikView 9.0 SR4. But if I check it in SAP GUI using SE16 then it shows me around 50000 records.

Could some body help me on this?

Thanks in Advance.

4 Replies
suniljain
Master
Master

what is the no. of record in "Z" table and How many records you are getting in Qlikview ?.

Not applicable
Author

Hi Sunil,

There are more than 50k records in the Z table. However, when i reload the application in QlikView the application freezes and does not pull any records at all.

The behavior is same from the Create Select Statement too in QV. No records will be displayed in the Preview screen but am able to see the structure here.

suniljain
Master
Master

Can Post log file generated during extraction ?.

Is it Cluster table ?.

Not applicable
Author

my Z tables doesn't contain any records because when i try to write an SQL Statement(e.g. select * from ZCUSTOMERS) and execute it it throws me a message "No Result". I also observed that in my NSP database it only contains 49% of data..can you help me fix this...I'm using SAP NetWeaver 7.01 ABAP Trial Version..

Thank you very much..