How to get the delivery number from billing document number

[Former Member]

Hi all,

how to get the delivery no. based on biling document no.

[Former Member · Accepted solution]

Hi ,

you can get the delivery number using the the billing doc from the VBFA table..

in table contents of VBFA...::

In field VBTYP_N = 'M'., VBELN = ' your billing doc number'.

VBTYP_V = 'J',

execute.. u will get the Delivery number in VBELV....

Hope this will help.. pls close the thread if done....

Also the VBFA is a general flow table.. U can get all the precceding and subsequent documents for any required document..

Thanks

Rajiv

[Former Member · Accepted solution]

Hi rajiv,

is there any FM to get delivery based on the billing document number?

its workinf fine with VBFA but user said there is perofrmance issue with VBFA?

he said one FM RV_ORDER_FLOW_INFORMATION

how do we use this

we have given the billing document but its not picking delivery number.

please help out this

[Former Member · Accepted solution]

hi Sriman,

you want only the delivery number... you have the billing number and item number... RV_ORDER_FLOW_INFORMATION will retrieve more number of records than wht we required... so my view is using the select statement to the VBFA by passing the ALL the primay key fields..is the better way then using this FM...but if u want different types of document with reference to this Billing then use the FM... wht u have to give is ...

1. BELEGTYP = 'M' -->Invoice

2. in the structure <b>COMWA</b> pass the Billing doc number...

[Former Member · Accepted solution]

Hi Sriman,

For the FM to function, u need to pass a work area of type VBC06 to the parameter COMWA , with the values..

The TABLES parameter should be passed with an internal of table of structure VBFA...

This will populate the table with the details..

Thanks

Rajiv

[Former Member]

<b>Go to vbrp table

VBELN - Billing document

VGBEL - Document number of the reference document

Vgbel contains u r delivery number

(or) in structure vbdkr

vbdkr-vbeln_vl - delivery number

vbdkr_vbeln_vauf - sales order no

vbeln - billing number

</b>

[Former Member]

Go to table VBRP. Field VGBEL

[Former Member]

hi,

u can get the delivery number from vbrk table

all the billing info will be vbrk and vbrp tables

VBRK-VBELN is the delivery document number

VBRP-VGBEL is the delivery docuement number

Message was edited by:

Durgaprasad Kare

Message was edited by:

Durgaprasad Kare