topic Re: Incremental on SAP KONV Table in QlikView

Incremental on SAP KONV Table

neha_shirsath — Tue, 05 Apr 2016 06:02:45 GMT

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

Re: Incremental on SAP KONV Table

Kushal_Chawda — Tue, 05 Apr 2016 06:06:29 GMT

Does it contains primary key?

Re: Incremental on SAP KONV Table

settu_periasamy — Tue, 05 Apr 2016 06:26:08 GMT

Hi,

Check this thread.. You will get an idea

INCREMENTAL SAP | Qlik Community

Re: Incremental on SAP KONV Table

neha_shirsath — Tue, 05 Apr 2016 06:26:20 GMT

It has composite key on 3 fields-

[Doc. condition no._KNUMV], [G/L Account_SAKN1],[Item_KPOSN]

Thanks for your quick reply.

Re: Incremental on SAP KONV Table

neha_shirsath — Tue, 05 Apr 2016 06:30:43 GMT

Yeh I saw that post, as the post not marked as correct i'm not sure if it will work for me or not.

But I'm trying with same.

Thanks.

Re: Incremental on SAP KONV Table

settu_periasamy — Tue, 05 Apr 2016 06:36:35 GMT

I think it will work.

Yes, some of the posts not closed by the requested person.

Re: Incremental on SAP KONV Table

bohravanraj — Tue, 05 Apr 2016 07:01:50 GMT

Hi Neha,

We are Refering EKKO For KONV Table incremental and its working fine.

Please refer below code:

Let vStartTime=num(Now());
/**************** Maxdate Start **************/
Temp_date:
LOAD [Created on_AEDAT] as Date
FROM [$(vTransaction_Qvd)\EKKO.QVD] (qvd);

Max_Table_date:
LOAD Max(Date) as MaxDate;

LOAD FieldValue('Date',IterNo()) as Date
AutoGenerate(1)
While not IsNull(FieldValue('Date',IterNo()));

LET vDateMax = date(num(Peek('MaxDate',0,'Max_Table_date')-2),'YYYYMMDD');

DROP Table Temp_date;
DROP Table Max_Table_date;

/**************** Maximum Date Ends *************/
Let _vstart = 'Where AEDAT >=' & ' ' & Chr(39)& $(vDateMax) & chr(39);
Let _vend = 'AEDAT <=' & ' ' & Chr(39)& $(vToDate) & chr(39);

[KONV]: // Conditions (Transaction Data)
Load
[KBETR] as [Amount_KBETR],
[WAERS] as [Currency_WAERS],
[KSCHL] as [Condition type_KSCHL],
[KNUMV] as [Doc. condition_KNUMV],
[ZAEHK] as [Counter_ZAEHK],
[KPOSN] as [Item_KPOSN],
[STUNR] as [Step number_STUNR],
[KWERT] as [Condition value_KWERT],
[KAWRT] as [Condition.base value_KAWRT],
[KPEIN] as [Pricing unit_KPEIN],
[KKURS] as [Cond.exch.rate_KKURS],
[KMEIN] as [Condition unit_KMEIN] ,
[KNUMV] & [KPOSN] & [STUNR] & [ZAEHK] as %Documentconditionkey;
SQL SUBSELECT KBETR WAERS KSCHL KNUMV KPOSN STUNR ZAEHK KWERT KAWRT KPEIN KKURS KMEIN from KONV
Where KNUMV In (Select KNUMV from EKKO $(_vstart) and $(_vend));

Concatenate

Load *,
[Doc. condition_KNUMV] & [Item_KPOSN] & [Step number_STUNR] & [Counter_ZAEHK] as %Documentconditionkey
From [$(vTransaction_Qvd)\KONV.QVD](qvd)
Where Not Exists(%Documentconditionkey,[Doc. condition_KNUMV] & [Item_KPOSN] & [Step number_STUNR] & [Counter_ZAEHK]);

DROP Field %Documentconditionkey;

STORE * FROM [KONV] INTO $(vTransaction_Qvd)\KONV.QVD;
DROP Table [KONV];

Regards

Re: Incremental on SAP KONV Table

Kushal_Chawda — Tue, 05 Apr 2016 07:18:01 GMT

Also see below query.

Using the vbrk table you can filter the incremental table.

SELECT requiredcolumns...
FROM KONV k
JOIN vbrk v
On v.knumv=k.knumv
WHERE v.erzet > @fetcheddatevalue

Re: Incremental on SAP KONV Table

neha_shirsath — Tue, 05 Apr 2016 07:24:51 GMT

Thank you Vanraj,

I'm trying with your code but i'm getting an error on -

Let _vend = 'AEDAT <=' & ' ' & Chr(39)& $(vToDate) & chr(39);

what you have set for vToDate variable.

Re: Incremental on SAP KONV Table

neha_shirsath — Tue, 05 Apr 2016 07:30:44 GMT

I tried with this but VBAK don't have POSNR field so I don't know if KNUMV will work as a primary key between KNOV and VBAK.

Re: Incremental on SAP KONV Table

bohravanraj — Tue, 05 Apr 2016 08:22:58 GMT

Hi Neha,

vtodate is today() -1

add following code before above script

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

Re: Incremental on SAP KONV Table

neha_shirsath — Tue, 05 Apr 2016 10:10:38 GMT

Hi Vanraj,

Great..!!

It's working.

Thank You.

-Neha

Re: Incremental on SAP KONV Table

neha_shirsath — Tue, 05 Apr 2016 10:23:30 GMT

Hi Vanraj,

Have you done BSEG Incremental also??

Re: Incremental on SAP KONV Table

bohravanraj — Tue, 05 Apr 2016 10:46:20 GMT

Hi Neha,

Similar to KONV,

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

Regards.

Re: Incremental on SAP KONV Table

neha_shirsath — Wed, 06 Apr 2016 03:31:07 GMT

Ok Thank you.

Re: Incremental on SAP KONV Table

Anonymous — Fri, 17 Jun 2016 22:37:39 GMT

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.

Re: Incremental on SAP KONV Table

Anonymous — Fri, 17 Jun 2016 22:40:42 GMT

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.

Re: Incremental on SAP KONV Table

bohravanraj — Tue, 05 Jul 2016 14:19:08 GMT

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.

Re: Incremental on SAP KONV Table

Anonymous — Mon, 18 Jul 2016 14:16:16 GMT

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.

Re: Incremental on SAP KONV Table

penkerton — Tue, 28 Jul 2020 07:23:48 GMT

Hi Ron,

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

Thank you.