clarification required

[Former Member]

hi friends,

1.should we take care of BADI and userexit in the upgrade .currently we r upgrading from 4.7 to ECC6

2.i need to read matnr from database table deleting leading zeros

for Example in database 00001122.

through select query i should resd only 1122 alone how to read.is ther any way

thanks in advance

regards,

raj

[Former Member]

hi friends,

1.should we take care of BADI and userexit in the upgrade .currently we r upgrading from 4.7 to ECC6

2.i need to read matnr from database table deleting leading zeros

for Example in database 00001122.

through select query i should resd only 1122 alone how to read.is ther any way

thanks in advance

regards,

raj

[jayanthi_jayaraman]

Hi,

2. data v_matnr type mara-matnr.

v_matnr = '1122'.

unpack v_matnr to v_matnr.

select * from mara into table itab where matnr = v_matnr.

you can use conversion_exit_* fm also.

[Former Member]

2.i need to read matnr from database table deleting leading zeros

for Example in database 00001122.

through select query i should resd only 1122 alone how to read.is ther any way

DATA v_matnr LIKE mara-matnr VALUE '00001122'.

SHIFT v_matnr LEFT DELETING LEADING '0'.

SELECT *

FROM mara

INTO ls_matnr

WHERE matnr EQ v_matnr.

Regards

Wenceslaus

[former_member404244]

Hi,

no need to takecare of the userexits or badi's it will be upgraded to newversion.

First retrieve the data from db and then use FM

CONVERSIONEXIT_ALPHA_INPUT OR

CONVERSIONEXIT_ALPHA_OUTPUT .to delete the leading zeros.

Regards,

Nagaraj