topic Re: rintime error in Application Development and Automation Discussions

rintime error

Former Member — Mon, 13 Nov 2006 11:29:36 GMT

Hellow I doing this select and I have a dump of runtime error

SELECT objid begda endda

FROM hrp1001

INTO 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 <= sy-datum

AND endda => sy-datum.

This is my declare of b_itab

TYPES: BEGIN OF 2_itab,

objid TYPE hrobjid,

sobid TYPE sobid,

begda TYPE begdatum,

endda TYPE enddatum,

priox TYPE priox,

END OF 2_itab.

DATA: b_itab TYPE TABLE OF 2_itab,

wa_b_itab LIKE LINE OF b_itab.

And z_course table is declare in tables in function module

This is the messege

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

In a SELECT access, the read file could not be placed in the target

field provided.

Either the conversion is not supported for the type of the target field,

the target field is too small to include the value, or the data does not

have the format required for the target field.

Re: rintime error

Former Member — Mon, 13 Nov 2006 11:31:37 GMT

check may be this is problem

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 =< sy-datum

AND endda >= sy-datum.

kishan negi

null

Re: rintime error

anversha_s — Mon, 13 Nov 2006 11:33:03 GMT

hi,

change like this.

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.

rgds

anver

Re: rintime error

Former Member — Mon, 13 Nov 2006 11:33:40 GMT

change the TYPES declaration to:

This is my declare of b_itab

TYPES: BEGIN OF 2_itab,

objid TYPE hrobjid,

begda TYPE begdatum,

endda TYPE enddatum,

sobid TYPE sobid,

priox TYPE priox,

END OF 2_itab.

this should solve your problem.

Note: Award points for helpful answers.

Re: rintime error

Former Member — Mon, 13 Nov 2006 11:37:12 GMT

check this one..

SELECT * 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 <= sy-datum

AND endda => sy-datum.

Re: rintime error

Former Member — Mon, 13 Nov 2006 11:37:30 GMT

Check the field type for z_course_table-objid

Is it the same as HRP1001-objid?

Also, since your declaration has sobid for b_itab, use that too in the select of add 'INTO CORRESPONDING FIELDS' .

Re: rintime error

Former Member — Mon, 13 Nov 2006 11:39:37 GMT

Hi sh_tal,

i think your select-statement must be expendet form

SELECT objid begda endda

to this

SELECT objid sobid begda endda

Hope it helps.

Regards, Dieter

Re: rintime error

Former Member — Mon, 13 Nov 2006 11:40:47 GMT

In select statement you are not selecting the data in the order you declared in the declaration and also you r not selecting all the data, if you dont want to select all the data give into correspoding fields of table b_itab :

SELECT objid begda endda

FROM hrp1001

INTO coresponding fields of table b_itab

or change the order of declaration of table like this:

TYPES: BEGIN OF 2_itab,

objid TYPE hrobjid,

begda TYPE begdatum,

endda TYPE enddatum,

sobid TYPE sobid,

priox TYPE priox,

END OF 2_itab.

Regards

Haritha