Cost of sales and Net Sales on the billing document - document nd local cur

[Former Member]

Hi guys,

I am working on preparing a sales summary report to get Cost of sales, net sales and margin.

They want all the above three value in document currency and local currency. The above values are present in VBRP table in document currency. How do i find out which is my local currency and how do i convert the values in document currency to that local currency?

There is one more currency...credit control area currency in the tables? what is this cur

Thanks,

Maulik

[Former Member]

Hi,

In the Billing document,

you can find out the Exchange rate through

VBRK-KURRF or VBRP-KURSK

Document currency available in

VBRK-WAERK

Local Currency avaialbe in

VBRK-BUKRS, based on BUKRS go to table T001 of selection BUKRS and get the WAERS

Regards

Goutham