TCode to Find Sales Orders - based on Sales Organization & Material inputs

[Former Member]

Hi Experts

I need to pull out all the sales orders raised with different sales organizations on different materials.

Is there any T-Code to pull out the data at one go u2013 instead of giving each material and each organization value one by one?

Example:

I have organizations u2013 2000, 2100 and 2300. Materials I have are, say, A, B, C, D, E and F.

How can I pull out list of sales orders raised for the above 6 materials (A u2013 F) in 3 organizations (2000 u2013 2300) through a single query or T-Code?

Thanks and Regards

Bobby

[GauthamV]

Use VA05 transaction.

Also you can use VBAK,VBAP tables.

[Former Member]

HiGautham

VA05 also accepts only single material# and sales organization as input. I need to feed multiple values as input. Plz guide.

[GauthamV]

Check these transactions.

MC(E,MC(I .

You can also write a simple report joining VBAK,VBAP tables to display the same.

[Former Member]

Sorry Gautham.. not working.

[former_member342013]

hi

check in VA05

[Former Member]

Hi Smitha

I sawe that VA05 also accepts only single material# and sales organization as input. I need to feed multiple values as input. If it allows, could u plz tell me how to input multiple values?

Rgds

[agnihotro_sinha2]

hi,

i m not sure whether i ur question is clear to me or not, but cant a simple SELECT query do it using SELECT-OPTIONs as S_VKORG and S_MATNR????

Select VBELN from

VBAK Inner join VBAP

on vbak_{vbeln eq vbap}vbeln

where

vbak~vkorg in S_VKORG

and vbap~matnr in S_MATNR.

in the select option screen you insert your VKORG and MATNR number.

Ignore my post if its not as per ur requiremnt.

ags.