Columns are not in exact same sequence as in alv

[Former Member]

Dear Team,

While downloading into excel, sometimes the fields go to the right most columns in excel and are not in exact same sequence as in alv.

Upon notice, we have found, columns which contains dates, amount aren't display in same sequence as in alv....

Product->  ECC6.0

SAP Basis->   701(sp8) 

Simply stating-> If columns in alv are in A,B,C,D order....but download in excel as A, D,B, C

Thanks

Sumit 

[amine_lamkaissi]

Hi Sumit,

Did you try to load them in an unconverted format?

Amine

[Former Member]

Hello amine,

Yes it's coming in right sequence in an unconverted format, but this require lot of manual work when pasted in excel. For users, whose daily task is dependent on this make their work tedious.

I think ,this is some error in SAP.... please help if SAP note/patch can be applied?

Thanks

Sumit jain....

[Ranjith418]

Hello Sumit,

Please check your GUI version and try to have it latest patch and also did you do any upgrades to the your office software.

Failure of Excel view within SAP GUI

Sometimes an SAP screen contains a frame that holds Excel (with the SAP

data). This is 'Excel Inplace'. Notably, it is an option in the ALV grid,

where the user can switch between the Excel view and the standard ALV

grid.

With some newer Windows versions it can happen that the SAP data fails to

appear in the Excel frame. Here is a reminder of the fix.

In Excel:

Tools -> Macro -> Security;

select the u2018Trusted Sourcesu2019 tab;

ensure that the box u2018Trust access to Visual Basic Projectu2019 is checked;

click OK.

Exit Excel.

For some SAP standard reports with an Excel view, Excel security needs to

be relaxed further.

In Excel:

Tools -> Macro -> Security;

select the u2018Security Levelu2019 tab;

ensure that the radiobutton u2018Mediumu2019 is selected;

click OK.

Exit Excel.

check out OSS note 696069, it may provide you with some additional leads.

THanks,

Ranjith