Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Loading BSEG and BKPF from SAP R/3


I'm trying to get faster extractions from SAP. In this case I'm loading BKPF (header) and BSEG (lines). I have some filters for BKPF in the WHERE clause, so I only get around 20% of the total number of records. After that, I only want to load the lines that correspond to the loaded headers.

With QlikView syntax I'd use the EXIST function, something like this:

      WHERE Exists([Document Number_BELNR]);

But I want to filter directly on the extraction from SAP so I don't get all the records in my QVDs, but only the 20% that I really need. Any suggestions???

0 Replies