topic Re: link between VBAK and VBRK in Application Development and Automation Discussions

link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:07:50 GMT

How to link VBAK(sales order)and VBRK(billing document)?

what are the fields to link and how to link. because vbak-vbeln is sales order number and vbrk-vbeln is billing document number.

need help...

Thanks

smita

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:09:46 GMT

vbrk-vgbel same as lips-vbeln

and now lips-vgbel is same as vbak-vbeln.

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:13:20 GMT

hopen this helps

Hope this will give u some idea..

select a_{vbeln b}fkdat into table itab from vbak as a inner join

vbrk as b on

a_{vbeln = b}vbeln where

a~audat in s_audat.

if not itab[] is initial.

select fkimg into corresponding fields of table itab_final

from vbrp for all entries in itab

where vbeln = itab-vbeln and

matnr = p_matnr and

charg = p_charg.

endif.

regards

navjot

Pls reward fopr helpful replies!!

Message was edited by:

navjot sharma

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:24:35 GMT

Hello,

Please check VBFA table.

You get relation between sales order number and billing document number there.

Regards,

tarun

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:28:04 GMT

Hi tarun

I know VBFA table link between VBAK and VBRK , But what are fields and how?

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:30:49 GMT

hi,

Following tables are included in link (In chronological order):

VBAK - sales documetn header,

VBAP - Sales document item

LIPS - Sales doc. Delivery items

VBRP - billing item data

VBRK - Billing header

generally sales doc and billing docs are related by delivery docs.

u can join these tables using joins in select statement.

join structure will loolk like.:

select .....

from vbak as a

inner join vbap as b on a_{vbeln = b}vbeln

inner join lips as c on c_{vgbel = b}vbeln and c_{vgpos = b}posnr

inner join vbrp as d on d_{vgbel = c}vbeln and d_{vgpos = c}posnr

inner join VBRK as e on e_{vbeln = d}vbeln

Also, pl refer following file, very helpful, forever.

http://www.sap-img.com/sap-download/sap-tables.zip

Jogdand M B

PS: Reward if helpful...

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:31:35 GMT

vbrp-vgbel = lips-vbeln

Get vgbel from lips

lips-vgbel = vbak-vbeln.

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:33:04 GMT

hi,

vbrk-vbeln eq vbak-vbeln for vbak-vbtyp eq 'M'.

VBTYP is SD document category.

u can use

on VBRK_{VBELN EQ VBAK}VBELN

WHERE VBAK~VBTYP EQ 'M'.

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:39:26 GMT

Hi..

VBFA table is the table for Sales Document Flow..SO In the field "Follow-On-Document" if we type the Billing document number, you will get the preceeding documents..there you can see the Sales Document numbers corresponding to them...

select VBELV

from VBFA

into table itab

where vbeln in s_billindocument

and VBTYP_N = 'M'.

try this..

Message was edited by:

Rammohan Nagam

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 05:47:40 GMT

Hi,

You can link VBRP and VBAP table using VBRP-AUBEL = VBAP-VBELN and VBRP-AUPOS = VBAP-POSNR.Header table you can't link, always links will be in Item tables.

Join VBAK and VBAP and VBRL VBRP using above link:

You can also using VBFA table:

Pass the Preceding Document as VBAK-VBELn and Preceeding Doc type as C(order) and Subceeding Doc as VBRK-VBELN and Subse doc Type as M.

hope you understood .

reward if useful

regards,

Anji

Re: link between VBAK and VBRK

Former Member — Fri, 30 Mar 2007 06:39:42 GMT

these are table relations

vbak n vbrk is vbeln

vbak n vbrp is vbeln

vbak n vbfa is vbeln, vbelv n vbtyp_n

vbak n lips is vbeln

Regards,

alson

Re: link between VBAK and VBRK

former_member199684 — Tue, 18 Dec 2007 16:42:09 GMT

I realize you've probably figured this out by now, but since I found this on a search and others might, here's what I found:

VBAK joins VBAP through VBELN

VBAP joins VBRP through VBAP-VBELN=VBRP-AUBEL and VBAP-POSNR=VBRP-AUPOS

VBRP joins VBRK though VBELN

The data elements for VBELN are different even though the names are the same (se11 helps)

I'm sure some of the other answers worked, I just couldn't follow them.

Re: link between VBAK and VBRK

former_member214709 — Thu, 16 May 2013 11:43:27 GMT

Thanks Lee.

Regards,

Dinesh