Warehouse
This table shows the tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tccom130 | Addresses |
| tccom139 | Cities by Country |
| tcemm030 | Enterprise Units |
| tcemm050 | Sites |
| tcemm100 | Time Zones |
| tcemm170 | Companies |
| tcmcs003 | Warehouses |
| tcmcs010 | Countries |
| tcmcs143 | States/Provinces |
| whwmd200 | Warehouses |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| City | tccom130.ccit |
| City Desc | tccom139.dsca |
| Company | Logical company of tcmcs003 |
| Country | tccom130.ccty |
| Country Desc | tcmcs010.dsca |
| Enterprise Unit | tcemm030.eunt |
| Enterprise Unit Desc | tcemm030.dsca |
| EU Member State | tcmcs010.meec |
| EU Member State Filter | tcmcs010.meec |
| EU Member State Sort | tcmcs010.meec |
| External Site | tcmcs003.xsit |
| External Site Filter | tcmcs003.xsit |
| External Site Sort | tcmcs003.xsit |
| Financial Company | tcmcs003.comp |
| Financial Company Desc | tcemm170.desc |
| GPS Latitude | tccom130.glat |
| GPS Location | Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Warehouse Desc. |
| GPS Longitude | tccom130.glon |
| Include in Enterprise Planning | tcmcs003.inep |
| Include in Enterprise Planning Filter | tcmcs003.inep |
| Include in Enterprise Planning Sort | tcmcs003.inep |
| Inventory Management | tcmcs003.imgt |
| Inventory Management Filter | tcmcs003.imgt |
| Inventory Management Sort | tcmcs003.imgt |
| ISO Country Code Alpha-2 | tcmcs010.ict2 |
| Logistic Company | tcemm030.lcmp |
| Logistic Company Desc | tcemm170.desc |
| Project WIP Warehouse | tcmcs003.pwip |
| Project WIP Warehouse Filter | tcmcs003.pwip |
| Project WIP Warehouse Sort | tcmcs003.pwip |
| Shop Floor Warehouse Used At | tcmcs003.swhu |
| Shop Floor Warehouse Used At Filter | tcmcs003.swhu |
| Shop Floor Warehouse Used At Sort | tcmcs003.swhu |
| Site | whwmd200.site |
| Site Desc | tcemm050.desc |
| 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 |
| Warehouse | tcmcs003.cwar |
| Warehouse Desc | tcmcs003.dsca |
| Warehouse ID Desc | tcmcs003.cwar + tcmcs003.dsca |
| Warehouse Type | tcmcs003.typw |
| Warehouse Type Filter | tcmcs003.typw |
| Warehouse Type Sort | tcmcs003.typw |
| WMS Controlled | tcmcs003.wmsc |
| WMS Controlled Filter | tcmcs003.wmsc |
| WMS Controlled Sort | tcmcs003.wmsc |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |
Address fields are included for tcmcs003.cadr.