SAP Connector: Fetching data from BKPF and BSEG using JOIN

[jesper_bagge]

Hi,

I noticed today that the usual JOIN statement doen't seem to work when calling the tables BKPF and BSEG.

The following SQL Statement

SQL Select
 BKPF~BELNR,
 BKPF~BUDAT,
 BKPF~GJAHR,
 BKPF~BUKRS,
 BSEG~SHKZG,
 BSEG~HKONT,
 BSEG~BUZEI,
 BSEG~DMBTR
from BKPF JOIN BSEG ON BKPF~BELNR = BSEG~BELNR AND BKPF~GJAHR = BSEG~GJAHR AND BKPF~BUKRS = BSEG~BUKRS
;

returns an error.

Im using version 5.0.6526.0 of the SAP Connector.

Using the same logic when fetching data from other tables work fine. It seems to only be when i call the tables BKPF and BSEG.

Any thoughts on why I get an error? Bug perhaps?

[suniljain]

BSEG is cluster table. cluster table donot physical identity at database level. It is logically exist.

so it itself fetch data from multiple table in background processing.

[jesper_bagge]

Yes, I know. This has already been said in this thread.

[suniljain]

in  qlikview sap connector 5.6 . this task become easy.

thanx to qliktech

[#5]

Hi Sunil,

It will be really helpful if you elaborate your comment

Regards

Kiran Shinde

[Anonymous]

Hi. Can you attach me the qvw you use to extract?

Thanks!