Data base tables

[Former Member]

hi to all,

how can we know the sales order number for a particular billing document number.

thanks

sun

[Former Member]

Hi,

VBRP-AUBEL..

OR

select vbelv up to 1 rows

from vbfa

where vbeln = 'billing doc. number'

and vbtyp_v = 'C'.

endselect.

Please award the points if it works..

Thanks,

Naren

Message was edited by: Narendran Muthukumaran

Message was edited by: Narendran Muthukumaran

[Former Member]

Hello Sundeep,

Check VGBEL field in the billing Ducument table.

Reward if helps.

Vasanth

[Former Member]

billing doc number form vbrp-vbeln.

vbrp-vgbel is delivey number in lips(lips-vbeln = vbrp-vgbel)

now lips-vgbel is order number in vbap-vbeln (vbap-vbeln = lips-vgbel)

[Former Member]

VBRP-VGBEL