Skip to Content
1
Oct 31, 2018 at 04:31 PM

SAP Business One Query: Who created this document?

638 Views

Dear experts,

We are using SAP Business One 9.3 HANA PL05

I need a query for FMS. In Purchase Order document, we created a new UDF, in that UDF, it should show the user who created this document. We tried this query, but it only gives the UserID.

SELECT $[OPOR.UserSign.0] FROM DUMMY

As you can see in the Query Preview, we need the User Name field not the User Signature field.

Thank you in advance,
Shak

Attachments