Skip to Content
0
Former Member
Jul 02, 2007 at 05:57 PM

Route Description is stored in which table??

1999 Views

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