cancel
Showing results for 
Search instead for 
Did you mean: 

SAP CRM what is DB table relationship b/w Account ->Mrk attribute set type

Former Member
0 Kudos

Hi Team,

In Zreport, I need to populate Account id based on particular set type present in marketing attribute assignment block.

I am able to filter the account based on set type using FM  CRM_MKTBP_READ_ALL_TPL.

Issue with this is first i am populating all account( 2.5 lakh ) then on each account checking the set type. So its a huge performance issue.

Question: what are db table and there relationship between account and set type assign in Market assignment block.

Please advice.

Thanks,

Rajan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

hi Spencer,

Its didn't work.

I need to get the template ID assign in marketing assignment block in the Account . so which are the table and their relationship be use to get it.

Please advice.

Thanks,

Rajan

spencer_liang
Active Contributor
0 Kudos

is the AB marketing attributes?

what template?

is it what you talked about in following pic?

Former Member
0 Kudos

Yes Spencer. you are correct. how can I map bd table to get this value (given in dropdown list). Starting from Account ID/GUID

spencer_liang
Active Contributor
0 Kudos

you need to debug CRM_MKTBP_READ_BP_DATA, put GUID of the BP into IV_BP_GUID.


In this FM, it will call following FM

CALL FUNCTION 'CRM_MKTBP_READ_KSSK_AUSP'

     EXPORTING

       IV_BYPASS_BUFFER = IV_BYPASS_BUFFER

     TABLES

       it_bp_list = lt_bp_list_imp

       et_kssk    = lt_kssk

       et_ausp    = lt_ausp

       et_bp_list = lt_bp_list.


LT_KSSK            stores the object ID                      [1x19(274)]Standard Table
LT_AUSP                                  stores the attributes and their values [2x30(432)]Standard Table


I think LT_AUSP contains values that you want.

You may learn from this exmaple how CRM_MKTBP_READ_KSSK_AUSP is called, and call this FM in your z report to retrieve the marketing attribute values.


Spencer

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks Spencer,

With your guidance I resolve my issue. Thank you very much.

spencer_liang
Active Contributor
0 Kudos

pass BP guid and attribute id in below FM and get all details of attached BP attributes

CRM_MKTBP_READ_BP_DATA

Also find some helpful table related to BP attributes:

INOB: Object ID, BP Number

KSSK: Object ID, Attribute set ID

CABN: Attribute ID and name

CAWN: Attribute name and values

AUSP: BP GUID, Attribute Name, Value, Object ID

KLAH: Attribute Set Name, ID

see scn question : https://scn.sap.com/thread/1350746

Spencer