topic Re: NEsted IF in Application Development and Automation Discussions

NEsted IF

Former Member — Tue, 22 May 2007 02:33:11 GMT

Hi,

can anyone correct this statement

select * from zco where co = siitab-id.

ENDSELECT.

if co = '11' and /cotyp = '14'.

j_itab-typ = 'aa' OR 'bb' OR 'cc' OR 'dd' OR 'dd'.

J_ITAB-RCOST_CENTER_ID = 'Y'

co = 'aa' and cotyp = '10'.

j_itab-typ = 'aa'.

else.

messsage e001 with ' values are out of range

endif.

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:35:53 GMT

see the code below :

REPORT ZTEST3 line-size 400.

select * from zco where co = siitab-id.

if co = '11' and /cotyp = '14'.

j_itab-typ = 'aa' OR 'bb' OR 'cc' OR 'dd' OR 'dd'.

J_ITAB-RCOST_CENTER_ID = 'Y'

co = 'aa' and cotyp = '10'.

j_itab-typ = 'aa'.

else.

messsage e001 with ' values are out of range

endif.

ENDSELECT.

You need to use if condition between select endselect.

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:42:50 GMT

Hi,

iam getting error in this line.....

j_itab-typ = 'aa' OR 'bb' OR 'cc' OR 'dd' OR 'dd'.

for OR operator its not allwoing this

Anjali

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:43:41 GMT

select single * from zco where co = siitab-id.

if co = '11' and /cotyp = '14'.

j_itab-typ = 'aa' OR 'bb' OR 'cc' OR 'dd' OR 'dd'.

J_ITAB-RCOST_CENTER_ID = 'Y'

co = 'aa' and cotyp = '10'.

j_itab-typ = 'aa'.

else.

messsage e001 with ' values are out of range

endif.

Thanks

Venki

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:46:02 GMT

use like this :

if j_itab-typ = 'aa' OR

if j_itab-typ = 'bb' OR

if j_itab-typ = 'cc' OR

if j_itab-typ = 'dd' .

endif.

endif

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:48:03 GMT

'OR' and 'AND' are used only for conditional statement and not for ASSIGNMENT.


SELECT * from zco where co = siitab-id.

if co = '11' and cotyp = '14'.
  j_itab-typ1 = 'aa'.
  j_itab-typ2 = 'bb'.
  j_itab-typ3 = 'c'.
  j_itab-typ4 = 'd'.
  J_ITAB-RCOST_CENTER_ID = 'Y'.
  co = 'aa'.
  cotyp = '10'.
  j_itab-typ = 'aa'.
else.
  messsage e001 with ' values are out of range
endif.

ENDSELECT.

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:48:42 GMT

Hi,

what about my previous condition... if i use this then i will ahve n no of if's

anjali

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:51:26 GMT

i did not have system right now..

if j_itab-typ1 = 'aa' or j_itab-typ1 = 'bb' or j_itab-typ1 = 'cc'.

endif.

check this condition

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:51:40 GMT

Hi Anjali,

I don't understand why you are using or when you are assing a value

j_itab-typ = 'aa' OR 'bb' OR 'cc' OR 'dd' OR 'dd' -- this is not correct syntax

the control doesn't know which value you are assingning this is correct when your checking

if j_itab-typ = 'aa' OR 'bb' OR 'cc' OR 'dd' OR 'dd'.-- yOu can do this here you are check whether it has anyone of those value

j_itab-typ = 'aa' OR 'bb' OR 'cc' OR 'dd' OR 'dd' - this doesn't make any sense for me

tell me what you are trying to do

Thanks

venki

Re: NEsted IF

Former Member — Tue, 22 May 2007 02:52:21 GMT

Is these your conditions

if co = '11' and cotyp = '14'.

and

j_itab-typ1 = 'aa' or j_itab-typ1 = 'bb' or j_itab-typ1 = 'cc' or j_itab-typ1 = 'dd'

if this is. try this


SELECT * from zco where co = siitab-id.
 
if co = '11' and cotyp = '14'.
  if j_itab-typ1 = 'aa' or 
   j_itab-typ1 = 'bb' or
   j_itab-typ1 = 'cc' or
   j_itab-typ1 = 'dd'.
     J_ITAB-RCOST_CENTER_ID = 'Y'.
     co = 'aa'.
     cotyp = '10'.
     j_itab-typ = 'aa'.
  endif.
else.
  messsage e001 with ' values are out of range
endif.
 
ENDSELECT.

Re: NEsted IF

Former Member — Tue, 22 May 2007 03:00:49 GMT

Hi Ardrian,

if co = '11' and cotyp = '14'.

j_itab-typ1 = 'aa'.

j_itab-typ2 = 'bb'.

j_itab-typ3 = 'c'.

j_itab-typ4 = 'd'.

J_ID = 'Y'.

co = 'aa'.

cotyp = '10'.

j_itab-typ = 'aa'.

...................................

in this if my IF condition is true ... it can fall under any one type....

for this can i go head with case and when...

plz suggest me.

Re: NEsted IF

Former Member — Tue, 22 May 2007 03:07:20 GMT

Hi Venki,

IF my coid is '11' and '14'.

then they types with be either one of it j_itab-typ1 = 'aa'.

j_itab-typ2 = 'bb'.

j_itab-typ3 = 'c'.

j_itab-typ4 = 'd'.

J_ITAB-RCOST_CENTER_ID = 'Y'.

anjali

Re: NEsted IF

Former Member — Tue, 22 May 2007 03:11:55 GMT

CASE Statment

case j_itab-typ1

when 'aa'.

J_ITAB-RCOST_CENTER_ID = 'Y'.

when 'bb'.

J_ITAB-RCOST_CENTER_ID = 'Y'.

when = 'c'.

J_ITAB-RCOST_CENTER_ID = 'Y'.

when 'd'.

J_ITAB-RCOST_CENTER_ID = 'Y'.

when others.

message

endcase.

Re: NEsted IF

Former Member — Tue, 22 May 2007 03:17:34 GMT

i am not clear your requirement and why you are using nested select query,

alrady you have jtab,then use loop..

loop at jtab.

get the data from ur ztable comapre with jtab.

endloop.

Re: NEsted IF

Former Member — Tue, 22 May 2007 12:06:14 GMT

hi Anjali

do this may be help you

select * from zco where co = siitab-id.

if co = '11' and cotyp = '14'.

if j_itab-typ = 'aa' OR

j_itab-typ = 'bb' OR

j_itab-typ = 'cc' OR

j_itab-typ = 'dd' OR

j_itab-typ = 'dd'.

J_ITAB-RCOST_CENTER_ID = 'Y'

co = 'aa' .

cotyp = '10'.

j_itab-typ = 'aa'.

else.

messsage e001 with ' values are out of range

endif.

ENDSELECT.