Skip to Content
-1

How to show additional field in table view?

Jul 28, 2017 at 03:03 PM

72

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded

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.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Aug 21, 2017 at 01:45 PM
-1

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

Share
10 |10000 characters needed characters left characters exceeded
Jelena Perfiljeva
Aug 21, 2017 at 07:01 PM
0

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".

Share
10 |10000 characters needed characters left characters exceeded