(Full load required to generate qvd initially)
[VBAP - Order Items]:
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
WHERE VBELN IN (
SELECT VBELN FROM VBAK // Order Header
WHERE ERDAT > '$(vLastReload)'
OR AEDAT > '$(vLastReload)'
CONCATENATE ([VBAP - Order Items])
FROM VBAP.qvd (qvd)
WHERE not exists ([%VBELN/POSNR]);
have you ever tried using DeltaQ?
It offers a built-in delta-mechanism for incremenatal loads from ECC and R/3.....
yes, in an average SAP system and good infrastructure it should take less than 18-20 hours to extract 500000000 rows.
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....
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 ?.
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.....