Command WHERE in the SAP

[#1]

Hi all,

Sorry for the blast.

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

Thanks

[danielrozental]

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'