topic Re: Database View in Application Development and Automation Discussions

Database View

Former Member — Tue, 11 Nov 2008 06:29:18 GMT

Dear All,

I want to create Database view, with three tables VBAK, VBRK BSEGC tables but there is no relation between bsegc table to the remaining tables. How to create the database view with these tables.

Thanks for your cooperation,

Krish.....

Re: Database View

Former Member — Tue, 11 Nov 2008 06:54:10 GMT

vbrk-belnr and bsegc-belnr will linked to each orher.

vbak and vbrk will link through their item tables vbrp,vbap tables, search those once.

Re: Database View

Former Member — Tue, 11 Nov 2008 09:19:21 GMT

there is no linking to bsegc and vbak table

Re: Database View

Former Member — Wed, 12 Nov 2008 04:21:00 GMT

Hi krish,

You dont have direct linking between these tables bcoz those are header tables but we have the link between between with item level with VBAP , VBRP with BSEG link field is called WBS element.

Senario :

take WBS element from BSEG-PROJK and put it in VBRP as well VBAP and get those header data from VBAK and VBRK.

if you have any issues plese let me know.

Thank you.

Regards

Ramana