Table with Multiple Views

[Former Member]

Hi All,

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

Thanks,

Jim

[Former Member]

hi

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

[Former Member]

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:

[Former Member]

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

[Former Member]

Yes this is possible.

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

Regards

Nishant

[Former Member]

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

[Former Member]

Hi,

I have some questions:

Can you access the transactions u create?

Did u open another transaction for maintenance view?

regds

Nishant