topic Re: Report material classification in Application Development and Automation Discussions

Report material classification

Former Member — Thu, 09 Aug 2012 08:59:18 GMT

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

Re: Report material classification

gouravkumar64 — Thu, 09 Aug 2012 09:21:55 GMT

Hi,

So debug program .

Gourav.

Re: Report material classification

gouravkumar64 — Thu, 09 Aug 2012 10:54:02 GMT

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.

Re: Report material classification

Former Member — Thu, 09 Aug 2012 12:43:31 GMT

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

Re: Report material classification

Former Member — Thu, 09 Aug 2012 12:45:21 GMT

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

Thanks

Amber

Re: Report material classification

Former Member — Fri, 10 Aug 2012 15:55:38 GMT

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"

Re: Report material classification

Former Member — Mon, 13 Aug 2012 09:36:29 GMT

Hi Zapgui,

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

Thanks

Amber