SAP ISU: Table that displays last billing information for CAs

[former_member903822]

Hi, I'm new to SAP ISU and I've been trying to find a way to find accounts that have the last due date on or before a specific date. Is there any table that I can use which displays the latest billing/invoice information such as invoice date, due date, etc.

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members. For example, you can:- outline what steps you took to find answers (and why they weren't helpful)- share screenshots of what you've seen/done- make sure you've applied the appropriate tags- use a more descriptive subject lineThe more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.htmlShould you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

[srinivasankh]

Hi Aakash,

You can get those details for the CA if they are invoiced in table DFKKOP. You may have to use the right Document Type and for Invoice you should get Invoice Document from ERDK table and then get FI-CA from table ERDB , once you have the FI-CA docs you will get all the details from table DFKKOP.

Thanks,

Srini