Skip to Content
0
Former Member
Jan 10, 2012 at 04:16 AM

How to change FIELD_LABEL of the CUSTOM DATA?

33 Views

Hello,

We would like to change FIELD LABEL of Custom Data.

However, the value is already registered into FIELD which wishes to change, and it cannot change into it by Custom Data Maintenance.

Would you teach me how to change FIELD LABEL of Custom Data.

If We change [FIELD_LABEL] of the [CUSTOM_FIELD_DEF] table using SQL (UPDATE), are there any problems, such as mismatching of data?

[example]

Case: change FIELD_LABEL (TABLE_NAME:ITEM and FIELD_NAME:AAA)

UPDATE [SAPMEWIP].[dbo].[CUSTOM_FIELD_DEF]

SET [FIELD_LABEL] = 'BBB'

where

SITE='JPN'

and TABLE_NAME='ITEM'

and FIELD_NAME='AAA'

Regards,

Yousuke Murakami

Edited by: Yousuke Murakami on Jan 10, 2012 5:22 AM