topic Re: Relation between VBAP and VBRK in Application Development and Automation Discussions

Relation between VBAP and VBRK

Former Member — Mon, 11 May 2009 07:15:22 GMT

Hi All,

I need to find out the relation ship between VBAP and VBRK,

Using VBRK-VBELN how i wll find out vbps-vstel.

Plese suggest me how to do this????

Re: Relation between VBAP and VBRK

GauthamV — Mon, 11 May 2009 07:17:27 GMT

Plz SEARCH in SCN beofre posting.

VBRP-AUBEL = VBAP-VBELN

VBRP-AUPOS = VBAP-POSNR.

Re: Relation between VBAP and VBRK

Former Member — Mon, 11 May 2009 07:18:52 GMT

gautham thanku fr u r reply.

I searched in SDN Ididnt get the proper solution .

Here i need to link between VBAP and VBRK

Re: Relation between VBAP and VBRK

GauthamV — Mon, 11 May 2009 07:22:08 GMT

VBRP-AUBEL = VBAP-VBELN

VBRP-AUPOS = VBAP-POSNR

VBRP-VBELN = VBRK-VBELN.

Re: Relation between VBAP and VBRK

I355602 — Mon, 11 May 2009 07:22:26 GMT

Hi,

If an invoice number exists for a sales document, the you can check the sales document number corresponding to the invoice number using VBRP-AUBEL

Hope this helps you.

Regards,

Tarun

Re: Relation between VBAP and VBRK

former_member222860 — Mon, 11 May 2009 07:23:17 GMT

Checked!

VBRK_{vbeln = VBAP}vbeln

Re: Relation between VBAP and VBRK

Former Member — Mon, 11 May 2009 07:25:51 GMT

HI Vinay ,

First you need to establish the relationship between VBRK and VBRP on the field VBELN. In the VBRP table there is one field called VGBEL it contains the referance number from the table VBPA.

Please try this and let me know.

Regards,

Nikhil Joshi