Sold-to BP

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

Table Description
tccom100 Business Partners
tccom110 Sold-to 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
tcmcs066 Channels
tcmcs125 Industry Codes
tcmcs127 Sales Territories
tcmcs143 States/Provinces

This table shows the attribute mapping for the dimension:

Attribute Mapping
Area tccom110.creg
Area Desc tcmcs045.dsca
Business Partner Status tccom110.bpst
Business Partner Status Filter tccom110.bpst
Business Partner Status Sort tccom110.bpst
Business Partner Type tccom110.cbtp
Business Partner Type Desc tcmcs029.dsca
Channel tccom110.chan
Channel Desc tcmcs066.dsca
City tccom130.ccit
City Desc tccom139.dsca
Company Logical company of tccom110
Country tccom130.ccty
Country Desc tcmcs010.dsca
End Date tccom110.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 Sold-to BP Name.
GPS Longitude tccom130.glon
Industry Code tccom110.incd
Industry Code Desc tcmcs125.dsca
ISO Country Code Alpha-2 tcmcs010.ict2
Line of Business tccom110.cbrn
Line of Business Desc tcmcs031.dsca
List Group tccom110.clgr
List Group Desc tcibd301.dsca
Rating tccom110.rtng
Rating Filter tccom110.rtng
Rating Sort tccom110.rtng
Sales Office tccom110.cofc
Sales Office Desc tcmcs065.dsca
Sales Territory tccom110.ster
Sales Territory Desc tcmcs127.dsca
Sold-to BP tccom110.otbp
Sold to BP Name tccom100.nama
Start Date tccom110.stdt
State/Province tccom130.cste
State Province Desc tcmcs143.dsca
Time Zone tcemm100.timz
Time Zone Code tccom130.tzid
Time Zone Desc tcemm100.dsca
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 tccom110.cadr.