topic Re: selection for sales docs from billing doc header in Application Development and Automation Discussions

selection for sales docs from billing doc header

Former Member — Wed, 05 Nov 2008 14:42:15 GMT

Hello All,

I have billing document header data i.e. vbrk

now i have to select all the sale order documents(vbap) . the billing docs are must be posted against deliveray docs(lips).

is there any view that is available ? or i need to query directly ?

if i have to query is for all entries faster or nested query faster?

please suggest

Amarender Reddy B

Re: selection for sales docs from billing doc header

naimesh_patel — Wed, 05 Nov 2008 14:44:48 GMT

You can get the Sales Order number from the VBRP. Fields are:

AUBEL Sales Document

AUPOS Sales Document Item

Or you can use the VBFA table to look for the doucment flow to find out the Sales Order attached to that billing document.

But, I would suggest to use the VBRP table.

Regards,

Naimesh Patel

Re: selection for sales docs from billing doc header

Former Member — Wed, 05 Nov 2008 14:54:22 GMT

Hello Nimesh,

Thanks for fast reply...

i have a doubt here ....'there can be several sales documents per delivery document (OR a delivery docuemnt can be created from several sales docuements)' in this case, vbrp cant contain all the sales orders...

am i right? please correct me

Re: selection for sales docs from billing doc header

Former Member — Mon, 10 Nov 2008 19:08:50 GMT

Write a select statement on VBFA, select vbelv posnv from vbfa where vbeln = vbrp-vbeln and posnn = vbrp-posnr and vbtyp_v = 'C'.