topic Re: Create Maintenance View without relationships in Application Development and Automation Discussions

Create Maintenance View without relationships

former_member300754 — Thu, 30 Oct 2008 08:55:11 GMT

hi all,

How can I create a maintenance view without the relationships? I want to join 2 tables with both are definitely not related to each other. Can I create the maintenance table?

Thanks in advance,

Peerasit

Re: Create Maintenance View without relationships

Former Member — Thu, 30 Oct 2008 08:57:59 GMT

Hi,

You will have to generate two separate maintenance dialogs if the tables are not linked by a foreign key. You can show both of these together in a view cluster - see transaction SE54.

Darren

Re: Create Maintenance View without relationships

former_member300754 — Thu, 30 Oct 2008 09:02:29 GMT

hi,

if i create a transparent table or structure table Znnnn then create maintenance table which has primary table as Znnnn. Is it make sense?

Regards,

Peerasit

Re: Create Maintenance View without relationships

former_member300754 — Thu, 30 Oct 2008 10:38:44 GMT

I did create a transparent table Z001 which has A as delivery class. Then I map the Maint view with Z001.

: )

Re: Create Maintenance View without relationships

Former Member — Fri, 31 Oct 2008 16:39:59 GMT

Hej Peerasit

I did the same way as you. But make sure the consistency before use it.

Basically, if your table provide CURR field, dont forget to put the Currency (CURKY) together. I think it's a basic, you may know it already. Just remind.

Thanks

Max

Re: Create Maintenance View without relationships

former_member300754 — Fri, 31 Oct 2008 16:42:05 GMT

Create a transparent table first. Then use it as the ref table in Maint view. For consistency, try to find the foreign key with related table. It would help somehow.