FINDING DIFFERENCES BETWEEN UDCS (SQL COMMANDS)

When comparing an individual or small number of UDC values between environments it will be easiest to use the Work With User Defined Codes application (P0004A).

However, in order to ensure that your UDCs are in sync between environments, it may be best to use SQL. The following tables make up UDCs:
F0004 – User Defined Code Types
F00041 – User Defined Code Types Language Status
F0004D – User Defined Codes – Alternate Language Descriptions
F0005 – User Defined Code Values
F00051 – User Defined Code Language Status
F0005D – User Defined Code – Alternate Language Descriptions

Below are a few queries that can be used to determine that status of your UDCs. Read more here...