01-28-2008 5:21 AM
Hello Gurus,
I want to format Amount in the below manner , I need to put this data in a text file ,
When I read it from SAP , irrespective of whatever format
I need to write the data in the text file in the following format
999999999999.999
if the amount is 12 then
000000000012.000
if the amount is 100 then
000000000100.000
Also , I need a help on date formating
My date will always appear in the text file in the following format
YYYY.MM.DD
so irrespective of whatever user settings on has I need the format to appear in the text file as above.
Please help me Points guaranteed , please try it at your end
and please paste the code.
rgds,
Aryan
01-28-2008 7:16 AM
01-28-2008 11:00 AM
01-28-2008 1:30 PM
Hi Aryan,
For Amount, try out the below code...it will work fine.
REPORT ZAMT_DAT .
TYPES amt TYPE p DECIMALS 3.
data : v_amt(16) type c ,
v_amt1 type amt value 100,
v_len type i,
v_len1 type c,
p_date(10) type c value '23012008'.
v_amt = v_amt1.
condense v_amt.
v_len = strlen( v_amt ).
v_len = 16 - v_len.
do v_len times.
concatenate '0' v_amt into v_amt.
enddo.
write : v_amt.
For date, set the user settings as below...
system-userprofile->owndata->defaults->dateformat
set it to the 4 th radio button....
it will work fine.
Thanks
01-28-2008 1:52 PM
Hi!!
check this out if it helps...
REPORT ztestdate.
DATA:lv_day TYPE c LENGTH 2,
lv_month TYPE c LENGTH 2,
lv_year TYPE c LENGTH 4,
lv_string TYPE c LENGTH 10.
*formatting the date into requested type.
lv_day = sy-datum+6(2).
WRITE:/ sy-datum+6(2).
lv_month = sy-datum+4(2).
WRITE:/ sy-datum+4(2).
lv_year = sy-datum(4).
WRITE:/ sy-datum(4).
CONCATENATE lv_year lv_month lv_day INTO lv_string SEPARATED BY '/'.
WRITE:/ lv_string.
Thanks & regards
@mit.