topic Re: Selected Records from SQL Table in QlikView in QlikView

Selected Records from SQL Table in QlikView

Fri, 11 Apr 2014 04:52:46 GMT

Hi Experts,

I am using QlikView and facing problem in some of the SAP Tables

e.g.-> JEST, MSEG, KONV.

There is huge database above 40 to 50 lac and 1 crore also.

I want selected data in final table.

Like, I have 10 records in VBAP table, So, with reference of 10 records data should be fetched in JEST table.

Reference field is OBJNR.

Because every time we have to load whole database and it takes 12 to 15 Minutes for such huge database tables.

Kindly suggest the same.

Thanks and Regards

Amol Khochare

Re: Selected Records from SQL Table in QlikView

Mon, 14 Apr 2014 03:53:36 GMT

Hi Amol,

If I understand you correctly, you want to get records from the JEST only if the records exist in the VBAP?

If you are using the SAP Connector maybe you could try left join the tables?. I can't test it now with the VBAP tables but below is the example syntax. As long as the tables are "transparent" the join should work.

SELECT MARA~MATNR, MAKT~MAKTX FROM MARA left join MAKT on (MARA~MATNR = MAKT~MATNR);

Please let us know how did it go.

Cheers,

Paul

Re: Selected Records from SQL Table in QlikView

Mon, 14 Apr 2014 04:24:56 GMT

Hi Paul,

I have tried the query in QlikView but, it gives the error. It will work in ABAP or SQL.

Regards

Amol Khochare

Re: Selected Records from SQL Table in QlikView

Mon, 14 Apr 2014 04:45:07 GMT

Hi Amol,

Just to clarify, are you using SAP connector to directly tap into SAP or you have some intermediary SQL server with your SAP tables?

Could you please share the error message?

Cheers,

Paul

Re: Selected Records from SQL Table in QlikView

Mon, 14 Apr 2014 05:01:55 GMT

Hi Paul,

I am using SAP connector.

Regards

Amol Khochare

Re: Selected Records from SQL Table in QlikView

Mon, 14 Apr 2014 05:07:27 GMT

Hi Paul,

It is working. Thnak u.

Regards

Amol Khochare

Re: Selected Records from SQL Table in QlikView

SergeyMak — Wed, 23 Apr 2014 02:52:14 GMT

Amol_Khochare, Please close the discussion by selecting the right answer