Column header format when exporting to Excel

[Former Member]

Hi,

I am working on an MS Access application that will import SAP data from MS Excel spreadsheets. Preferably I would have integrated directly to the SAP system using the BAPI ActiveX component but unfortunately the client does not allow me to do that.

I need the the Excel spreadsheets to be of a fixed format and, most important, the column names to be the same as the SAP technical field names (e.g. WERKS for Plant), but the sheets I receive contain the descriptive column names (e.g. names like "Unrestr.-use stock"). As you might understand, a table column name like that is not allowed in a database.

I am not sure the client knows how to export data from SAP to Excel in a more "database friendly" way so to speak, so I am trying to help them understand how to do it, but so far I have not found right solution.

Data we are interested in is PO History, material usage, Inventory, BOM and equipment criticality.

Thanks a lot in advance for your help!

Kind regards,

Younes

[Former Member]

Have you tried creating an ALV report with all the fields you need? At that point you control what the heading names are. Then they can export the data to excel. It has the added advantage of setting up parameters and/or select-options.

[Former Member]

Hi!

Sounds lika a good idea.

The thing is that I, personally, don't have access to the SAP system. I only get the spreadsheets from the client. Consequently I won't be able to test anything.

But I can pass on the information to the client. Using the ALV-grid functionality, is that something a regular SAP user can do or do you need to be an ABAP programmer to handle it?

Best regards,

Younes