Skip to Content
0
Former Member
Dec 17, 2006 at 10:14 PM

Automatically displaying description in SE11 / SM30, given customer number

1084 Views

Hi,

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

INTO zinvoutput-name1

FROM kna1

WHERE kunnr = zinvoutput-kunnr.

but obviously this was not going to work, since my custom table does not have a customer name field.

Thanks!

Madeline