topic Re: clarification required in Application Development and Automation Discussions

clarification required

Former Member — Mon, 27 Nov 2006 07:38:38 GMT

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 — Mon, 27 Nov 2006 07:42:54 GMT

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 — Mon, 27 Nov 2006 07:43:27 GMT

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 — Mon, 27 Nov 2006 07:44:02 GMT

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