topic Re: BSEG Table Loading Issue in QlikView

BSEG Table Loading Issue

Fri, 15 May 2015 06:40:57 GMT

Hi ,

I am working on SAP Reports development.

I extracted BSEG table everything and am writing Incremental loading by using Subselect query for daily transactions.

when I reload this am getting below error.

Custom read failed

SQL SUBSELECT BELNR,DMBTR FROM BSEG WHERE BELNR IN ( SELECT BELNR FROM BKPF WHERE BLDAT >= '20150428' )

Please help me to resolve this Issue .

I Need to fetch the BSEG and MSEG it is compulsory

Thanks

Surender

Re: BSEG Table Loading Issue

anbu1984 — Fri, 15 May 2015 06:52:59 GMT

Try after removing Sub

SQL SUBSELECT BELNR,DMBTR FROM BSEG WHERE BELNR IN ( SELECT BELNR FROM BKPF WHERE BLDAT >= '20150428' )

Re: BSEG Table Loading Issue

Fri, 15 May 2015 07:06:21 GMT

Qv showing below Error.

Please help me...

<< BSEG

Error: QVX_UNEXPECTED_END_OF_DATA: Fetch aborted, due to an unexpected exception. Key = JOB_CANCELLED (ID:00 Type:E Number:001 Job aborted, check log for Job /QTQVC/READ_DATA in Job Overview (transaction SM37))

Re: BSEG Table Loading Issue

Fri, 15 May 2015 07:07:28 GMT

It is giving 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".)

Re: BSEG Table Loading Issue

anbu1984 — Fri, 15 May 2015 08:20:53 GMT

Check this link Loading BSEG and BKPF