How to locate the user id of user which created a Business Partner Master Data set

[former_member239601]

Hi everyone,

First post on here, on a number of occasions I have found either the answer to or a steer towards when facing a issue, hopefully someone can help with this question.

I'm working with SAP B1, v9 PL11 on SQL 2008R2.

I have to create a query which displays; cardcode, cardname, createdate, cardtype, username of creating user, on or after a date variable.

Having looked over the OCRD table I can't see a specific field containing data that would correspond to a user code.

OUSR looks like a good candidate with the user details but I don't think I can see any data types which are directly comparable so not able to make a workable join.. I've tried a number of combinations, such as ocrd.usersign = ousr.usersign and while it returned data it was not correct.

Please can someone help me find the name of the relevant field, or table which would contain this value so I can then complete my query.

Many thanks in advance!

[kothandaraman_nagarajan · Accepted solution]

Hi,

Welcome to SAP B1 forum.

Try this query:

SELECT T0.[CardCode], T0.[CardName],T0.usersign, T1.[U_NAME] FROM OCRD T0 left join  OUSR T1 on t1.userid  = t0.usersign WHERE T0.[CardType]  = 'c'

Thanks & Regards,

Nagarajan

[former_member239601 · Accepted solution]

Hi Nagarajan,

Thanks for the example, left join did the trick and I was able to build up the query as needed.

Thanks again!