topic Re: Re: Data base tables in Application Development and Automation Discussions

Re: Data base tables

Former Member — Thu, 24 Aug 2006 04:23:23 GMT

hi to all,

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

thanks

sun

Former Member — Thu, 24 Aug 2006 04:26:40 GMT

Hi,

VBRP-AUBEL..

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

Former Member — Thu, 24 Aug 2006 04:27:21 GMT

Hello Sundeep,

Check VGBEL field in the billing Ducument table.

Reward if helps.

Vasanth

Former Member — Thu, 24 Aug 2006 04:35:50 GMT

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 — Thu, 24 Aug 2006 04:38:59 GMT

VBRP-VGBEL