topic Re: While downloading missing column data in excel in Application Development and Automation Discussions

While downloading missing column data in excel

former_member712994 — Tue, 24 Jun 2014 05:41:22 GMT

Hi All,

I have an ALV report using factory model method. Now when I am trying to download the output into an excel sheet one column data is missed out.

It is downloading a blank column with the heading.

The length of the column is 255 characters. Do we have any restrictions for the length?

If not help me out to solve this issue.

Thanks,

Subhashini.K

Re: While downloading missing column data in excel

davis_raja — Tue, 24 Jun 2014 06:55:23 GMT

Dear Subhashini,

Just have a look at the order of the fields in the internal table which you are displaying in the output and the order of the fields in the field catalogue.

The download option may miss some data if the orders of the fields in the internal table and the field catalogue are not matching.

Regards

Davis

Re: While downloading missing column data in excel

former_member712994 — Tue, 24 Jun 2014 07:11:18 GMT

Hi Davisraja,

Even the order of field catalog is same as we are downloading. Even then it is not downloading the data.

Here the column heading is downloaded but not the data.

Will it be an issue if the column data have space in the beginning or starts with some special character?

Thanks,

Subhashini.K

Re: While downloading missing column data in excel

davis_raja — Tue, 24 Jun 2014 07:14:14 GMT

Dear Subhashini,

Can you post the screenshot of the Excel file and the order of the fields in the internal table?

Regards

Davis

Re: While downloading missing column data in excel

Mohamed_Mukhtar — Tue, 24 Jun 2014 07:16:11 GMT

Hello Subhashini,

Yes, there will be issues(example : distortion of excel columns) whiles downloading if a column is having special characters.

Replace those special characters with space and remove the left spaces before downloading to excel.


replace first occurence of '"' in wa_variable with space.
       shift wa_variableleft deleting leading ' ' .

Thanks

Re: While downloading missing column data in excel

former_member712994 — Tue, 24 Jun 2014 07:39:14 GMT

I have tried removing the special character and the leading space, even then it is not downloading the data.

Thanks,

Subhashini.K

Re: While downloading missing column data in excel

former_member712994 — Tue, 24 Jun 2014 07:43:46 GMT

Although the Coding Long Text have some data, after downloading the excel looks like this.

Thanks,

Subhashini.K

Re: While downloading missing column data in excel

davis_raja — Tue, 24 Jun 2014 08:36:08 GMT

Can you please post your field catalogue code and the structure declaration code.