topic Re: Database View Creation in Application Development and Automation Discussions

Database View Creation

Former Member — Tue, 11 Nov 2008 06:02:55 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 Creation

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

The BELNR from BSEGC...and check the fields VGBEL,XBLNR in VBAK table.

Regards,

Vishwa.

Re: Database View Creation

Former Member — Tue, 11 Nov 2008 06:34:02 GMT

hi,

BSEGC- BELNR and

VBAK-XBLNR

Re: Database View Creation

Former Member — Tue, 11 Nov 2008 06:35:52 GMT

VBRK-VBELN EQ BSEGC-BELNR

Re: Database View Creation

Former Member — Tue, 11 Nov 2008 06:37:34 GMT

i think vbrk-belnr = bseg-belnr see it once. whether those two are mach are not.

vbrp-vgbel = lips-vbeln

vbrp-vgpos = lips-posnr.

lips-vgbel = vbap-vbeln.

lips-vgpos = vbap-posnr.

item tables of vbak,vbrk,likp are linked to each other .

regds:

rajesh.k