10-06-2009 2:33 PM
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
10-08-2009 1:13 AM
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.
10-07-2009 4:45 PM
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.
10-07-2009 4:46 PM
10-08-2009 1:13 AM
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.
10-12-2009 3:17 PM