topic Re: Validation Problem in Application Development and Automation Discussions

Validation Problem

Former Member — Thu, 25 Mar 2010 07:08:34 GMT

im doing the Validation in LSMW

is it possible to get the Material Description from Table (By default) for the material in Excel Sheet Entered ?

i have written a code for this by im not getting the description details

can any one help me on this ?

Regards

Smitha

Former Member — Thu, 25 Mar 2010 07:23:21 GMT

Hi,

material text will be in MAKT table.

Select from MAKT table using material number and Sy-langu (logon Language). Then pass it to target maerial description field in LSMW.

Please note that material number should contian leading zeros before select statement otherwise query will fail.

Regards,

Shanmugavel chandrasekaran

Former Member — Thu, 25 Mar 2010 07:33:18 GMT

thanks for ur reply

i have done as u told but im struck somewhere can u help me by referring my below code

data : v_maktx type makt-maktx.

data : v_bmatn type mara-bmatn.

clear : v_maktx,v_bmatn.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = MFPMATSS-BMATN

IMPORTING

OUTPUT = v_bmatn

select single maktx

from makt

into v_maktx

where matnr eq v_bmatn.

if sy-subrc eq 0.

move v_maktx to MFPMATSS-MAKTX_01.

endif.

*MFPMATR-MAKTX_01 = MFPMATSS-MAKTX_01.