Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Incremental Load on SAP R/3 Standard Tables

QlikView is in the Market for a long time & also making SAP connector that is certified by SAP Netweaver, But why not QlikView introducing Delta Load Procedure & Fields from various Standard SAP Tables, Bec'z SAP tables are standard in any Industrial verticals .... And without knowing the Delta procedure its very difficult task to fetch 100Million records ... only Delta is the solution ... so can't we expect the Templates for the same .... if the Template is present then only we can guide Client's ABAP team to make some Index on Delta Fields ... believe that will be Faster ...

But in Any case if anybody having the Delta Script, made on Standard SAP R/3 Tables, please kindly reply back ... [Smiley Very Happy]
Facing Hard Time as well as quite a time taking process when we are trying to create Delta process from VBRK & VBRP tables...
Bec'z VBRK having a timestamp field AEDAT, But VBRP doesn't ... similarly Cluster Tables are also difficult .Only possibility to fetch the Relevant from Closed Tables instead-off Cluster Tables, But taking more time than Full Load ... [:@]

In this matter I am surprised, why not QlikTech is introducing concept like PSA (Persistence Staging Area) in SAP, as well as some process which automatically Keep a track on all document changed Items from CDPOS.

5 Replies
suniljain
Honored Contributor

Incremental Load on SAP R/3 Standard Tables

Dear Amitava,

I raised same issue to qliktech lots of time but till now donot get any response from qliktech.

But Qliktech have to take it seriously to retain SAP Customer.

Regards;

Sunil Jain

suniljain
Honored Contributor

Incremental Load on SAP R/3 Standard Tables

Dear Amitava,

pls raise this issue to qliktech by sending mail to support@qliktech.com

suniljain
Honored Contributor

Incremental Load on SAP R/3 Standard Tables

(Full load required to generate qvd initially)

DIRECTORY;

[VBAP - Order Items]:

LOAD

VBELN & '/'& POSNR as [%VBELN/POSNR],

[MEINS] as [Base Unit_MEINS],

[MATKL] as [Material Group_MATKL],

[WERKS] as [Plant_WERKS],

[MATNR] as [Material_MATNR],

[SPART] as [Division_SPART],

[KPEIN] as [Pricing unit_KPEIN],

[KMEIN] as [Unit of measure_KMEIN],

[ERNAM] as [Created by_ERNAM],

[ERDAT] as [Created on_ERDAT],

[AEDAT] as [Changed on_AEDAT],

[POSNV] as [Item_POSNV],

[VSTEL] as [Shipping Point_VSTEL],

[VBELN] as [Sales Document_VBELN],

[POSNR] as [Item_POSNR],

[NETWR] as [Net value_NETWR];

SQL SELECT MEINS MATKL WERKS MATNR SPART KPEIN KMEIN ERNAM ERDAT AEDAT POSNV VSTEL VBELN NETWR POSNR

FROM VBAP

WHERE VBELN IN (

SELECT VBELN FROM VBAK // Order Header

WHERE ERDAT > '$(vLastReload)'

OR AEDAT > '$(vLastReload)'

);

CONCATENATE ([VBAP - Order Items])

LOAD *

FROM VBAP.qvd (qvd)

WHERE not exists ([%VBELN/POSNR]);

Not applicable

Incremental Load on SAP R/3 Standard Tables

Thanks Sunil ... believe it will help

Not applicable

Re: Incremental Load on SAP R/3 Standard Tables

Hi Sunil & Amitava,

I need to delta load few SAP tables(VBPA, VBUK &  VBPO) which are dependent on other SAP tables(LIKP, LIPS, VBAK & VBAP). Did you guys find any other faster way to perform delta load of these..?

Please help..

Thanks,

Pragya

Community Browser