topic Re: how to avoid the leading zero compression. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720226#M1579994 <HTML><HEAD></HEAD><BODY><P>use function modules conversion exit alpha input</P></BODY></HTML> Mon, 14 Mar 2011 11:12:44 GMT Rushikesh_Yeole 2011-03-14T11:12:44Z how to avoid the leading zero compression. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720225#M1579993 <HTML><HEAD></HEAD><BODY><P>hi experts,</P><P></P><P>i am converting the excel file into internal table by using the function module ALSM_EXCEL_TO_INTERNAL_TABLE . I have the single row and 5 columns in my excel file. one of the column is <STRONG>sales division(spart)</STRONG> and the value is <STRONG>00</STRONG> . while converting this to internal table i got the value as 0. how to avoid the zero compression here, because i need to pass this internal table to trasnaction <STRONG>VA01 using BDC technique</STRONG>, while doing so it shows the error message there is no division called 0. </P><P></P><P>kindly help me to find the solution.</P><P></P><P>thanks in advance</P></BODY></HTML> Mon, 14 Mar 2011 11:08:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720225#M1579993 Former Member 2011-03-14T11:08:32Z Re: how to avoid the leading zero compression. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720226#M1579994 <HTML><HEAD></HEAD><BODY><P>use function modules conversion exit alpha input</P></BODY></HTML> Mon, 14 Mar 2011 11:12:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720226#M1579994 Rushikesh_Yeole 2011-03-14T11:12:44Z Re: how to avoid the leading zero compression. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720227#M1579995 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>This compression of zero is happening because the target fiels is a non character like field(i.e interger or packed).</P><P>I would simply suggest you to chnage the type of the field in the internal table to numeric or char.</P><P></P><P>I would not suggest the use of Function Module if the above solution works.</P><P></P><P>Thanks</P><P>Ajay</P></BODY></HTML> Mon, 14 Mar 2011 11:50:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720227#M1579995 Former Member 2011-03-14T11:50:12Z Re: how to avoid the leading zero compression. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720228#M1579996 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This is happening because the excel file in assuming it to be a numerical value than a text, and change the cell format to Numeric. I would suggest you to send the value as <STRONG>="00"</STRONG> instead of just <STRONG>00</STRONG>. What this does is it makes the cell format as text and the leading zeroes will be preserved.</P><P></P><P>Regards</P><P>Ranganath</P></BODY></HTML> Mon, 14 Mar 2011 11:58:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720228#M1579996 Former Member 2011-03-14T11:58:30Z Re: how to avoid the leading zero compression. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720229#M1579997 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P></P><P>Change the excel file Column into Character/String/Text field ,Autmatically the field will come into internal table with 000 calues.</P><P></P><P>make sure the The field in the table is a character field.</P><P></P><P></P><P>Prabhud@s</P></BODY></HTML> Mon, 14 Mar 2011 12:05:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720229#M1579997 Former Member 2011-03-14T12:05:25Z Re: how to avoid the leading zero compression. https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720230#M1579998 <HTML><HEAD></HEAD><BODY><P>thanks to all... i found the answer myself</P></BODY></HTML> Mon, 14 Mar 2011 12:16:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-avoid-the-leading-zero-compression/m-p/7720230#M1579998 Former Member 2011-03-14T12:16:32Z