Difference between bex user exit and macros in functionality?

[Former Member]

Hi all,

I need to create a report on material master data. I created an infoset on 0material and 0mat_plant. In the requirem

ent, I have a report containing different material numbers followed by attributes in each row. the final column in each

row should be calculated using logic. the logic involves comparing different row values and arrive at final conclusion.

the logic comprises of large number of if conditions. so should i use bex user exit or excel macros?

what is the difference between user exit and macros in funcitonalilty?

is there an issue transporting the macro to Prod for end users to use?

any performance criteria?

Any how to documents ..will be of a lot of help

plz send them to aps804@yahoo.com

Message was edited by:

ravi a

[Former Member · Accepted solution]

Hi,

Macros offer a powerful and flexible way to extend the features of MS Excel. You can either create a macro using VB code or Record a macro. Use Alt+F11 for creating macro using VB code.

You can refer to Microsoft help site or this link for more details:

http://www.taltech.com/support/sw_tricks/exmacros.htm

User-exits are empty subroutines that SAP Developers have provided for you.You can fill them with your own source code.Technically this is a modification.Customer exits are nothing but a include in customer name space will be provided in the function module which starts with CALL CUSTOMER.You can fill them with your own source code.Technically this is an enhancement.

look into following links for procedure to find and use user-exits transaction for finding user-exits is 'SMOD'

http://www.sapbrain.com/TUTORIALS/TECHNICAL/user_exits_tutorial.html

http://www.sap-img.com/abap/a-short-tutorial-on-user-exits.htm

[Former Member]

thanks guys for all your useful inputs, points awarded for everybody

[Former Member]

Hi Ravi,

Sending some documents explaining use of Excel VBA (macros) with BEx Analyzer. Check your in-box.

- Pete

[Former Member]

Hi Peter,

I know you had helped me with some stuff before, but If you don't mind can you please send me the documents? I need to go over some stuff before we move to NW2004s and looking at the all the post I think you have lot of valuble experience that can help me improve.

email: shettydatta@gmail.com

Thanks in Advance.

Datta.

[Former Member]

Done.

- Pete

[former_member184494]

Ravi,

User Exit - this is to manipulate the data being fetched

Macro - this is to manipulate the data in excel AFTER the data has been fetched.

Arun