Skip to Content
0
Jul 23 at 02:48 PM

SAP Odata to Excel Number Format Problem

58 Views

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'

Attachments

1.png (33.7 kB)
2.png (5.2 kB)