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! 

[xavisanse]

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