CDS views for clearing entry

[Expert]

Hi,  We have a requirement to check whether the invoice is cleared or not and if cleared get the clearing amount ( invoice paid ) for a work package.  As per the CDS views I_Journalentryitem or I_Journalentryitemcube" field " clearing entry" is not updated for the invoices raised with document type RV . In customer open item list we can see that the clearing entry is updated .  We want to check or build custom CDS views todetermine whether the invoice is already cleared or not .  Any suggestions on this would be very helpful .  Thanks in advance

[Expert · Accepted solution]

Hi Deepika,

Please look at the CDS VIew 'I_OperationalAcctgDocItem', it has the information whether an invoice has been cleared or not.

I have in the attached document also provided an example how you can query this CDS view to obtain the clearing information.

Kind regards,

Martin

[bhushan_tatar · Accepted solution]

Can not find out attachment..plz suggest

[Expert]

This is a re-posted Q&A of an earlier question on this community