How will I get the exchange rate from KOMV table in a report ?

[former_member609634]

Hello Team,

I am trying to fetch the data from billing condition details for the exchange rate converison from foreign to local currency.

Can somebody please help me to find out the logic in order to have the field mapping done in report layout in SAP SD ?

Thanks & Regards,

[Lakshmipathi]

First of all, you have not mentioned what are the fields you considered for the report. Assuming that you want to generate sales data from billing documents, are you not aware of Logical Database from SQVI for VFV where you have the field KKURS from KONV

[former_member609634]

Thanks Lakshmipathi. I could resolve the issue.

What I did was, I went to VBAK picked up the sales order number and document condition number. I passed the document condition number in KONV table and could fetch the exchange rate field value for the sales order.

Appreciate your help on this.

Thanks & Regards,

[Lakshmipathi]

If your query is answered, please check this