Canceled Journal Entry

[Former Member]

hi

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

[K_Pauquet · Accepted solution]

Hi rajeswari,

please see this wiki article from the Expert-on-Phone Newsletter February 2009:

[How to cancel a journal entry using today as posting date? |https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=81428745]

All the best,

Kerstin

[Former Member]

In OJDT, field 'stornototr' displays the JE number that this JE canceled by .

Does this work?

[former_member197621]

NOTE:put correct entry and then cancel that entry then give that 2 transid in my example you will get some idea,Test this in test database

[former_member197621]

Hai

Try this example,

SELECT T1.[BaseRef], T1.[StornoDate], T1.[StornoToTr], T0.[TransId] FROM JDT1 T0  INNER JOIN OJDT T1 ON T0.TransId = T1.TransId WHERE T0.[TransId] in('81452','81453')

Edited by: Prasanna s on Mar 30, 2009 8:17 AM

Edited by: Prasanna s on Mar 30, 2009 8:32 AM