Uderc programming article aggregator sites

In what way could i get the Shipping conditions of the SO?

Tags:
Answers: Have 6 answers
Advertisement
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??
<b>Selection Screen:</b>
Sales document type: ZTO
Routes: AABB
<b>Output List :</b>
SO#  |  Shipping condition | Route  |Trans.Zone(optional) |
Advertisement
The best answer: 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.
Thanks
Nikhil

Search

Related articles

Shipping condition determination (OVL2) not open and system close

Restrict Shipping conditions on the Sales Orde Header Document

How to: Make Shipping Condition field required in Tx. VT01N

Transport planning and shipping condition

CRM Exchange order - shipping condition not copied from Sales order

Availability of material based on the shipping conditions

Stock Transport Scheduling Agreement - PO - created but Shipping Conditions

Shipping condition in vendor evaluation

Ship.condition 01 loading grp 0003 plant MCP1 StLoc not defined Message no.

Regarding shipping condition field vbak-vsbed in VA03 transaction

Recommended article

I am not able to activate my iPhone 3GS after upgrading it to IOS 5.1.1 since it shows the error message "your iPhone could not be activated because the activation server is temporarily unavailable. I am asked to retry after some time. How can I avoid thi

Using search pages (i.e. Google) how can I get a different color on a link (website) that I have previously visited? It used to work that way, but now every link is the same color.

Hello - I am trying to sync my ipod touch with itunes and I have done many times and now today I am getting error message 13019. I have listened to all the suggestions of how to fix it from apple and now I lost all my music off my ipod. HELP?

Can I connect two non-TB external displays to a new MBP?

Cannot Adjust Brightness

Case SeeThru Satin 15'' Speck for MacBook Pro

Transport Request for logical database

Unequal Distribution of Objects

Can you max out a library?

Using FileInputStream to view File Details.