topic aging report in Application Development and Automation Discussions

aging report

Former Member — Wed, 19 Mar 2008 15:29:19 GMT

Please give the code snippet for the following case.

aging analysis program for open items:-

payments not receivecd for 15 days,30 ,60 ,90days

imput:

custno range

sales area

days 30,60,90 selection sort by cust no,sales organization

output :report program ALV grid format

my eid: <REMOVED BY MODERATOR>

Many Thanks in Advance.

Edited by: Alvaro Tejada Galindo on Mar 19, 2008 4:23 PM

Former Member — Wed, 19 Mar 2008 15:40:18 GMT

hi ,

check this ..

<REMOVED BY MODERATOR>

venkat.

Edited by: Alvaro Tejada Galindo on Mar 19, 2008 4:23 PM

Former Member — Thu, 20 Mar 2008 04:27:29 GMT

hello Ishwar-

For open G/L items refer to the table BSIS.

Logic:

First fetch all the docs from bsis(open items) based on the selection.

Use FM:HR_HK_DIFF_BT_2_DATES to find the difference between P.date and Sy-datum.

Till here you will get all the openitems based on the given selection.

One important thing to note,the reversal documents will not be present in BSIS.

If this logic not OK or any problems in understanding send me your requirement to my mail id srinivas.oota@eds.com

i will build the report.

cheers,

~Srini...