topic Extract the classification data into internal table in Application Development and Automation Discussions

Extract the classification data into internal table

Former Member — Wed, 04 Apr 2007 02:08:32 GMT

Hi all,

I having requirement to extract classification data for material number.

1) Provide the selection option for material number (MATNR).

2) Based on the material number, then extract all that data into internal table as below layout. My problem is how to retrieve the following data from different table based on the MATNR (material number).

Please provide the sample code for select the following data. Thanks.

Classification table

OBJEK (from AUSP table)

MAFID (from AUSP table)

KLART (from AUSP table)

CLASS (from KLAH table)

ATWRT (from AUSP table)

MSEHI (from CABN table)

OBTAB (check if class type=002, set it as “MARA”)

STDCL (from KSSK table)

Re: Extract the classification data into internal table

Former Member — Wed, 04 Apr 2007 04:24:56 GMT

Hi,

Something to correct my Classification table, it should be as below. Could I know how i can select the below data from different table into internal table. What I the linking between below tables. Thanks.

OBJEK (from AUSP table)

MAFID (from AUSP table)

KLART (from AUSP table)

CLASS (from KLAH table)

ATWRT (from AUSP table)

ATAW1 (from AUSP table)

OBTAB (check if class type=002, set it as “MARA”)

STDCL (from KSSK table)

Re: Extract the classification data into internal table

Former Member — Wed, 04 Apr 2007 09:38:23 GMT

Hi,

if I understand, you´re trying to get information from the classification system for the material. You can use the following code:

DATA: clases LIKE TABLE OF sclass WITH HEADER LINE,

datos LIKE TABLE OF clobjdat WITH HEADER LINE.

CALL FUNCTION 'CLAF_CLASSIFICATION_OF_OBJECTS'

EXPORTING

class = 'DESK' "clase a buscar

classtype = '001' "tipo de la clase

features = 'X'

language = sy-langu

object = 'PM00A000C055' "Material

objecttable = 'MARA'

key_date = sy-datum

initial_charact = 'X'

change_service_clf = 'X'

TABLES

t_class = clases

t_objectdata = datos

EXCEPTIONS

no_classification = 1

no_classtypes = 2

invalid_class_type = 3

OTHERS = 4.

loop at datos.

endloop.

Re: Extract the classification data into internal table

Former Member — Thu, 12 Apr 2007 02:30:51 GMT

I've solved my own. Thanks.