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: 
sagarkharpude
Creator III
Creator III

SAP Incremental Load

Hi All,

Can someone provide me the incremental script for VBAP sap table.

Thanks

Sagar Kharpude

3 Replies
amit_saini
Master III
Master III

Sagar,

Try something below:

Let suppose table name is "BSIS"

----------------------------------------------------------------------

Let vStart = now();

Let vReloadStart = now();

//############## ##############

set vTab = 'BSIS';

$(vTab):

select * from $(vTab)

;

LET vMDTB_LOAD_DURATION = Interval(now() - vStart) ;

LET vStart = now();

//############## ##############

store $(vTab) into $(vTab).qvd;

LET vMDTB_Size = num(filesize('$(vQVD)\BSIS.qvd')/1024,'00.0') & ' KB';

LET vMDTB_Records = QvdNoOfRecords ('$(vQVD)\BSIS.qvd');

//############################

drop table $(vTab);

Thanks,
AS

sagarkharpude
Creator III
Creator III
Author

Hi Aninash,

I checked this but not working as we expect

Thanks