topic Re: for all enteries problem in Application Development and Automation Discussions

for all enteries problem

Former Member — Mon, 13 Nov 2006 17:57:32 GMT

Problem (select 2)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

for ALL enteries IN table b_itab

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.

Re: for all enteries problem

Former Member — Mon, 13 Nov 2006 17:59:06 GMT

SELECT objid sobid priox begda endda

FROM hrp1001

INTO CORRESPONDING FIELDS OF TABLE c_itab

*for ALL enteries IN table b_itab

for ALL enteries IN b_itab

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

*AND objid = wa_b_itab-objid <----

ERROR????

AND objid = 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.

Max

Re: for all enteries problem

Former Member — Mon, 13 Nov 2006 18:15:56 GMT

Hi,

SELECT objid sobid priox begda endda

FROM hrp1001

INTO CORRESPONDING FIELDS OF TABLE c_itab

for ALL enteries IN table b_itab

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 entries