Journal entry cancelled entry

[former_member229757]

Hi,

How to find the canceled journal entry is there any field in OJDT and JDT1 tables which specifies the journal entry have been canceled.

select sum(debit) as debit,sum(Credit) as credit from JDT1 t0 inner join OJDT t1 on t0.transid=t1.transid

where account='161011' and t1.TransType in(24,30,46)

and t1.refdate between '10-01-2022' and '10-31-2022'

Thanks

Vinoth

[azizelmir]

It is not recommended to use delete statement against SAP database directly .