Database View

[Former Member]

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

[Former Member]

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.

[Former Member]

there is no linking to bsegc and vbak table

[Former Member]

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