where clause in QlikView while fetching data from SAP DSO

[bhavik123]

Hi All,

I am trying to fetch the data from SAP DSO using SAP DSO connector. While fetching the data I want to fetch Invoice Clearing Date with blank value.

I have seen different options for where clause like EQ NE CP in QlikView SAP Connector manual but i am not sure how to utilise this option to fetch field with blank value.

Could you please some one help me on this?

Thanks & Regards,

Bhavik

[Anil_Babu_Samineni]

Can u tell me exactly what you want to do with Where condition?

[bhavik123]

Hi Anil,

I want to fetch only those INVOICE_NO against which there is no CLEARING_DATE.

For this in where clause i want to mention CLEARING DATE as blank or null.

[tamilarasu]

Hi Bhavik,

This should work. If not, please post snapshot of your SAP data.

DSO_NAME:

Load * Where Len(Trim(CLEARING_DATE))=0 ;

SQL Select (NoKey) Invoice_No,

                              CLEARING_DATE

from DSO_NAME;