wanted how to use use where condition in provide and endprovide

Hi all,

i am using provide and end provide for getting leave details of persons according to the plant wise and subgroup wise and stat2 = 3. here is the logic which i am using.

provide * from p0000

• from p0001

• from p0002

between pn-begda and pn-endda

where p0000-stat2 = '3' and

p_btrtl = pernr-btrtl and

p_persk = pernr-persk.

move statements.

endprovide.

note: p_btrtl and p_persk (parameters in input selection screen)

but why the where condition is not working.

wanted solution for this.

thanking u.

with regards,

giri.