Skip to Content
0
Former Member
Feb 20, 2009 at 05:15 AM

Fetching DATE problem

173 Views

Hi experts

i need a help in the below ...........

i tried few but still cudnt get the solution

here is the query where

=======================

Select pernr endda massn from pa0000 into corresponding fields of table it_pa0000

WHERE

Endda = '99991231' and

MASSN in ('S1', 'S2', 'S3', 'S4', 'S7')

and pernr in so_pernr.

where it fetches all the pernr which satisfies the condition

but problem is that since i have mentioned the Endda as '99991231 its fetching

the begda for the corresponding endda ,

but my requirement is that it shud satisfy my select criterial

and if satisfied it shud fetch the begda of S1 instead of

fetching endda 's corresponding begda.

thanx in advance

Rachel