08-09-2012 9:59 AM
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
08-09-2012 11:54 AM
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.
08-09-2012 10:21 AM
08-09-2012 11:54 AM
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.
08-09-2012 1:43 PM
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
08-09-2012 1:45 PM
It is filled in FORM build_data so you can debug why i_final is not filled..
Thanks
Amber
08-10-2012 4:55 PM
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"
08-13-2012 10:36 AM
Hi Zapgui,
Yes, you can do that. You will need to change the program to display i_objectdata instead of the error.
Thanks
Amber