topic Re: table for batch classification details in Application Development and Automation Discussions

table for batch classification details

Former Member — Thu, 18 Mar 2010 09:53:48 GMT

In classification view there is a tab called class...

i want the details of the class for each material...

i checked in

INOB

KSSK

KLAH tables but im not meeting my requirement

can anybody tell the table name ? ...

Regards

Smitha

Edited by: Smitha KB on Mar 18, 2010 10:54 AM

Re: table for batch classification details

GauthamV — Thu, 18 Mar 2010 10:00:39 GMT

Use these FM.

CLAF_CLASSIFICATION_OF_OBJECTS.

BAPI_OBJCL_GETDETAIL.

BAPI_OBJCL_GETDETAIL_KEY.

BAPI_OBJCL_GET_KEY_OF_OBJECT.

Re: table for batch classification details

Former Member — Thu, 18 Mar 2010 10:05:35 GMT

thanks for ur reply

i dnt want function module

i want the table name

Re: table for batch classification details

Former Member — Thu, 18 Mar 2010 10:08:43 GMT

TCLA

Re: table for batch classification details

Former Member — Thu, 18 Mar 2010 11:58:17 GMT

To check batch characteristics ; go to table INOB - give OBTAB as MCH1 ; OBJEK - combination of MATNR and batch ( 18 char+batch) and get the CUOBJ value.

Using this CUOBJ , go to table AUSP ; OBJEK of AUSP = CUOBJ ; give appropriate class type and ATINN and ATWRT holds the characteristic value.

Regards,

Ravinder.

Re: table for batch classification details

kesavadas_thekkillath — Thu, 18 Mar 2010 12:11:38 GMT

Check this query


1.
  SELECT mara~matnr kssk~klart kssk~clint klah~class klah~statu
            INTO TABLE i_class
             APPENDING CORRESPONDING FIELDS OF TABLE i_class
             FROM kssk JOIN mara ON kssk~objek = mara~matnr
                       JOIN klah ON kssk~klart = klah~klart
                                AND kssk~clint = klah~clint
             FOR ALL entries IN i_mara
             WHERE mara~matnr = i_mara-matnr   "material no
             AND   kssk~klart IN s_klart       "Class type
             AND   klah~class IN s_class       "Class


**-Get internal object number from INOB
        SELECT cuobj
               klart
               obtab
               objek
          INTO TABLE i_inob
          FROM inob
          FOR ALL ENTRIES IN i_mara_tmp
          WHERE klart IN r_klart AND
                obtab = c_mara   AND
                objek = i_mara_tmp-matnr.  "Material No

        SELECT kssk~objek kssk~klart kssk~clint klah~class klah~statu
               INTO CORRESPONDING FIELDS OF TABLE i_class
               FROM kssk
                         JOIN klah ON kssk~klart = klah~klart
                                  AND kssk~clint = klah~clint
          FOR ALL entries IN i_inob
               WHERE kssk~objek = i_inob-cuobj
               AND   kssk~klart IN r_klart
               AND   klah~class IN s_class.