Obtain list of fields for marketing attributes against BP

[Former Member]

Hi All,

I'm working on a data extraction routine for BP data and need to be able to allow the user to select which fields will be extracted and added to the output file. I've got some standard code that so far uses a data dictionary structure to create a pop up of fields with checkboxes so the user can select which fields to output - it uses FM DDIF_FIELDINFO_GET to simply list all fields for a given structure.

My requirement is to extend this so that all possible marketing attributes against business partners are also available for selection in the field list. I guess to do this I need to find a way of reading all fields defined for any BP type attribute sets.

Does anyone know of any FM's that do this or have any ideas around tables I can read?

Note: I'm after the atttribute names not the actual values.

Thanks,

Gareth.

[Former Member · Accepted solution]

I didn't find any function modules so ended up simply reading the tables mentioned.

[Former Member · Accepted solution]

Hi Gareth

I think the function modules in group CRM_MKTPFTPL_OW are really valuable.

Maybe you could call CRM_MKTPFTPL_GETLIST and then call CRM_MKTPFTPL_READ_CHR for each one.

They aren't called by Pratik's FM's though .

Cheers

Dom

[Former Member · Accepted solution]

Dom,

Thanks very much - thats exactly what I was looking for.

(I wouldn't like to comment on the other answers again for fear of appearing rude...

Gareth.

[Former Member]

Dom has supplied the perfect function group and module - changing to unanswered to award points

[Former Member]

Gareth,

the following tables contain the information:

CABN / CABNT Attributes & description

CAWN / CAWNT Attribute values & description

KLAH / KLAT Classes & description

KSML Class-Attribute Assignment

Sorry, but I do not know the function modules.

Hope this helps,

Kai

[Former Member]

Thanks Kai,

I've seen a few posts now mentioning these tables but nothing about specific function modules other than those that actually read the attribute data values which I don't want - guess there aren't any.

I'll have to write some code to build the list up from the tables.

Thanks,

Gareth.

[Former Member]

Hi Gareth,

You may use FMs

CRM_MKT_EXT01_EXPORT

CRM_MKT_EXT01_EXPORT_DAT

CRM_MKT_EXT_GENERAL

CRM_MKT_EXT_DATA_EXPORT

Best Regards,

Pratik Patel

<b>Reward with Points!</b>

[Former Member]

Pratik,

Did you even read my question?!

Gareth.

[Former Member]

No comments to rude reply and no further answers.. sorry boss

[Former Member]

Fine.

No points for irrelevant answers either...

[Former Member]

No Problem at all.. Go ahead... find ur relevant answers to unformated questions..

Last tip: if atall you would have took some pain to explore the FM i have suggested you, you would have got some hint, from where exactly data is fetched and using what API's. Don't ignore the hidden knowledge.. But m disappointed.. m passing this tip to a person who will never respect it..

[Former Member]

What?!

[animesh_kumar2]

Hi,

Try FM "CRM_MKTBP_READ_CHAR".

Regards,

Animesh

[Former Member]

Hi,

Thanks, I've seen that but it appears to get BP specific data - as I said I just want a list of attribute fields from the attribute sets, not the actual data held in the attributes. I want to list all attributes available that could be against any BP.

Thanks,

Gareth.