SUM of FKIMG joining VBRP and VBRK

Sir\Mam\Gurus ;

I hardly found it difficult in resolving my program in getting the sum of FKIMG inside the VBRP and VBRK tables

The scenario is that i have one Sales Order with multiple invoices . What i need to do is to sum up the fkimg or the quanitity of specific material regardless of how many invoices the material have in a particular SO

Example I have Sales Order number 35678952 with

3 invoices

Invoice # 123 with material number mat1=12, mat2=5 , mat3=7

1. 345 with material number mat1=7, mat2=7

2. 678 with material number mat1=5, mat3=10

Output shoud be

salesorder# 35678952

mat1 = 24

mat2 = 12

mat3 = 17

I will really appreciate your great help..

Thanks !

Moderator message : Duplicate post locked. Continue with original thread.

Edited by: Vinod Kumar on Sep 20, 2011 1:23 PM