I need to calculate the Ageing in a Bex Query based on the Current date & Clearing date. To calculate Ageing, i am first trying to get the difference between Current date & Clearing Date. By refering a PDF posted here in SDN for Ageing, i created the Current date as Customer exit & the date value is getting populated for this, i checked this through debugging the Customer exit.
Whereas, For the Clearing date, i created a Formula Variable with Replacement path assigning Clearing date as the Reference Characteristics. As per the document for the Replacement Rule, i gave 'Attribute value' as the Replace with. But for this type, in the Dimension(Last tab in Variable creation screen) 'Date' is not coming up, only Quantity, Amount etc. are coming in. So, in the output, i am not getting the difference in Numbers, instead its giving up the Current date.
Any help on this will highly be appreciated.
In the document you had referd to has the data field as attribute thats why in the document reference it was selected as attribute, in your case it will key not attribute as clearing date is itself a char not a attribute of any IO.
select key and check in the last tab you will find date.
Difference of dates will be numeric value only not the dates.
Documents in SDN are only for reference the procedure may warry depending on the business requirement.