Select Query

[Former Member]

Dear All

I am using the following query sum the Quantity but did not come sum

select ekko_{ebeln ekpo}matkl Sum( ekpo~MENGE )

into corresponding fields of table t_pur_reg

from ekko

inner join ekpo on ekko_{ebeln = ekpo}ebeln

inner join ekkn on ekpo_{ebeln = ekkn}ebeln and

ekpo_{ebelp = ekkn}ebelp

where

ekko~ebeln eq t_ekkn-ebeln and

ekkn~VBELN eq s_vbeln and

ekko~FRGKE eq 'R' and

ekko~bstyp eq 'F' and

ekpo~loekz eq space

GROUP by ekko_{ebeln ekpo}MATKL

ORDER BY ekko_{ebeln ekpo}MATKL.

Any Body know tell the reason

Thanks and Regards

Suresh

[Former Member]

hi

Please cehk it here and search get lot of threads

[deepak_dhamat]

data : t_pur_reg1 type t_pur_reg .

select ekko_{ebeln ekpo}ebelp ekpo_{matkl ekpo}MENGE

into corresponding fields of table t_pur_reg

from ekko

inner join ekpo on ekko_{ebeln = ekpo}ebeln

inner join ekkn on ekpo_{ebeln = ekkn}ebeln and

ekpo_{ebelp = ekkn}ebelp

where

ekko~ebeln eq t_ekkn-ebeln and

ekkn~VBELN eq s_vbeln and

ekko~FRGKE eq 'R' and

ekko~bstyp eq 'F' and

ekpo~loekz eq space

GROUP by ekko_{ebeln ekpo}MATKL

ORDER BY ekko_{ebeln ekpo}MATKL.

i.e declare another internal table like t_pur_reg ,

move t_pur_reg to_t_pur_reg1 .

t_pur_reg1 = []t_pur_reg.

loop at t_pur_reg.

t_pur_reg-ebelp = '' .

modify t_pur_reg transporting ebelp .

endloop.

loop at t_pur_reg.

collect t_pur_reg into t_pur_reg2 .

endloop.

then you will get sum of ebeln and matkl .

Use that table for further .

Regards

Deepak .