topic If statement in Application Development and Automation Discussions

If statement

Former Member — Fri, 29 Jun 2007 03:25:02 GMT

Hi friends,

I want to keep two if conditions.,

1. IF ( zinv_mov-status = 'DI' and zinv_mov-xblnr is initial ).

2. IF not ( zinv_mov-status is initial

and zinv_mov-xblnr is initial ).

Can you tell me what is wrong in the statement.

Regards,

Line

Re: If statement

former_member196280 — Fri, 29 Jun 2007 03:29:06 GMT

Try to keep the 2 if statement first and first if statement later.

IF not ( zinv_mov-status is initial

and zinv_mov-xblnr is initial ).

IF not ( zinv_mov-status is initial

and zinv_mov-xblnr is initial ).

***********

**************

************

ENDIF.

Reward points if useful.

Regards,

SaiRam

Re: If statement

Former Member — Fri, 29 Jun 2007 03:31:26 GMT

Can you please tell what exactly do you want,after writting the statements as the objective of writing the statement is not clear nothing can be suggested.

Thanks

Re: If statement

Former Member — Fri, 29 Jun 2007 03:31:29 GMT

i am not sure what is your requirement but if you are using like this

IF ( zinv_mov-status = 'DI' and zinv_mov-xblnr is initial ).

IF not ( zinv_mov-status is initial

and zinv_mov-xblnr is initial ).

endif.

then two ifs are contradictory because in first if you are checking zinv_mov-xblnr must be initial and in the 2nd if you are checking zinv_mov-xblnr must not be initial.

i think you want to do like that..

IF ( zinv_mov-status = 'DI' and zinv_mov-xblnr is initial ).

elseif not ( zinv_mov-status is initial

and zinv_mov-xblnr is initial ).

endif.

correct me if i am wrong and what is your exact requirement...

regards

shiba dutta

Re: If statement

Former Member — Fri, 29 Jun 2007 03:33:25 GMT

Hi Line,

What exactly is your requirement.

Just by looking at your IF I can say you should change

2. IF not ( zinv_mov-status is initial

and zinv_mov-xblnr is initial ).

<b>IF zinv_mov-status is NOT initial AND

zinv_mov-xblnr is NOT initial</b>.

Regards,

Atish

Re: If statement

Former Member — Fri, 29 Jun 2007 03:39:33 GMT

Sorry Friends,

I need to select the data on two requirement.,

1. When the user uses the status in the screen

2. When the user uses the status with the invoice number.

Based on this two conditions I need to pick the data from the database table.

Regards,

Line

Re: If statement

Former Member — Fri, 29 Jun 2007 03:41:10 GMT

Hi,

do it like this.

IF ( zinv_mov-status = 'DI' and zinv_mov-xblnr is initial ) or not ( zinv_mov-status is initial

and zinv_mov-xblnr is initial ).

endif.

<b>reward if helpful.</b>

rgds,

bharat.

Re: If statement

Former Member — Fri, 29 Jun 2007 03:42:14 GMT

Hi Line,

Just paste your code then, I can suggest the required changes.

Regards,

Atish

Re: If statement

Former Member — Fri, 29 Jun 2007 04:00:32 GMT

make your status field mandatory so that user must enter one value there.

if zinv_mov-xblnr is initial.

select .... where status = zinv_mov-status.

"or you can specify DI in where as per ur requirement

else.

select .... where status = zinv_mov-status and xblnr = zinv_mov-xblnr .

endif.

regards

shiba dutta

Re: If statement

Former Member — Fri, 29 Jun 2007 04:05:43 GMT

Hi there,

Here is my code

*IF zinv_mov-status EQ 'DI' and zinv_mov-xblnr is not initial.

SELECT trans

lifnr

xblnr

bukrs

procese

appdate

usnam

status

FROM zinv_mov INTO CORRESPONDING FIELDS OF

TABLE lt_invmov WHERE clear NE 'CL'

AND status NE 'PV'

OR xblnr EQ zinv_mov-xblnr.

PERFORM vendorname.

SORT lt_invmov BY xblnr.

IF sy-subrc <> 0.

MESSAGE i000(x) WITH 'No Records for processing'.

ENDIF.

ENDIF.

IF zinv_mov-status = 'DI'.

SELECT trans

lifnr

xblnr

bukrs

procese

appdate

usnam

status

FROM zinv_mov INTO CORRESPONDING FIELDS OF

TABLE lt_invmov WHERE clear NE 'CL'

AND status NE 'PV'

AND xblnr EQ zinv_mov-xblnr.

IF sy-subrc <> 0.

MESSAGE i000(x) WITH 'No Records for processing'.

ENDIF.

Regards,

Line

Re: If statement

Former Member — Fri, 29 Jun 2007 04:18:19 GMT

Hi Line,

Just change your code as below.

IF zinv_mov-status EQ 'DI' OR inv_mov-xblnr is not initial.

SELECT trans

lifnr

xblnr

bukrs

procese

appdate

usnam

status

FROM zinv_mov INTO CORRESPONDING FIELDS OF

TABLE lt_invmov WHERE clear NE 'CL'

AND status NE 'PV'.

if inv_mov-xblnr is not initial.

DELETE lt_invmov where xblnr NE inv_mov-xblnr.

ENDIF.

PERFORM vendorname.

SORT lt_invmov BY xblnr.

IF sy-subrc <> 0.

MESSAGE i000(x) WITH 'No Records for processing'.

ENDIF.

Reward points if useful.

Regards,

Atish

Re: If statement

Former Member — Fri, 29 Jun 2007 04:49:56 GMT

you can try this ...

IF ZINV_MOV-STATUS EQ 'DI'.

IF ZINV_MOV-XBLNR IS NOT INITIAL.

SELECT TRANS

LIFNR

XBLNR

BUKRS

PROCESE

APPDATE

USNAM

STATUS

FROM ZINV_MOV INTO CORRESPONDING FIELDS OF

TABLE LT_INVMOV WHERE CLEAR NE 'CL'

AND STATUS NE 'PV'

OR XBLNR EQ ZINV_MOV-XBLNR.

PERFORM VENDORNAME.

SORT LT_INVMOV BY XBLNR.

IF SY-SUBRC <> 0.

MESSAGE I000(X) WITH 'No Records for processing'.

ENDIF.

ELSEIF ZINV_MOV-XBLNR IS INITIAL.

SELECT TRANS

LIFNR

XBLNR

BUKRS

PROCESE

APPDATE

USNAM

STATUS

FROM ZINV_MOV INTO CORRESPONDING FIELDS OF

TABLE LT_INVMOV WHERE CLEAR NE 'CL'

AND STATUS NE 'PV'

AND XBLNR EQ ZINV_MOV-XBLNR.

IF SY-SUBRC <> 0.

MESSAGE I000(X) WITH 'No Records for processing'.

ENDIF.

Rewards if useful.

Regards