on 10-22-2008 6:22 AM
What is table for Business Partner Marketing Attributes and Attribute Set .
hi anup...
check table AUSP and CABN ....
hope it works ....
thanks
sandy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
Hi,
CRMD_MKTPL_PAR
CRMD_PARTNER
CRM_MKTPL_ATTR
CGPL_PROJECT
Regards
Srinu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.