topic Re: Table with Multiple Views in Application Development and Automation Discussions

Table with Multiple Views

Former Member — Tue, 27 Mar 2007 04:36:55 GMT

Hi All,

Is it possibele for one custom table to have multiple views?

Thanks,

Jim

Re: Table with Multiple Views

Former Member — Tue, 27 Mar 2007 04:43:29 GMT

That muti dimensional view is possible in BW not in SAP R/3 here it is only flat tabular view.

Re: Table with Multiple Views

Former Member — Tue, 27 Mar 2007 07:14:59 GMT

You can create mulitiple views as many as you want each may having different join conditions.But you can see only one at time (From one SE11 transaction)

Example:

if your table is like : Table1 with F1,F2,...,Fn fields.

Create view1 with F1,F2.

Create view2 with F3,F4.

Create view3 with F5,F6. with some condtions if needed.

You can append one view in another view but result value set may decrease as joins will be more.

for appending views refer below links:

Re: Table with Multiple Views

Former Member — Tue, 27 Mar 2007 10:11:59 GMT

Hi.

Thanks for your reply. But the user wants to have 2 maintenance views for just one table. Is that possible? They want 2 separate transaction codes for the 2 views.

Thanks,

Jim

Re: Table with Multiple Views

Former Member — Tue, 27 Mar 2007 11:50:28 GMT

Yes this is possible.

Since you can create two maintenance views you can also create seperate t-codes for them.

Regards

Nishant

Re: Table with Multiple Views

Former Member — Mon, 02 Apr 2007 06:56:54 GMT

Hi Nishant,

I've created 2 maintenance views for a single table. I created 2 transaction codes for each maintenance view. When I execute the transaction code i create, the system is prompting for an error which says " you are not authorize to use transaction XXXX".

Why is that? Please help. I really need two transaction codes for the 2 maintenance views.

Thanks,

Jim

Re: Table with Multiple Views

Former Member — Thu, 05 Apr 2007 11:39:17 GMT

Hi,

I have some questions:

Can you access the transactions u create?

Did u open another transaction for maintenance view?

regds

Nishant