topic Marge SAP tables in QlikView

Marge SAP tables

Wed, 06 Oct 2010 09:30:19 GMT

Hello,

I download VBRK table from our SAP system and keeps it in QVD file

Every day I download VBRK delta from our SAP system and saves them in another QVD file.

I want to save the second QVD file into the first one and to make VBELN field ad a key.

I will be happy to help - How do I write the script.

Thank you

Elad

Marge SAP tables

suniljain — Wed, 06 Oct 2010 11:49:16 GMT

I implemented Following scenarion for increamenta load of SAP Table Scenario:

load

From Todays_VBRP

concatinate

load *

From Historical_VBRN

where VBELN Not exist.

Marge SAP tables

Thu, 07 Oct 2010 15:18:51 GMT

Hello Sunil,

Thank you for your answer.

i tried to implment this script.

VBRK:

load

* From \\DEV\V BRK_DELTA.QVD (QVD)

;

Concatenate

load

* From \\DEV\VBRK.QVD (QVD) where (VBELN) not exist;

store

* from VBRK into \\DEV\VBRK_ALL.QVD;

And I recived this error message "Garbage after statement
Concatenate"

Thank you again

Elad

Marge SAP tables

etay_netintent — Thu, 07 Oct 2010 16:13:57 GMT

Hello

In order to do incremental loads from/into QVD you do need to use the concatenate keyword.

Qlikview will append 2 tables with the same structure automatically.

In order to avoid overlap between the two files you need to use the NOT EXISTS(Field, Field).

Unlike exists you can not use the same field name in the exist.

If your field is names Key the load should look something like this:

Table:

LOAD X, Y, Key, Key as Key1;

Select X. Y. key

FROM SAP;

LOAD X, Y, Key , 0 as Key1

FROM OLD.qvd (qvd)

WHERE NOT EXISTS (Key, Key1);

DROP FIELD Key1;

STORE * FROM Table into OLD.qvd;

I hope I haven't confused you even more....

Etay Elazar

Marge SAP tables

Miguel_Angel_Baeyens — Thu, 07 Oct 2010 16:19:10 GMT

Hello Elad,

Use the where statement as follows

LOAD* From \\DEV\VBRK.QVD (QVD) where NOT EXISTS(VBELN);

Meaning will be loaded only VBELN values not already retrieved by the previous LOAD.

Hope that helps

Marge SAP tables

suniljain — Thu, 10 Feb 2011 10:35:11 GMT

Dear Elad,

Are you get delta load solution of SAP R/3 ?.

Regards

Sunil