SAP for Retail Blogs
Gain insights and practical tips to captivate customers, optimize your supply chain, and drive growth with SAP for Retail software. Share your own insights!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Create Generic and Variants Using LSMW

paul_gendreau
Contributor
‎12-04-2014 3:29 PM


-----------------------------------------------------------------------------------------------------------------

Edit: 6/5/2021

For the S/4HANA version of this blog, see:  ​​Load Generic/Variant Articles in S/4HANA with LSMW

This new blog (June 2021) explains the most common mistake made when attempting to create Generic/Variant Articles in data migration. It's all about understanding the functional use of ARTMAS IDoc segments.

-----------------------------------------------------------------------------------------------------------------

Article Master – LSMW – Generic/Variants - ARTMAS05

This subject raised a few questions in an SCN thread with the title of Error while trying to create Generic Articles with variants using LSMW (ARTMAS05).

A document that I wrote in response to that question is requested frequently. This post replaces the document named md_article_generic_lsmw.pdf

Creating a generic article master with variant articles is accomplished via processing of one ARTMAS05 IDoc.

There is important prerequisite master data, which is detailed in steps below that were executed to create an example.

































































PROCESS STEP PROCESS STEP IMAGE


CT04 – Create Characteristic

Create HN_COLOURS


CT04 – Create Characteristic

Maintain values for HN_COLOURS


CLWE – Create Characteristic Profile

Create HN001


CLWE – Create Characteristic Profile

Assign Characteristic and make relevant for the creation of Variants.


WG21 – Create Merchandise Category

Create S14


WG22 – Change Merchandise Category

Change S14

Assign Characteristic Profile HN001


WG22 – Change Merchandise Category

Change S14

Create reference article.


WG22– Change Merchandise Category

This takes you to MM41 / MM42 to create or change the reference article.

Create reference article A11000011.

Maintain all views except Purchasing.


LSMW – Process ARTMAS05

See IDoc detail at end of document.


LSMW – Process ARTMAS05

See IDoc detail at end of document.


LSMW – Process ARTMAS05

See IDoc detail at end of document.


LSMW – Process ARTMAS05

See IDoc detail at end of document.


MM43 – Display Article

Click the Variants button to display the Variants.
MM43 – Display Article

Here is the IDoc that created the example Article Master

Observe the usage of segments and fields.

 

















































































































































































































































































































































































































































































































































































































































































































SEGMENT FIELD NAME SHORT
DESCRIPTION		 VALUE
E1BPE1MATHEAD FUNCTION Function 009
E1BPE1MATHEAD MATERIAL Article Number A11000010
E1BPE1MATHEAD MATL_TYPE Article Type HAWA
E1BPE1MATHEAD MATL_GROUP Merchandise Category S14
E1BPE1MATHEAD MATL_CAT Article Category 01
E1BPE1MATHEAD CHAR_PROF Characteristic
profile		 HN001
E1BPE1MATHEAD REF_MATL Reference article A11000011
E1BPE1MATHEAD BASIC_VIEW Include Basic Data View X
E1BPE1MATHEAD LIST_VIEW Indicator: Consider
Listing view		 X
E1BPE1VARKEY FUNCTION Function 009
E1BPE1VARKEY MATERIAL Article Number A11000010
E1BPE1VARKEY VARIANT Variant number A11000010001
E1BPE1VARKEY FUNCTION Function 009
E1BPE1VARKEY MATERIAL Article Number A11000010
E1BPE1VARKEY VARIANT Variant number A11000010002
E1BPE1AUSPRT FUNCTION Function 009
E1BPE1AUSPRT MATERIAL Article Number A11000010001
E1BPE1AUSPRT CHAR_NAME Characteristic Name HN_COLOURS
E1BPE1AUSPRT CHAR_VALUE Characteristic Value 10
E1BPE1AUSPRT FUNCTION Function 009
E1BPE1AUSPRT MATERIAL Article Number A11000010002
E1BPE1AUSPRT CHAR_NAME Characteristic Name HN_COLOURS
E1BPE1AUSPRT CHAR_VALUE Characteristic Value 20
E1BPE1AUSPRTX FUNCTION Function 009
E1BPE1AUSPRTX MATERIAL Article Number A11000010001
E1BPE1AUSPRTX CHAR_NAME Characteristic Name HN_COLOURS
E1BPE1AUSPRTX CHAR_VALUE Updated information
in related user data field		 X
E1BPE1AUSPRTX FUNCTION Function 009
E1BPE1AUSPRTX MATERIAL Article Number A11000010002
E1BPE1AUSPRTX CHAR_NAME Characteristic Name HN_COLOURS
E1BPE1AUSPRTX CHAR_VALUE Updated information
in related user data field		 X
E1BPE1MARART FUNCTION Function 009
E1BPE1MARART MATERIAL Article Number A11000010
E1BPE1MARART OLD_MAT_NO Old article number 9999MAT
E1BPE1MARART BASE_UOM Base Unit of Measure EA
E1BPE1MARART TRANS_GRP Transportation Group 0001
E1BPE1MARART DIVISION Division 10
E1BPE1MARART TAX_CLASS Tax classification of
the article		 1
E1BPE1MARART1 BRAND_ID Brand 0001
E1BPE1MARARTX FUNCTION Function 009
E1BPE1MARARTX MATERIAL Article Number A11000010
E1BPE1MARARTX OLD_MAT_NO Updated information
in related user data field		 X
E1BPE1MARARTX BASE_UOM Updated information
in related user data field		 X
E1BPE1MARARTX TRANS_GRP Updated information
in related user data field		 X
E1BPE1MARARTX DIVISION Updated information
in related user data field		 X
E1BPE1MARARTX TAX_CLASS Updated information
in related user data field		 X
E1BPE1MARARTX BRAND_ID Updated information
in related user data field		 X
E1BPE1MAW1RT FUNCTION Function 009
E1BPE1MAW1RT MATERIAL Article Number A11000010
E1BPE1MAW1RT REPL_LIST Assortment List Type 1
E1BPE1MAW1RT ABC_ID ABC Indicator A
E1BPE1MAW1RT PUR_GROUP Purchasing Group 100
E1BPE1MAW1RT COUNTRYORI Country of origin of
the article		 AU
E1BPE1MAW1RT LOADINGGRP Loading Group 0001
E1BPE1MAW1RT ASSORT_LEV Assortment grade 1
E1BPE1MAW1RT LI_PROC_ST Listing procedure for
store or other assortment categories		 B1
E1BPE1MAW1RT LIST_ST_FR Date from which
listed in the store		 20130401
E1BPE1MAW1RT LIST_ST_TO Date to which listed
in the store		 99991231
E1BPE1MAW1RT SELL_ST_FR Date from which sold
in the store		 20130401
E1BPE1MAW1RT SELL_ST_TO Date to which sold in
the store		 99991231
E1BPE1MAW1RT VAL_CLASS Valuation Class 3100
E1BPE1MAW1RTX FUNCTION Function 009
E1BPE1MAW1RTX MATERIAL Article Number A11000010
E1BPE1MAW1RTX REPL_LIST Updated information
in related user data field		 X
E1BPE1MAW1RTX ABC_ID Updated information
in related user data field		 X
E1BPE1MAW1RTX PUR_GROUP Updated information
in related user data field		 X
E1BPE1MAW1RTX COUNTRYORI Updated information
in related user data field		 X
E1BPE1MAW1RTX LOADINGGRP Updated information
in related user data field		 X
E1BPE1MAW1RTX ASSORT_LEV Updated information
in related user data field		 X
E1BPE1MAW1RTX LI_PROC_ST Updated information
in related user data field		 X
E1BPE1MAW1RTX LIST_ST_FR Updated information
in related user data field		 X
E1BPE1MAW1RTX LIST_ST_TO Updated information
in related user data field		 X
E1BPE1MAW1RTX SELL_ST_FR Updated information
in related user data field		 X
E1BPE1MAW1RTX SELL_ST_TO Updated information
in related user data field		 X
E1BPE1MAW1RTX VAL_CLASS Updated information
in related user data field		 X
E1BPE1MAKTRT FUNCTION Function 009
E1BPE1MAKTRT MATERIAL Article Number A11000010
E1BPE1MAKTRT LANGU Language Key E
E1BPE1MAKTRT MATL_DESC Article Description
(Short Text)		 QUEEN BED
E1BPE1MARMRT FUNCTION Function 009
E1BPE1MARMRT MATERIAL Article Number A11000010
E1BPE1MARMRT ALT_UNIT Alternative Unit of
Measure for Stockkeeping Unit		 KG
E1BPE1MARMRT NUMERATOR Numerator for
Conversion to Base Units of Measure		 1
E1BPE1MARMRT DENOMINATR Denominator for
conversion to base units of measure		 1
E1BPE1MARMRT LENGTH Length 10
E1BPE1MARMRT WIDTH Width 12
E1BPE1MARMRT HEIGHT Height 15
E1BPE1MARMRT UNIT_DIM Unit of Dimension for
Length/Width/Height		 M
E1BPE1MARMRT VOLUMEUNIT Volume unit CCM
E1BPE1MARMRT GROSS_WT Gross Weight 1
E1BPE1MARMRT UNIT_OF_WT Weight Unit KG
E1BPE1MARMRTX FUNCTION Function 009
E1BPE1MARMRTX MATERIAL Article Number A11000010
E1BPE1MARMRTX ALT_UNIT Alternative Unit of
Measure for Stockkeeping Unit		 KG
E1BPE1MARMRTX NUMERATOR Updated information
in related user data field		 X
E1BPE1MARMRTX DENOMINATR Updated information
in related user data field		 X
E1BPE1MARMRTX LENGTH Updated information
in related user data field		 X
E1BPE1MARMRTX WIDTH Updated information
in related user data field		 X
E1BPE1MARMRTX HEIGHT Updated information
in related user data field		 X
E1BPE1MARMRTX UNIT_DIM Updated information
in related user data field		 X
E1BPE1MARMRTX VOLUMEUNIT Updated information
in related user data field		 X
E1BPE1MARMRTX GROSS_WT Updated information
in related user data field		 X
E1BPE1MARMRTX UNIT_OF_WT Updated information
in related user data field		 X
E1BPE1MLTXRT FUNCTION Function 009
E1BPE1MLTXRT APPLOBJECT Texts: Application
Object		 MATERIAL
E1BPE1MLTXRT TEXT_NAME Name A11000010
E1BPE1MLTXRT TEXT_ID Text ID BEST
E1BPE1MLTXRT LANGU Language key E
E1BPE1MLTXRT TEXT_LINE Text Line POS 2nd line
description
E1BPE1MLTXRT MATERIAL Article Number A11000010
E1BPE1MLTXRT MATERIAL_EXTERNAL Long Article Number
for MATERIAL Field
E1BPE1MLTXRT MATERIAL_GUID External GUID for
MATERIAL Field
E1BPE1MLTXRT MATERIAL_VERSION Version Number for
MATERIAL Field

--- end of document ---

6 Comments
Popular Blog Posts