topic Re: select with join in Application Development and Automation Discussions

select with join

Former Member — Thu, 31 May 2007 23:25:32 GMT

hello abapers,

below is my scenario,

Extract each entry from DBtab1 for FLD1 in DBtab2-FLD1, and FLD2 in DBtab3-FLD2

sum(FLD3) by FLD2 into

internal tab ITAB (fields FLD2, FLD3).

i thought something like this;

select FLD1 FLD2 sum( FLD3) into ITAB from DBtab1 where FLD1 = DBtab2-FLD1 and FLD2 = DBtab3-FLD2

GROUP by FLD2.

i know this doesnot work, because fld1 should check each and every entry in DBtab2 and same is the case with DBtab3,

i should be using inner or outer join, can some one help.

thank you.

Re: select with join

Former Member — Thu, 31 May 2007 23:31:50 GMT

Hi saritha,

Either use inner join, or get the data into the internal tables by using FOR ALL ENTRIES.

Regards,

Atish

Re: select with join

Former Member — Thu, 31 May 2007 23:43:50 GMT

If you want to have SAP write the code for you use the quick viewer to build a join and generate the code.

Run the quuey. Do a system > statuson the result and lift the code.

Quick viewer is either System >services >quick viewer or systemt >quick viewer can't remember which from the session manager transaction.

Also to view the documentation in the abap editor type the word join and hit F1.

Re: select with join

Former Member — Fri, 01 Jun 2007 00:37:58 GMT

See the example code :

select matnr shkzg meins sum( fklmg )

into table i_billed

from ( vbrk as k INNER JOIN vbrp as p on k_{vbeln = p}vbeln )

where ( vbtyp = 'M' or "invoice

vbtyp = 'N' ) and "invoice cancellation

k~fkdat in so_vdatu and

matnr in so_matnr and

p~werks = p_werks

group by matnr shkzg meins.

Re: select with join

Former Member — Fri, 01 Jun 2007 02:17:48 GMT

Hi,

Its better if u use Inner Join or For All entries.......to join the tables.....

with regards,

madhuri.

Re: select with join

Former Member — Fri, 01 Jun 2007 02:18:24 GMT

Hi,

Its better if u use Inner Join or For All entries.......to join the tables.....

with regards,

madhuri.