topic Re: Function module for classifications/characteristics in Application Development and Automation Discussions

Function module for classifications/characteristics

Former Member — Wed, 14 Jun 2006 14:17:44 GMT

Can anyone suggest a function module or bapi I can use to get values for characteristics.

We are using characteristics to store additional information about fleet vehicles that are not included as standard SAP fields.

At the moment, I am using a couple of database calls, using tables 'CABN' and 'AUSP' to find values of these characteristics for a particular vehicle.

There must be an easier way, using a function module or bapi. Could anyone shed some light?

Re: Function module for classifications/characteristics

Former Member — Wed, 14 Jun 2006 14:20:48 GMT

Use CLAF_CLASSIFICATION_OF_OBJECTS.

Re: Function module for classifications/characteristics

Former Member — Wed, 14 Jun 2006 14:21:44 GMT

You can use the bapi: BAPI_CLASS_GET_CHARACTERISTIC

Regards,

ravi

Re: Function module for classifications/characteristics

RichHeilman — Wed, 14 Jun 2006 14:22:48 GMT

Have you tried...... CUOBJ is the internal object number. This works good for us when getting characteristics for a sales doc item(VBAP-CUOBJ).



* Internal Table for Characteristic Data
  data: begin of i_char occurs 0.
          include structure comw.
  data: end of i_char.
  clear i_char.  refresh i_char.

* Retrieve Characteristics.
  call function 'CUD0_GET_VAL_FROM_INSTANCE'
       exporting
            instance           = cuobj
       tables
            attributes         = i_char
       exceptions
            instance_not_found = 1.

Is this what you are looking for?

Regards,

Rich Heilman

Re: Function module for classifications/characteristics

Former Member — Wed, 14 Jun 2006 15:29:37 GMT

Hi,

you can try this BAPI BAPI_CLASS_GET_CLASSIFICATIONS

Regards

vijay

Re: Function module for classifications/characteristics

Former Member — Mon, 19 Jun 2006 08:48:40 GMT

Thanks for the replies guys.

I have had a look at

CLAF_CLASSIFICATION_OF_OBJECTS

BAPI_CLASS_GET_CHARACTERISTIC

BAPI_CLASS_GET_CLASSIFICATIONS

but either they don't do what I want, or my knowledge is insufficient :oP

As for CUOBJ - I am using equipment that have classifications, however the CUOBJ field in table EQUI is not filled.

Re: Function module for classifications/characteristics

Former Member — Mon, 19 Jun 2006 08:55:42 GMT

Hi,

For a given object, the following functions should give the details of the classification / characteristic values.

BAPI_OBJCL_GETDETAIL

This will give the details of the classes to which the Equipement belongs

BAPI_OBJCL_GETCLASSES

Pass the Equipment number as the object number to the function modules.

Regards,

Ravi

Re: Function module for classifications/characteristics

Former Member — Mon, 19 Jun 2006 08:59:23 GMT

Just check Function Modules CLSE_SELECT_CABN and CLSE_SELECT_CAWN for Reading characteristic attributes and Reading characteristic values respectively.

Also have a look at BAPI_OBJCL_GETDETAIL for which object table as 'MARA'.

rgds,

TM.

Please mark point if helpful.

Re: Function module for classifications/characteristics

Former Member — Mon, 19 Jun 2006 13:05:11 GMT

Hi Stuart,

You can use 'BAPI_OBJCL_GETCLASSES' and 'BAPI_OBJCL_GETDETAIL' to get the value of the characteristics.

See the Example.

(I am assuming that you are mentioning about the characteristics of an Equipment)

ws_equipment = ‘1012122’.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = ws_equipment

IMPORTING

output = ws_equipment.

i_object-object = ws_equipment.

i_object-objecttable = EQUI.

i_object-classtype = 002.

APPEND i_object.

CALL FUNCTION 'BAPI_OBJCL_GETCLASSES'

EXPORTING

objectkey_imp = i_object-object

objecttable_imp = i_object-objecttable

classtype_imp = i_object-classtype

read_valuations = 'X'

TABLES

alloclist = i_alloclist

allocvalueschar = i_allocvaluescharnew

allocvaluesnum = i_allocvaluesnumnew

allocvaluescurr = i_allocvaluescurrnew

return = i_return.

LOOP AT i_alloclist.

CASE i_alloclist-classnum.

WHEN "classname".

CALL FUNCTION 'BAPI_OBJCL_GETDETAIL'

EXPORTING

objectkey = i_object-object

objecttable = i_object-objecttable

classnum = i_alloclist-classnum

classtype = i_object-classtype

unvaluated_chars = 'X'

TABLES

allocvaluesnum = i_allocvaluesnumnew

allocvalueschar = i_allocvaluescharnew

allocvaluescurr = i_allocvaluescurrnew

return = i_return.

LOOP AT i_allocvaluescharnew.

CASE i_allocvaluescharnew-charact.

WHEN ‘characteristic name’

Fetch the current value of the characteristic from i_allocvaluescharnew-value_char

ENDCASE.

ENDLOOP.

Tip: If the characteristic is NUM, then get the corresponding value from i_allocvaluesnumnew

Regards,

Bittu

Re: Function module for classifications/characteristics

Former Member — Tue, 20 Jun 2006 07:41:40 GMT

Here's what I currently use

SELECT SINGLE atinn FROM cabn INTO char_no
                      WHERE atnam = 'WARRANTY_SUPPLIER1'.
  SELECT SINGLE atwrt FROM ausp INTO wa_vehicle-warr_supp1
                      WHERE objek = wa_vehicle-equnr
                      AND   atinn = char_no.

Are there any reasons why I shouldn't do it this way?

It seems quicker than calling two BAPIs

Re: Function module for classifications/characteristics

Former Member — Tue, 20 Jun 2006 07:45:10 GMT

There is no issue using your won select statement. Infact, if you drill down BAPI also will be fetching values from the same tables.

However, the BAPI will give you far more details. So, if you need more details you can use the BAPI without worrying about from which table they are coming.

In fact your SELECT statements might be more efficient in this case as the data you are selecting is limited.

Regards,

Ravi

Note : Please mark the helpful answers and close the thread if the issue is resolved.

Re: Function module for classifications/characteristics

Former Member — Tue, 20 Jun 2006 07:46:11 GMT

You can do this way also...

The table which you are using are correct tables. classifications/characteristics values present in those tables.

Regards

vijay

Re: Function module for classifications/characteristics

Former Member — Wed, 28 Feb 2007 05:38:26 GMT

Hai Rich Heilman ,

It works fine.

Thanks.

J.Chandaran