Skip to Content
0
May 29, 2018 at 02:48 PM

Vendor Aging bucket Report in BEx query

1027 Views Last edit May 29, 2018 at 02:50 PM 3 rev

Hi,

I'm trying to create a Vendor Aging report using Invoice date.

Followed below blog and need clarification.

https://blogs.sap.com/2013/08/11/step-by-step-how-to-calculate-age-in-bex-query-designer/

As per blog, mentioned 4 variables and used 2. Apparently, blogger used 2 formula variables.

I don't have option to use 0CALDAY in BEx query which is on AP system and 0FISPER gives me only MM/YYYY.

How can I get Current day and use invoice date (0DOC_DATE) as replacement path?.

2018-05-28-18h58-15.png

Any inputs are appreciated.

Thanks,

Jothi

Attachments