topic Re: Select statement queries in Application Development and Automation Discussions

Select statement queries

Former Member — Thu, 10 Apr 2008 07:24:59 GMT

Hi all

What could be the cause of this error. occuring at select statement.

"the table name is too long"

Regrd

Mona

Former Member — Thu, 10 Apr 2008 07:28:01 GMT

Hi,

Please write that select querry also.

Former Member — Thu, 10 Apr 2008 07:30:45 GMT

Select a~kaganplntcode

b~labst

c~matnr

INTO CORRESPONDING FIELDS OF TABLE t_input

FROM (zmmkaganplant AS a

INNER JOIN mard AS b ON a_{werks = b}werks )

INNER JOIN mara AS c ON b_{matnr = c}matnr )

WHERE a~werks = v_werks AND

b~matnr = v_matnr AND

b~werks = v_werks AND

b~lgort = v_lgort AND

b~labst = v_labst AND

c~matnr = v_matnr AND

a~kaganplntcode = v_matnr.

Former Member — Thu, 10 Apr 2008 07:38:39 GMT

Make sure that there is a space in between,

FROM ( zmmkaganplant

ThomasZloch — Thu, 10 Apr 2008 07:42:36 GMT

you can omit all "(" and ")", not necessary here. At the moment, you have one opening and two closing brackets, this probably causes the error.