Issue When Creating a Database View

[Former Member]

Hi

       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)..

[Clemenss]

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