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.