Supplier Invoice clearing query

[xavisanse]

Hi community,

After read some questions and answers posted here and going more deep in the S4C, I have the need to ask for one topic.

We want to expose an API to know if a Supplier Invoice is paid or not. After seen the api.sap.com we haven't seen any of them that give us these information (or we havent seen it). So, anybody knows the CDS to merge to expose the query? 

PS. we have seen this API  https://help.sap.com/viewer/bb9f1469daf04bd894ab2167f8132a1a/2005.500/en-US/13c22c58f5809344e1000000...

But just expose a field SupplierInvoiceStatus with the domain RBSTAT that doesn't have the payment of itself as status.

Thanks in advance! 

[OwenLiu · Accepted solution]

Hi Xavier,

It would seem you could gather the information you are looking for via the CDS view I_JournalEntryItem

The BUSINESSTRANSACTIONTYPE = 'RMRP' and REFERENCEDOCUMENT = 'MM Invoice number'

If an invoice is paid in FI the CLEARINGDATE and CLEARINGACCOUNTINGDOCUMENT will be filled

if they are not filled the document has not been paid as far as I understand.

Best Regards,

Owen

[xavisanse]

Thanks owen, we have found a workaround but i'll check your solution because I'm joining two CDS. Thanks