Problem with AFVV-BEARP and AFVV-BEARZ field fetching

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member182485]

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

[Former Member]

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

[Former Member]

Hi guys!!!

Please help in the issue which I raised.

Cheers

VJ

[former_member182485]

Hi,

I found CTCV_CONVERT_FLOAT_TO_DATE which translates float to Date ,

[Former Member]

Thanks Bikas,

The mentioned FM will just convert float value to Date but I want it in Time format.

Cheers

VJ