Where does "Partner-Role" hide?‏

Though I already have some experience on SAP BI and ERP before I come into this project, SAP CRM is absolutely new to me. My coacher, a BI-Expert, also doesn’t use CRM before. My colleagues? This is the first CRM project in this company, so...no one really knows something about it. The only one who really knows CRM is our consulting company which is 500 Kilometer away from us. So during the process to build the DataSources up, I spent lots of time to figure out which attribute in which table are the data I need.
For example, the most important DataSource I need to create: “Activity”.
On our UI, our end user (which are sales department) need to fill in the different partner when they create “activity”.
And I though those Partner-data will be in the table “CRMD_ORDER_INDEX”.

The attributes “PFT_6”, “PFT_7”, “PFT_8” indicate which Partner-Role the partner is. Totally wrong!!
Until I found, one activity have 3 partners with 3 different roles, but they are all marked in the attribute “PFT_8” in table “CRMD_ORDER_INDEX”. OMG! Something wrong!!
So, I read the SAP HELP firstly, it looks like I should go to “CRMD_PARTNER” table. But with deeply search on SDN Forum, I found out the true:
The Table “CRMV_linkPartner” includes the information: “Activity number”, “Partner Number” and “Partner role”. The attribute “PARTNER_FCT” indicates the “partner role”. These are what I am searching for.



【輕鬆一下】
聽說第一道鋒面已經降臨台灣了，不過我猜台灣應該還是熱得不得了吧，來看點清涼的降降火吧！
本日推薦文章：拜訪馬其頓王國 -- 人間仙境