Data Table for Transportation Lanes

[Former Member]

Hello Experts,

Could someone please help me in getting list of standard data tables and Fields which stores below Information:

CARRIER	The name of the carrier associated with the transportation mode.
DEST	Destination location associated with the link defined in this row.
LEADTIMEEFFCNCYCAL	Name of the Lead Time Efficiency calendar associated with the sourcing method.
LOADTIME	Vehicle Loading Time (LoadTime) is the fixed time required to load the vehicle used for this mode between this source and destination.
SOURCE	The source location associated with the link defined in this row.
TRANSCAL	Calendar that specifies when the actual truck movement can occur.
TRANSLEADTIME	The transit time between this source and destination, using this mode.
TRANSMODE	The transportation mode associated with the link defined in this row.
TRANSMODENAME	Transportation Mode Name (TransModeName) is the description of the transportation mode associated with the link defined in this row.
UNLOADTIME	Time required to unload the vehicle used for this mode between the source and destination.

I am looking for standard master tables. For Example: MARA is standard table which stores Material related Information.

Thanks,

Imran Khan

[I310607 · Accepted solution]

Dear Imran,

Please check the following T-lane tables:

/SAPAPO/TRMCARR

/SAPAPO/TR

/SAPAPO/TRM

/SAPAPO/TRMC

Basically you can reach Transportation lane related information in:

/SAPAPO/TR*

tables.

I hope it helps!

Regards

Gergely

[Former Member]

Thanks Gergely and Virender for your response. Above information is quite helpful but I am new to SAP and looking for fields which stores relevant data.

I tried searching on net but didn't found any site which mentions fields that are present in above T-lane tables. Could you please suggest me a way to get fields available in above tables?

Thanks,

Imran

[Former Member]

Imran,

SE11 shows the structure of tables (including fields within the table).

SE16 is a table browser (review data contents of a table)

Best Regards,

DB49

[Former Member]

Thanks Dogboy 49.

On running code SE 11, I got "ABAP Dictionary : Initial Screen". but when I am trying to get details of Transport Lane tables , I am getting "Table does not exist" message.

Please find screen shot below for the same.

It is displaying me all information for standard tables such as MARA.

Could you please let me know where I am doing mistake?

Thanks,

Imran

[I310607]

Hi Imran,

In APO you will always need '' /SAPAPO/'' prefix for tables Function Modules, Reports etc.

eg TRE table is: /SAPAPO/TRE

For transaction use prefix: /N/SAPAPO/

Eg. /N/SAPAPO/SCC_TL1

Hope it helps!

Gergely

[Former Member]

Imran,

Best Regards,

DB49

[Former Member]

Hi Imran

Pls find additional tables

SAPAPO/TRE                    Enhancement for Transportation Lane Headeer

/SAPAPO/TRM                    Means of Transport for Transportation Lane

/SAPAPO/TRMC                   Means of Transport for Transport. Service

/SAPAPO/TRMCARR                Transportation Service Provider at Transp

/SAPAPO/TRPRODM                Means of Transport for Transportation Lane

/SAPAPO/TRPRODV                Version-Dependent, Product-Specific Trans.

/SAPAPO/TRTYPE                 Means of Transport

Regards

Virender