SAP Query
Hi.
When I join two tables in an infoset, e.g. MARA and S031, a line are shown in the basic list as many times as it is in S031. But I only need a sum of a field in S031 where the material is the same, and the periods lie between x and y. I need to use this value for further calculations, so the Statistic is not usefull.
Can anybody help - if a code in the infoset is needed, please give me an example, ABAP is not my competance.
Thanks in advance.
Claus.
Claus,
There are several ways to solve this.
You can use DELETE ADJACENT DUPLICATES on your internal table after you have SELECTed, Or you can sort your internal table and within the LOOP...ENDLOOP containing the WRITE statemsnts use AT END OF, or AT LAST etc. with SUM.
_________________
"You start coding. I'll go find out what they want"