topic Re: Convert Breakdown time in Application Development and Automation Discussions

Convert Breakdown time

former_member328875 — Mon, 21 Oct 2013 09:41:32 GMT

Hi experts,

Breakdown time in format like 5.1840000000000000E+05 how it can be converted like 144.00

Thanks,

saquib Khan

Re: Convert Breakdown time

Arun_Prabhu_K — Mon, 21 Oct 2013 09:58:10 GMT

Hello Saquib Khan.

DATA: fvar type f,

pvar type p decimals 2.
fvar = '5.1840000000000000E+05'.

pvar = fvar / 3600. "(to get your desired result 144.00 )

Regards.

Re: Convert Breakdown time

Former Member — Mon, 21 Oct 2013 10:17:46 GMT

Hi Saquib,

5.1840000000000000E+05 is in hex format(seconds i guess),so you need to move this to a integer then just divide by number as you with(by 60 for min and by 3600 for hr).

Regards,

Supratik

Re: Convert Breakdown time

former_member328875 — Mon, 21 Oct 2013 10:43:06 GMT

Thanks Arun. I it works but I want to know the reason why in SAP many values are not in actual format but in exponent forms n why conversion is required.

regards,

Saquib

Re: Convert Breakdown time

Arun_Prabhu_K — Mon, 21 Oct 2013 10:49:36 GMT

Very good question Saquib.

But frankly I don't know the reason behind it.

If I come to know it, I will let you know surely.

Regards.

Re: Convert Breakdown time

danilo_schembri — Mon, 21 Oct 2013 15:56:35 GMT

Hi Saquib,

This is the output representation for an F type field.

Here you can find more informations:

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9e2335c111d1829f0000e829fbfe/content.htm

and subsequents:

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb2fd9358411d1829f0000e829fbfe/content.htm

You can see an F field has a size of 8 bytes, but outputs with 22 characters.

Here

http://help.sap.com/saphelp_40b/helpdata/en/34/8e732f6df74873e10000009b38f9b8/content.htm

you can found an output example for P and F type fields.

If your question was about desing, well, we should try to guess... 🙂

Regards.

Danilo Schembri