topic Re: Formatting and data type problem... in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411596#M198210 <HTML><HEAD></HEAD><BODY><P>Make the w_qty field a type c field and write the value.</P><P></P><PRE><CODE>data: w_qty(15) type c. write eket-menge to w_qty decimals 0. shift w_qty left deleting leading space. check sy-subrc = 0.</CODE></PRE><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Wed, 05 Jul 2006 22:56:03 GMT RichHeilman 2006-07-05T22:56:03Z Formatting and data type problem... https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411595#M198209 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a small code line as follows:</P><P></P><P>Data: w_qty type int4.</P><P></P><P>w_qty = EKET-MENGE.</P><P></P><P>Now w_qty has many leading spaces, so if I use</P><P></P><P>shift w_qty left deleting leading spaces.</P><P></P><P>It gives error that w_qty should be C,N or string type.</P><P></P><P>But If I define w_qty as Char5 or something, then if the value of EKET-MENGE is 5000, it does not convert automatically to 5,000 but if it is an int4 then it converts itself automatically to 5,000.</P><P></P><P>Hence I want to delete the leading spaces as well as I want to have it format getting converted to comma format as defined in user profile in system...</P></BODY></HTML> Wed, 05 Jul 2006 22:52:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411595#M198209 Former Member 2006-07-05T22:52:06Z Re: Formatting and data type problem... https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411596#M198210 <HTML><HEAD></HEAD><BODY><P>Make the w_qty field a type c field and write the value.</P><P></P><PRE><CODE>data: w_qty(15) type c. write eket-menge to w_qty decimals 0. shift w_qty left deleting leading space. check sy-subrc = 0.</CODE></PRE><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Wed, 05 Jul 2006 22:56:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411596#M198210 RichHeilman 2006-07-05T22:56:03Z Re: Formatting and data type problem... https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411597#M198211 <HTML><HEAD></HEAD><BODY><P>hi Tushar,</P><P> Do this way</P><P></P><P> </P><PRE><CODE>Data: w_qty type i, w_final type i. w_qty = EKET-MENGE. w_final = w_qty. Write : w_final.</CODE></PRE><P>you get the values in the required format now</P></BODY></HTML> Wed, 05 Jul 2006 22:56:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411597#M198211 Former Member 2006-07-05T22:56:37Z Re: Formatting and data type problem... https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411598#M198212 <HTML><HEAD></HEAD><BODY><P>But I am wondering that this may not solve problem because if I define it as type C then at the time of outputting on form it will not convert itself to comma format I mean 5,000 or 10,000.</P><P>It only does it when its not type C...</P></BODY></HTML> Wed, 05 Jul 2006 23:04:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411598#M198212 Former Member 2006-07-05T23:04:21Z Re: Formatting and data type problem... https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411599#M198213 <HTML><HEAD></HEAD><BODY><P>hi Tushar,</P><P> Did you try the above method as i have specified in my previous post????.....</P></BODY></HTML> Wed, 05 Jul 2006 23:06:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411599#M198213 Former Member 2006-07-05T23:06:20Z Re: Formatting and data type problem... https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411600#M198214 <HTML><HEAD></HEAD><BODY><P>If it is type c, then it will show whatever is in the field. Since in my example, I am using the WRITE statement, it is formatting with a comma, as the thousands separator(via user specific setting). If my user settings was to have '.' as the separator, it will write that as well. You form will show the separator as you need it to.</P><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Wed, 05 Jul 2006 23:07:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411600#M198214 RichHeilman 2006-07-05T23:07:45Z Re: Formatting and data type problem... https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411601#M198215 <HTML><HEAD></HEAD><BODY><P>Ya but it won't remove leading spaces if I define as type i.</P></BODY></HTML> Wed, 05 Jul 2006 23:13:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411601#M198215 Former Member 2006-07-05T23:13:41Z Re: Formatting and data type problem... https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411602#M198216 <HTML><HEAD></HEAD><BODY><P>If you use the code here, it will work.</P><P></P><PRE><CODE> data: w_qty(15) type c. write eket-menge to w_qty decimals 0. shift w_qty left deleting leading space. </CODE></PRE><P></P><P></P><P>REgards,</P><P>Rich Heilman</P></BODY></HTML> Wed, 05 Jul 2006 23:19:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/formatting-and-data-type-problem/m-p/1411602#M198216 RichHeilman 2006-07-05T23:19:28Z