I have a custom table with customer number (check table KNA1-KUNNR) in it, among other fields. I would like to see customer name (KNA1-NAME1) displayed when I'm viewing / maintaining the table in SE11 and SM30, respectively. (Like how tables like TCSTR in SAP display their contents along with the a description, even though the description is not included in the table.)
I know that I can use view V_TVIMF and add forms to the events, but how exactly can I get the customer name to display, if I don't want it to be a field in my custom table?
I have been trying to do the following in my form:
Get customer name
SELECT SINGLE name1
WHERE kunnr = zinvoutput-kunnr.
but obviously this was not going to work, since my custom table does not have a customer name field.