cancel
Showing results for 
Search instead for 
Did you mean: 

Table for Business Partner Marketing Attribute

Former Member
0 Kudos

What is table for Business Partner Marketing Attributes and Attribute Set .

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

hi anup...

check table AUSP and CABN ....

hope it works ....

thanks

sandy

Former Member
0 Kudos

Its not working dear .

Former Member
0 Kudos

Anup,

If want the value of the particular attribute for particular business partner, then you have to get the ATINN by giving ATNAM = attribute name from table CABN first. Then you have to select ATWRT from table AUSP by giving ATINN (what u got from CABN) and PARTNER_GUID = partner guid of Business Partner.

Thanks..

RR

Former Member
0 Kudos

Hi ,

i have gone through the tables , but i am facing problem in getting table details for particular B.P.

FOR EX-

B.P. no/ id is there and we have assigned Marketing Attributes to it .

So give me procedure to search the Table where B.P Id and all assigned Marketing attributes and its value will reflect considering i have only B.P. Guid no.

Former Member
0 Kudos

Anup,

Ok you have BP Guid. You goto table AUSP and enter the PARTNER_GUID = BP GUID and check contents. Here you will get all the attribute list (field ATINN) and corresponding values of attributes (field ATNAM). But here in this table u will find ATINN in form of number; using that number you can find corresponding attribute name in field ATNAM of table CABN where ATINN = ATINN u got in the AUSP for each attribute rows.

Thanks,

RR

Former Member
0 Kudos

Hi,

CRMD_MKTPL_PAR

CRMD_PARTNER

CRM_MKTPL_ATTR

CGPL_PROJECT

Regards

Srinu

Former Member
0 Kudos

Hi

We create Marketing Attributes / Attribute Set for Business Partner in marketing and then we assign Marketing set to Business Partner in Marketing Attribute Data set or Tab .

I want to know in which table these marketing attributes / sets are getting stored .