Retail Article Master Data and Material Master Data

Differences
April, 2015
Internal
High Level Overview
SAP Retail - Article Master Data
SAP Retail – Article Master Data

SAP ERP SAP Retail

Material Master Common DB tables Article Master

MARA MAKT MARC MARD

MEAN MLGN MBEW …

and specific DB tables
MKAL MAPE MAW1 MALG
… …
Article Maintenance View
Material Maintenance View MARA-ATTYP = blank MARA-ATTYP ≠ blank
00 = Single, 01 = Generic, … Structured Articles

Single SKU Generic SKU – Shades Sets and Displays

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 3

SAP Retail – Article Master Data Definition Process

UPC,
UPC, EAN,
EAN,
Assortment
Assortment rules
rules
Status
Status
Maintain basic Assortment
data definition
Units
Units of
of measure
measure Vendor(s)
Vendor(s)

Valid
Valid period
period Discount(s)
Discount(s)
Maintain
purchase
costs

Item
Item (SKU)
(SKU) Cost-plus,
Cost-plus, MSRP
MSRP
Maintain
initial retail
price

Maintain
logistics
data Repleneshiment
Repleneshiment
parameters
parameters

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 4

SAP Retail – Kinds of Article (article categories)

Single
article
Case set Shoe prepack Socks
= = =
Sales set Display
Prepack
Groups of Articles
Quantity
articles combined
Generic arrangement
with special with an
article of the variants
sales price particular
of a generic article
packing

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 5

SAP Retail – Generic Article / Variants

 Variants are articles, which are only different in particular characteristics

(for example: taste, color, size)
 Variant articles are combined under a generic article
 Own master data record for every inventory-managed variant

Generic article Generic article

Variants Variants
© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 6
SAP Retail – Merchandise Category/Material Group Hierarchy
Node and assignment structure
MERCH_HIER_1

Material group
MERCH_HIER_2_01 ..... MERCH_HIER_2_50
hierarchy levels /
Merch. category
CHAR004 hierarchy levels
MERCH_HIER_3_001 ... MERCH_HIER_3_004 MERCH_HIER_3_197 ... MERCH_HIER_3_200

MCAT0016 ... MCAT0020 MCAT0996 ... MCAT1000

CHAR001 Material groups /
MCAT0001 ... MCAT0005 MCAT0981 ... MCAT0985 Merch. categories

CHAR002
CHARPROFIL_001 CHARPROFIL_002 Charact. profiles
CHAR003

Class of the
GEN_ART_0001 GEN_ART_0002 generic article

Objects of the
... ...
generic article
GA V1 V2 V9 GA V1 V2 V7
class
© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 7
Comparison of DB Table Usage
Master Data DB Tables used in Article Master Data (MM4x) versus Material Master Data (MM0x)
Comparison Article and Material Master Data Tables (1)

Tables collectively used by MM4x and MM0x but with additional Retail specific fields

• MARA (about 40 own fields): General Data for Article

• MARC (about 9 own fields): Site Data for Article

• MBEW (about 6 own fields): Valuation Data for Article

• MVKE (about 11 own fields): Sales Data for Article

Fash
ion M
bring anag
s in s emen
ome t So l
addit ution
ional
fields

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 9

Comparison Article and Material Master Data Tables (2a)

Tables collectively used by MM4x and MM0x without any additional Retail specific fields

• MAKT: Short texts for Article

• STXH,
STXL: SAPscript texts (longtexts)
Fash
ion M
anag
• MARM: Units of Measure for Article bring
s in s emen
t S ol
ome ution
addit
• MEAN: Global Trade Item Numbers (GTINs) for Article ional
table
s
• MLAN: Tax Classification for Article

• MARD: Storage Location Data for Article

• MLGN: Article Data for Each Warehouse Number

• MLGT: Article Data for Each Storage Type

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 10
Comparison Article and Material Master Data Tables (2b)

Tables collectively used by MM4x and MM0x without any additional Retail specific fields

• MPOP: Forecast Parameters (-> structure MPOP spreads data into tables MAPR and PROP)

• PROW: Forecast Values

• PROF: Forecast Errors

• MVER: Article Consumption

• MPGD: Product Group/Member Data (-> structure MPGD spreads data into tables PGMI and PGZU)

• MDVM,
DBVL,
DBVM: Entry in MRP File/Planning File

• MYMS: LIFO-relevant Articles

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 11

Comparison Article and Material Master Data Tables (4a)

Tables only used by MM0x

• MFHM : Production Resource Tool (PRT) Fields in the Article Master

(-> structure MFHM spreads data into tables CRFH, CRVP, CRTX)

• MKAL: Production Versions of Article

• MAPE: Article Master: Export Control File

• MAEX: Article Master: Legal Control

• MDMA: MRP Areas

• MOFF: Missing Maintenance Statuses

• MSTA: Already Available Maintenance Statuses

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 12

Comparison Article and Material Master Data Tables (4b)

Tables only used by MM0x

• QMAT: Inspection type - article parameters

• CKMLKALNR,
CKMLPR,
CKMLPP,
CKMLCR,
CKMLPRKEKO, Fashio
n Ma
CKMLPRKEPH: Material Ledger Solutio nagement
Materia n enab
l Ledge les
r in MM
• Configuration Data 4x

• Classification Data

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 13

Comparison Article and Material Master Data Tables (3)

Tables only used by MM4x

• MAW1: Default Fields and Special Retail Fields in addition to table MARA

• MLEA: Vendor-Specific EANs Mayb

e Foo
curre d Info
ntly s rmat
• WLK2: POS Control Data PRIC
in so
AT ta tored ion
in
b
me a les will b
dditi
• MAMT: Texts per Unit of Measure and Text ID onal ring
table
s
• MABW: Management of Differently Maintained Article Data in Retail

• WRF_TEXTILE_COMP,
Fashio
WRF_TEXTILE_FIBR: Textile Compositions (components and fiber codes) n
Solutio Management
n bring
additio s in so
nal fiel me
ds

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 14

Comparison Article and Material Master Data Tables (5a)

Additional (master) data objects integrated into MM4x

• Creation of classification data for merchandise category hierarchy assignment (class type "026")
(classification tables: KLAH, KSSK, CABN, CAWN, INOB, AUSP, …)

• Execution of listing to create listing conditions (table WLK1)

• Maintenance of purchasing and sales price conditions incl. sales price calculation (condition tables)

• Maintenance of purchasing inforecords (tables EINA, EINE)

Overlap
• Maintenance of source list records (table EORD)
Fashio with ne
w
n Mana
Solutio gemen
• Maintenance of vendor specific characteristic values (WYT2, WYT2M, WYT6) “Chara n Feature t
cteristi
Conver c Value
sion”

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 15

Comparison Article and Material Master Data Tables (5b)

Additional (master) data objects integrated into MM4x

• Maintenance of BOMs for structured articles like (prepacks, displays, sales sets)
(tables MAST, STKO, STPO, T415B)

• Maintenance of replenishment data (tables WRPL, WRPT, WRPP)

Overlap
Fashio with ne
• Maintenance of additionals like labels and tags (tables WTADDI, MAMT) n Mana w
Solutio g
n Featu ement
A d re “Val
• Maintenance of layout module assignments (tables MALG, WLVA) d e d Servi
ce”
ue

• Maintenance of article hierarchy assignments (table WRF_MATGRP_SKU)

• Maintenance of follow-up/replacement article assignments (table WRF_FOLUP_TYP_A)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 16

Function Differences (UI View)
Functional Differences in Article Master Data (MM4x) compared to Material Master Data (MM0x) collected
from the UI side
Functional Differences MM4x / MM0x – Entry Screen for Creation

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 18

Functional Differences MM4x / MM0x – Entry Screen for Changing

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 19

Functional Differences MM4x / MM0x – Basic Data (Single Article)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 20

Functional Differences MM4x / MM0x – Basic Data (Single Article)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 21

Functional Differences MM4x / MM0x – Empties Components

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 22

Functional Differences MM4x / MM0x – Successor/Substitute Article

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 23

Functional Differences MM4x / MM0x – Image Data

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 24

Functional Differences MM4x / MM0x – Basic Data (Sales Set)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 25

Functional Differences MM4x / MM0x – Sales Set Components

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 26

Functional Differences MM4x / MM0x – Basic Data (Generic Article)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 27

Functional Differences MM4x / MM0x – Basic Data (Generic Article)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 28

Functional Differences MM4x / MM0x – Basic Data (Variant)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 29

Functional Differences MM4x / MM0x – Charact. Value Restrictions

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 30

Functional Differences MM4x / MM0x – Variant Matrix

Supp
ort o
than f mor
2 d im e
ensio
ns

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 31

Functional Differences MM4x / MM0x – Variants Image Data

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 32

Functional Differences MM4x / MM0x – Variant GTINs Generation

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 33

Functional Differences MM4x / MM0x – Basic Data Fashion

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 34

Functional Differences MM4x / MM0x – Listing

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 35

Functional Differences MM4x / MM0x – Listing

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 36

Functional Differences MM4x / MM0x – Purchasing (Single Article)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 37

Functional Differences MM4x / MM0x – Purchasing (Generic Article)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 38

Functional Differences MM4x / MM0x – Variant Purchasing Prices

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 39

Functional Differences MM4x / MM0x – Sales (Single Article)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 40

Functional Differences MM4x / MM0x – Sales (Generic Article)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 41

Functional Differences MM4x / MM0x – Sales Price Calculation

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 42

Functional Differences MM4x / MM0x – Variant Sales Prices

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 43

Functional Differences MM4x / MM0x – Logistics DC

Fash
io n Ma
bring nage
s in s ment
ome So lu
tion
logis ad ditio
tics D nal
C tab
s
© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 44
Functional Differences MM4x / MM0x – Non-Reference DC

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 45

Functional Differences MM4x / MM0x – Logistics Store

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 46

Functional Differences MM4x / MM0x – Non-Reference Store

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 47

Functional Differences MM4x / MM0x – POS

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 48

Functional Differences MM4x / MM0x – Additional Data

Fash
i on M
bring anag
s in s emen
ome t Sol
addit ution
ional
tabs

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 49

Function Differences (Conceptional View)
Different concepts in Article Master Data (MM4x) compared to Material Master Data (MM0x)
Main Conceptional Improvements in MM4x

Reference Handling:

• Usage of Reference Sites

• Distinguishing between Distribution Centers and Stores

• Generic Article and Variants

• MARA->MARC and much more

• Vendor->MARC

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 51

Function Differences (Technical View)
Technical differences in Article Master Data (MM4x) compared to Material Master Data (MM0x)
Collection of Main Development Objects for MM0x / MM4x

Object MM0x MM4x

Packages MGA MGW

Function Groups MGD1, MGMM, MGMD, MGMV MGD2, MGMW, MGWD, MGUT, MGUV

Function Modules MATERIAL_MAINTAIN_DARK, MATERIAL_MAINTAIN_DARK_RETAIL,

MATERIAL_UPDATE_ALL, MATERIAL_UPDATE_ALL_RETAIL,
MATERIAL_UPDATE_DB MATERIAL_ARRAY_UPDATE_RETAIL(_2)
BAPIs BAPI_MATERIAL_SAVEREPLICA, BAPI_MATERIAL_MAINTAINDATA_RT
BAPI_MATERIAL_SAVEDATA

IDOCs MATMAS ARTMAS

Business Objects BUS1001006 BUS1001001
Change Documents MATERIAL MAT_FULL

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 53

Appendix
Thank you

Contact information:

Karin Blank
Retail Product

© 2015 SAP SE or an SAP affiliate company. All rights reserved.