I have a problem... I have to select all the customer information corresponding to the data from external system user key in.
These information exist in SAP table KNA1 u2192Samsung TW、Samsung KR、Samsung CN、APPLE、IBM、GOOGLE
When user key in "Samsung" on Web, SAP will export "Samsung TW、Samsung KR、Samsung CN" through RFC, and show the three customer data on Web screen.
But I don't know what SELECT syntax I can use?
My code as below....
*" IMPORTING *" VALUE(IN_CUSTOMERNO) TYPE CHAR30 ... SELECT A~KUNNR A~LAND1 B~NAME1 B~CITY1 B~POST_CODE1 B~STREET B~HOUSE_NUM1 FROM KNA1 AS A INNER JOIN ADRC AS B ON A~ADRNR = B~ADDRNUMBER INTO CORRESPONDING FIELDS OF TABLE iPARTNER WHERE B~NAME1 IN IN_CUSTOMERNO.
It will show the error msg like that "The IN operator with "IN_CUSTOMERNO" is followed neither by an internal table nor by a value list".
Is any suggestion?
Thanks in advance.