Issue When Creating a Database View

Former Member — Sat, 07 Jul 2012 06:12:42 GMT

I am trying two join two tables using a database view through SE11 and this tables are related to SAP HR.

As per the requirement we need to create a table join using SQVI in which we are facing a issue where the transaction is freezed as as we create a

Table join using SQVI.

So..

Is their any alternative method to join two tables in HR ABAP apart from SQVI.

When I try to create a DATBASE VIEW in SE11 it says no relation exists even there is one primary key in both the tables.

Can we do this using SE11 or is there any other way two join these tables or infotypes..for ex how we join p0008 and p0002

I am new to this pls help me.(Sry for posting ths in ABAP DEV)..

Re: Issue When Creating a Database View

Clemenss — Sat, 07 Jul 2012 19:48:32 GMT

Hi,

there is a difference between database tables and structures. Structures do no exist in the database, they are just a grouping of fields in ABAP dictionary. P0002 ans P0008 are structures that do not contain any data by definition.

You can create SQVI quick view or database view using database tables PA0002 and PA0008.

Check if all join conditions can be used in your case, you may change or delete join conditions using right-mouse-click.

Regards

Clemens

topic Re: Issue When Creating a Database View in Application Development and Automation Discussions

Issue When Creating a Database View

Re: Issue When Creating a Database View