on 2024 Aug 13 12:05 PM
I would like to find a Freight Order that has multiple underlying Sales Orders. How can I do so? Thanks in advance!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
109 | |
8 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.