Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Creating a View based on another View

Hi there,

I have the following tables:

table 1 (Object List):

- Key

- ID Object

table 2 (Object Reference):

- ID Object 1

- ID Object 2

Now I need to get the <table1.Key> of the referring Object from <table2> with a selection condition concerning <table1.Key> (Some Keys are only for Projects, others for certain Documents, so I need the related Document Key to a certain Project Key).

My "solution":

Part 1 - I would choose all <ID Objects> from <table1> related to <ID Object 2> from <table2> that meet the selection condition for their <Keys> in <table1> and select by joining the related <ID Object 1> from <table 2>.

Part 2 - After that I choose those <Keys> from <table1> which have the concerning <ID Object 1> from <table2>.

I hope everybody is confused now

With my "solution" I would need to proceed a view (part 2) based on another view (part 2), which the workbench doesn't allow me to do, cause a view cannot get its data from another view but only from a basis database table.

Any ideas?

Many thanks in advance.

Best regards

Tobias

Not what you were looking for? View more on this topic or Ask a question