cancel
Showing results for 
Search instead for 
Did you mean: 

QUERY TRANSLATION TABLES

Former Member
0 Kudos

hello
someone could help with a query, I need to bring the English translation
of information that I have in the master data table items
that brings the field in which I have the translation.


Thanks in advance for your help

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Try this first:

SELECT T0.FieldAlias,T0.PK,T1.Trans

from omlt T0

JOIN MLT1 T1 ON T1.TranEntry=T0.TranEntry

WHERE T0.TableName='OITM'

Thanks,

Gordon

Former Member
0 Kudos

gracias

me funciono

Answers (1)

Answers (1)

former_member541807
Active Contributor
0 Kudos

hi Sandra,

you may try this

SELECT T0.[ItemCode], T0.[ItemName], T0.[FrgnName] FROM OITM T0

regards,

Fidel

Former Member
0 Kudos

thanks for reply,

but MLT1 table and OMLT, making query to bring the translation
example of user fields that I have in the master data table


grace in advance if you can help me