Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Selected Records from SQL Table in QlikView

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

6 Replies
Not applicable

Re: Selected Records from SQL Table in QlikView

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

Not applicable

Re: Selected Records from SQL Table in QlikView

Hi Paul,

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

Regards

Amol Khochare

Not applicable

Re: Selected Records from SQL Table in QlikView

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

Not applicable

Re: Selected Records from SQL Table in QlikView

Hi Paul,

I am using SAP connector.

Regards

Amol Khochare

Not applicable

Re: Selected Records from SQL Table in QlikView

Hi Paul,

It is working. Thnak u.

Regards

Amol Khochare

sergey_maka8
Valued Contributor

Re: Selected Records from SQL Table in QlikView

, Please close the discussion by selecting the right answer

Community Browser