Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Kawar,
Can you post what you did?
Usually you go via a document number range to minimize your output.
Antoine
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!!
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
Thanks Mukesh!!
will check and let you know...
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
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.
Hi,
BUKRS
GJAHR
BELNR
BUZEI
Regards,
Mukesh
Once again thanks Mukesh!!
Hi Subodh,
Please close thread if u got u r answer, by selecting correct answer
Regards,
Mukesh