topic table name - urgent in Application Development and Automation Discussions

table name - urgent

Former Member — Thu, 28 Jun 2007 09:58:07 GMT

i want to find the class and class type based on matnr ,batch and werks..

Please can amy one suggest me the table name from where i can get them

Re: table name - urgent

Former Member — Thu, 28 Jun 2007 09:59:34 GMT

Hello,

Check this


  SELECT A~CUOBJ A~OBJEK A~KLART B~ATINN B~ATZHL B~ATWRT B~ATFLV
         B~ATAWE B~ATFLB B~ATAW1 C~CLINT D~CLASS
    INTO CORRESPONDING FIELDS OF TABLE G_T_OBJECTS
    FROM INOB AS A INNER JOIN AUSP AS B
      ON A~CUOBJ = B~OBJEK AND
         A~KLART = B~KLART
         INNER JOIN KSSK AS C
         ON B~OBJEK = C~OBJEK AND
            B~KLART = C~KLART
         INNER JOIN KLAH AS D
         ON C~CLINT = D~CLINT
   WHERE A~OBJEK IN S_MATNR AND
         A~OBTAB EQ 'MARA'  AND
         A~KLART IN S_KLART AND
         B~ADZHL EQ '0000'  AND
         C~LKENZ EQ ' '     AND
         D~CLASS IN S_CLASS.

Vasanth

Re: table name - urgent

Former Member — Thu, 28 Jun 2007 10:01:22 GMT

Hi Neha,

Material Class and class type exist in table KLAH.

Please refer to below code for more:

select single clint from kssk

into wf_clint

where objek = p_matnr and klart = '001'.

if sy-subrc = 0.

select single class from klah

into wf_class

where clint = wf_clint and klart = '001'.

select single kschl from swor into wf_desc

where clint = wf_clint and

spras = sy-langu.

endif.

I hope this helps.

Please reward if helpful.

Regards,

Amit Goyal

Re: table name - urgent

former_member491305 — Thu, 28 Jun 2007 10:20:12 GMT

Hi,

KSSK--?Table which is having assignment of classes to the object

KLAH-->Class Header Details:

TCLA-->Class types

CABN-->Characteristics

KSML--->Characteristics of a Class