Invoice-to BP
This table shows the tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tccom100 | Business Partners |
| tccom112 | Invoice-to Business Partners |
| tccom130 | Addresses |
| tccom139 | Cities by Country |
| tcemm100 | Time Zones |
| tcmcs002 | Currencies |
| tcmcs010 | Countries |
| tcmcs013 | Payment Terms |
| tcmcs029 | Business Partner Types |
| tcmcs064 | Credit Ratings |
| tcmcs143 | States/Provinces |
| tfacr001 | Financial Customer Groups |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Business Partner Status | tccom112.itst |
| Business Partner Status Filter | tccom112.itst |
| Business Partner Status Sort | tccom112.itst |
| Business Partner Type | tccom112.cbtp |
| Business Partner Type Desc | tcmcs029.dsca |
| City | tccom130.ccit |
| City Desc | tccom139.dsca |
| Company | Logical company of tccom112 |
| Country | tccom130.ccty |
| Country Desc | tcmcs010.dsca |
| Credit Analyst | tccomn112.ccra |
| Credit Analyst Name | tccom001.nama |
| Credit Limit | tccom112.crlr |
| Credit Rating | tccom112.crat |
| Credit Rating Desc | tcmcs064.dsca |
| Currency | tccom112.ccur |
| Currency Desc | tcmcs002.dsca |
| Department | tccom012.cofc |
| Department Desc | tcmcs065.dsca |
| End Date | tccom112.endt |
| EU Member State | tcmcs010.meec |
| EU Member State Filter | tcmcs010.meec |
| EU Member State Sort | tcmcs010.meec |
| Financial Customer Group | tccom112.cfcg |
| Financial Customer Group Desc | tfacr001.desc |
| GPS Latitude | tccom130.glat |
| GPS Location | Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Invoice-to BP Name. |
| GPS Longitude | tccom130.glon |
| Invoice-to BP | tccom112.itbp |
| Invoice to BP ID Name | tccom112.itbp + tccom100.nama |
| Invoice to BP Name | tccom100.nama |
| ISO Country Code Alpha-2 | tcmcs010.ict2 |
| Payment Terms | tccom112.cpay |
| Payment Terms Desc | tcmcs013.dsca |
| Start Date | tccom112.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 tccom112.cadr.
Department and Department Desc attributes are not available: department-specific records are not created in the dimension.