Skip to Content
avatar image
Former Member

to see sales orders which have been created using a particular material

Hi all,

This question might sound like dumb but I would like to know the best possible way.

I have a material ABC, and I want to see sales order numbers which have been created using the material ABC. What I am so far doing is, in VBAK I search for orders for some duration letu2019s say last 6 months and copy all these sales order numbers in VBAP, enter material number ABC in the material field in VBAP and execute then I will get a list of sales order which consist of material ABC. This will take time if the search duration is longer. Is there any easier way to solve this purpose? Any table?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 07, 2010 at 09:29 AM

    Hello,

    Only for your information to complete previous update:

    T-code: VA05N corresponds to program: SD_SALES_ORDERS_VIEW

    T-code: VA25N corresponds to program: SD_SALES_QUOTATIONS_VIEW

    T-code: VA35N corresponds to program: SD_SALES_SCHED_AGREEMNTS_VIEW

    All these programs are standard SAP with user friendly selection screen.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2010 at 08:59 AM

    Hello,

    Standard programs of SAP that allow to perform query on sales order, quotation or scheduling agreements are:

    SD_SALES_ORDERS_VIEW

    SD_SALES_QUOTATIONS_VIEW

    SD_SALES_SCHED_AGREEMNTS_VIEW

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 07, 2010 at 09:20 AM

    Use Standard Transaction code VA05N.

    As per our requirement, provide

    - Document Date (from to)

    - Material

    Thanks & Regards

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2010 at 09:44 AM

    Thank you both.. though I did know this transaction, didnt strike intime until I see your post 😊 Thanks again.

    Add comment
    10|10000 characters needed characters exceeded