Sales Document Number

[Former Member]

Hi All,

Is there any function module that returns the sales document number for the relative billing document generated?

Thanks in advance.

Regards,

Arunkumar S

[Former Member]

1)billing vbrp-vgbel

2)it gives delivery number(vbrp-vgbel).

3)now go to lips and put this number into lips-vbeln.

4)u get vgbel in lips it is order number.

Message was edited by: kishan negi

[Former Member]

I am not aware of any function but you get it from the document flow table VBFA.

Regards,

Ravi

Note :Please mark the helpful answers

[Former Member]

Hi Ravikumar,

Do u have any other option to get the sales document other than document flow table.

Thanks for the earlier reply.

Regards,

Arunkumar S

[Former Member]

As I said, I don't think there is any function that gives you but VBFA should give you the details.

Regards,

Ravi

Note :Please mark the helpful answers

[former_member188685]

Hi Arun,

did you check that...

In se37 you can directly run the FM <b>RV_ORDER_FLOW_INFORMATION</b>

Just don't do any thing enter only COMWA with your Billing Invoice (VBELN)

<b> COMWA 107220249 0000000000 </b>

and Run it. and check the Table parameter <b>VBFA_TAB</b>.

Regards

vijay

[Former Member]

Hi Vijay,

Yes I checked the function module. Thanks for your timely help.

Keep in touch.

/Arunkumar S

[Former Member]

You can go to the table VBFA to get the sales order no for the given billing doc no..

First get the Delivery by passing the bill doc no to VBELN, VBTYP_N = 'M' and VBTYP_V = 'J' to VBFA.

With the resultant VBELV, go to VBFA, pass the VBELV to the field VBELV, VBTYP_N = 'J' and VBTYP_V = 'C'

[former_member188685]

Hi,

Check this FM <b>RV_ORDER_FLOW_INFORMATION</b>

this will help you in getting the SD flow.

Regards

vijay

[Clemenss]

Hi,

all answers have been given. There may be more than one sales document for one billing. Definitely may be zero or q sales document for one billing item.

Regards,

Clemens