topic Re: Loading BSEG and BKPF in QlikView

Loading BSEG and BKPF

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to Extract BSEG table from SAP for a limited time date.

but getting below mention error.

********************************************************************************************************************************************************

/QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 Subqueries are only valid for transparent tables: "BSEG".)

BSEG:

Sql select * from BSEG where BELNR in

(select BELNR

from BKPF where BUDAT >= '20160115' and BUDAT <= '20160204')

*********************************************************************************************************************************************************

Plz help me to resolve the issue..

Thanks,

Lalit Kumar

Re: Loading BSEG and BKPF

marcus_sommer — Wed, 16 Mar 2016 14:16:09 GMT

I think it meant that sub-queries aren't allowed - maybe you could find here more: SAP.

- Marcus

Re: Loading BSEG and BKPF

Anonymous — Tue, 22 Mar 2016 01:15:51 GMT

Try using SUBSELECT

Here's a link to a similar discussion:

https://community.qlik.com/thread/138014

Yaniv

Re: Loading BSEG and BKPF

jagan — Tue, 22 Mar 2016 03:29:03 GMT

You can try like below using INNER JOIN

BSEG:

Sql select * from BSEG

INNER JOIN BKPF

ON BSEG.BELNR = BKPF.BELNR

where BKPF.BUDAT >= '20160115' and BKPF.BUDAT <= '20160204';

Regards,

jagan.