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

[suniljain]

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

[suniljain]

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

[suniljain]

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

[suniljain]

In SAP Everytime you required to take help of header table

VBRP->VBRK

LIPS->LIKP

VBAP->VBAK

KONV->VBRK(KNUMV)

[#5]

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