Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

AP aging report

Hello all gurus,

I need to write a functional specs for ABAPer to develop AP aging report with vendor number,vandor name,invoice date and by due dates 30,60,90,180. I haven't written any functional specs earlier can any one provide me the functional spec for AP aging with above requirements, million thanks in advance.

Kind regards,

Krishna

Former Member
Former Member replied

Hi,

Basic data on the vendor open invoices subject for your aging can be located in BSIK table such as company code, vendor number, reference, invoice date, amount.

For aging computation such as 0-30, 31-60, 61-90 and over 90 days can be computed as follows:

Compute Due Date. Compute using T052 table where BSIK-ZTERM = T052-ZTERM. Due Date = BSIK-ZFBDT + no of days*. To get No of Days: Condition 1: If T052-ZTAG3 ne 0; then No. Of Days = T052-ZTAG3; Condition 2: If T052-ZTAG3 = 0 and T052-ZTAG2 ne 0; then No. of Days = T052-ZTAG2; Condition 3: If T052-ZTAG3 = 0 and T052-ZTAG2 = 0; then No. of Days = T052-ZTAG1; Condition 4: Else Due Date = BSIK-ZFBDT

Should you have any question, let me know.

Hope this helps you.

Thanks,

Rod

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question