or keyword

[Former Member]

hi,

may i know if or keyword in sql statement correct? if this field has empty or 0 value then will not select it. this is a char type. or any other way which is better than mine?

thanks.

SELECT a_{xxx a}yyy a~parob

INTO CORRESPONDING FIELDS OF wa_tab

FROM coep AS a INNER JOIN csks AS b ON a_{objnr = b}objnr

WHERE

a~gjahr = p_gjahr AND

b~kostl IN s_kostl AND

a~parob <> '' OR

a~parob <> '0'.

[former_member181962]

SELECT a_{xxx a}yyy a~parob

INTO CORRESPONDING FIELDS OF wa_tab

FROM coep AS a INNER JOIN csks AS b ON a_{objnr = b}objnr

WHERE

a~gjahr = p_gjahr AND

b~kostl IN s_kostl AND

a~parob not in ( '' , '0' ).

Regards,

Ravi

[Former Member]

Hi

Yes it is a keyword.

do like this:

SELECT a_{xxx a}yyy a~parob

INTO CORRESPONDING FIELDS OF wa_tab

FROM coep AS a INNER JOIN csks AS b ON a_{objnr = b}objnr

WHERE

a~gjahr = p_gjahr AND

b~kostl IN s_kostl AND

( a~parob <> ' ' OR

a~parob <> '0' ).

Regards,

Anji

[Former Member]

You need this

WHERE

a~gjahr = p_gjahr AND

b~kostl IN s_kostl AND

( a_{parob <> '' OR a}parob <> '0' ).

[Former Member]

Hello El,

Better u can do like this:

SELECT a~xxx a~yyy a~parob 
INTO CORRESPONDING FIELDS OF wa_tab
FROM coep AS a INNER JOIN csks AS b ON a~objnr = b~objnr
WHERE
a~gjahr = p_gjahr AND
b~kostl IN s_kostl AND
a~parob <> ( ' ', '0') . "Check here


else built a range with NE SPACE and NE 0 and put the select like this:
SELECT a~xxx a~yyy a~parob 
INTO CORRESPONDING FIELDS OF wa_tab
FROM coep AS a INNER JOIN csks AS b ON a~objnr = b~objnr
WHERE
a~gjahr = p_gjahr AND
b~kostl IN s_kostl AND
a~parob IN SO_PAROB . "Check here

If useful reward.

Vasanth

[Former Member]

hi

u can use it but make small change ...

SELECT a_{xxx a}yyy a~parob

INTO CORRESPONDING FIELDS OF wa_tab

FROM coep AS a INNER JOIN csks AS b ON a_{objnr = b}objnr

WHERE

a~gjahr = p_gjahr AND

b~kostl IN s_kostl AND

a~parob <> '' AND '' <----

---

a~parob <> '0'.

[Former Member]

Hi el,

It is the best way I hope.

SELECT a_{xxx a}yyy a~parob

INTO CORRESPONDING FIELDS OF wa_tab

FROM coep AS a INNER JOIN csks AS b ON a_{objnr = b}objnr

WHERE a~gjahr = p_gjahr

AND b~kostl IN s_kostl

AND ( a~parob <> ' '

OR a~parob <> '0' ).

Regards,

Kasinath.

[Former Member]

SELECT a_{xxx a}yyy a~parob

INTO CORRESPONDING FIELDS OF wa_tab

FROM coep AS a INNER JOIN csks AS b ON a_{objnr = b}objnr

WHERE

a~gjahr = p_gjahr AND

b~kostl IN s_kostl AND

a~parob NE ''.

I THINK PAROB IS CHARACTER FIELD YOU CAN USE THAT

[Former Member]

Hi,

This may not give u the results since u have to seperate the condition by a bracket

(a_{parob <> '' OR a}parob <> '0').

or

AND a~parob <> (' ' , '0').

or u can use

NE space or NE '0'.