Report on Batch - Class

[Former Member]

In Tcode MM03

I am asked to make report on

Matrial , class type, class and characteristic description

I cannot find any DataSource for this...

I thought of creating custom Datasource... searched for the underlying fields... by doing F1 help....

But I am only getting structures... How can I find the tables where this data resides...

Or Is there any other way to do this????

Please help....

Thanks

[former_member213275]

Hi Mohammed,

The table which give classification information are KLAH,KSSK etc..

If you are looking for custom data source and if you would like to implement tehn below logic would be useful.

SELECT SINGLE stlnr INTO lw_stlnr FROM  mast

               WHERE  matnr  = LW_EKPO_CUOBJ-MATNR

               AND    werks  =  your plant

               AND    stlan  = '5'.

        IF lw_stlnr IS NOT INITIAL.

          SELECT * INTO TABLE Lt_stpo FROM  stpo

                 WHERE  stlty  = 'M'

                 AND    stlnr  = lw_stlnr

                 AND ( POSTP = 'K' OR POSTP = 'L' ).

       ENDIF.

        IF LT_STPO[] IS NOT INITIAL.

         SELECT A~CLINT A~CLASS B~SPRAS B~KSCHL B~KSCHG

               FROM KLAH AS A INNER JOIN SWOR AS B ON

                 A~CLINT = B~CLINT

                INTO TABLE LT_CLASS_DESCR

                FOR ALL ENTRIES IN LT_STPO

                WHERE CLASS EQ LT_STPO-CLASS

                      AND B~SPRAS EQ SY-LANGU.

      ENDIF.

Refer below thread.

https://scn.sap.com/thread/1634211

http://affine.co.uk/cms/uploads/How_to_Extract_Classification_Data_into_BW.pdf

If you want more information pls drop a mail.

Srikanth.