Financial - JDE1 (MOSC)

MOSC Banner

E1: How to set Report operators OR / AND to turn out some data

edited Jan 16, 2019 12:51PM in Financial - JDE1 (MOSC) 3 commentsAnswered

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 BETWEENLiteral: 19000001 - 19000006
AND  VoidDateForGLJulian (F03B11)(VDGJ)[Date]<>Literal: U20190110

Thanks in advance for your assistance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center