topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Fri, 04 Aug 2006 11:33:23 GMT

hi friends,

Could u please send me details how can we write this Query

Once the Batch is selected. Select the process order(AFPO-AUFNR) from the table AFPO where the batch number(CHARG) selected from MSEG equals the batch number(CHARG) from AFPO. Select the total amount(AFKO-GAMNG) where the procress order(AFKO-AUFNR) equals the procress order selected from AFPO.

Regards

srinu

Re: Query

Former Member — Fri, 04 Aug 2006 12:07:53 GMT

SELECT A_{AUFNR, B}CHARG, B_{MATNR, A}GMANG

INTO ITAB

FROM AFKO AS A INNER JOIN AFPO AS B

ON A_{AUFNR = B}AUFNR

WHERE B~CHARG = P_CHARG.

Regards

Anurag

Re: Query

Former Member — Fri, 04 Aug 2006 12:14:16 GMT

select *

from mseg

into table it_mseg

where

<your where condition>.

if not_it_mseg[] is initial.

select aufnr

charg

from afpo

into it_afpo

for all entries in it_mseg

where charg = it_mseg-charg.

if not it_afpo[] is initial.

select aufnr

gamng

from afko

into table it_afko

for all entries in it_afpo

where aufnr = it_afpo-aufnr.

endif.

Regards,

ravi

Re: Query

Former Member — Fri, 04 Aug 2006 12:36:28 GMT

Hello Srinu,

Firstly u have to select unique batch number from MSEG as same batch may be split. Once u have found the batch connect it to the table AFPO. For each unique record found in AFPO select header table AFKO and get collect the qty in field GAMNG.

Re: Query

Former Member — Fri, 04 Aug 2006 12:48:44 GMT

Hi srinu,

try this code.

data:begin of itab1 occurs 0,

CHARG like MSEG-CHARG,

end of itab1.

data:begin of itab2 occurs 0,

aufnr like afpo-aufnr,

charg like afpo-charg,

end of itab2.

data:begin of itab3 occurs 0,

GAMNG like afko-gamng,

aufnr like afko-aufnr,

end of itab3.

select charg from mseg into table itab1.

select aufnr charg from afpo into table itab2

for all entries in itab1

where charg = itab1-charg.

select GAMNG aufnr from afko into table itab3

for all entries in itab2

where aufnr = itab2-aufnr.

Please reward me if it helps you.

Thanks,

Sowjanya