Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel attachment downloaded from SOST rounding off the columns

former_member565051
Participant
0 Kudos
539

Hello,

While downloading the Excel file from the SOST, the column (eg. Idoc no.) is automatically rounding to the nearest decimal.

For eg. If idoc number is 5000000009681031, in the excel it will be displayed as 5000000009681030.

Problem seems to be in Dev system only. When i try the same report in Sandbox, the values are coming correctly.

Is there any setting we need to do for system specific? or any excel settings?

TIA,

Ajay

7 REPLIES 7

FredericGirod
Active Contributor
335

Are you sure this is how the file is stored ? and not Excel doing this ?

A lot of time, the file suppose to be excel file is a simple CSV. So just drag and drop this file in a notepad app. and check the value

abo
Active Contributor
335
frdric.girod

rule of thumb, when people say "Excel file" it usually isn't 🙂

Also, SOST does not care about the files' content, as long as they have the proper attachment type the rest is up to the users / developers.

FredericGirod
Active Contributor
0 Kudos
335

scot has a transformation tool, to convert the format (oss note 762870)

Sandra_Rossi
Active Contributor
335

You must understand the difference between texts and numbers in Excel, to make it work correctly. For numbers, Excel guarantees only a precision up to 15 digits. As IDoc numbers may have up to 16 digits, you should format the column of IDoc numbers as text.

former_member565051
Participant
0 Kudos
335

sandra.rossi

Thanks for the help. Yes the issue is with Idoc number range. It is 17 in the Dev while its 9 in sandbox. Excel has some limitations it seems.

0 Kudos
335

Please use the COMMENT button for comments, questions, adding details, replying to a comment or a proposed solution or to the OP question, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

335

IDoc number = 16 digits maximum in SAP.