Skip to Content
avatar image
-1
Former Member

How to show additional field in table view?

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?

Add comment
10|10000 characters needed 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.

  • Get RSS Feed

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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 21, 2017 at 07:01 PM

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

    Add comment
    10|10000 characters needed characters exceeded