Hello,
I'm have created a calculated field (extension) that looks up the shipping contraint of a business partner. I'm showing this field in the sales order header, but it only shows the ID of the shipping contraint and not the description. Is there anybody who can tell me how to get the field showing the description?

I have used this statement in the calculated field:
select scon
from tccom110 as a
where a._index1 = {tdsls400.ofbp}

I'm adding a snapshot of how the field is currently displayed. I guess that I need to add an extra table to find the correct description, but I am not sure where the descriptions are stored.

PS: I am rather new to LN and this is my first post. Hope that it is clear enough.

You need to define the calculated field in the extension with domain tdscon.

In 4c4 I just ran the session which had the field I was looking for. I could then hit the help button and click in the filed I wanted help on - of course this assumes the you know a session with the description included. And if a display field I would just go pull up the form and see what field it displayed. Of course this assumes you know a session which displays the field. Another thing I could do to try to locate tables is run table maintenance and see if there was a referencing field, then check that table out for what I was looking for. And last but not least was go print were used on domain or tables. So in your case I would run field scon - or you could run the domain for scon to see what other tables it could be related to. Of course I usually limited it across one module or something like that.

That tccom110 does not exist in our 4c4.

Thank you for the support JaapJD and mark_h.

The comment of JaapJD did it for me. In the calculated field, I refered to domain tdscon and that worked perfect.