How to get var. configuration characteristic value description in CRM 5 ?

[gerd_hotz]

Hello experts,

we have installed crm50 with vmc and we can do configuration in

crm-online very well (as in r3, from which we have donwloaded the sce) .

But for creating our sales order-printouts with smartforms,

we need the longtext of the characteristic value description in crm,

but I do not get them. I've checked fm crm_order_read_text, but nothing.

Is it possible to get this long texts by fm, or do we need java, because

all is stored in vmc/ipc ?

Best regards

Gerd

[former_member184067 · Accepted solution]

hi Gerd,

do you talking about product variant configuration value description ?

if yes, you can get the description of the value from table CAWNT

hopes it helps.

cheers

[Ivanino1]

You can use Function module 'CRM_CONFIG_READ_IB' and take information from CUVAL table

[gerd_hotz]

Has nobody an idea ?

Gerd

[Former Member]

I think you did use the wrong Download Object.

<b>Check the following object(s):</b>

VIA Transaction code for Object Management <b>R3AC1</b>:

Select Object "<b>ATTRIBUTE</b>" :

Source Site is R/3 and target Site type is CRM

This object contains the following tables:

CABN

CABNT

CABNZ

CAWN

CAWNT

TCME

Another Object that might be suitable is (but this is used for MOBILE SALES Scenario): so from CRM to CDB

<b>DNL_CHAR </b>

So if you need to place filter settings, you can it in your case in the object ATTRIBUTE.

Next do the initial download of this object via transaction R3AS.

please reward with points .... pretty sure this is the answer you are looking for

[gerd_hotz]

Hello Davy,

I've checked R3AC1, tables CABN

ICABN

CABNT

CABNZ

CAWN

CAWNT

TCME

are there, but in tab filters there are two entries:

KSML KLART eq 026

KSML KLART eq 023

and when I want to download this attribute inial, I get error:

error, attribute can not be loaded.

Have you an idea what there is wrong ?

BR

Gerd

[Former Member]

The available Class types I can find back in our system are:

001 Material class

002 Equipment class

003 Functional location

004 Ref. functional location

005 Inspection characteristics

006 Inspection methods

007 Code groups

008 Selected set

009 Prod. resources/tools

010 Vendor class

011 Customer class

012 Characteristics class

013 Controlling: orders

014 Controlling: projects

015 Message item

016 Object link

017 Document management

018 Task list class

019 Work center class

020 Standard network class

021 Network

022 Batch

024 Dependency

025 Engin. change mgmt

030 Plnt

031 User-defined data type

032 Release strategy

033 Cap. inv. program items

034 Department

035 Plant hierarchy

037 Measuring point

038 Activity

039 Sample warranty

041 Commitment funds center

042 Funds

043 Commitment item

044 Characteristic value

047 Assortment

048 Object links

049 Approvals

050 Reconciliation

053 iPPE Node

055 Contract Class

056 iPPE Variant

060 Layout areas

100 Substance values

170 Document distribution

200 Material (configurable objects)

201 Document (configurable objects)

300 Variants

301 Model service specifications

501 Contact persons

502 Relations

503 Opportunities

504 Activities

800 Business Location

I am not sure why class types 023 and 026 are mentioned in the filter settings as they do not seem to exist.

<u><b>Personally I would check the following:</b></u>

Check the different characteristics that are relevant for your download. (CT04)

Next, check the classes to which those characteristics are assigned.

You can do this by going into the Characteristic (CT04) and next via the menu:

Environment&#61664; Where used list. (flag Classes).

As soon as you have determined all relevant classes (CL02), you should check the class type they belong to.

E.g. 300 “Variants”.

I assume the relevant Class type in your case will at least be '300' (if you are using variant configuration for materials). If you have defined your own class type in customizing (which allows variant configuration) than you should use that one….

[Former Member]

Hi Gerd,

Please try VMC RFC "CFG_API_GET_FILTERED_CSTICS" ,and the long description of C&S store in table "COMM_CFGLNGTXT",hope this will helpful!

Regards,

Xianjun

[gerd_hotz]

Hello again,

I've checked table cawnt/cabnt in crm and they are empty.

1. How can I fill this tables from r3 ? (I did download object SCE, thats wrong ?)

Are this tables normally filled in crm with the same data in r3 ?

2. Table comm_cfglngtxt is filled with longtext, but for some objects

the description is wrong. So I get wrong textes for products in my form in crm.

How can I download this texts again ?

Thanks

Gerd

[gerd_hotz]

Hi,

yes, we are talking about product variant configuration value description .

But in cawnt I do not get the longtexts, there are only classification texts.

In r3 the texts are in cawnt but not in crm, and thats the problem.

Where do I get this longtexts ???

Or is it not possible because all data is in IPC (Java) ?

br

Gerd

[former_member184067]

hi Gerd,

have check the parameter ET_CONFIG in function module CRM_ORDER_READ ?

in that parameter there is a internal table CUVAL that contains the value of the configuration.

please check it wheather it can be used for your document printing or not.

honestly i have never know anything about IPC and i haven't know yet the mechanisme how the SAP keep the description of value of the characteristic, wheather it is in IPC or not.

sory

cheers

[gerd_hotz]

Hi Eddie,

can you specify how to use the paramter et_config in crm_order_read ?

Thanks

Gerd

[former_member184067]

hi Gerd,

ET_CONFIG is configuration for each order item.

to get the proper configuration for each order item, you need to read the ET_CONFIG based on order item.

for example :

loop at et_orderadm_i into es_orderadm_i.

loop at et_config where guid = es_orderadm_i-guid.

loop at et_config-cuval into es_cuval.

< code to get proper value for each characteristic >

endloop.

endloop.

endloop.

the characteristic code is in the field CHARC and the value of the configuration is in the field VALUE.

i don't know your scenarion / requirement for your document printing, but i think you need to get the description of the characteristic in table CABNT.

hopes it helps.

cheers.

[Former Member]

Hello Gerd,

See if this helps.

http://help.sap.com/saphelp_nw04/helpdata/en/e0/e2903c5a7a6619e10000000a114084/frameset.htm

regards,

Muralidhar Prasad.C

[gerd_hotz]

Has nobody an idea ???