How to identify where customers has paid or not

[Former Member]

Hi

I have BW query requirement to identify where customers has paid or not their bills (invoices). I am looking which tables are storing this data in ISU. Please provide the table names and tcodes for this requirement.

Any standard sap report available to understand better this requirement.

Thanks

Sree

Edited by: Sree on Oct 6, 2009 5:05 PM

Edited by: Sree on Oct 7, 2009 11:40 AM

[Former Member]

You will have to query DFKKOP where XBLNR = your print doc number(or invoice number as some call it), AUGST = 9(cleared) HVORG = 0100, and TVORG = '0002'. This will tell you if the FICA document created as a result of this print doc has been cleared (meaning paid) or not.

[Former Member]

You can look at FPL9 for that contract account to understand the links.

[william_eastman · Accepted solution]

Sree:

Open items are managed in table DFKKOP. Field AUGST can be checked for the status (9 = cleared, space = open). There are standard extractors for open items though which might be useful for you.

regards,

bill.

[Former Member]

understand the solution with user input partially.