Skip to Content
0
Feb 09, 2012 at 06:49 AM

How to get the information corresponding to the words transfer from RFC

25 Views

Dear Gurus,

I have a problem... I have to select all the customer information corresponding to the data from external system user key in.

For example:

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.