Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Author

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
Author

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
Author

Hi Paul,

I am using SAP connector.

Regards

Amol Khochare

Not applicable
Author

Hi Paul,

It is working. Thnak u.

Regards

Amol Khochare

SergeyMak
Partner Ambassador
Partner Ambassador

, Please close the discussion by selecting the right answer

Regards,
Sergey