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