topic Re: error inserting code in lsmw in Application Development and Automation Discussions

error inserting code in lsmw

Former Member — Wed, 30 May 2007 03:05:23 GMT

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

Re: error inserting code in lsmw

Former Member — Wed, 30 May 2007 03:07:35 GMT

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'

Re: error inserting code in lsmw

Former Member — Wed, 30 May 2007 03:29:25 GMT

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

Re: error inserting code in lsmw

Former Member — Wed, 30 May 2007 03:44:21 GMT

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

email id : mseshureddy@yahoo.com