Skip to Content
0

Creator of Journal Entry

Jul 21, 2017 at 06:24 AM

63

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Balaji Selvaraj Jul 21, 2017 at 07:16 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Mr. Balaji Selvaraj,

The FMS worked, thank you!

Best Regards,

Nikka

0