SAP Incremental Load

[sagarkharpude]

Hi All,

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

Thanks

Sagar Kharpude

[avinashelite]

Did you checked this thread

SAP Tables: VBAK / VBAP / VBPA | Qlik Community

How to extract delta load from SAP R/3 ?.

[amit_saini]

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]

Hi Aninash,

I checked this but not working as we expect

Thanks