cancel
Showing results for 
Search instead for 
Did you mean: 

How can I find a freight Order that has multiple Sales Orders attached to it?

Ahmed0007
Discoverer
0 Kudos
121

I would like to find a Freight Order that has multiple underlying Sales Orders. How can I do so? Thanks in advance!

View Entire Topic
PankajDiwan
Explorer
0 Kudos

One fool-proof way would be to to write an SQL query via SQ00, where you can check the TOR_ITEM table, with item category = PRD, and the base business document contains the sales order number. You can then in ALV grid display just do a unique count of the column. 

Other way, not foolproof, would be to use the TORROT label field. usually this field will contain the sales order/delivery number if there is only unique sales order/delivery/trq.