Table name for Transportation lane in SNP

[Former Member]

Hi,

Request to help me to identify Transportation Lane TABLES in SNP.

ie...

- Customer > Hub> Plant-->Vendor(for procurement type "F" items)

- In one Table, is it possible to get the full (above) sequence....or please update me how to get this?

- Like Hub(1002) is Source of Supply to Customer(1010)

Plant(1001) is Source of Supply to Hub(1002)

Vendor(1011) is Source of Supply to Plant(1001)

- How to identify the predessor and successor location?

- Request Table names for an enhancement.

Thanks,

Sai Ganesh

[Former Member]

Excellent

[Former Member]

Hi Sai,

You can try joining the two tables as /sapapo/v_tr and /sapapo/trprod.

The first table will give you source and destination(along with their IDs and names) and the second table will give the product associated with the T Lane.

Let me know if it helps.

Regards

Manotosh

[Former Member]

Hi,

In one table you may not get all the required information.

If create a view of 2-3 tables, you will be able to get infomration in steps, or otherwise, create a ABAP program to check data in the following tables and again relook,.

Please check below:

/SAPAPO/TR Transportation Lanes

/SAPAPO/LOCMAP : Location Id, Location type

In there table /SAPAPO/TR, there are fields "Fromlocation " , "Tolocation" , so finding out source and destination is not a problem.

Regards

Datta

[Former Member]

Hi Datta,

Thanks for the input.

- Here i missed one information...ie for a PRODUCT....i want to check the all TL.

- In table /sapapo/tr---> Location from and To have Internal number rather than Location Code (eg. IN04 - Hub, IN06 - Plant)

Kindly, help

Thanks,

Sai Ganesh

[Former Member]

Hi Sai,

Please check table below:

/SAPAPO/MATLANE

The table /SAPAPO/TR , you will find location id codes and not location names.

You need to create a view on this table and /SAPAPO/LOCMAP for linking location Ids with location names and types.

Some additional related 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

Datta

[Former Member]

Hi Datta,

Thanks for the speedy response.

I am struggling to cretae View between this 2 tables.

My requirement here is....

Selection :

Source Location - Plant

Destination Location - Hub

Product - XXXX

Kindly, help.

Thanks

Sai Ganesh

[Former Member]

Hi Sai,

You will have take help of a technical consultant for creating view on the 4 tables:

Table

/SAPAPO/LOCMAP

Location Id , Locantion Names, Location Types

table /SAPAPO/TR : Lcoation Id, LOCFR, LOCTO, TRLID (Internal GUID for the Transportation Lane), MODEL

Source location

Destination location

Table /SAPAPO/MATLANE

MATID, TRMID, MODEL

Table: /SAPAPO/MATMAP

EXT_MATNR

MATID

Regards

Datta