Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Route Description is stored in which table??

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
Former Member replied

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).

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question