SAP Odata to Excel Number Format Problem

[former_member698644]

Hi Experts, I consume Odata Service in Excel but shows Decimal values like string, how can i resolve this problem

Thank you in advance.

@AbapCatalog.sqlViewName: 'Z_MARA_XX' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'MARA' @OData.publish: true define view Z_MARA as

select from mara {

key mandt as Mandt,

key matnr as Matnr,

meins as Meins,

@Semantics.quantity.unitOfMeasure: 'Meins'

@DefaultAggregation: #SUM

ltrim(rtrim(replace(cast(brgew as abap.sstring(30)),'.',','),''),'') as Brgew,

@Semantics.quantity.unitOfMeasure: 'Meins'

@DefaultAggregation: #SUM ntgew as Ntgew

} where mtart = 'ZP06'

[Sandra_Rossi]

I don't know much all this, but don't you think the issue is because BRGEW is declared as a text field? Why do you need to change the thousands and decimal point characters?

[former_member698644]

I try different ways to solve the problem, NTGEW doesn't display properly either