Report Problem

Hi all,

I have got a requirement where I need to prepare report, the report should look out for the document number in BKPF and then display the detail of that document number such as Gross amount, Net amount from other FI table.

So basically if a document has multiple line items then we need to add up all those line items.

My scenario is like this:

doc # item# Gross amount Net amount

123 1 12 10

123 2 12 9

123 3 13 11

124 1 15 13

So the output should be:

doc # Gross amount Net amount

123 37 30

124 15 13

So can you please tell me how to care of this.

Thanks,

Rajeev!!!!!!