Report material classification

[Former Member]

Hi,

I'm running the following report:

http://wiki.sdn.sap.com/wiki/display/Snippets/Fetch+material+Classifications+and+characteristics

In material master I have some materials which have a class but the class

has not characteristics because characteristics were removed because no more used.

If in the selection screen I enter a class which has not any characteristic, the report generates the error: "No record found".

but I don't understand in which part of the program the code skips materials with classes which have no characteristics

Thanks

Best regards

[gouravkumar64]

Hi,

So debug program .

Gourav.

[gouravkumar64]

Hi,

Atnam (characteristics name) field u will get in cabn table.

may be some problem in select query and for all entries where u r checking & writing error messages type 'E like this.

this link will help u

http://wiki.sdn.sap.com/wiki/display/SAPMDM/Issues+in+fetching+internal+characteristics+of+materials

to know the idea about cabn table.

Regards

Gourav.

[Former Member]

Hello Zapgui,

The error is raised in the following code.

  IF i_final[] IS NOT INITIAL.

    PERFORM build_field_catalouge.

    PERFORM display_data.

  ELSE.

    MESSAGE 'No records found' TYPE 'E'.

    EXIT.

  ENDIF.

It is raised because i_final is empty. It seems that this internal table is filled with class/characteristics so if you have no characteristic it wont fill this table and therefore will rturn the error.

Hope that helps

Thanks

Amber

[Former Member]

It is filled in FORM build_data so you can debug why i_final is not filled..

Thanks

Amber

[Former Member]

I'll try to add an instruction so that if for a material exists a class but not characteristics the output (each row) will show material number, class name and the other columns will be leaved "blank"

[Former Member]

Hi Zapgui,

Yes, you can do that. You will need to change the program to display i_objectdata instead of the error.

Thanks

Amber