How to get the currency field from KONV

[Former Member]

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

[naveenvishal]

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.

[Former Member]

thank u naveen.

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

Regards,

Muralidhar

[naveenvishal]

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.

[former_member467220]

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

[Former Member]

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

[abdulhameed_hussain]

Hi

     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.

[former_member201275]

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:

[Lakshmipathi]

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

[Former Member]

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

[Lakshmipathi]

 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

[Former Member]

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

[Lakshmipathi]

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

G. Lakshmipathi

[suresh_mamilla]

Hi Murali,

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Nadim,

i am using Deliver order Number not sales order.

Regards,

Muralidhar

[Former Member]

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