Invoice-from BP

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

Table	Description
tccom100	Business Partners
tccom122	Invoice-from Business Partners
tccom130	Addresses
tccom139	Cities by Country
tcemm100	Time Zones
tcmcs002	Currencies
tcmcs010	Countries
tcmcs013	Payment Terms
tcmcs029	Business Partner Types
tcmcs143	States/Provinces
tfacp001	Financial Supplier Groups

This table shows the attribute mapping for the dimension:

Table	Description
Business Partner Status	tccom122.bpst
Business Partner Status Filter	tccom122.bpst
Business Partner Status Sort	tccom122.bpst
Business Partner Type	tccom122.cbtp
Business Partner Type Desc	tcmcs029.dsca
City	tccom130.ccit
City Desc	tccom139.dsca
Company	Logical company of tccom122
Country	tccom130.ccty
Country Desc	tcmcs010.dsca
Credit Limit	tccom122.crlr
Currency	tccom122.ccur
Currency Desc	tcmcs002.dsca
Department	tccom122.cofc
Department Desc	tcmcs065.dsca
End Date	tccom122.endt
EU Member State	tcmcs010.meec
EU Member State Filter	tcmcs010.meec
EU Member State Sort	tcmcs010.meec
Financial Supplier Group	tccom122.cfsg
Financial Supplier Group Desc	tfacp001.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- from BP	tccom122.ifbp
Invoice from BP ID Name	tccom122.ifbp + tccom100.nama
Invoice from BP Name	tccom100.nama
ISO Country Code Alpha-2	tcmcs010.ict2
Payment Terms	tccom122.cpay
Payment Terms Desc	tcmcs013.dsca
Start Date	tccom122.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 tccom122.cadr.

Department and Department Desc attributes are not available: department-specific records are not created in the dimension.