topic Loading BSEG and BKPF from SAP R/3 in QlikView https://community.qlik.com/t5/QlikView/Loading-BSEG-and-BKPF-from-SAP-R-3/m-p/249959#M710321 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>With QlikView syntax I'd use the EXIST function, something like this:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE Exists([Document Number_BELNR]);</P><P></P><P>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???</P></BODY></HTML> Fri, 01 Jul 2011 16:15:43 GMT villafuerte 2011-07-01T16:15:43Z Loading BSEG and BKPF from SAP R/3 https://community.qlik.com/t5/QlikView/Loading-BSEG-and-BKPF-from-SAP-R-3/m-p/249959#M710321 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>With QlikView syntax I'd use the EXIST function, something like this:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE Exists([Document Number_BELNR]);</P><P></P><P>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???</P></BODY></HTML> Fri, 01 Jul 2011 16:15:43 GMT https://community.qlik.com/t5/QlikView/Loading-BSEG-and-BKPF-from-SAP-R-3/m-p/249959#M710321 villafuerte 2011-07-01T16:15:43Z