topic Issue pulling data from SAP Z-Tables in QlikView

Issue pulling data from SAP Z-Tables

Fri, 01 Oct 2010 11:16:24 GMT

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.

Issue pulling data from SAP Z-Tables

suniljain — Fri, 01 Oct 2010 11:54:52 GMT

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

Issue pulling data from SAP Z-Tables

Fri, 01 Oct 2010 13:29:30 GMT

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.

Issue pulling data from SAP Z-Tables

suniljain — Sun, 03 Oct 2010 09:16:33 GMT

Can Post log file generated during extraction ?.

Is it Cluster table ?.

Issue pulling data from SAP Z-Tables

Thu, 07 Oct 2010 03:27:41 GMT

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..