Skip to Content
0
Former Member
Mar 23, 2009 at 06:13 AM

FOR ALL ENTRIES and Duplicate entries

2866 Views

Hi All,

I have used following code...

SELECT WORKDATE RNPLNR CATSHOURS raufpl raplzl FROM CATSDB

INTO CORRESPONDING FIELDS OF TABLE IT_CATSDB

FOR ALL ENTRIES IN IT_WBS

WHERE RNPLNR = IT_WBS-NETWORK

AND WORKDATE >= v_date1

AND WORKDATE <= v_date3

and status = '30'.

If the database table is having 2 records on the same date, this code is not selecting the multiple entries...

If catsdb-workdate (01.08.2008) is having 2 entries, the code will take only one entry.

If particular date has 3 entries, code is taking only 2 entries...

Any idea how to get all entries?

Regards

Pavan