Leading zero

[Former Member]

Hi,

I working in table control.When i click the download button then all the material number which is in table control should be download in local excel file.

Its working fine.But the leading zero of the material number is removed.

Is it possible to download the material with leading zero.If then please guide me.

Regards,

K.Sudhakaran.

[Former Member]

Hi

Are you sure the leading zero is removed by excel and not while downloading it?

Max

[Former Member]

Hi max,

Yes sure the leading zeros are available till the last internal table. After excel only zeros are removed.

With out excel configure how can i download data with leading zeros ?.Because client doesnt know abt excel configuration.

Regards,

K.Sudhakaran.

[Former Member]

Sudha,

Sorry for a mis-leading answer before. i didnt think through the problem before giving you an answer. The thing here is there are leading zeroes added to your data as long as your data stays in SAP. You will also see leading leading zeroes if you have downloaded the file as a text file.

But the problem here is Excel has already been set to remove zeroes from the front of a number if that particular coloumn has been declared as a numerical field. You try to show your user to change that field in excel to character so that there will be leading zeroes again.

Unfortunately, there is not much we can do on the SAP side, as SAP is giving the number out with leading zeroes and excel is doing the trick for you.

Regards

Aneesh.

[martin_schffler]

Hi,

when handing the values to excel you could change your value to this: '=REPLACE(". That will also force excel to render your value as text.

Message was edited by:

Martin Schöffler

[Former Member]

Sudha,

Use function module <b>CONVERSION_EXIT_ALPHA_INPUT</b> before downloading to add leading zeroes.

Regards

Aneesh.

[Former Member]

Sometimes sticking a single quote in front works, eg '0000000012345689. You may have to do that in a temporary table to avoing mashing the existing values.

It might make a difference what type of file you're downloading - is it excel, tab delimited, CSV.

(oops, didn't see Martin had said the same thing)

[former_member325225]

Hi All,

This can be solved in a better and simpler way as follows:

CONCATENATE '="' wa-field_name '"' INTO wa-field_name.

This should solve the problem

Thanks,

Jiten

[pappu_kumar2]

thanx...

[Former Member]

No, in excel you have to define the column as text and not number. If you define it as a number it will remove the leading zeros. So if you have a downloaded tab delimited file, when you open in excel, first define the column attributes where you want to display the leading zeros.

Albert