Skip to Content
0
Former Member
Jul 12, 2007 at 09:47 AM

wanted how to use use where condition in provide and endprovide

13 Views

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.