Creator of Journal Entry

[former_member236650]

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

[former_member312729 · Accepted solution]

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

[former_member236650 · Accepted solution]

Hi Mr. Balaji Selvaraj,

The FMS worked, thank you!

Best Regards,

Nikka