cancel
Showing results for 
Search instead for 
Did you mean: 

how to get local currency and customer currency in sales report?

Former Member
0 Kudos

Hi

We created one report ZDS01 (sales report) in that, the client want local currency and customer  of the particular material while doing  export sales.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Check this T.code whether it could be useful to you or not. S_ALR_87012172 = Customer balance in Local currency

Any how you developed your own report, you can get the local currency details from table's said by Mr.JP. And also from table BKPF - HWAER (Local Currency)

Regards

Ram

jpfriends079
Active Contributor
0 Kudos

Sales Doc like invoice happens on Document Currency.
And doc currency is based currency maintain in customer master.

So, if you want report based on different currency than you can get those from BSEG Table after invoice is post to accounts: 
- BSEG – DBMTR – Amount in Local Currency
- BSEG – DMBE2 – Amount in 2nd Local Currency
-
BSEG – DMBE3 – Amount in 3rd Local Currency.

Alternatively,
Also, following Blog from Jignesh will be help in further understanding:
- Local & Global Currency