BSEG Table Loading Issue

[#1]

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

[anbu1984]

Try after removing Sub

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

[#3]

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))

[#4]

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".)

[anbu1984]

Check this link Loading BSEG and BKPF