Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
neha_shirsath
Specialist
Specialist

Incremental on SAP KONV Table

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

19 Replies
bohravanraj
Partner - Creator II
Partner - Creator II

Hi Neha,

vtodate is today() -1

add following code before above script

let vToDate = date(today() - 1,'YYYYMMDD');

neha_shirsath
Specialist
Specialist
Author

Hi Vanraj,

Great..!!

It's working.

Thank You.

-Neha

neha_shirsath
Specialist
Specialist
Author

Hi Vanraj,

Have you done BSEG Incremental also??

bohravanraj
Partner - Creator II
Partner - Creator II

Hi Neha,

Similar to KONV,

BKPF is header table of BSEG hence you will have to refer BKPF for BSEG increemental.

Regards.

neha_shirsath
Specialist
Specialist
Author

Ok Thank you.

Anonymous
Not applicable

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.

Anonymous
Not applicable

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.

bohravanraj
Partner - Creator II
Partner - Creator II

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

  • VBEP
  • LIKP,
  • LIPS.

it will be a great help if you can help me with this increemental.

Any help is highly appreciated.

Thanks in Advance.

Anonymous
Not applicable

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.

penkerton
Contributor
Contributor

Hi Ron,

I didn't find your post about BSEG. Could you share the link, please?

Thank you.