Loading Material Master Characteristics with LSMW Direct Input method

——————————————————————————–

This LSMW shows how to mass load material master characteristics. The LSMW used is exactly the same as what was used to load release procedure values. Input file is obviously different.

Material Master classification can be used to store additional information against a material master. Example: if it is finished products you may want to store: brand, pack, etc. If it is maintenance materials, you may want to store: size of item, grouping, etc.

Before loading the values (per material), you first need to create the fields (characteristics) and group them together in a class. This is done with following transaction codes:
Create class ? transaction CL02
Create characteristic(s)s ? transaction CT04
Assign characteristic(s) to class – transaction CL02
No screen shots about CL02 and CT04 ? you should be be able to get that right.

Material characteristic values can be viewed from a few places:
MM03 Display material and select characteristic view
CL20N Specify class type 001 and material master number
CL24N Specify class name and class type (001 in this case)


This data was loaded with attached LSMW and following input file (cl20_1.txt)

If the material numbers is numeric (example ‘123’) then add leading zero’s (as in my sample input file). This is not required for alpha material numbers (example if material number is ‘A123C’).

This is how the data look in UltraEdit


Same information but displayed in Excel

See how the leading zero’s are chopped off in Excel, this is one of the main reasons to use Excel only to display data. Do not save from Excel, as you may alter the input data.

The last line can be deleted ? it was added to show a deliberate error when all the data was loaded.
So in this case
KLART – 001 (Material Master)
OBJEK – material master number
CLASS – Class name
ATNAM – Characteristic name
ATWRT – Characteristic value
Details of LSMW (attached)

Running LSMW
If no error, you will see the deliberate error (that was added in last line)

This demo was produced using LSMW version: 4.0.0
SAP version: SAP R/3 EnterpriseLoading Material Master Characteristics with LSMW Direct Input method

——————————————————————————–

This LSMW shows how to mass load material master characteristics. The LSMW used is exactly the same as what was used to load release procedure values. Input file is obviously different.

Material Master classification can be used to store additional information against a material master. Example: if it is finished products you may want to store: brand, pack, etc. If it is maintenance materials, you may want to store: size of item, grouping, etc.

Before loading the values (per material), you first need to create the fields (characteristics) and group them together in a class. This is done with following transaction codes:
Create class ? transaction CL02
Create characteristic(s)s ? transaction CT04
Assign characteristic(s) to class – transaction CL02
No screen shots about CL02 and CT04 ? you should be be able to get that right.

Material characteristic values can be viewed from a few places:
MM03 Display material and select characteristic view
CL20N Specify class type 001 and material master number
CL24N Specify class name and class type (001 in this case)

This data was loaded with attached LSMW and following input file (cl20_1.txt)

If the material numbers is numeric (example ‘123’) then add leading zero’s (as in my sample input file). This is not required for alpha material numbers (example if material number is ‘A123C’).

This is how the data look in UltraEdit

Same information but displayed in Excel

See how the leading zero’s are chopped off in Excel, this is one of the main reasons to use Excel only to display data. Do not save from Excel, as you may alter the input data.

The last line can be deleted ? it was added to show a deliberate error when all the data was loaded.
So in this case
KLART – 001 (Material Master)
OBJEK – material master number
CLASS – Class name
ATNAM – Characteristic name
ATWRT – Characteristic value
Details of LSMW (attached)

Running LSMW
If no error, you will see the deliberate error (that was added in last line)

This demo was produced using LSMW version: 4.0.0
SAP version: SAP R/3 Enterprise

Advertisements
Categories: LSMW | 4 Comments

Post navigation

4 thoughts on “Loading Material Master Characteristics with LSMW Direct Input method

  1. dear sir

    I LIKE TO KNOW DETAILS ABOUT SAP MATERIAL MANAGEMENT

    AND VARIOUS STEPS IN LSMW SCREEN NAVIGATION

  2. sowmiyanarayanan

    I LIKE DETAIL ABOUT VARIOUS IN PRICING DECISION FOR THE MATERIAL MANAGEMENT AND SCREEN NAVIGATION OF VARIOU BASIS PROJECT IMPLEMENTATION FOR THE PRODUCTION FIRM BY USING SAP MATERIAL MANAGEMENT

  3. Superman

    I see this info is also on http://www.sap123.com

  4. Shridevi

    Hi,

    I am unable to view any attachments or Images. Could you please help?

    Regards,
    Shridevi

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: