topic Re: How to apply incremental load on BSEG?? in QlikView

How to apply incremental load on BSEG??

subodh_kawar — Mon, 26 Jan 2026 18:19:17 GMT

I tried BSEG via BKPF but unable to load the script as given in SAP connector manual.

Does any one know how to do this by some other method??

Thanks in advance

Re: How to apply incremental load on BSEG??

Anonymous — Wed, 11 Mar 2015 09:33:02 GMT

Hi Kawar,

Can you post what you did?

Usually you go via a document number range to minimize your output.

Antoine

Re: How to apply incremental load on BSEG??

subodh_kawar — Wed, 11 Mar 2015 09:38:58 GMT

hi Antoine,

Thanks for your immediate response to the query.

Following is the script for your reference:

SQl SELECT *

from BSEG where (BUKRS = 'XXXX' or BUKRS = 'XXXX') and GJAHR >= 'XXXX'

IN (Select BUKRS BELNR GJAHR From BKPF where (BUKRS = 'XXXX' or BUKRS = 'XXXX') and GJAHR >= 'XXXX' and CPUDT IN ( '$(today)', '$(today_1)' , '$(today_2)' , '$(today_3)' , '$(today_4)'

Thanks!!

Re: How to apply incremental load on BSEG??

mukesh24 — Wed, 11 Mar 2015 09:58:43 GMT

Hi,

let vDate = date(Today()-1,'YYYYMMDD');

SQL SUBSELECT

from BSEG

where BUKRS GJAHR BELNR IN (SELECT BUKRS GJAHR BELNR FROM BKPF where CPUDT = '$(vDate)')

;

Regards,

Mukesh

Re: How to apply incremental load on BSEG??

subodh_kawar — Thu, 12 Mar 2015 07:23:23 GMT

Thanks Mukesh!!

will check and let you know...

Re: How to apply incremental load on BSEG??

Peter_Cammaert — Thu, 12 Mar 2015 07:34:10 GMT

Note that BSEG, being a cluster table, is often too big to do any classical incremental load tricks on.

An alternative approach is to individually load all years before the current in separate QVD's once, and only reload the last year (in full) repetitively.

Best,

Peter

Re: How to apply incremental load on BSEG??

subodh_kawar — Thu, 12 Mar 2015 08:24:55 GMT

Hi peter thanks for your inputs.

I do agree with you completely even i was using the same approach till now but i realized that the data size for month is also too huge.

so now it becomes important for me to restrict extraction based on number of days to consume less time to extract the data.

Also can any1 please suggest what can be the best primary key combination for getting accurate incremental in BSEG.

Re: How to apply incremental load on BSEG??

mukesh24 — Thu, 12 Mar 2015 08:56:10 GMT

Hi,

BUKRS

GJAHR

BELNR

BUZEI

Regards,

Mukesh

Re: How to apply incremental load on BSEG??

subodh_kawar — Thu, 12 Mar 2015 09:06:51 GMT

Once again thanks Mukesh!!

Re: How to apply incremental load on BSEG??

mukesh24 — Thu, 12 Mar 2015 09:09:12 GMT

Hi Subodh,

Please close thread if u got u r answer, by selecting correct answer

Regards,

Mukesh