05-25-2006 1:02 PM
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
05-25-2006 1:20 PM
Hi,
Check this FM <b>RV_ORDER_FLOW_INFORMATION</b>
this will help you in getting the SD flow.
Regards
vijay
05-25-2006 1:07 PM
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
05-25-2006 1:07 PM
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
05-25-2006 1:09 PM
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
05-25-2006 1:12 PM
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
05-25-2006 1:34 PM
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
05-25-2006 1:37 PM
Hi Vijay,
Yes I checked the function module. Thanks for your timely help.
Keep in touch.
/Arunkumar S
05-25-2006 1:11 PM
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'
05-25-2006 1:20 PM
Hi,
Check this FM <b>RV_ORDER_FLOW_INFORMATION</b>
this will help you in getting the SD flow.
Regards
vijay
05-25-2006 2:27 PM
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