Location and BP relation table

[Former Member]

Dear Experts,

In which table will i get the realtionship between a location and the BP selected for it.

For example if i have a plant 1000, and have assigned it "200" as BP, in which table will i find this relation ship.

I know that in location details under master data i can find it manually. But i need the table in which this realtionship is maintained.

Thanks

Gaurav Gupta

[Former Member · Accepted solution]

Hi Gaurav,

You can get BP GUID(field name PARTNER_GUID) from table /SAPAPO/LOC3 and you can use this BP GUID(field name PARTNER_GUID) value and search in table BUT000.

You can go to SQVI tcode and create joint between table /SAPAPO/LOC3 and BUT000 with field BP GUID(field name PARTNER_GUID)

Regards,

Nikhil

[Former Member · Accepted solution]

Hi Nikhil,

Thanks for the reply.

I have one more question , In which table/tables data related to "transport service provider" maintained in t-lane can be seen.

Thanks and Regards

Gaurav Gupta

[Former Member · Accepted solution]

Hi Gaurav,

Please find the below tables which are releavent to Transportaion lane.

/SAPAPO/TCATTR                 Means-of-Transport Combination/Compartment: Attributes

/SAPAPO/TL                     Obsolete (Transportation Lanes)

/SAPAPO/TLM                    Obsolete (Transport Modes for Transportation Lanes)

/SAPAPO/TLMAT                  Obsolete (Link Material - Transportation Lane)

/SAPAPO/TLMATM                 Obsolete (Link Material - Transportation Lane)

/SAPAPO/TMODCOD                Transportation Mode

/SAPAPO/TMODCODT               Transportation Mode Texts

/SAPAPO/TMODE                  Transportation Mode

/SAPAPO/TMODET                 Description of Transportation Method

/SAPAPO/TPCFC                  Transportation Planning Cost Functions

/SAPAPO/TPDCA                  Capacity Decrease per Means of Transport and Load Dimensio

/SAPAPO/TPKMV                  Transportation Planning: Maximum Visit Time

/SAPAPO/TPKOG                  Transportation Planning: Global Costs

/SAPAPO/TPKOS                  Transportation Planning Costs Priority

/SAPAPO/TPKPM                  Transportation Planning: Penalty Multipliers

/SAPAPO/TPKTF                  Transportation Planning: Costs Transport Type (fixed)

/SAPAPO/TPKTY                  Transportation Planning: Costs Transport Type Dimensions

/SAPAPO/TPKWT                  Transportation Planning: Wait time

/SAPAPO/TPLCO                  Transportation Planning Load Costs

Regards,

Mahesh KHM

[Former Member · Accepted solution]

Hi Gaurav,

Location number is nothing but your transport service provider.

Please use this table /SAPAPO/TRMCARR(Transportation Service Provider at Transportation Lanes).

Regards,

Mahesh KHM