topic Re: SAP Incremental Load in QlikView

SAP Incremental Load

sagarkharpude — Mon, 11 Jul 2016 05:26:19 GMT

Hi All,

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

Thanks

Sagar Kharpude

avinashelite — Mon, 11 Jul 2016 05:33:05 GMT

Did you checked this thread

amit_saini — Mon, 11 Jul 2016 05:40:49 GMT

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 — Mon, 11 Jul 2016 06:07:13 GMT

Hi Aninash,

I checked this but not working as we expect

Thanks