Skip to Content
avatar image
Former Member

Creator of Journal Entry

Good day Experts!

I would like to show the SAP user who created/added a specific Journal Entry document. I tried checking on SQL using SELECT * FROM OJDT and I found a column titled CREATOR but is has NULL values.

Is there any other way to know the creator of a Journal Entry? Or a formatted search to be attached to a UDF in the JE window that fetches the current user who is logged on in SAP?

Would appreciate your help, Experts.

Thank you very, much.

Best Regards,

Nikka Paula Castillo

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 21, 2017 at 07:16 AM

    Hi ,

    For report purpose you can use this

    SELECT T0.[TransId], T1.[U_NAME] FROM OJDT T0 inner join OUSR T1 on T0.[UserSign] = T1.[Internal_K]

    If you want to use FMS then try below one

    SELECT T0.USER_CODE FROM OUSR T0 WHERE INTERNAL_K = $[user]

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded