Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Command WHERE in the SAP

Hi all,

Sorry for the blast.

How we can to do the command WHERE in the SAP, using SAP Connector? 

Thanks

1 Reply
danielrozental
Honored Contributor II

Re: Command WHERE in the SAP

SQL SELECT MANDT

FROM BKPF

WHERE MANDT = 400

If you have several tables in your SELECT then you must use the "~" character (beware that it will not work with mandt)

SQL SELECT MANDT

FROM BKPF

WHERE BKPF~BUKRS = 'ABCD'