how to include conditions in select query

[Former Member]

i want to write a select query wherein plants have to to be fetched from table vekp

and if it is a plant then the set movement type to 999 else leave for exiting.please help me on this

[Former Member]

Hi,

Select * from vekp into table i_vekp where condition.

loop at i_vekp.

if i_vekp-werks = value.(check u r condition)

movement type = 999 .

endif.

endloop.

[Former Member]

Hi try this..

Select * from Vekp into table itan

where plant eq <p_pant>

and momenttype EQ '999'.

[Former Member]

This is my exact requirement(This is module pool programming)

Select the plant from the table VEKP and compair the value of plant in ZPCS_PARAM table , If this plant is matching in ZPCS_PARAM then change the value of movement type to 999 else leave for exiting .Please help me on this.

[Former Member]

>

> (This is module pool programming)

what is modulepool programming doing in form printing forum.

Please use appropriate forum next time.

кu03B1ятu03B9к