GoalSeek Function in ABAP

[Former Member]

Hi,...

Is there any function in ABAP similar to GoalSeek function in Excel?

thanks

[Former Member]

how do we get that application? does it come with standard bw BC?

[Former Member]

well, Actually I have a math calculation say:

net + tax = gross (this is for example only, the real one should be more complex than this)

with this formula I can have gross value ... but what if I have gross value ... how is the net if I have tax?

with excel GoalSeek function, I easyly can do that....

I wonder is there any similar function or command or whatever in abap/sap? or I can only do that by creating 2 sub procedures, one for net + tax = gross, second for gross - tax = net?

thanks

[christian_wohlfahrt]

Hi Yusuf,

there is indeed a goal seeking function: it's implemented in applications VKP1 / VKP5. There you can not only the base value, but also the target value. With 'enter', your base value is then changed accordingly in a recursive calculation.

But in general: as you have to program the forward way, how can you expect the backward way to be automatically?

Regards,

Christian

[Former Member]

Hi Christian,...

thanks for replying... I have to look for the applications you mention first then... Actually, I am working on HR module now, so I kinda need to know what is the applications (VKP1/VKP5) do exactly... could you give me more details on it?

Well, right now I just create two sub routines for that....

btw, since I don't exactly understand what you mean in the last reply, but I give you helpful answer points for replying... thanks n sorry takes so long to come back

[christian_wohlfahrt]

Hi!

VKP1 is part of Retail module and much to big for a short explanation. Half of course IRT 110 is about this topic.

Regards,

Christian

[Former Member]

Hi Yusuf,

Excel is an <i>application</i> and ABAP is a <i>programming language</i>. You cannot expect to draw similarities between the two.

Could you please rephrase your question and also explain the requirement?

Regards,

Anand Mandalika.

[Former Member]

Hi,

Plz let me what u want to import and export in the function module.

Thanks & Regards,

Judith.