topic Re: Difference Requirement in Application Development and Automation Discussions

Difference Requirement

Former Member — Fri, 22 Aug 2008 11:10:48 GMT

Hello all,

I have a requirement that in an internal table field i want to select data from a standard sap table that is difference of two fields of that table.

""Difference qty has to be calculated as the difference between the booked qty and Posted Qty(ISEG/MSEG u2013 ISEG/BUCHM)""

How do I write the SELECT statement that my this requirement is fulfilled?

Thanks in advance.

ThomasZloch — Fri, 22 Aug 2008 11:16:32 GMT

You will have to select first and do calculations afterwards by looping through the result set.

Thomas

Former Member — Fri, 22 Aug 2008 11:20:34 GMT

hi,

try to code like this:

itab1 with field qty1 and qty2.

define itab2 with qty1 , qty2 and qty_diff (type of qty1 or qty2).

fire select query.

selcect qty1 qty2 from 'sap table' into itab1 where 'Your condition'.

loop at itab1 into wa_itab1.

wa_itab2-qty1 = itab1-qty1.

wa_itab2-qty2 = itab1-qty2.

wa_itab2-qty_diff = ( itab2-qty1 - itab2-qty2 ).

append wa_itab2 to itab2.

clear wa_itab2.

endloop.

Now u will get your required result in itab2. Pass itab2 to alv, will get the data and difference.

Former Member — Fri, 22 Aug 2008 11:23:12 GMT

hi yogesh

first select the data from database table ISEG into internal table (eg Itab) by using corresponding fields of keyword

then loop at internal table itab

loop at Itab

diff = Itab-MSEG u2013 Itab-BUCHM.

modify itab transporting diff.

endloop.

Here Diff is field in our internal table to hold the difference

Hope it will help you

Regards

deva