Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

subodh_kawar
New Contributor II

How to apply incremental load on BSEG??

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

1 Solution

Accepted Solutions
mukesh24
Contributor III

Re: How to apply incremental load on BSEG??

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

9 Replies
eruditio
Contributor III

Re: How to apply incremental load on BSEG??

Hi Kawar,

Can you post what you did?

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

Antoine

subodh_kawar
New Contributor II

Re: How to apply incremental load on BSEG??

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

mukesh24
Contributor III

Re: How to apply incremental load on BSEG??

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

subodh_kawar
New Contributor II

Re: How to apply incremental load on BSEG??

Thanks Mukesh!!

will check and let you know...

Re: How to apply incremental load on BSEG??

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

subodh_kawar
New Contributor II

Re: How to apply incremental load on BSEG??

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.

mukesh24
Contributor III

Re: How to apply incremental load on BSEG??

Hi,

BUKRS

GJAHR

BELNR

BUZEI

Regards,

Mukesh

subodh_kawar
New Contributor II

Re: How to apply incremental load on BSEG??

Once again thanks Mukesh!!

mukesh24
Contributor III

Re: How to apply incremental load on BSEG??

Hi Subodh,

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

Regards,

Mukesh