topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Fri, 22 Jan 2010 06:22:07 GMT

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

Re: Select Query

Former Member — Fri, 22 Jan 2010 06:26:16 GMT

Please cehk it here and search get lot of threads

Re: Select Query

deepak_dhamat — Fri, 22 Jan 2010 09:01:43 GMT

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 .