cancel
Showing results for 
Search instead for 
Did you mean: 

Obtain list of fields for marketing attributes against BP

Former Member
0 Kudos
68

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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
0 Kudos

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.

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

Pratik,

Did you even read my question?!

Gareth.

Former Member
0 Kudos

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

Former Member
0 Kudos

Fine.

No points for irrelevant answers either...

Former Member
0 Kudos

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
0 Kudos

What?!

animesh_kumar2
Active Participant
0 Kudos

Hi,

Try FM "CRM_MKTBP_READ_CHAR".

Regards,

Animesh

Former Member
0 Kudos

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.