Creating a view on VBAK and VBAP

Saurav G May 1, 2012 7:54 PM

Currently Being Moderated

Dear ABAP/BW gurus,

This should be an easy question to answer.

I am trying to create a view on VBAK and VBAP through t-code SE11.

When I enter and highlight both VBAK and VBAP in the Table/Join Conditions tab and click on Relationships, the system says "No Relationships are defined for the tables". I can clearly see at SE11 that the tables are linked through VBELN.

Can you please tell me why the system says that there are no relationships between the two tables?

Thanks in advance

Re: Creating a view on VBAK and VBAP

M Tibollo May 2, 2012 7:44 AM (in response to Saurav G)

Currently Being Moderated

the foreign key for both tables is pointing at vbuk.
Report Abuse

Like (0)
- Re: Creating a view on VBAK and VBAP
  
  Saurav G May 2, 2012 4:29 PM (in response to M Tibollo)
  
  Currently Being Moderated
  
  Thanks for your response. Can you please elaborate?
  
  Report Abuse
  
  Like (0)
  - Re: Creating a view on VBAK and VBAP
    
    Raf Boudewijns May 3, 2012 11:49 AM (in response to Saurav G)
    
    Currently Being Moderated
    
    check one of the standard views on both tables... make sure to "link" MANDT and VBELN
    
    Report Abuse
    
    Like (0)
Re: Creating a view on VBAK and VBAP

Tushar Gawali May 10, 2012 8:28 AM (in response to Saurav G)

Currently Being Moderated

Hi Saurav,

You can manually apply the join conditions as shown below

because the foreign key for both the tables is pointing to VBUK.

You can also have a look at WB2_V_VBAK_VBAP2 view.

Regards,
Tushar
Report Abuse

Like (0)
- Re: Creating a view on VBAK and VBAP
  
  Saurav G May 21, 2012 9:07 PM (in response to Tushar Gawali)
  
  Currently Being Moderated
  
  Thanks for the reply and screenshot. It worked.
  
  Report Abuse
  
  Like (0)

Go to original post