Skip to Content
avatar image
Former Member

Sales order number from Sales invoice

Hello All ,

I have a requirement in which when I am running a certain mass update program in which the sales invoice will be populated with a certain number in the Sales invoice text . However before running it I need to ensure that Sales order corresponding to the Sales invoice is updated with a certain number in the Sales order Text field . The user will give the input SAP invoice number > I need to identify the most efficient/quickest way to find the sales order corresponding to the Sales Invoice and check if a particular field is updated or not I tried used VBFA , but it will point to delivery and time take is also more .

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 15, 2012 at 07:48 AM

    Hi Nagabhushan,

    Since you say you will be given the Invoice no as an input from the user you can use VBFA table to get the cooresponding Sales order no.

    In VBFA table in the Prec.doc.categ. field enter C as the value which is Order and the system will give you the corresponding Sales Order that was created for the respective Sales Invoice.

    Hope thsi will help.

    Thanks and Regards,

    J Nagesh

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16, 2012 at 04:57 AM

    Hi

    In VBFA Table, check that the preceding document is coming as C.Also check in VTFL copy control that the reference document feild is set as sales order.

    Regards

    Srinath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2012 at 08:07 AM

    Hi,

    The sales order number is stored in field AUBEL in table VBRP (billing document item).

    Regards,

    Marcin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2013 at 10:29 PM

    Thank you very much for your response the issue has been resolved .

    Add comment
    10|10000 characters needed characters exceeded