Skip to Content
avatar image
Former Member

Need help in mass load of Classification data in MDG through FILE UPLOAD only

Hi Experts,

Has anyone worked on a scenario where we need to mass load the classification data of Materials through “File Upload” feature in NWBC.

Though, SAP has provided us 2 entity types  i.e Characteristic Valuation (Classification) and Class Assignment (Classification) for upload, but they are not sufficient enough to load the classification data completely.

The process for loading the classification data are listed below:

  1. Upload the class type and class information for the existing materials using the entity type “Class Assignment (Classification)” for upload. PFB the screenshot for available attributes for upload:

2) Then upload the characteristics values against the already loaded class types and classes for the related characteristics descriptions fields of the materials using the entity type” Characteristic Valuation (Classification) “ . But the issue here is that in the list of attributes for this entity type, we don’t have any field such as Class name or internal class no. so that we may load the characteristics values for those specific class names.

Also, there are 2 Internal Char No attributes above ( Internal Char No and Internal char no), Please let me know if they are correct or mistyped by SAP or if one if them is internal class no which I am looking for,

Please let me know if I am missing any point while performing upload or if my approach is wrong.

Any inputs would be very helpful for us.

Thanks in advance.



c2.PNG (19.7 kB)
c1.PNG (21.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 09, 2015 at 11:20 PM

    Hi Satyam

    The characteristic valuation is never done specific to one class. So the class information in the entity VALUATION would not make sense. Check the backend classification functionality: If you have a char. COLOR, assign it to two classes and assign both classes to the same material, you'll only get one COLOR in the classification screen, not one COLOR per class.

    Secondly, classification is a very powerful and generic tool, which unfortunately also reflects in the naming. If you want a better understanding which backend field (table AUSP) maps to which model fields, you could have a look at the MDGM structure for char. valuation /MDGMM/_S_MM_PP_VALUATION and the labels for the data elements. You'll find that "Internal Char No." is indeed the ID of the characteristic, whereas "Internal char no." belongs to user-defined data types.

    The two fields "Alternative unit" are indeed hard to hold apart...

    Best regards, Ingo Bruß

    Add comment
    10|10000 characters needed characters exceeded

    • Well, from a governance point of view, it's not really best practise to load any material data from any frontend file. But that's of course slightly off topic...

      I'm not aware that "the old Web UI application MDG_FILE_UPLOAD_CMP" can't load CLFMAS IDoc XMLs. Did you try it? What errors did you witness?

      Regards, Ingo