Skip to Content
author's profile photo Former Member
Former Member

Sales order

Hi,

Is there any Transaction or Table which says that the Sales order is open.

Actually i want the list of materials which have open sales order?

Thanks

Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 03:47 PM

    VBUK TABLE

    FIELD GBSTK.

    space Not Relevant

    A Not yet processed

    B Partially processed

    C Completely processed

    these are the values for that field.

    & VBUP too

    regards

    Srikanth

    Message was edited by: Srikanth Kidambi

    Message was edited by: Srikanth Kidambi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I did create a sales order of type RE(return order).

      Whenever i am saving it, automatically the delivery is being created and i am not able to see it in VA05 (open orders)

      Actually i have to see a list of open return orders in VA05.

      Does anyone know how can i do this?

  • Posted on Aug 02, 2006 at 03:49 PM

    Open sales orders can mean different things to different companies, so you will most likely have to build your own logic. For example, if a sales order has not been invoiced, it is open, then you can check against the document flow tables(VBFA) and/or the billing tables VBRK, VBRP.

    Regards,

    Regards,

    Rich Heilman

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 03:51 PM

    Since you wish to have the status info at material level you can check the VBUP table as it has info pertaining to line item, hence with material data.

    Regards

    Anurag

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 05:44 AM

    Hi

    I think transaction: VA05 will suit your requirement. This can give you the list of all materials, sales documents and the item number in the sales document and other details. If you can not view some of these details use Ctrl+F8 to add new fields to the display.

    Thanks

    Eswar

    Note: Reward for helpful answers.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      You need to maintain the number ranges for the billing document type in SNUM/SNRO transaction, the number range object for which you will have to maintain interval is RV_BELEG, after you maintain the number ranges, the billing document would be created,

      Check with your Functional consultant about the range to be maintained, or if you know yourself, you can create the same,

      Rgds,