Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Pls suggest the way if you implemented to extract delta load from SAP R/3 ?.
still lots of client struggling in Delta extraction from SAP R/3
(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]);
In SAP Everytime you required to take help of header table
VBRP->VBRK
LIPS->LIKP
VBAP->VBAK
KONV->VBRK(KNUMV)
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