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
Showing results for 
Search instead for 
Did you mean: 

Maintenance view for 2 Tables with MANDT key only

Former Member
0 Kudos

Hi colleagues, experts,

I am trying to create a customizing activity out of two tables. I have created one of the tables, the other one is in a lower SWC. That table contains some interesting fields, what I would welcome on the same customizing activity.

So I tried to create a maintenance view out of these 2 tables, but it doesn't work, since both have MANDT key only, therefore there is no foreign key that I could use to create a Relationship. Unfortunatelly this seems to be the only way to join the two tables.

If I create a Database view first, it cannot be maintained afterwards. DBview doesn't allow write operation with two or more tables joined.

I do not want to duplicate those fields from the other table in my table as I want exactly those fields to be changed, so that we can influence the logic in the lower SWC.

The only option seems feasible is to separate this activity into two.

Do you know any other option? Is there a way to create a maintenance view out of two such tables?

Thanks in advance and best regards,

Janos

2 REPLIES 2

ThomasZloch
Active Contributor
0 Kudos

What's SWC again? Only MANDT as key field sounds strange, you would be able to store only one entry per client. Please list the primary key fields of the involved tables here.


Thomas

raymond_giuseppi
Active Contributor
0 Kudos

As I suppose you are not re-creating the T000 table, are you meaning that client MANDT is the only common primary key between the two tables ?

If yes you could create a view cluster with two independent root dialogs.

I didn't understand what you are calling SWC ?

Regards,

Raymond