E1: How to set Report operators OR / AND to turn out some data
Hello,
Can you help me to set version operators OR / AND in order to select data as following:
select * from F03B11 where RPCO='00001' and RPDOC <> 'DT' and RPDCT not between 19000001 and 19000006 and RPVDGJ <> 119010;
I did it as below. It doesn't work !!! I mean it turned out 2 881 records instead of 6 records
| IF Company (F03B11)(CO)[String] | <> | Literal: 00001 |
| AND DocumentType (F03B11)(DCT)[String] | <> | Literal: DT |
| AND DocVoucherInvoiceE (F03B11)(DOC)[MATH_NUMERIC] | NOT BETWEEN | Literal: 19000001 - 19000006 |
| AND VoidDateForGLJulian (F03B11)(VDGJ)[Date] | <> | Literal: U20190110 |
Thanks in advance for your assistance