topic Re: Control table error, need a numeric value in Application Development and Automation Discussions

Control table error, need a numeric value

Former Member — Fri, 22 Dec 2006 15:24:58 GMT

Hi guys,

im using an internal table that is displayed via control table.

im displaying employee number (pa0001-pernr)

loans, save plan etc,

my problem is that when i add pa0001 table to my SeLect, an error is displayed in the control table that reads "You need to enter a numeric number"

I add that table (pa0001) for getting the sname field (employee full name)

ti_news

data: BEGIN OF ti_new occurs 0.

DATA: status like zthrca001-status,

sname like pa0001-sname,

marca(2),

END of ti_new.

SELECT *

INTO CORRESPONDING FIELDS OF TABLE ti_news

FROM zthrca002 inner join zthrca001

ON ( zthrca002_{idmov = zthrca001}idmov )

<b>inner join Pa0001

ON ( zthrca002_{PERNR = Pa0001}PERNR )</b> WHERE zthrca001~status = 'P'.

if i remove the inner join with pa0001 the error disapear, but i need the sname field

=( any help?

Re: Control table error, need a numeric value

Former Member — Fri, 22 Dec 2006 15:31:41 GMT

hi Javier,

Check whether the datatype of PERNR is same in zthrca002 and Pa0001.

Small observation donot give * in the select statement take the required fields.

Regards,

Santosh

Re: Control table error, need a numeric value

Former Member — Fri, 22 Dec 2006 15:43:45 GMT

the datatype is the same PERSNO

i remove the * from the SELECT and only write the fields that i need and the error is still displayed

Re: Control table error, need a numeric value

Former Member — Fri, 22 Dec 2006 15:48:19 GMT

hi Javier,

Refer this Link you may get an idea where you have made the mistake ..

http://www.sap-img.com/abap/inner-joins.htm

<b>Paste your latest code </b>

Regards,

Santosh

Re: Control table error, need a numeric value

Former Member — Fri, 22 Dec 2006 16:06:15 GMT

TI news

data: BEGIN OF ti_news occurs 0.

include structure zthrca002.

DATA: status like zthrca001-status,

sname like pa0001-sname,

marca(2),

END of ti_news.

SELECT status sname zthrca001_{idmov zthrca002}pernr fecha pahorro

INTO CORRESPONDING FIELDS OF TABLE ti_news

FROM zthrca002 inner join zthrca001

ON ( zthrca002_{idmov = zthrca001}idmov )

inner join Pa0001

ON ( zthrca002_{PERNR = Pa0001}PERNR )

WHERE zthrca001~status = 'P'.

the error do not happen on runtime, (i can conpile and run)

the error appears when im trying to do something after the ti_news is displayed on the control table

( u need to enter a numeric value)

Re: Control table error, need a numeric value

Former Member — Fri, 22 Dec 2006 16:49:01 GMT

i had a seem mistake you must check the control table atributes sometimes when you use control table wizard it puts the char atributes as numeric and you need to change it manually.

Regards.