Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Paul,
I have tried the query in QlikView but, it gives the error. It will work in ABAP or SQL.
Regards
Amol Khochare
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
Hi Paul,
I am using SAP connector.
Regards
Amol Khochare
Hi Paul,
It is working. Thnak u.
Regards
Amol Khochare
Amol_Khochare, Please close the discussion by selecting the right answer