Sales order & Billing document ( VBAK & VBRK )

[Former Member]

Hello All,

What is the link between table VBAK and VBRK? I have requirement where I need to find out the sales document number from the billing document number. I can see the relation in the relationship browser but I couldn't find the columns which link those tables.

Thank you.

[Former Member · Accepted solution]

Hi

The link between sales order and billing is found in VBRP table. The following fields will tell you which sales order is used to create the billing document / item. you can also find the delivery document here.

VBRP-VGBEL Document number of the reference document ( This will be the delivery document if the invoice is referred to delivery document )

VBRP-VGPOS Item number of the reference item ( Item no. of VGBEL )

VBRP-VGTYP Document category of preceding SD document (

VBRP-AUBEL Sales document ( This will be the sales order no. )

VBRP-AUPOS Sales document item ( Item no. of AUBEL )

I hope this helps.

Regards

Yatin Thakkar

[Former Member · Accepted solution]

Hello,

You can see the relation in document flow of sales order/ billing. But i hope that you require this relation for large number of sales orders and it is difficult to see each document flow.

The other oiption is to see table VBFA this is document flow table .

Go to se16 and open table vbfa , Put all your sales orders in prededing document fielD and put sub doc catagory as M (Invoice). You shall get the required invoice numbers.

Hope this helps.

Vivek

[Lakshmipathi]

In VBRK, you can see the following fields.

a) XBLNR - Reference Document Number

b) ZUONR - Assignment Number

In either of the above fields, you can see sale order reference but it depends on your copy control VTFL at header level where you can see these two fields. There if you maintain B, you can see sale order reference in VBRK table.

thanks

G. Lakshmipathi

[Former Member]

This message was moderated.

[amit_tunara]

This message was moderated.

[former_member182378]

This message was moderated.

[Former Member]

This message was moderated.

[former_member182378]

This message was moderated.

[amit_tunara]

This message was moderated.

[Former Member]

This message was moderated.

[former_member1175469]

What are the values and description within the column VGTYP in VBRP, such as C, H, J, K and L?