topic Re: material link tables in Application Development and Automation Discussions

material link tables

Former Member — Fri, 26 Oct 2007 05:22:52 GMT

In the VF05N transaction w e need to include the 2 fields in the list view. that 2 feilds are in the material master clasification tab->material class 001->characteristic name-> characteristic value.(atinn)

can some body help me out to find the link tables for these 2 feilds and the material so that we can write a FS to devveloper to include the 2 feilds.

rewards points for solutions.

thanks

venkat

Re: material link tables

Former Member — Fri, 26 Oct 2007 05:24:50 GMT

Use CABN and AUSP tables

or use the following BAPI or fun module

BAPI_OBJCL_GETDETAIL

BAPI_OBJCL_CHANGE

or use the fun module:

CLAF_CLASSIFICATION_OF_OBJECTS.

Regards

Anji

Re: material link tables

Former Member — Fri, 26 Oct 2007 07:49:39 GMT

----

FORM get_mat_claf *

----

取物料分类的特征 *

----

--> p_matnr: 物料号 *
--> p_class: 类种类 *
--> p_atnam: 特征代码 *
--> p_value: 控制返回特征代码或描述 *
<-- p_ausp1: 特征值代码或特征值描述 *

----

FORM get_mat_claf USING p_matnr p_class p_atnam p_value

CHANGING p_ausp1.

DATA: objek LIKE ausp-objek.

DATA: it_class LIKE TABLE OF sclass WITH HEADER LINE,

it_objectdata LIKE TABLE OF clobjdat WITH HEADER LINE.

CLEAR: p_ausp1.

objek = p_matnr.

REFRESH: it_class,

it_objectdata.

CALL FUNCTION 'CLAF_CLASSIFICATION_OF_OBJECTS'

EXPORTING

classtype = p_class

object = objek

no_value_descript = p_value

TABLES

t_class = it_class

t_objectdata = it_objectdata

EXCEPTIONS

no_classification = 1

no_classtypes = 2

invalid_class_type = 3

OTHERS = 4.

IF sy-subrc = 0.

READ TABLE it_objectdata

WITH KEY atnam = p_atnam.

IF sy-subrc = 0.

p_ausp1 = it_objectdata-ausp1.

IF p_ausp1 = '?'.

CLEAR p_ausp1.

ENDIF.

ENDFORM. " get_mat_claf

Re: material link tables

Former Member — Fri, 04 Jan 2008 04:55:07 GMT

Hi ,

If have solved this problem can you send me i have similar type problem

Thanks

Ajay Pandey