for all enteries problem

[Former Member]

Problem (<b>select 2</b>)in for all entries the error messege is incorrect spelling or comma error

SELECT objid begda endda

FROM hrp1001

INTO CORRESPONDING FIELDS OF TABLE b_itab

FOR ALL ENTRIES IN z_course_table

WHERE objid = z_course_table-objid

AND otype = z_course_table-otype

AND plvar = '01'

AND relat = '020'

AND rsign = 'B'

AND begda LE sy-datum

AND endda GE sy-datum.

*select 2

SELECT objid sobid priox begda endda

FROM hrp1001

INTO CORRESPONDING FIELDS OF TABLE c_itab

<b>for ALL enteries IN table b_itab</b>

WHERE ( otype EQ 'E' OR otype EQ 'ET' )

AND objid = wa_b_itab-objid

AND ( relat EQ '025' OR relat EQ '614' )

AND sclas EQ 'P'

AND begda LE sy-datum

AND endda GE sy-datum.

ENDLOOP.

ENDIF.

[Former Member]

Hi

SELECT objid sobid priox begda endda

FROM hrp1001

INTO CORRESPONDING FIELDS OF TABLE c_itab

<b>*for ALL enteries IN table b_itab

for ALL enteries IN b_itab</b>

WHERE ( otype EQ 'E' OR otype EQ 'ET' )

<b>*AND objid = wa_b_itab-objid <----

---

ERROR????

AND objid = b_itab-objid</b>

AND ( relat EQ '025' OR relat EQ '614' )

AND sclas EQ 'P'

AND begda LE sy-datum

AND endda GE sy-datum.

Max

[Former Member]

Hi,

SELECT objid sobid priox begda endda

FROM hrp1001

INTO CORRESPONDING FIELDS OF TABLE c_itab

<b>for ALL enteries IN table b_itab</b>

WHERE ( otype EQ 'E' OR otype EQ 'ET' )

AND objid = wa_b_itab-objid

AND ( relat EQ '025' OR relat EQ '614' )

AND sclas EQ 'P'

AND begda LE sy-datum

AND endda GE sy-datum.

It is not for ALL enteries but for ALL <b>entries</b>