topic calculation in internal table values in Application Development and Automation Discussions

calculation in internal table values

Former Member — Tue, 16 Apr 2013 00:57:31 GMT

I have brought the output of a field in the alv output which is Konv_kbetr for condition type (kschl) of ZCH, whose value appears as 250 instead 25. Konv table value also shows this as 250. I want to do 250/10.

For bring the value of 250 in the output, i have used select statement, created internal table , Loop statement created and modified the internal table etc. I am now struck to proceed further for doing this calculation 250/10.

please guide as i am very new to this abap.

Re: calculation in internal table values

Former Member — Tue, 16 Apr 2013 03:06:36 GMT

Hi Pooja,

10 is fixed or you are calculating unit price? If latter, you should use konv-kbetr/konv-kpein before appending the value to internal table.

Chloe

Re: calculation in internal table values

satyabrata_sahoo3 — Tue, 16 Apr 2013 04:14:53 GMT

You want to display 250 or 25 in output?

Can you post ur code here, so that we can check where you facing issue.

Re: calculation in internal table values

Former Member — Tue, 16 Apr 2013 04:26:37 GMT

wanted 25 in the output. My code as follows :

SELECT

KONV~KNUMV

konv~kposn

konv~kschl

konv~kbetr as kbetr2

into CORRESPONDING FIELDS OF TABLE it_display3 from konv

for ALL ENTRIES IN it_display where

konv~knumv = it_display-knumv AND

konv~kschl = 'ZCAS'.

LOOP AT it_display.

READ TABLE it_display3 WITH KEY knumv = it_display-knumv .

IF sy-subrc = 0.

it_display-kbetr2 = it_display3-kbetr2.

MODIFY it_display.

ENDIF.

ENDLOOP.

Re: calculation in internal table values

Former Member — Tue, 16 Apr 2013 04:42:16 GMT

hi,

SELECT

KONV~KNUMV

konv~kposn

konv~kschl

konv~kbetr as kbetr2

into CORRESPONDING FIELDS OF TABLE it_display3 from konv

for ALL ENTRIES IN it_display where

konv~knumv = it_display-knumv AND

konv~kschl = 'ZCAS'.

LOOP AT it_display.

READ TABLE it_display3 WITH KEY knumv = it_display-knumv . ( You also need to match the KPOSN )

IF sy-subrc = 0.

it_display-kbetr2 = ( it_display3-kbetr2 / 10 ).

MODIFY it_display.

ENDIF.

ENDLOOP.

Regards,

Rahul Singh

Re: calculation in internal table values

Former Member — Tue, 16 Apr 2013 04:44:00 GMT

Hi Pooja,

In the loop you can have :

it_display-kbetr2 = it_display3-kbetr2 / 10.

So your code becomes:

SELECT

KONV~KNUMV

konv~kposn

konv~kschl

konv~kbetr as kbetr2

into CORRESPONDING FIELDS OF TABLE it_display3 from konv

for ALL ENTRIES IN it_display where

konv~knumv = it_display-knumv AND

konv~kschl = 'ZCAS'.

LOOP AT it_display.

READ TABLE it_display3 WITH KEY knumv = it_display-knumv .

IF sy-subrc = 0.

it_display-kbetr2 = it_display3-kbetr2 / 10.

MODIFY it_display.

ENDIF.

ENDLOOP.

Regards,

Sonal