Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inserting data into Excel using SOI interface and INSERT_ONE_TABLE

I am using this method to transfer data from an internal table to Excel.

First I read the internal table structure using RFC_GET_STRUCTURE_DEFINITION.

Then I pass in the data to excel using the INSERT_ONE_TABLE method.

The problem I have is that for date entries when the internal table contains an initial value 00000000 this is interpereted by excel in some cases as 1999-11-30 and others as 12:00 am.

Even in debugger if the table field is cleared then in Excel it behaves differently

I would prefer a blank cell.

Rgds

Glenn

Glenn

Not what you were looking for? View more on this topic or Ask a question