04-27-2010 7:40 AM
Dear all,
I am facing some issue regarding fetching of BEARP and BEARZ field values from AFVV table. Since these two fields correponds to Processing time (Forecast) and Processing Time respectively and their values are like 5.000000000000000E01 or 4.000000000000000E01, I am confused how can a time field have these kind of values. How should I display these field values in my report? Apart from that please guide where can I see these values on the screen, I mean in which transaction.
Looking forward for some helpful replies.
Cheers
VJ
04-27-2010 8:10 AM
If it si an ALV Report then use he parameter for time
TIMS for Time
otherwise in classical report use Edit Mask for Display.
Regards,
Gaurav Sood
04-27-2010 8:27 AM
The data type for the fields which I have mentioned above is FLTP which is floating type.
I am not sure the way you are suggesting will help.
Cheers
VJ
04-27-2010 8:30 AM
Hi,
Declear a vriable with type P in your program and move the value to the variable you will get your desired result.
Data : v_abc type P.
v_abc = wa_afvv-bearp.
see the content of v_abc.
Regards
Bikas
04-27-2010 8:40 AM
I have already tried the way you have suggested.
DATA:
V_FLTP TYPE BEARZEIT,
V_PACKED TYPE p." DECIMALS 2.
*V_tim TYPE tims." DECIMALS 2.
SELECT BEARZ INTO V_FLTP
FROM AFVV UP TO 100 ROWS
WHERE BEARP IS NOT NULL.
ENDSELECT.
IF V_FLTP IS NOT INITIAL.
MOVE V_FLTP TO V_PACKED.
* MOVE V_PACKED TO V_tim.
WRITE:
/ V_FLTP,
V_packed.
else.
write : 'No values'.
ENDIF.
Suppose V_FLTP = 2,400000000000000E+02, then output V_PACKED is 240.
But value 240 does not correponds to Time format.
I hope I am able to convey it properly.
Cheers
VJ
04-27-2010 12:49 PM
04-27-2010 1:11 PM
Hi,
I found CTCV_CONVERT_FLOAT_TO_DATE which translates float to Date ,
04-28-2010 4:12 AM
Thanks Bikas,
The mentioned FM will just convert float value to Date but I want it in Time format.
Cheers
VJ