query on inner join

[Former Member]

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

[Former Member]

<<Incorrect answer removed>>

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

[JozsefSzikszai]

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?

[Former Member]

>

> just to avoid any misunderstanding...

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

Rob

[matt]

Incorrect answers removed.

[Former Member]

<<Incorrect answer removed>>

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

[Former Member]

<<Incorrect answer removed>>

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

[Former Member]

Amazing!

Rob

[Former Member]

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.

[Former Member]

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

Rob