topic Re: Material master source file error ! in Application Development and Automation Discussions

Material master source file error !

sachin_soni — Wed, 25 Apr 2007 05:58:52 GMT

HI all !

When i open my tab delimited file in excel (so that it is easily editable), i face a problem and that is values like '00204' OR '0001' get converted to 204 and 1 respectively and that causes error as such values are not what that particular field expects.

if somebody cud give me a permanent soln for that ,that wud be grt

regards

sachin soni

Re: Material master source file error !

Former Member — Wed, 25 Apr 2007 06:02:04 GMT

maintain that column as a TEXT , then it will not remove ZEROS , u cannt do any thing in SAP , its totally with EXCEL.

Regards

Prabhu

Re: Material master source file error !

sachin_soni — Wed, 25 Apr 2007 06:10:41 GMT

prabhu thx 4 prompt ans , buddy but the problem is even after maintaining it as text when i open again in excel ,the zeeroes are gone again.

regards,

sachin

Re: Material master source file error !

Former Member — Wed, 25 Apr 2007 06:18:28 GMT

download the file in text format.

Re: Material master source file error !

sachin_soni — Wed, 25 Apr 2007 06:20:35 GMT

utsah i didnt get u ,download frm where??

Re: Material master source file error !

Former Member — Wed, 25 Apr 2007 06:25:14 GMT

Hi,

try this,

Sent that field value to some character data type variable and then download it.

Regards,

Suresh

Re: Material master source file error !

sachin_soni — Wed, 25 Apr 2007 09:06:44 GMT

hi suresh i think ppl r nt getting me , i have a source file .which is to be uploaded and not in the system yet.i need to upload it and not download it and there is no question of transferring it to a char type variable at all.

thanks

sachin

Re: Material master source file error !

sachin_soni — Wed, 25 Apr 2007 09:50:20 GMT

anybody????????????????????????????

Re: Material master source file error !

Former Member — Wed, 25 Apr 2007 21:29:17 GMT

Hey,

First open an excel sheet and format all the cell contents as text. Later copy the contents of your tab delimited file and paste it on that excel sheet.

Thanks,

Surya