cancel
Showing results for 
Search instead for 
Did you mean: 

UDF data insert

Former Member
0 Kudos

Dear ALL experts,

I have two udfs in AR invoice

1) Tax1

2) Tax2

Enduser generaly doing entries in first UDF 1 i.e. Tax1, i want that when user enter values in Tax1, then its automatically Tax1 values gets saved in Tax2 udf.

Please suggest me, how to acheive this.

Regards,

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Please clarify what do you refer as database level only. Do you have a UDT? You mentioned 2 UDF in the system table first.

Thanks,

Gordon

Former Member
0 Kudos

I have kept the field at databas only., not kept as UDF.

former_member206488
Active Contributor
0 Kudos

As I mentoned Earlier, database level fields are not supported by SAP.

Former Member
0 Kudos

Hi,

Try This....

write this query and save it


SELECT $[OINV.U_Tax1]

In Tax2 Field you can attach this query by using FMS

in that select option as Auto Refresh Regularly

Thanks

Shafi

Edited by: shafi_sunshine on Oct 19, 2011 11:13 AM

Former Member
0 Kudos

Sorry actually the second UDF, is not showing in AR invoice, because we have added one extra filed in database level only.

So i want that when i enter any values in UDF 1, then that value should went to that database field.

Former Member
0 Kudos

HI

Make that field visible and active in form settings and then apply the FMS....

former_member206488
Active Contributor
0 Kudos

Hi,

SAP do not support direct modifications to tables on database level. why you created filed on dataabase level. it could cause inconsistancy and database.

Thanks,

Neetu

Former Member
0 Kudos

If the field is not in the same document you can update UDFs with an update query in a fomrated search. But you need to save the document first and then run the query...

Former Member
0 Kudos

As client required such requirements, hence we have to do it.

former_member206488
Active Contributor
0 Kudos

You have to tell client that direct modifications to database tables are not supported .

as work arround you can create field in SAP and add formatted serach to pick values from field 1 and then can set field 2 as invisible and not editable .

Thanks,

Neetu

Former Member
0 Kudos

HI

You can use Automatic Formatted search for your functionality