on 05-18-2015 6:56 PM
Hi All,
I have a need to change the way SAP exports specification data to Excel using the standard Empty -> Excel output variant. When I output data currently and there are specs that have more than one sort sequence in a VAT, the spec number, NAM PROD identifier and material number are not copied down for each line that holds the subsequent sort sequences.
So I get something like this:
Spec Number Nam PROD Material Number Data field 1 Data field 2
12345 Spec one 1234 55 Grams 45 Degrees
70 Grams 50 Degrees
60 Grams 60 Degrees
62738 Spec two 4321 80 Grams 55 Degrees
40 Grams 32 Degrees
What I need to have happen is this:
Spec Number Nam PROD Material Number Data field 1 Data field 2
12345 Spec one 1234 55 Grams 45 Degrees
12345 Spec one 1234 70 Grams 50 Degrees
12345 Spec one 1234 60 Grams 60 Degrees
62738 Spec two 4321 80 Grams 55 Degrees
62738 Spec two 4321 40 Grams 32 Degrees
I'm not finding any configuration that changes this. I was told this is standard SAP output. Is there a user exit to alter this, or would we need to add a macro to the output template within SAP? Any advice would be greatly appreciated. We need to avoid customizing any standard SAP code, so if that is the only way to accomplish this, please advise and we'll look for other options.
Thank you so much!
Jason
Hi Jason,
The excel that is outputted is based on Macros. If you want to change the output you have to change the macro in the Excel.
Please verify the following notes can be of help.
1) SAP Note 1223805 - Output variant for Excel
2) SAP Note 1103234 - FAQ: Output in Excel
Let me know if this works.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Jason
as Kalyan provided as input: it is very common and quite standard to "copy" SAP standard output variants; to change/adapt them to "optimize" etc. for the companies need. Your findings in context of "EXCEL" output variant are correct. Most of the customers "love " this output variant (as it generates EXCEL) but hate it at the same time because of the reasons etc. you have described.
But by analysing the ABAP code and by analysing how the "EXCEL" work (you need a makro) you can "migrate" the EXCEL one to you own one.
In theory (here I have less experience): you may be know that SAP delivers as well something which is called "EXCEL in place"; what I do not know if you can use here as well a macro. But other "workaorunds" might exists here as well.
But you can try to do it complely different. You can completely use your own ABAP code and generate a "ALV" look and feel display. Here you can sort, switch columns,export to EXCEL etc. etc. using own user interface. ALV is in most cases a very good solution option to solve such kinds of demands
Take a look in:
and
You will find links to threads in context of "output variant" and "idea" how to use the exising "Exit" options in EHS
C.B.
User | Count |
---|---|
12 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.