Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 03, 2007 at 02:40 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2007 at 01:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 02, 2007 at 06:46 PM

    TVRO could got Route Description.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2007 at 01:37 AM

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

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2007 at 02:34 AM

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

    Add comment
    10|10000 characters needed characters exceeded