In what way could i get the Shipping conditions of the SO?
In what way could i get the Shipping conditions for those SOs which used route 'AABB'.
What i mean is whether there exist a table could let me search and get output list like below??
Sales document type: ZTO
<b>Output List :</b>
SO# | Shipping condition | Route |Trans.Zone(optional) |
Shipping Condition comes from the customer master onto the sales document header. This means, the data would be referred at the sales order header level. Whereas, the route, shipping point is determined at the item level. Transportation Zone is determined at the Ship to partner level (WE). So, in order to generate a report list that should fetch all orders lines with a particular route to give you SO#, Shipping condition, Route and Zone, you would have to use three different tables. VBAK, VBPA and VBAP.
The best way would be to use SAP Query (SQ01). Define an infoset first at SQ02 with these three tables VBAK, VBAP and VBPA and join them. Then go to SQ01 and select from the field list, Document type and Route as your selection criterion fields. Then select the output list per your requirement. Please have your ABAPer set this query up for you and it will work for sure.