adding some fields to existing report program called customer ageing analysis report

[charan3747]

want to add { credit date,payment date,report date, over due } to my existing report program where should i get these fields from i didn't find in any of the tables please let me know how should i add these field in my report.

[Marian_Zeis]

What tables do you use and what tables did you search for?

[raymond_giuseppi]

• To find the payment that cleared a document, you have to identify the clearing document (saved on item) and then find the bank statement document value date (Look at FM such as GET_CLEARED_ITEMS)
• In pre-Hana version, due date was not saved in database but must be calculated from item information (Look at FM such as DETERMINE_DUE_DATE)

[charan3747]

can you please write in detail thanks for responding raymond.giuseppi

thanks and regards,

sai charan .

[charan3747]

i have used Bsid table and i want to display as mentioned in picture above in the output how do i get credit days and due date ?

thanks and regards

charan