Auto tag Login User Id to Marketing Document

[Former Member]

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

[former_member541807 · Accepted solution]

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

[Former Member · Accepted solution]

Hey Fidel,

Is it the "Owner" field in any SBO Marketing Document? Actually I can't get the UserSignature.

Thank you.

Regards,

Wai Leng

[Former Member · Accepted solution]

You need run query to find it out.

[Former Member · Accepted solution]

Hey Gordon,

Thank you. I got it!

Regards,

Wai Leng

[former_member541807 · Accepted solution]

Hi,

you need to implement Data Ownership so that the Owner field in your marketing document will be filled up.

regards,

Fidel

[Former Member · Accepted solution]

Hey Fidel,

If i would like to auto tag the login user ID to the owner field, is it possible to do so?

Thank you.

Regards,

Wai Leng

[former_member541807 · Accepted solution]

hi Wai Leng Tan ,

yes it is possible through Data Ownership.

fidel

[Former Member · Accepted solution]

Hi Wai Leng,

Few points here:

1. Data owner came from employee master data, while user came from user master data. You could tag particular employee to particular user. Go to Human Resources - Employee Master Data and you could choose User Code for pertaining employee.

2. Data owner in document could be different from user who create original document.

Example:

User code - User name

manager - Jayson Butler

user01 - Wai Leng Tan

Employee - User code

Wai Leng Tan - user01

Jayson Butler - manager

Hendry Wijaya - NONE

If you login using "manager", you could attach Wai Leng Tan instead of Jayson Butler as owner of the document. SAP won't restrict this. As a matter of fact, you could create employee with no user code (Hendry Wijaya as example) and attach this employee to the document. In other word, no exclusive relation between employee master data(data owner) with user master data. If you want automatically tag, let say if you login using "manager", data owner should be Jayson Butler, you need formatted search.

Best Regards,

Hendry Wijaya

[Former Member · Accepted solution]

Hey Hendry,

A clear and simple explanation. I have the concept about the setting now.

I am working witht the data ownership authorization. Thank you very much.

Regards,

Wai Leng

[Former Member]

Hi Wai Leng,

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

Thanks,

Gordon

[Former Member]

Hey Gordon,

Thanks for your answer again! You help me a lot in SBO.

By the way, do you mind to tell me where to find the UserSign? I can't get it.

Thank you.

Regards,

Wai Leng