topic Re: query on inner join in Application Development and Automation Discussions

query on inner join

Former Member — Wed, 13 Aug 2008 05:42:55 GMT

Hello experts,

i 'd like to join the tables BKPF and BSEG using the joins concept. let me know the statement for this so that i get the output as desired. USING selection screen concept as well.

BKPF-BELNR,

BKPF-BUKRS

BKPF-GJAHR ( FISCAL YEAR)

BSEG-WRBTR (VOUCHAR AMOUNT)

BSEG-WRBTR( CREDIT )

BSEG-WRBTR( DEBIT)

Regards,

CHK

Re: query on inner join

Former Member — Wed, 13 Aug 2008 05:46:48 GMT

<<Incorrect answer removed>>

Edited by: Matt on Dec 3, 2008 3:49 PM

Re: query on inner join

Former Member — Wed, 13 Aug 2008 05:50:56 GMT

<<Incorrect answer removed>>

Edited by: Matt on Dec 3, 2008 3:50 PM

Re: query on inner join

Former Member — Wed, 13 Aug 2008 06:05:40 GMT

<<Incorrect answer removed>>

Edited by: Matt on Dec 3, 2008 3:50 PM

Re: query on inner join

Former Member — Wed, 13 Aug 2008 13:28:50 GMT

Amazing!

Rob

Re: query on inner join

Former Member — Wed, 03 Dec 2008 06:55:28 GMT

I tried using the Same, not working.

ROB: any suggestion.

Code:

select *

INTO TABLE BSEGitab

FROM bkpf AS a

INNER JOIN bseg AS b

ON a_{belnr= b}belnr

WHERE a~LIFNR IN Vendor

and b~BUDAT LE Ikeydate.

Re: query on inner join

Former Member — Wed, 03 Dec 2008 14:05:49 GMT

Just search the forum on joining BSEG with another table. (But only pay attention to the answers that say you cannot do it.)

Rob

Re: query on inner join

JozsefSzikszai — Wed, 03 Dec 2008 14:13:10 GMT

just to avoid any misunderstanding: BSEG is cluster table, so it is not possible to JOIN it with other tables. Even if it is rewarded with points, still does not work. To everyone who advised this: Have you ever tried it?

Re: query on inner join

Former Member — Wed, 03 Dec 2008 14:32:22 GMT


> just to avoid any misunderstanding...

You'd think that would clear it up, but...

Rob

Re: query on inner join

matt — Wed, 03 Dec 2008 14:50:45 GMT

Incorrect answers removed.