Ship-from BP
This table shows the tables from which fields are retrieved for the dimension:
Table | Description |
---|---|
tccom100 | Business Partners |
tccom121 | Ship-from Business Partners |
tccom130 | Addresses |
tccom139 | Cities by Country |
tcemm050 | Sites |
tcemm100 | Time Zones |
tcmcs003 | Warehouses |
tcmcs010 | Countries |
tcmcs029 | Business Partner Types |
tcmcs080 | Carriers/LSP |
tcmcs143 | States/Provinces |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Business Partner Status | tccom121.bpst |
Business Partner Status Filter | tccom121.bpst |
Business Partner Status Sort | tccom121.bpst |
Business Partner Type | tccom121.cbtp |
Business Partner Type Desc | tcmcs029.dsca |
Carrier/LSP | tccom121.cfrw |
Carrier LSP Desc | tcmcs080.dsca |
City | tccom130.ccit |
City Desc | tccom139.dsca |
Company | tccom130.ccty |
Country | Logical company of tccom121 |
Country Desc | tcmcs010.dsca |
End Date | tccom121.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 a tooltip with the Ship-to BP Name. |
GPS Longitude | tccom130.glon |
ISO Country Code Alpha-2 | tcmcs010.ict2 |
Ship-from BP | tccom121.sfbp |
Ship from BP ID Name | tccom121.sfbp + tccom100.nama |
Ship from BP Name | tccom100.nama |
Site | tccom121.site |
Site Desc | tcemm050.desc |
Start Date | tccom121.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 |
Warehouse | tccom121.cwar |
Warehouse Desc | tcmcs003.dsca |
deleted | 1 if deleted in LN, else 0 |
Customer Defined Fields | Standard list of fields |
Address fields are included for tccom121.cadr.