cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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,

Answers (3)

Answers (3)

Former Member
0 Kudos

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

jpfriends079
Active Contributor
0 Kudos

Use Standard Transaction code VA05N.

As per our requirement, provide

- Document Date (from to)

- Material

Thanks & Regards

JP

Former Member
0 Kudos

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,