cancel
Showing results for 
Search instead for 
Did you mean: 

Document Owner Auto update with Current User

dinesh-pn
Active Participant
0 Kudos

Dear Experts,

I need to update the owner field automatically with the current user, especially when we are copying the base document to the target document.

Once the document is added another user should not change the owner code for any document.

Example: User A created a Sales quote with the Owner code A when the user B create the Sales Order from the Sales quote created by User A Document Owner should automatically update with Current User Login User B.

Please tell me a direct solution or workaround, if we can achieve it through SP Transaction notification or FMS please give me a sample.

Thanks

Dinesh

Accepted Solutions (1)

Accepted Solutions (1)

former_member595093
Participant

You can use FSM

Get current employee FSM query:

SELECT firstName FROM OHEM WHERE userId = $[USER]

Answers (1)

Answers (1)

dinesh-pn
Active Participant
0 Kudos

Dear all,

I found my FMS, This is for SAP Business one HANA.

Assign this fms on owner update the value based on any field change :

SELECT cast(T0."lastName" as NVARCHAR)||','||' '|| cast(T0."firstName" as NVARCHAR) FROM OHEM T0


🙂