Carrier LSP

This table shows the tables from which fields are retrieved for the dimension:

Table	Description
tccom100	Business Partners
tccom120	Buy-from Business Partners
tccom130	Addresses
tccom139	Cities by Country
tcemm100	Time Zones
tcibd301	List Groups
tcmcs010	Countries
tcmcs029	Business Partner Types
tcmcs031	Lines of Business
tcmcs045	Areas
tcmcs065	Departments
tcmcs080	Carriers/LSP
tcmcs143	States/Provinces

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Area	tccom120.creg
Area Desc	tcmcs045.dsca
Business Partner Status	tccom120.bpst
Business Partner Status Filter	tccom120.bpst
Business Partner Status Sort	tccom120.bpst
Business Partner Type	tccom120.cbtp
Business Partner Type Desc	tcmcs029.dsca
Buy-from BP	tcmcs080.suno
Buy from BP Name	tccom100.nama
Carrier/LSP	tcmcs080.cfrw
Carrier LSP ID Desc	tcmcs080.cfrw + tcmcs080.dsca
Carrier LSP Desc	tcmcs080.dsca
City	tccom130.ccit
City Desc	tccom139.dsca
Company	Logical company of tccom080
Country	tccom130.ccty
Country Desc	tcmcs010.dsca
End Date	tccom120.endt
EU Member State	tcmcs010.meec
EU Member State Filter	tcmcs010.meec
EU Member State Sort	tcmcs010.meec
GPS Latitude	tccom130.glat
GPS Location	Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Carrier LSP Desc.
GPS Longitude	tccom130.glon
ISO Country Code Alpha-2	tcmcs010.ict2
Line of Business	tccom120.cbrn
Line of Business Desc	tcmcs031.dsca
List Group	tccom120.clgr
List Group Desc	tcibd301.dsca
Purchase Office	tccom120.cofc
Purchase Office Desc	tcmcs065.dsca
Standard Carrier Alpha Code	tcmcs080.scac
Start Date	tccom120.stdt
State/Province	tccom130.cste
State Province Desc	tcmcs143.dsca
Time Zone	tcemm100.timz
Time Zone Code	tccom130.tzid
Time Zone Desc	tcemm100.dsca
Transport Category	tcmcs080.trmd
Transport Category Filter	tcmcs080.trmd
Transport Category Sort	tcmcs080.trmd
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields

Address fields are included for tccom120.cadr.