SAP CRM Marketing tables

[Former Member]

Hi All,

can anybody tell me in CRM what is the table for marketing attributes ,attributes values and set types.

Regards,

rajasekhar

[Former Member · Accepted solution]

Hi,

I believe they are :

CABN Attribute Details - The attribute, like Hobby etc..

CAWN Attribute's values, like under Hobby - Cricket, Football etc...

KLAH Class ID or the Attribute Set ID. Like Hobby could be under Personal Interest Attribute set

SWOR Key word for Attribute Set

KSSK Attribute set ID vs Object ID (linking to BP) - Which partners has been assigned an attribute set.

INOB Object ID vs BP ID - Object ID linked to the BP ID

AUSP Gives BP GUID for an Attribute ID, Value and Object ID

Hope it helps.

Regards,

Rajiv

[Former Member · Accepted solution]

Hi All,

    Old thread I know.

    From AUSP-OBJEK I can search table KSSK-OBJEK to KLAH-CLINT to get the attribute sets.

From AUSP-ATINN to CABN-ATINN & CAWN-ATINN to get the attributes & attribute values.

But not seeing how to join the attributes with the attribute sets.   CABN has field CLINT but is always null in the tables.   Not seeing logically how to map the attributes in CABN to the Attribute sets in KSSK / KLAH

[Former Member · Accepted solution]

I think I found my answer thru table KSML

KLAH-CLINT to KSML-CLINT

then the matches in KSML-IMERK to CABN-ATINN