Hi gurus,
I have a problem !!!!
I am working on a report...where I need to get the document number from table BKPF and then I need to get the line item data from table BSEG such as gross amount and Net amount, then I need to sum up the gross amount and net amount of one header and need to display it. ...
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 yoy please tell me how can I take care of this....
Any help will really be appreciated !!!! actually I am trying to learn!!!
Thanks,
Rajeev !!!!