Loading BSEG and BKPF

[lalitkgehlot89]

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

[marcus_sommer]

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

- Marcus

[Anonymous]

Try using SUBSELECT

Here's a link to a similar discussion:

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

Yaniv

[jagan]

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.