cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ECC 6 ALV Export not showing .xlsx 2007 and 10 format

former_member186190
Participant
0 Kudos

Dear Team

Is there any SAP Note Available to activate  XLSX version to ECC 6.  BASIS 701 SAPKB70109.


Please see the attachment





Thanks

Yoonus

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member186190
Participant
0 Kudos

Hi Team

I have imported the snoe 0001693607   but still same there is no option to select 2007 or 2010 format. still available only older  here ill show here what is in new solution manager i need the same on my ECC 6


Thanks

Yoonus



former_member182034
Active Contributor
0 Kudos

aoa Younas,

did you check these SAP note? If not then follow & implement the correction.

1522778 - ALV View: Templates with XLSX extension cannot be selected

1691220 - ED: Inventory settlement - Excise Duty - Error - Excel exp.


Regards,


former_member186190
Participant
0 Kudos

vos

As per this 1522778  note , I did the changes and added the entry on TOADD table, but it does not reflect anywhere else.

Here is the value of  import after changing  does not showing newly added template.

Thanks

Yoonus

d
@EB@EN01.07.201506:49:31BASISE01.07.201506:49:31BASISESAP_STANDARD_TEMPLATE1Esap_mm.xls
@EB@EN01.07.201506:49:31BASISE01.07.201506:49:31BASISESAP_STANDARD_TEMPLATE1Esap_om.xls
@EB@EN01.07.201506:49:31BASISE01.07.201506:49:31BASISESAP_STANDARD_TEMPLATE1Lsap_mm.123
@EB@EN01.07.201506:49:31BASISE01.07.201506:49:31BASISESAP_STANDARD_TEMPLATE1template.xls
@EB@DE01.07.201506:49:30BASISE01.07.201506:49:30BASISESAP_STANDARD_TEMPLATE1template.xls
@EB@EN01.07.201506:19:23BASISE01.07.201506:19:23BASISESAP_STANDARD_TEMPLATE1Esap_mm.xls
@EB@EN01.07.201506:19:23BASISE01.07.201506:19:23BASISESAP_STANDARD_TEMPLATE1Esap_om.xls
@EB@EN01.07.201506:19:23BASISE01.07.201506:19:22BASISESAP_STANDARD_TEMPLATE1Lsap_mm.123
@EB@EN01.07.201506:19:22BASISE01.07.201506:19:22BASISESAP_STANDARD_TEMPLATE1template.xls
@EB@DE01.07.201506:19:22BASISE01.07.201506:19:22BASISESAP_STANDARD_TEMPLATE1template.xls
@EB@EN01.07.201506:19:20BASISE01.07.201506:19:20BASISESAP_STANDARD_TEMPLATE1Esap_mm.xls
@EB@EN01.07.201506:19:20BASISE01.07.201506:19:20BASISESAP_STANDARD_TEMPLATE1Esap_om.xls
@EB@EN01.07.201506:19:19BASISE01.07.201506:19:19BASISESAP_STANDARD_TEMPLATE1Lsap_mm.123
@EB@EN01.07.201506:19:19BASISE01.07.201506:19:19BASISESAP_STANDARD_TEMPLATE1template.xls
@EB@DE01.07.201506:19:19BASISE01.07.201506:19:17BASISESAP_STANDARD_TEMPLATE1template.xls
former_member182034
Active Contributor
0 Kudos

hi,

1693607 - ALV view: Checking XLSX/XLSM templates in and out


If above not is not applicable then you can get this format in SAP_BASIS 7.02


1517329 - ALV Spreadsheet Export: Format Overview



Excel 2007 (XLSX)

  • Description:
    • Zipped, XML based Export format.
  • Availability:
    • WD ALV: since SAP_BASIS 7.02
    • SAP GUI ALV: since SAP_BASIS 7.02
  • Limitations:
    • No export of "Top Of List" and "End Of List" sections of ALV.
    • Only available for SAP_BASIS 7.02 and later.



Regards,


Former Member
0 Kudos

Yoonus,

Please check following SAP note :-

1686797 - ALV Excel: Signed SAP standard templates

Regards

Anand

former_member182034
Active Contributor
0 Kudos

hi Younus,

this note also helpful for you regarding Excel 2007 (XLSX).

1925897 - Excel cannot open the file '*.xlsx' because the file format or file extension is not valid

Regards,

Former Member
0 Kudos

Hi Yoonus,

You can check the OSS Note below:


1522778 - ALV View: Templates with XLSX extension cannot be selected

Regards,

Mark

Sriram2009
Active Contributor
0 Kudos

Hi Yoonus

Could you refer the SAP note for supported spreadsheet format supported.

1517329 - ALV Spreadsheet Export: Format Overview


Regards

SS

Former Member
0 Kudos

Hello Yoonus,

Please check following SAP notes.

1080608 - Defining ABAP ALV export format for spreadsheet

1693607 - ALV view: Checking XLSX/XLSM templates in and out

Regards

Anand