Relation between VBAP and VBRK

[Former Member]

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

[GauthamV]

Plz SEARCH in SCN beofre posting.

VBRP-AUBEL = VBAP-VBELN

VBRP-AUPOS = VBAP-POSNR.

[Former Member]

gautham thanku fr u r reply.

I searched in SDN Ididnt get the proper solution .

Here i need to link between VBAP and VBRK

.

[GauthamV]

VBRP-AUBEL = VBAP-VBELN

VBRP-AUPOS = VBAP-POSNR

VBRP-VBELN = VBRK-VBELN.

[I355602]

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

[former_member222860]

Checked!

VBRK_{vbeln = VBAP}vbeln

[Former Member]

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