Manufacturer
This table shows the tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tccom100 | Business Partners |
| tccom130 | Addresses |
| tccom139 | Cities by Country |
| tcemm100 | Time Zones |
| tcmcs005 | Reasons |
| tcmcs010 | Countries |
| tcmcs060 | Manufacturers |
| tcmcs143 | States/Provinces |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Buy-from Business Partner | tcmcs060.otbp |
| Buy from Business Partner Name | tccom100.nama |
| City | tccom130.ccit |
| City Desc | tccom139.dsca |
| Company | Logical company of tcmcs060 |
| Country | tccom130.ccty (Country for Address field on Manufacturer) |
| Country Desc | tcmcs010.dsca |
| Country of Origin | tcmcs060.ccty (Country field on Manufacturer) |
| Country of Origin Desc | tcmcs010.dsca |
| Effective Date | tcmcs060.indt |
| EU Member State | tcmcs010.meec |
| EU Member State Filter | tcmcs010.meec |
| EU Member State Sort | tcmcs010.meec |
| Expiry Date | tcmcs060.exdt |
| GPS Latitude | tccom130.glat |
| GPS Location |
Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Pay-by BP Name. |
| GPS Longitude | tccom130.glon |
| ISO Country Code Alpha-2 | tcmcs010.ict2 |
| Manufacturer | tcmcs060.cmnf |
| Manufacturer Desc | tcmcs060.dsca |
| Manufacturer ID Desc | tcmcs060.cmnf + tcmcs060.dsca |
| Manufacturer Status | tcmcs060.stat |
| Manufacturer Status Filter | tcmcs060.stat |
| Manufacturer Status Sort | tcmcs060.stat |
| Reason | tcmcs060.cdis |
| Reason Desc | tcmcs005.dsca |
| 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 tcmcs060.cadr.