topic Re: SAP ABAP: Internal table query in Application Development and Automation Discussions

SAP ABAP: Internal table query

Former Member — Fri, 01 Jun 2018 11:39:46 GMT

Hello experts,

I am new to SAP ABAP. Could you please help me with the below issue.

I have an internal table with non-unique values as shown below.

I need to calculate the minimum price and percentage change for each material and populate the next 2 columns, which should look as below.

I tried implementing this with a select query, but it did not work. Is there any other way to modify an internal table to accommodate the changes.

Thanks in advance.

Thank you,
Abhishek

Re: SAP ABAP: Internal table query

retired_member — Fri, 01 Jun 2018 12:35:29 GMT

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenitab.htm

Re: SAP ABAP: Internal table query

socrates_socratous2 — Fri, 01 Jun 2018 12:36:36 GMT

Hi,

first of all you need to calculate the minimum for each material in your itab. To do this you need to create a temp itab which you will collect each material with the minimum price. Sample code below

types: begin of t_min,

matnr type matnr,

min type netpr,

end of t_min.

data: lt_min type table of t_min.

data: ls-min type t_min.

data: w_index type i.

loop at itab into ls_itab. "itab is you internal table.

read table lt_min into ls_min with key matnr = ls_itab-matnr.

w_index = sy-tabix

if sy-subrc <> 0. " first time

ls_min-matnr = ls_itab-matnr.

ls_min-min = ls_min-netpr.

append ls_min to lt_min.

else.

if ls_itab-netpr < ls_min-netpr.

ls_min-netpr = ls_itab-netpr.

modify lt_min from ls_min index w_index.

endif.

endloop.

After you have calculate the min for all materials just loop once more to update you original table

loop at itab into ls_itab.

w_index = sy-tabix.

read table lt_min into ls_min with key matnr = ls_itab-matnr.

ls_itab-min_price = ls_min-min.

*Now calculate persentage

ls_itab-perc = (( ls_itab-netpr - ls_itab-min_price) * 100 ) / ls_itab-min_price.

modify itab from ls_itab index w_index.

endloop.

I hope this helps.

S.Socratous

Re: SAP ABAP: Internal table query

omer_sakar — Fri, 01 Jun 2018 13:36:21 GMT

Hi,

Use control level statements like this reference : https://wiki.scn.sap.com/wiki/display/ABAP/Control+Level+Statements+in+ABAP

1. Sort itab comparing matnr netpr (descending)

2. Loop itab.

at end of matnr.

--> this line minimum of netpr

endat.

endloop.

Re: SAP ABAP: Internal table query

retired_member — Fri, 01 Jun 2018 16:13:40 GMT

It would be simpler and more effective with LOOP AT ASSIGNING instead of MODIFY.

It would be contemporary with expressions.

It would be more readable if you formatted your code example.

Re: SAP ABAP: Internal table query

retired_member — Fri, 01 Jun 2018 16:14:47 GMT

Better use LOOP AT GROUP BY.