Sales order entry user

[Former Member]

Is there a table in the db where SAP automatically stores the userid that added a sales order? i know there is an "Owner" field on the sales order, but its not required and thus I would be relying on users to remember to select their name on each order.

[JesperB1 · Accepted solution]

HI Robert,

It should be in ORDR.usersign.

If you want to see who has modified a Sales Order after it was added chech in ADOC. Objtype 17 indicates that it is a sales order.

SELECT docnum, usersign FROM adoc T0 WHERE objtype = 17

Jesper

[keith_taylor2]

tools> audit trail will also show you the user that created and updated any of the marketing docs

[jitin_chawla]

Hi,

I dont know the expectation from the query asked by you but whatever I understood may be you can check the following query :

SELECT * FROM ORDR T0 INNER JOIN OUSR T1 ON T0.UserSign = T1.INTERNAL_K WHERE T1.[U_NAME] ='xxxxxx'

'xxxxxx' = user name.

Kind Regards,

Jitin Chawla

SAP Business One Forum Team