topic Query in Application Development and Automation Discussions

Query

Former Member — Wed, 19 Jul 2006 10:32:33 GMT

hi friends,

Could u please send me the details

Average weight - read CUOBJ_BM from table MCH1 where MATNR = RSEBD-MATNR

and charg = RSEBD-CHARG. Read ATWRT from table AUSP where OBJEK = CUOBJ_BM

and ATINN = 'AVE_TABLET_WEIGHT'. ATWRT is average weight

for above that one how we can write the inner join or for all enteris

regrads

srinu

Re: Query

Former Member — Wed, 19 Jul 2006 10:37:14 GMT

select mch1~cuobj_bm

ausp~atwrt

from mch1 inner join ausp

on cuobj_bm = objek

into table itab

where mch1~matnr = rsebd-matnr

and mch1_{charg = rsebd}charg

ausp~atinn = 'AVE_TABLET_WEIGHT'.

Regards,

ravi

Re: Query

Former Member — Wed, 19 Jul 2006 10:38:06 GMT

select a~cuobj_bm

b~awart

into table itab

from mch1 as a inner join ausp as b

on a_{cuobj_bm = b}objek

where a~matnr = RSEBD-MATNR and

a~charg = RSEBD-CHARG and

b~atinn = 'AVE_TABLET_WEIGHT'.

Regards

Ashok Parupalli.

Message was edited by: Ashok Parupalli

Re: Query

Former Member — Wed, 19 Jul 2006 10:41:41 GMT

select cuobj_bm

from mch1

into table itab1

where matnr = rsebd-matnr

and charg = rsebd-charg.

select objek

atwrt

from ausp

into table itab2

for all entries in itab1

where objek = itab1-cuobj_bm

and atinn = 'AVE_TABLET_WEIGHT'.

Regards,

Ravi