Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to Know User ID in SBO_SP_TransactionNotification?

It is too easy for users who should be able to close production orders to forget to report completion first. If these steps are done in the wrong order, you cannot simply re-open the production order to fix it.

I want to update SBO_SP_TransactionNotification to make it disallow non-superusers from closing incomplete production orders. But the logged-in user's ID isn't passed as a parameter.

Is there any way to learn the logged-in user's UserCode or UserID during execution of SBO_SP_TransactionNotification?

Tags:
Former Member
Former Member replied

Hi,

Through UserSign field you can create the validation.

You can use the below query

IF EXISTS (SELECT T1.DocEntry FROM OITM T0 JOIN PDN1 T1 On T0.ItemCode =T1.ItemCode JOIN OPDN T2 ON T1.DocEntry= T2.DocEntry WHERE T0.QryGroup7 ='Y' AND T2.usersign <>1  AND T1.DocEntry = @list_of_cols_val_tab_del)

Regards,

Tausif

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question