Aged Creditor Report - Due & No Due
I have an issue with Aged Creditor report. my user wants the report as below -
In the report he wants two more rows need to be added, the rows are "Due" & "No due" and these two rows need to be based on the Net due date.
Due-->amounts which are overdue i.e. > net due date calculated in SAP
Not due u2013 amounts where open items date < net due date
Do i need to create a selection in the report for these two feilds & have to restrict with the netduedate (both Less than & Greated Than). Please correct if i'm wrong.
Also what i'm unable to understand is-"Where does these Due & No-Due data will be picked from ?? " i have seen that the report is running on the 0FIAP_C03 Cube, and this cube do not have these due & No-due feilds.
Thanks in advance.