topic Re: SELECT - ENDSELECT statment error in Application Development and Automation Discussions

SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:18:23 GMT

Hi Friends,

I got the following statement in my pgm .

I get a short dump at the following select statemenet . Please advise what is wrong .

SELECT erdat uzeit FROM ztable

INTO (w_date,w_time)

WHERE tknum = vttk-tknum

AND zindicator <> vttk-tplst.

ENDSELECT.

It does not allow me to use without endselect and when I use it I get a short dump .

In the ztable there may be more than 1 record but I need the one where zindicator <> vttk-tplst.

Re: SELECT - ENDSELECT statment error

RichHeilman — Thu, 19 Jul 2007 18:21:22 GMT

What does the dump say? You should try this. Use SINGLE and remove the ENDSELECT



SELECT SINGLE erdat uzeit
      FROM ztable
         INTO (w_date, w_time)
                   WHERE tknum   =   vttk-tknum
                       AND zindicator <> vttk-tplst.

Regards,

Rich Heilman

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:22:04 GMT

use select single statement

SELECT single erdat uzeit FROM ztable
INTO (w_date,w_time)
WHERE tknum = vttk-tknum
AND zindicator <> vttk-tplst.

Re: SELECT - ENDSELECT statment error

ferry_lianto — Thu, 19 Jul 2007 18:22:11 GMT

Hi,

Please try this.


SELECT SINGLE erdat uzeit 
FROM ztable
INTO (w_date, w_time)
WHERE tknum = vttk-tknum
AND zindicator <> vttk-tplst.

Regards,

Ferry Lianto

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:26:44 GMT

HI,

U can use up to 1 rows..

SELECT erdat uzeit up to 1 rows FROM ztable

INTO (w_date,w_time)

WHERE tknum = vttk-tknum

AND zindicator <> vttk-tplst.

ENDSELECT.

cheers'

Mahesh

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:27:04 GMT

Hi Rich ,

It still give me the same short dump . I dont understand what could be wrong with the SELECT statement .

Thanks,

Hari

This is what i have in my code .

SELECT single erdat uzeit

FROM ztable

INTO (w_date, w_time)

WHERE tknum = vttk-tknum

AND zindicator <> vttk-tplst.

Re: SELECT - ENDSELECT statment error

ferry_lianto — Thu, 19 Jul 2007 18:29:30 GMT

Hi,

How do you declare w_date, w_time?


data: w_date type ztable-erdat,
      w_time type ztable-uzeit.

Can you paste the whole coding?

Regards,

Ferry Lianto

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:29:37 GMT

Error Analysis

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

The data read during a SELECT access could not be inserted into the

target field.

Either conversion is not supported for the target field's type or the

target field is too short to accept the value or the data are not in a

form that the target field can accept

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:29:38 GMT

hi Hari,

Try it out in this way then

SELECT erdat uzeit up to 1 rows FROM ztable
INTO (w_date,w_time)
WHERE tknum = vttk-tknum
AND zindicator <> vttk-tplst.
ENDSELECT.

Re: SELECT - ENDSELECT statment error

RichHeilman — Thu, 19 Jul 2007 18:29:59 GMT

What does the short dump say?

REgards,

RIch Heilman

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:30:51 GMT

hi ,

May be zindicator and vttk-tplst are of not the same type and length. So to correct it use same type in where condition.

Regards,

Santosh

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:32:38 GMT

What is data type for w_date, w_time ?

Try to read Short Dump ,it will give breif message

Thanks

Seshu

Re: SELECT - ENDSELECT statment error

RichHeilman — Thu, 19 Jul 2007 18:33:13 GMT

Make sure that w_ fields are defined in this way.

data: w_date type sy-datum.
data: w_time type sy-uzeit.

Regards,

Rich Heilman

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:34:15 GMT

HI Hari,

Check the data type of w_date, w_time they should be same as the erdat uzeit fields in the ztable.

Thanks

mahesh

Re: SELECT - ENDSELECT statment error

Former Member — Thu, 19 Jul 2007 18:35:41 GMT

Try like :

SELECT erdat uzeit up to 1 rows FROM ztable

INTO (ztable-erdat,ztable-uzeit)

WHERE tknum = vttk-tknum

AND zindicator <> vttk-tplst.

ENDSELECT.

Thanks

Seshu

Re: SELECT - ENDSELECT statment error

marcelo_ramos1 — Thu, 19 Jul 2007 18:44:10 GMT

Hi,

Look at this code, its similar to yours.

DATA: erdat TYPE erzet, "Correct type ->erdat

erzet TYPE erzet.

START-OF-SELECTION.

SELECT single erdat erzet

FROM vbak

INTO (erdat, erzet)

WHERE vbeln = '0000000004'.

This generated the same dump as below.

The data read during a SELECT access could not be inserted into the

target field.

Either conversion is not supported for the target field's type or the

target field is too short to accept the value or the data are not in a

form that the target field can accept

You already know what to do ? No ? Ok !

- Check the fields's types of the internal tables !

This error occurs whenever a type conflict occurs, that is, the field's type of the BD table is different of the type declared in the internal table

The correct code is:

DATA: erdat TYPE erdat,

erzet TYPE erzet.

I hope that my tip be useful for you !

Regards .

Marcelo Ramos