Select statement queries

[Former Member]

Hi all

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

"the table name is too long"

Regrd

Mona

[Former Member]

Hi,

Please write that select querry also.

[Former Member]

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]

Make sure that there is a space in between,

FROM ( zmmkaganplant

[ThomasZloch]

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