Modify UDF field value

[Former Member]

<p><font face="Trebuchet MS">Hi there,</p>

<p>I got just a simply question. I created some UDF

field for the document, like Customer Invoice, Customer Orders...Now the users

entered some value in my UDF, but those are incorrect.</p>

<p>What I would like to do is thru Visual Studio, or

SQL Manager Studio make a query that update that value with the correct one.Can

I do that? I mean can I manipulate the database (just my UDF field) or is not

possible. I'm talking not technically but related with the guarantee of SAP.</p>

<p>Appriciate any comments</p>

<p>Thx Roberto</font> </p>

[former_member186095 · Accepted solution]

Hello,

if the UDF is not authorized and located in the title area, you could update the correct value or amount although the document is closed. You could edit the UDF in the row of a certain document if the document has been closed. you must cancel the document using standard one for example AR invoice with A/R credit memo.

Manipulation of database is prohibited except SAP Support can do that. They know the query and the table to correct it directly to database.

Let me know if you are still confusing.

Rgds,

[Former Member · Accepted solution]

<p><font face="Trebuchet MS">Thank you Jimmy,</p>

<p>I thought was like that. Unfortunately the UDF are

in the row of the document. I knew that manipulating the db was prohibited but

I thought maybe the UDF that dosn't impact over other table...</p>

<p>Anyway..</p>

<p>Thx again</p>

<p>Roberto</font></p>

[Former Member · Accepted solution]

<p><font face="Trebuchet MS">Sorry Jimmy,</p>

<p>if you look at the thread "Password", there is guy that is forcing the db. Is made on his own risk or what?</p>

<p>I mean, is manipulating the db or Im wrong?</font></p>

[former_member186095 · Accepted solution]

Hello Roberto,

I am sure if someone works directly in database by using injection model, without query that surely insert, update or delete in the correct table, it will give errors in the GUI application. I suggest to create user login with the secret password that only user admin can open the database.

Rgds,