business partner role type

[Former Member]

hello friends

In which table i can get business partner roles .

I know about BUT100

i want Business Partner Roles like (sold_to_party,ship_to_party,bill_to_party)

[former_member1063151]

Hi Ekta,

Perhaps you could try BUB_BUPR_BUT050_READ to get the bp's role.

Cady.

[Former Member]

I am genrating a report in SE38 for displaying meeting details. In Activity Meeting we are having Business Partners and Partner_Function.

And now I want Business Partner's Role Which we have assigned in Business Transaction BP 's Change in Role Business Partner(sold_to_party ship_to_party

Bill to Party etc).

from which table i can get this BP Role.

[Former Member]

Hi,

In CRM , the roles of the Business partner can be seen in table BUT100.

Take the business partners from the activity (assuming this is a transaction type).

<b>The partner function and business partner roles are not directly related.</b>

regards,

PD

[Former Member]

Hi,

Though the requirement is not crystal clear, hope following solution meet your requirement ,

you can use following table

1) Enter your transaction number in object_id in table CRMD_ORDERADM_H

2) get guid from above table and pass it into CRMD_LINK

3) Get the set guid from CRMD_LINK and pass it into table CRMD_PARTNER

So you will get all the partners in transaction,

regards,

PD

Reward points if it helps......

[Former Member]

hi ekta let me know what u want to do exactly

wud like to create new one, and tell me the version u r using

[Former Member]

hi sourab

i am creating report for displaying meeting details... in that report i want all partner roles (sold_to_party ship_to_party employee etc..)

[sudheer-tammana]

Hi Ekta,

If you want to know about the types of partner roles defines in the system.

It is table TB003 in relase CRM 5.0 and above.

But if you are working on a CRM 4.0 release the table is TBZ0 for role types.

Regards,

Sudheer.

[Former Member]

I am working on a CRM 4.0 release the table is TBZ0 for role types.

I don't want types of partner roles defines in the system.

I want Change in Role define in business transaction bp

thanks for reply

[sudheer-tammana]

Hi Ekta,

Sorry to say but I haven't even now understood your requirement

Regards,

Sudheer.

[Former Member]

HI ,EKTA JAIN

TB003/TB003A/TB003B