topic Doubt About Lmenge field conversion to CSV Format. in Application Development and Automation Discussions

Doubt About Lmenge field conversion to CSV Format.

ronaldo_aparecido — Fri, 10 Mar 2017 20:04:37 GMT

Hi Guys I converted vbpr-Lmenge field to CSV With SAP_CONVERT_TO_CSV_FORMAT function. In se16 transaction the value appears like 1.000 and in csv internal table is 1.000,0000. How can i show the value 1.000,0000 like 1,000 on screen ? I can use 'translate value' to get off the '.' but the value apeears like 1000,000 and i need 1,000.

Thanks For help.

Re: Doubt About Lmenge field conversion to CSV Format.

Jelena_Perfiljeva — Fri, 10 Mar 2017 20:38:01 GMT

Post your code. I seriously doubt you are using CSV conversion FM for just one field, that would make no sense. So obviously there is a bit more to it.

There is no VBPR table in SAP and no LMENGE field in VBRP. If you meant VBRP-LMENG then I'd have to see what you're claiming to believe it. Because for me SE16 shows decimals in this field and in the definition it has 3 decimals, not 4 as in your post. Screenshots or didn't happen.

Re: Doubt About Lmenge field conversion to CSV Format.

ronaldo_aparecido — Mon, 13 Mar 2017 11:27:41 GMT

Hi thanks for reply .

Sorry is VBRP-LMENG.

I'm moving it to field with 4 decimals.

I need to sendo to al11 with value 1.0000 but it is showed like 1000.0000

Re: Doubt About Lmenge field conversion to CSV Format.

ronaldo_aparecido — Mon, 13 Mar 2017 14:52:00 GMT

Hi Jelena the functional was think the value was 1 but is 1000 we was confusing because of value is showed like 1.000

i went to table and i filter one with 1 and one with 1.000 .Then i saw and understood.

Thanks for help.

Re: Doubt About Lmenge field conversion to CSV Format.

RaymondGiuseppi — Mon, 13 Mar 2017 15:16:15 GMT

What is the associated value for VBRP-MEINS, this unit code should define the number of decimals (Table T006, fields like DECAN, Customizing transaction CUNI) but when ALV (correctly defined) or SE16/SE16N (from ddic) use this information, I do have doubts, though, when it comes to (also unreleased) FM like SAP_CONVERT_TO_TEX_FORMAT or SAP_CONVERT_TO_CSV_FORMAT that just seem to execute some WRITE statement without any options?

Re: Doubt About Lmenge field conversion to CSV Format.

ronaldo_aparecido — Tue, 14 Mar 2017 12:23:33 GMT

I'm using SAP_CONVERT_TO_CSV_FORMAT.

Thanks for reply