error inserting code in lsmw

[Former Member]

hello iam migrating goods movement using direct input method.iam getting isbn number and quantity in to a table from legacy system and i need to retrieve material number for corresponding isbn number from table and at step 5 mapping fields i

wrote select statement iam getting error as field

select is unknown .in the select statement

SELECT SINGLE MATNR FROM JPTIDCDASSIGN IN TO

BMSEG-MATNR WHERE IDENTCODE = 'MATNR'.

in this select statement jptidcdassign is table and

identcode is cloumn which contain isbn number.can you

also check whther iam writing select statement at

correct place.

pls help me its urgent .iam approaching my dead line.

janapathi

[Former Member]

use like this

SELECT SINGLE MATNR FROM JPTIDCDASSIGN INTO

BMSEG-MATNR WHERE IDENTCODE = 'MATNR'

looks like you written like

SELECT SINGLE MATNR FROM JPTIDCDASSIGN IN TO

BMSEG-MATNR WHERE IDENTCODE = 'MATNR'

[Former Member]

hello seshu thanks for early reply.iam still getting the error and conversion program is generating with same error.iam wondering am i giving this select statement at correct place.iam assigning giving this at mapping field matnr by using translation.thanks in advance.can u give me ur mail id

Regards

janapathi

[Former Member]

I do not have system right now and i will see the code when i go to office .

email id : mseshureddy@yahoo.com