topic Re: Characteristics Table ? in Application Development and Automation Discussions

Characteristics Table ?

Former Member — Tue, 21 Jul 2009 08:04:10 GMT

Dear Experts ,

I have created a characteristics contanis the SLED with reference to table MCHA & field VFDAT , but I have a problem finding the table that contains the data i stored in the characteristics

I have looked at AUSP & CAWN but it just contains Null values in the Character Value Field

The other problem that even the field VFDAT in table MCHA does not contain the dates i entered in the MIGO in the SLED Field

Note : I enter the Date twice .. once in the characteristics and the other in the original SLED field

Please Advice

Thanks in Advanced

Re: Characteristics Table ?

Former Member — Tue, 21 Jul 2009 08:22:55 GMT

Hi,

If my understanding is right.

Try using the following function module for Material characteristics CLAF_CLASSIFICATION_OF_OBJECTS and VB_BATCH_GET_DETAIL for Batch characteristics.

Regards,

Sandhya

Re: Characteristics Table ?

Former Member — Tue, 21 Jul 2009 08:31:48 GMT

Hi,

For Charactersitics,

You can find here in this tables,,

Here is a sample code to retrieve the Char values from the standard table,,,! check out my previously replied thread...!

[Charatecristics values|]

Regards,

Dileep .C

Re: Characteristics Table ?

Former Member — Tue, 21 Jul 2009 08:58:24 GMT

You can find the value of characteristics related value from table INOB and AUSP.

Check the below sample code in this code you can fetch the vaue of UD characteristics.

IF s_compcd-low = '003'.

CONCATENATE gt_invent1_temp-matnr gt_invent1_temp-werks gt_invent1_temp-charg INTO gv_objek.

SELECT SINGLE cuobj FROM inob

INTO gv_cuobj

WHERE klart = '022' AND

obtab = 'MCHA' AND

objek = gv_objek.

IF sy-subrc = 0.

SELECT SINGLE atwrt FROM ausp

INTO gv_atwrt

WHERE objek = gv_cuobj AND

atinn = '0000000448' (this value ix fixed for UD characteristics).

IF sy-subrc = 0.

MOVE gv_atwrt TO gt_invent1-ud_char.

ENDIF.

endif.

Or you can also use BAPI to fetch this value check the below sample code

CALL FUNCTION 'QMSP_MATERIAL_BATCH_CLASS_READ'

EXPORTING

i_matnr = matnr

i_charg = charg

i_werks = werks

i_mara_level = 'X'

i_no_dialog = 'X'

i_datuv = sy-datum

IMPORTING

e_class = lv_class

e_klart = lv_klart

e_obtab = lv_table

e_objec = lv_objek

EXCEPTIONS

no_class = 1

internal_error_classif = 2

no_change_service = 3

OTHERS = 4.

IF sy-subrc = 0.

CALL FUNCTION 'BAPI_OBJCL_GETDETAIL'

EXPORTING

objectkey = lv_objek

objecttable = lv_table

classnum = lv_class

classtype = lv_klart

keydate = sy-datum

language = sy-langu

TABLES

allocvaluesnum = lt_alloc_values_num

allocvalueschar = lt_allocvalueschar

allocvaluescurr = lt_allocvaluescurr

return = lt_return.

ENDIF.

Hope this will help you.

Re: Characteristics Table ?

Former Member — Wed, 22 Jul 2009 07:25:46 GMT

The probem is when the characteristics's type is "Char" the value is displayed in AUSP but when the its type is DATE there is no data displyed even though the data is exicted when I try viewing it by a standard transaction

Thanks a lot guys for you help

Re: Characteristics Table ?

Former Member — Wed, 22 Jul 2009 07:35:35 GMT

Hello

In some cases values type DATE are stored in field AUSP-ATFLV (instead AUSP-ATWRT). Check this.

Re: Characteristics Table ?

Former Member — Wed, 22 Jul 2009 08:03:07 GMT

The value of the field in the table is :

2.0090703000000000E+07

but in real when i display it through the standard transaction is 03.07.209

How can convert it to date type in SAP Query ??

Thanks alot for you help

Re: Characteristics Table ?

Former Member — Wed, 22 Jul 2009 08:11:06 GMT

Hello

In programm I do like this:


data: IDATE TYPE I,
      XDATE(10),
      TEMP(8),
      DAY(2),
      MONTH(2),
      YEAR(4).
IDATE = AUSP-ATFLV.
TEMP = IDATE.
YEAR = TEMP.
MONTH = TEMP+4(2).
DAY = TEMP+6(2).
CONCATENATE DAY MONTH YEAR INTO XDATE SEPARATED BY '.'.

As result - in XDATE I will have date.

Re: Characteristics Table ?

Former Member — Wed, 22 Jul 2009 08:31:36 GMT

A lot of thanks for you answers

But please can you till me if it possible to enter this code in a LOCAL field in SAP Query

Note : I have tested this code in se93 with a seperate program and it worked very good

Please Advice

Re: Characteristics Table ?

Former Member — Wed, 22 Jul 2009 08:37:32 GMT

Hello

Regrettably, I do not work with SAP Query. So I can not advise

Re: Characteristics Table ?

Former Member — Wed, 22 Jul 2009 08:43:14 GMT

even though Thanks alot for you help .. i will continue from this ... you are very helpful

Thanks again