‎2007 Aug 29 10:30 AM
ihave
matnr = '3al78830aa'
i use this FM and it's not making convert
so this
SELECT SINGLE * FROM MARA
WHERE MATNR = MATNR.
dont work
idea???
‎2007 Aug 29 10:46 AM
hi little richi,
conversion only takes place for fields where are only numbers inside, for example:
123 will be converted to 000000000000000123 if it is a material number.
I guess you have to convert the letters to uppercase, than it why it is not retreiving any data.
hope this helps
ec
‎2007 Aug 29 11:02 AM
‎2007 Aug 29 10:53 AM
hey declare variable v_matnr ........
parameter: p_matnr like mara-matnr default '3al78830aa'.
data: v_matnr type mara-matnr.
then write u r select single
SELECT SINGLE matnr FROM MARA into v_matnr
WHERE MATNR = p_matnr.
reward points if helpful......
Message was edited by:
raam
‎2007 Aug 29 10:54 AM
the fm is correct - it should format your material number into upper case. in fact it is working perfect in my systems.
There are a few customer exists inside that FM - just ensure somebody didnt mess with those.
‎2007 Aug 29 10:59 AM
first translate the matnr into upper-case.
Translate var to upper case.
Then apply the conversion exit. SAP stores things in uppercase. Now it will work.
Regards,
Mallick
‎2007 Aug 29 11:07 AM
hey no need to use conversion exit here ...........jst try wat i have given above it worked for me .............
reward points if helpful....
‎2007 Aug 29 11:10 AM
‎2007 Sep 05 9:01 AM
there is no solution for this
i have a matnr with numric and alpha '2ff562fg''
and when i make selct from mara it is not recognize it...