ABAP vs. MDX vs. SQL

[Former Member]

Dear experts,

I know this question has been asked before, but I am not seeing a straight forward answer.

My client uses SAP 6.5 and is currently on BPC 7.5 NW.  They want to migrate to 10.0.

No script logic has been written yet.  Is it possible to make the mandate on the project to write all script logic to call BADI written in ABAP?

We don't have in-house skills of MDX or SQL. 

Is this an issue in 7.5 or 10.0 NW version for any reason like performance, etc?

Thanks.

[Former Member]

Hi Jason,

MDX has performance issues, and hence is not advisable much.

If you compare Script and BADI, performance of BADI is much better than script. Moreover, any type of calculation can be easily done in BADI.

Hope this helps.

[former_member186338]

Hi Jason,

But the BADI support is much more complicated then script support

Vadim

[Former Member]

why would a badi be more complicated to support if that's the in house skill that we have?

[Former Member]

why would a badi be more complicated to support if that's the in house skill that we have?

[former_member186338]

Hi Jason,

Because it's easier to support 10 lines of script code then 100-1000 lines of BADI code. There are a lot of scenarios where simple script will do the job. For sure in some cases you have to write a BADI:

1. Not possible to write script (today script language is very limited).

2. Script performance is poor.

B.R. Vadim