Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I need you help for Incremental load on SAP KONV table, But the problem is KONV table has no last updated date field or other date field.
So, how can I do incremental load on KONV.
your assistance will be highly appreciated
Thanks,
Neha
Hi Neha,
vtodate is today() -1
add following code before above script
let vToDate = date(today() - 1,'YYYYMMDD');
Hi Vanraj,
Great..!!
It's working.
Thank You.
-Neha
Hi Vanraj,
Have you done BSEG Incremental also??
Hi Neha,
Similar to KONV,
BKPF is header table of BSEG hence you will have to refer BKPF for BSEG increemental.
Regards.
Ok Thank you.
I have a working incremental for BSEG that works even for business period-end close postings I will share when I get back to the office on Monday.
I am not understanding why you're referencing the PO header table EKKO for KONV. Wouldn't you be using VBAK or VBRK as the reference? KONV is for sales and KONP is for purchasing/AP, no? Referencing EKKO only sounds appropriate for KONP.
Hi Ron,
we did this increemental after refering to S&D SAP consultant and its working fine.
we got stuck on Increemental of 3 SAP Table which is
it will be a great help if you can help me with this increemental.
Any help is highly appreciated.
Thanks in Advance.
Hi Vanraj,
I don't have any delta logic for those three tables (schedule lines, Delivery header and items). I would imagine that something very similar to VBAK and VBAP can be done for LIKP and LIPS. Should i start a new thread for sharing SAP table delta loads? Has anyone tried that yet? I have a great BSEG delta load and an SAP-based 4-4-5 fiscal accounting calendar to contribute. Maybe if i share them and you share a few deltas that you have, we can get someone to share a solution for those three tables.
Thanks.
Hi Ron,
I didn't find your post about BSEG. Could you share the link, please?
Thank you.