Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
subodh_kawar
Partner - Contributor II
Partner - 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
Partner - Creator III
Partner - Creator III

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

View solution in original post

9 Replies
Anonymous
Not applicable

Hi Kawar,

Can you post what you did?

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

Antoine

subodh_kawar
Partner - Contributor II
Partner - Contributor II
Author

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
Partner - Creator III
Partner - Creator III

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
Partner - Contributor II
Partner - Contributor II
Author

Thanks Mukesh!!

will check and let you know...

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Partner - Contributor II
Partner - Contributor II
Author

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
Partner - Creator III
Partner - Creator III

Hi,

BUKRS

GJAHR

BELNR

BUZEI

Regards,

Mukesh

subodh_kawar
Partner - Contributor II
Partner - Contributor II
Author

Once again thanks Mukesh!!

mukesh24
Partner - Creator III
Partner - Creator III

Hi Subodh,

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

Regards,

Mukesh