Route Description is stored in which table??

[Former Member]

Hi, i want to collect full route infomations within a SO by using a Query.

Currently i know that there should join some tables to get some info.

For example:

My output list will be showed like below:

-

---

SO# VBAK

Created on VBAK

SOrg./DChl/Dv VBAK

Sold-to pt VBAK

Material VBAP

Plnt VBAP

ShPt VBAP

Route VBAP

Departure Country ???

Departure zone ???

Shp.Cond. VBAK

Trans. Group MARA

DestinationCtry ???

Transport.zone VBPA

Route Description ???

-

---

I dont know which table could be used to get the value of those ??? fields??

And also want to know the Trans.Group found in table VBPA is right or not?

Thanks!!!

Message was edited by:

Hoo Laa

Message was edited by:

Hoo Laa

[Former Member · Accepted solution]

Incase of Route determination without weight.

Table-Field: VBAP-ROUTE --> You get Route in Sales Order

Table & Field Link: TROLZ01-ROUTE = VBAP-ROUTE --> Table Joints

Table-Field: TROLZ01-ALAND --> You can capture Departure Country from here.

Table-Field: TROLZ01-AZONE You can capture Departure Zone from here

Incase of Route determination with weight

Table-Field: VBAP-ROUTE --> You get Route in Sales Order

Table & Field Link: TROLZ02-ROUTE = VBAP-ROUTE --> Table Joints

Table-Field: TROLZ02-ALAND --> You can capture Departure Country from here.

Table-Field: TROLZ02-AZONE You can capture Departure Zone from here

Regards,

Rajesh Banka

Reward suitable points.

• How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

[Former Member]

hi,

pl check

TROLA : Routes: Allowed Actual Routes for Delivery

TROAZ : Routes: Determination in Sales Documents

TROIZ : Route Determination: By Country and Zone

regards

Sadhu Kishore

[Former Member]

TVRO could got Route Description.

[Former Member]

<b>Incase of Route determination without weight.</b>

Table-Field: VBAP-ROUTE --> You get Route in Sales Order

Table & Field Link: TROLZ01-ROUTE = VBAP-ROUTE --> Table Joints

Table-Field: TROLZ01-ROUTXT --> You can capture Route Description from here.

<b>Incase of Route determination with weight</b>

Table-Field: VBAP-ROUTE --> You get Route in Sales Order

Table & Field Link: TROLZ02-ROUTE = VBAP-ROUTE --> Table Joints

Table-Field: TROLZ02-ROUTXT --> You can capture Route Description from here.

Hope this answers your query.

Regards,

Rajesh Banka

Reward suitable points.

• How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

[Former Member]

The route determination information is stored in the TROLZ table. This would virtually all the info that you are looking for.

Regards.