Skip to Content
0
Former Member
Mar 01, 2009 at 01:39 PM

The column name "PERNR" has two meanings. ABAP/4 Open SQL statement.

885 Views

Hi All,

Could anyone advise on what are the error I encountered at below code.

I get the error in " The column name "PERNR" has two meanings. ABAP/4 Open SQL statement." . This errors happen to all the key fields I have selected in below code (eg: pernr, subty, objps, sprps, begda, endda, seqnr).

The field zeih also encountered error in "Unknown column name "ZEIH". not determined until runtime, you cannot specify a field list."

SELECT pernr

subty

objps

sprps

begda

endda

seqnr

zlsch

ZEIH

SELECT * INTO CORRESPONDING FIELDS

OF TABLE i_pa0009

FROM pa0001 INNER JOIN pa0009

ON pa0001pernr = pa0009pernr

WHERE bukrs IN s_code AND

banks NE space.