topic Re: How to get the currency field from KONV in Application Development and Automation Discussions

How to get the currency field from KONV

Former Member — Sun, 03 Aug 2014 17:00:37 GMT

Hi friends,

in one scenario i want to compare the VBFA-WAERS and KONV-WAERS .

for this i want to pass some values from VBFA to KONV to get WAERS . i don't know which values to be pass. Please help on this.

Regards,

Muralidhar

Re: How to get the currency field from KONV

naveenvishal — Sun, 03 Aug 2014 17:07:49 GMT

If you want to relate VBFA to KONV, it is through field KNUMV (Document Condition number). Now KNUMV, you can easily get from VBRK based on billing doc picked from VBFA table.

Re: How to get the currency field from KONV

Former Member — Sun, 03 Aug 2014 17:33:49 GMT

thank u naveen.

But there is no field KNUMV in VBFA to pass KONV.

Regards,

Muralidhar

Re: How to get the currency field from KONV

former_member467220 — Mon, 04 Aug 2014 03:06:14 GMT

The document number which you are passing to VBFA must be sales order , delivery , invoice etc. Then you can find KNUMV from this dcoument number.

If it is sales order, pass it to VBAK to get VBAK-KNUMV. If delivery then pass it to LIKP to get LIKP-KNUMV. If it is invoice, then pass it to VBRK to get VBRK-KNUMV.

You can use this KNUMV value to read from KONV table.

Also check with your functional person.

Thanks,

Devendra

Re: How to get the currency field from KONV

naveenvishal — Mon, 04 Aug 2014 04:50:44 GMT

Pick Billing doc No (based on Document category) from VBFA and pass it on to VBRK for picking Document Condition number (KNUMV). Based on KNUMV for can fetch the respective data (WAERS in your case) from KONV.

Re: How to get the currency field from KONV

Former Member — Mon, 04 Aug 2014 07:30:47 GMT

You will not get a direct relation between VBFA (Doc Flow)and KONV(Condition Table)..You will have to go through another table based on what you are searching..

With Sales Document

you will have to use table VBAK (Sales Header) and get KNUMV to connect to KONV-KNUMV

With Shipping.Delivery

you will have to use table LIKP (Sales Header) and get KNUMV to connect to KONV-KNUMV

With Billing

you will have to use table VBRK (Sales Header) and get KNUMV to connect to KONV-KNUMV

Hope this helps.

Regards

Re: How to get the currency field from KONV

abdulhameed_hussain — Mon, 04 Aug 2014 13:26:40 GMT

Get the sales order number from preceding document field vbelv from vbfa table then get the condition number from vbak table then compare currency field from vbak with konv table.Hope it will solve your problem.Click answered if solved.

Re: How to get the currency field from KONV

former_member201275 — Mon, 04 Aug 2014 14:01:39 GMT

I installed the Tablescope program available somewhere here on scn, i think, for download. When I run this for these 2 tables i.e. VBFA and KONV I see a number of relationships, some of which are:

Re: How to get the currency field from KONV

Lakshmipathi — Mon, 04 Aug 2014 15:43:42 GMT

If the WAERK (document currency) is same as WAERS, then as already suggested, you can input the field KNUMV in VBAK where you get WAERK and get KNUMV value. Pass this KNUMV to KONV so that you will get the desired result.

On the other hand, if WAERK would be different in some cases, then you can straightaway take the WAERS from program RMCV0100 where all Info Structure data would be stored.

G. Lakshmipathi

Re: How to get the currency field from KONV

Lakshmipathi — Mon, 04 Aug 2014 15:52:04 GMT

Better ask your functional consultant to execute SQVI where they can execute this report via Logical Database without any ABAP development.

G. Lakshmipathi

Re: How to get the currency field from KONV

Former Member — Tue, 05 Aug 2014 07:06:45 GMT

Dear Laxshmipathi,

In KONV there is 4 key felds Doc.Condition (KNUMV) ,item(KPOSN),step number (STUNR), counter(ZAEHK). if we pass all the values to this fields then we can get the exact (KONV-WAERS). so i am passing only one value which is present in VBFA KONV-KPOSN = VBFA-POSNV. so for this i am getting dublicate records. please suggest what values should be pass to STUNR , ZAEHK and where can i get.

Regards,

Muralidhar

Re: How to get the currency field from KONV

suresh_mamilla — Tue, 05 Aug 2014 07:19:08 GMT

Hi Murali,

Make use of the field KNUMV(Condition document number).

Re: How to get the currency field from KONV

Former Member — Tue, 05 Aug 2014 07:52:59 GMT

Hi Suresh,

i have passed knumv value, then also i am getting duplicates , so we have to pass remaining two fields STUNR , ZAEHK, then we can exact.

Regards,

Muralidhar

Re: How to get the currency field from KONV

Former Member — Tue, 05 Aug 2014 07:57:03 GMT

if you will pass only item No into Konv from vbfa so obviously it'll fetch Duplicate Data also, so better is that take Doc. condition No from vbak and pass into konv and pass also vbak-currency and check sy-subrc value.

Regards,

Nadim

Re: How to get the currency field from KONV

Former Member — Tue, 05 Aug 2014 08:45:05 GMT

Hi Nadim,

i am using Deliver order Number not sales order.

Regards,

Muralidhar

Re: How to get the currency field from KONV

Former Member — Tue, 05 Aug 2014 09:08:14 GMT

Hi Muralidhar,

you can not check the currecy with Delivery and KONV Data but you can check Sales order currency as well Billing document Currency. bcz Doc Conditaion not generating while create Delivery .

Reards,

Nadim

Re: How to get the currency field from KONV

Lakshmipathi — Tue, 05 Aug 2014 09:24:27 GMT

 i am getting dublicate records

If you validate from VBFA table, system will populate one header data and one line item data and hence, you are getting duplicate records. In order to avoid this, pass POSNV as "Equal To" blank and check.

G. Lakshmipathi

Re: How to get the currency field from KONV

Former Member — Tue, 05 Aug 2014 09:35:16 GMT

this is the data which is present in konv internal table.

KNUMV	KPOSN	STUNR	ZAEHK	KAPPL	KSCHL	KDATU	KRECH	KAWRT	KBETR	WAERS
$1	10	11	13	V	PR00	20140803	C	10	29.54	AED
$1	10	100	1	V		20140703	C	10	30.45	SAR
$1	10	800	2	V		20140703	C	10	30.45	SAR
$1	10	811	3	V		20140703	C	10	30.45	SAR
$1	10	816	4	V		20140703	C	10	30.45	SAR
$1	10	822	5	V		20140703	C	10	30.45	SAR
$1	10	824	6	V		20140703	C	10	30.45	SAR
$1	10	826	7	V		20140703	C	10	30.45	SAR
$1	10	920	8	V		20140703	C	10	30.45	SAR
$1	10	930	9	V	SKTO	20140703	A	30.45	0
$1	10	940	10	V	VPRS	20140703	C	10	11.96	SAR
$1	10	950	11	V		20140703	C	10	18.49	SAR
$1	10	951	14	V	ZCST	20140803	A	11.96	1000
$1	10	952	15	V	ZADM	20140803	A	11.96	100
$1	10	981	12	V		20140703	C	10	13.16	SAR
$1	10	982	16	V	ZMKU	20140803	A	13.16	250

Regards,

Muralidhar