Formula variable with replacement path on system date

356 Views

Hi Experts,

I got a requirement to calculate "Days without payment" in report level.

Days without payment = System Date - Payment Date.

(Payment date field is available in CUBE, but system date field is not available in the CUBE)

As we know, the difference b/w 2 dates is not possible directly.It can be possible by creating 2 formula variables with replacement paths on the dates and by writing aformula on these 2 formula variables.

But the thing is I dont have system date readily available, and I tried by using SAP Exit. But we cant create formula variable replacement path on another variable (SAP EXIT).

Do we have any SAP variable for formula with replacement path readily avaliable to get system date (or) any other suggession.

Please suggest me.

Thanks,

Sai Chand.S