topic Re: querying based on list in Application Development and Automation Discussions

querying based on list

Former Member — Thu, 20 Dec 2007 09:52:14 GMT

Hi,

I have the employee number in an internal table. I should pick the leave hours for the employees from catsdb.

When I use 'for all entries in itab' , I am not getting all the records.

One employee has 8 , 6 , 8 hours of leave. But I get only first and second record. Not the thrid one.

Is their anyother way without using for all entries in select query.

regards

Balaji

Re: querying based on list

former_member386202 — Thu, 20 Dec 2007 09:54:33 GMT

Hi,

Refer this

&----

*& Form sub_read_catsdb

&----

text

----

FORM sub_read_catsdb .

*--Local Variables

DATA : lv_index LIKE sy-tabix.

IF NOT it_pa2010[] IS INITIAL.

*--Select Personnel number Date Receiver Order and Wage Type from

Table catsdb

SELECT pernr "Personnel number

workdate "Date

raufnr "Receiver Order

lgart "Wage Type

FROM catsdb

INTO TABLE it_catsdb

FOR ALL ENTRIES IN it_pa2010

WHERE pernr EQ it_pa2010-pernr

AND workdate GE it_pa2010-begda

AND workdate LE it_pa2010-endda

AND lgart EQ it_pa2010-lgart

AND raufnr IN s_raufnr.

IF sy-subrc EQ 0.

*--Sort Table by personnel number and wage type

SORT it_catsdb BY pernr lgart.

ENDIF.

Regards,

Prashant

Re: querying based on list

Former Member — Thu, 20 Dec 2007 09:57:17 GMT

Hi,

Keep employee no as the common field for both internal tables.

select empno from table .. into itab1.

if not itab1 is initial.

select leave from ... into itab2

for all entries in itab1

where empno = itab1-empno.

endif.

Reward points if useful.