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

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

suniljain — Thu, 16 Dec 2010 13:16:59 GMT

Pls suggest the way if you implemented to extract delta load from SAP R/3 ?.

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

suniljain — Thu, 16 Dec 2010 13:18:02 GMT

it is tough to extract delta load from cluster table like KONV.

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

Sun, 19 Dec 2010 16:50:19 GMT

Hi Sunil,

have you ever tried using DeltaQ?

http://www.theobald-software.com/en/products/xtractqv/deltaq.htm

It offers a built-in delta-mechanism for incremenatal loads from ECC and R/3.....

regards,

Patrick

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

suniljain — Tue, 21 Dec 2010 06:47:43 GMT

Dear Patrick,

Are you tried your software on KONV table for Delta load which have 500000000 records.

regards

Sunil Jain

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

Tue, 21 Dec 2010 08:28:46 GMT

Hi Sunil.

yes, in an average SAP system and good infrastructure it should take less than 18-20 hours to extract 500000000 rows.

But....

1.) The interesting point is the built-in delta option, not only the capability to extract large amount of data....

2.) I'm no QlikView expert but I expect the need for really, really good hardware to handle 500000000 rows.... Have you ever tried it in QV? In SQL server (-> non-in-Memory BI) it works fine, but maybe not in QV. I don't know....

regards,

Patrick

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

suniljain — Tue, 21 Dec 2010 10:06:31 GMT

Dear Patrick,

KONV is cluster table in SAP and that table donot have any time stamp you can extract delta load directly but with help of VBRK,VBAK you can extract delta load based on KNUMV.

To extract delta load in that manner is always time out duting extraction. because SAP server takes lots of time for each KNUMV.

is it possible through DeltaQ to extract delta load from cluster table of SAP ?.

Regards;

Sunil

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

Wed, 22 Dec 2010 08:11:26 GMT

Hi Sunil,

you wouldn't use direct table acces or joins to detect your delta. The DeltaQ use OLTP data sources in R/3 that bring along their own encapsulated delta logic.
For extracting conditions one would use the extractor 2LIS_11_VAKON. Check google to find our more about the extractor.....

Regards,

Patrick

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

suniljain — Wed, 22 Dec 2010 08:29:50 GMT

can you post features of DeltaQ ?.

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

Wed, 22 Dec 2010 13:50:59 GMT

Hi Sunil,

Please check out the White Paper, that is available in the download section:

http://www.theobald-software.com/en/download/xtractqv.htm

Regards,

Patrick

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

suniljain — Fri, 31 Dec 2010 13:22:41 GMT

Still i have doubt regarding delta load extraction from deltaQ for KONV table ?.

Patrick , it is not simple job even though with help of deltaQ.

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

suniljain — Tue, 08 Feb 2011 11:42:19 GMT

still lots of client struggling in Delta extraction from SAP R/3

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

suniljain — Tue, 08 Feb 2011 11:54:20 GMT

(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]);

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

suniljain — Sat, 30 Apr 2011 06:54:31 GMT

In SAP Everytime you required to take help of header table

VBRP->VBRK

LIPS->LIKP

VBAP->VBAK

KONV->VBRK(KNUMV)

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

Fri, 21 Jun 2013 06:00:48 GMT

Hi Sunil,

How can i join the KONV with VBRK VBRP when joinin it it creates multiple records and data increases.

Please help for this.

Thnaks

Ritul