Incremental Load for SAP tables (VBAP, VBRP, LIPS, VBUP)

EdgarMM — Mon, 26 Jan 2026 21:26:37 GMT

Hi there

I'm looking for a script to create an incremental for SAP Tables VBAP, VBRP, LIPS and VBUP; I have read a lot of posts about (insert, update and delete) and I do not see in any of them have an example of how it willl work for SAP details tables. I´m following the next script I found in the Qlikview posts.

Let ThisExecTime = ReloadTime();

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(ThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT EXISTS(PrimaryKey);

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

STORE QV_Table INTO File.QVD;

Let LastExecTime = ThisExecTime;

End If

Best regards,

Edgar.

topic Incremental Load for SAP tables (VBAP, VBRP, LIPS, VBUP) in QlikView

Incremental Load for SAP tables (VBAP, VBRP, LIPS, VBUP)