Jun 07, 2019 at 12:26 PM

Customer Exit or Type Exchange Rate to get last day in a period (Exchange rate)

326 Views Last edit Jun 13, 2019 at 03:05 PM 2 rev

Hello all!

I have a report that has a condition of converting a certain amount to the exchange rate of the last day of the month. It's working correctly. However, when I present 2 or more months in my query, the conversion occurs for the last day of each month presented.

Example: If I select only 1 month (01.2018) it is working ok, because it searches the last day of this period (31.01).

If I select 01.2018 - 02.2018, the system searches the last day of 02.2018, but if I present the months in the columns or in the lines, it calculates to 01.2018 the last day of January and 02.2018, the last day of February.

Example: Variable Input = (01.2018 - 02.2018)

01.2018 = exchange rate of 31.01

02.2018 = exchange rate of 28.02

I understand that it is correct, however I need that regardless of the period informed (if 1 month or N months), the system always presents the last day of the period.

Example: Variable Input = (01.2018 - 02.2018)

01.2018 = exchange rate of 28.02

02.2018 = exchange rate of 28.02

Through RSCUR I tested and did not find any option that does this way. I think through it (Customer Exit) can solve but I do not have deep knowledge in ABAP to test.

Could someone tell me if it's possible?

Thanks in advance

Alex Moreira