Skip to Content

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 15, 2014 at 01:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded