Qlik Community

QlikView Connectors

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.
thomaslg_wq
Contributor III

SAP SQL Connector : Where is not null

Hi everyone,

I am working with SAP SQL Connector for QV.

I would like to load BSEG table where LIFNR field value is not null.

It seems that the following statements do not work in the SQL SELECT (which then makes the load longer because I have to add the clause in the QV Load)

"where LIFNR IS NOT NULL"

"where len(trim(LIFNR))>0"

How do you deal with that kind of need ?

Thank you for your help,

BR,

Thomas

1 Solution

Accepted Solutions
yfe
Contributor III

Re: SAP SQL Connector : Where is not null

What about

SQL

SELECT *

FROM BSEG

WHERE LIFNR NE ''

NE in ABAP stands for 'Not Equal'

Try to use 2 single quotes:  ''  to refer to null.

Not sure whether this can improve extract performance from BSEG as I suspect LIFNR is not a key field.

Try to check with the SAP team whether they have an index using field LIFNR for this table, this may help.

Cheers

Yaniv

1 Reply
yfe
Contributor III

Re: SAP SQL Connector : Where is not null

What about

SQL

SELECT *

FROM BSEG

WHERE LIFNR NE ''

NE in ABAP stands for 'Not Equal'

Try to use 2 single quotes:  ''  to refer to null.

Not sure whether this can improve extract performance from BSEG as I suspect LIFNR is not a key field.

Try to check with the SAP team whether they have an index using field LIFNR for this table, this may help.

Cheers

Yaniv

Community Browser