on 04-29-2016 7:46 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Thanks Spencer,
With your guidance I resolve my issue. Thank you very much.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.