Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to show additional field in table view?

Former Member

‎07-28-2017 4:03 PM

0 Kudos

Hello,

I have a Z-table:

MANDT

LIFNR

TEXT

How can I show one additional field (e-mail address) from table ADR6 for particular LIFNR in SM30?

I mean I need the next structure in sm30:

LIFNR TEXT E-MAIL(only display)

I should not change the structure of Z-table.

Is it possible?

3 REPLIES 3

kiran_k8
Active Contributor

‎08-21-2017 11:56 AM

0 Kudos

Mongo,

check any of the existing views for your ready referrence. for ex VIEW : T002V

SPTXT2 field not available in T002 but in T002TX and view T002V displays SPTXT2 also.

Try adding the Z table,ADRC and ADR6 tables in the VIEW by mapping the corresponding fields.

K.Kiran.

Former Member

‎08-21-2017 2:45 PM

0 Kudos

Hi Mongo,

Create two Z-tables one is without E-MAIL and one is with E-MAIL and LIFNR field will be common in both the tables. Then create maintenance view on these two tables.

I hope this approach will meet your requirement.

Regards,

Ramesh

Jelena
Active Contributor

‎08-21-2017 8:01 PM

0 Kudos

Ramesh correctly suggested to create a maintenance view but I'm not sure why this would require two Z-tables. As long as you can define the JOIN criteria, you can join your Z table and ADR6 in the view and define which field is maintainable or display only. Google -> "maintenance view site:sap.com".