Skip to Content
author's profile photo Former Member
Former Member

Auto tag Login User Id to Marketing Document

Hey all,

I would like to tag the Login User ID to every Marketing Document when created. Is it any way to do so?

For example, Login User ID 0001 create a SO, the SO will automatically record the 0001 to the document.

Thank you.

Regards,

Wai Leng

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Sep 30, 2011 at 02:09 AM

    hi,

    SAP provided that already, in every document added to SBO there is a UserSignature that you can query. also you can check the change log from Tools -- Change log.

    try this query

    SELECT T0.[DocNum], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price], T0.[UserSign]
    FROM ORDR T0  INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry

    this will give you who created the SO

    regards,

    Fidel

    Edited by: Avelino Fidel on Sep 30, 2011 4:12 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2011 at 02:14 AM

    Hi Wai Leng,

    You can find this info from UserSign field. There is UserSign2 too which records update user id.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.