LSMW - Examples

Project: Subproject: Object:

PROJECT00 LOGISTICS I!OCM"TLE

LSMW examples Log st cs !ata Mater al master # a I!OC

!ata tra$s%er program: M"TM"S0& !ata tra$s%er met'o(: I )I!oc*

Source structures
MATL - material master basic data MATL2 - material master consumption data

Target struct.
E1MARAM - Master material general data (MARA) E1MAKTM - Master material short texts (MAKT) E1MAR M - Master material segment (MAR ) E1M!E"M - Master material total consumption E1MARMM - Master material units o# measure (MARM) E1M$E%M - Master material material &aluation (M$E%)

Structure relations
E1MARAM '((( MATL E1MAKTM '((( MATL E1MAR M '((( MATL E1M!E"M '((( MATL2 E1MARMM '((( MATL E1M$E%M '((( MATL

Source fields
MATL - material master basic data MAT)R material number MATT.-E material t*pe 0E T1R industr* sector -LA)T plant L1 AT31) storage location 1M- 15E compan* code 7)3T unit o# measure TE9T short text 0TAT70 status to be trans#ered MAT"R17material group TRA)0"R transportation group

T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+

Lgth+,1, Lgth+,,/ Lgth+,,/ Lgth+,,/ Lgth+,,/ Lgth+,,/ Lgth+,,2 Lgth+,2, Lgth+,14 Lgth+,,4 Lgth+,,/

-osition+,,,1 -osition+,,,2 -osition+,,,2 -osition+,,,/ -osition+,,,4 -osition+,,,6 -osition+,,,8 -osition+,,,: -osition+,,,; -osition+,,1, -osition+,,11

16.01.14

-1-

LSMW - Examples
L1A5"R -osition+,,12 -7R <"R MRMR- 1)TR L1T <E K"R -ER315 0 <E5 0T1R 10T loading group purchasing group MR- t*pe MR- controller lot si=e chec> group #or a&ailabilit* period indicator sched marg? >e* #or #loats storage costs indicator T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ Lgth+,,/ Lgth+,,2 -osition+,,12 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,1 Lgth+,,2 Lgth+,,1 -osition+,,1/ -osition+,,14 -osition+,,16 -osition+,,18 -osition+,,1: -osition+,,1; -osition+,,2,

MATL2 - material master consumption data MAT)R material number 1)5ATE consumption date 1)!AL7E consumption &alue

Lgth+,1, -osition+,,,1 Lgth+,,: -osition+,,,2 Lgth+,1, -osition+,,,2

Target fields
E1MARAM - Master material general data (MARA) M0"@) @unction MAT)R Material number ER05A reation date ER)AM )ame o# -erson Aho reated the 1bBect LAE5A 5ate o# last change AE)AM )ame o# person Aho changed obBect -0TAT Maintenance status L!1RM @lag Material #or 5eletion at lient Le&el MTART Material t*pe M$R0< 3ndustr* sector MATKL Material group $30MT 1ld material number ME3)0 $ase unit o# measure $0TME 1rder unit CE3)R 5ocument number (Aithout document management s*stem) CE3AR 5ocument t*pe (Aithout 5ocument Management s*stem) CE3!R 5ocument &ersion (Aithout 5ocument Management s*stem) CE3@1 -age #ormat o# document (ADo 5ocument Management s*s?) AE0C) 5ocument change number (ADo document management s*s?) $LATT -age number o# document (ADo 5ocument Management s*s?) $LA)C )umber o# sheets (Aithout 5ocument Management s*stem) @ERT< -roductionDinspection memo @1RMT -age @ormat o# -roduction Memo "R1E0 0i=eDdimensions %RK0T $asic material (basic constituent o# a material) )1RMT 3ndustr* 0tandard 5escription (such as A)03 or 301) LA$1R Laborator*Ddesign o##ice EK%0L -urchasing &alue >e* $R"E% "ross Aeight )T"E% )et Aeight "E%E3 %eight 7nit !1L7M !olume !1LE< !olume unit $E<!1 ontainer reFuirements RA7$E 0torage conditions TEM-$ Temperature conditions indicator TRA"R Transportation group 0T1@@ <a=ardous material number 0-ART 5i&ision K7))R ompetitor %E0 < Euantit*+ )umber o# "RD"3 slips to be printed $%!1R -rocurement rule $%0 L 0ource o# 0uppl* 0A301 0eason categor* ET3AR Label t*pe T*pe+ <AR T*pe+ <AR T*pe+5AT0 T*pe+ <AR T*pe+5AT0 T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+7)3T T*pe+7)3T T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+)7M T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+E7A) T*pe+7)3T T*pe+E7A) T*pe+7)3T T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR Lgth+,,2 Lgth+,1: Lgth+,,: Lgth+,12 Lgth+,,: Lgth+,12 Lgth+,14 Lgth+,,1 Lgth+,,/ Lgth+,,1 Lgth+,,; Lgth+,1: Lgth+,,2 Lgth+,,2 Lgth+,22 Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,,6 Lgth+,,2 Lgth+,,2 Lgth+,1: Lgth+,,/ Lgth+,22 Lgth+,1/ Lgth+,1: Lgth+,,2 Lgth+,,/ Lgth+,1/ Lgth+,1/ Lgth+,,2 Lgth+,1/ Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,1: Lgth+,,2 Lgth+,1, Lgth+,1/ Lgth+,,1 Lgth+,,1 Lgth+,,/ Lgth+,,2

16.01.14

-2-

LSMW - Examples
ET3@1 T*pe+ <AR EA)11 )7MTLabel #orm Lgth+,,2 3nternational Article )umber (EA)D7- ) )umber categor* o# 3nternational Article )umber (EA)) Length %idth <eight 7nit o# dimension #or lengthDAidthDheight -roduct hierarch* A5 indicator AlloAed pac>aging Aeight %eight 7nit AlloAed pac>aging &olume !olume unit Excess Aeight tolerance #or shipping unit Excess &olume tolerance limit during pac>ing !ariable order unit acti&e on#igurable Material $atch management reFuirement indicator 0hipping material t*pe @illing le&el (b* &olume) 0tac>ing #actor Material group+ shipping materials Authori=ation group EM in -rocurement is Acti&e atalog -ro#ile Minimum remaining shel# li#e Total shel# li#e 0torage percentage Maintenance status o# complete material External material group ross--lant Material 0tatus ross-distribution-chain material status 5ate #rom Ahich cross-plant material status is &alid 5ate #rom Ahich 9-distr?-chain mat?- status is &alid 3ndicator+ En&ironmentall* rele&ant -roduct allocation determination procedure Material Fuali#ies #or discount in >ind Manu#acturer part number Manu#acturer number To material number M#r part pro#ile 5angerous goods indicator pro#ile 3ndicator+ <ighl* &iscous 3ndicator+ 3n bul>DliFuid 0hipping material is closed pac>aging 3ndicator+ Appro&ed batch record reFuired Material completion le&el Assign e##ecti&it* parameter &aluesD Rounding rule #or calculation o# 0LE5 -eriod indicator #or shel# li#e expiration date 3ndicator+ -roduct composition printed on pac>aging "eneral item categor* group Excess Aeight tolerance #or shipping unit Excess &olume tolerance limit during pac>ing $asic Material

T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+7)3T T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+7)3T T*pe+E7A) T*pe+7)3T T*pe+5E T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+3)T2 T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+5E T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5AT0 T*pe+5AT0 T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+)7M T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+LA)" T*pe+ <AR T*pe+ <AR T*pe+ T*pe+ T*pe+ T*pe+ T*pe+ <AR <AR <AR <AR <AR

Lgth+,1: Lgth+,,2 Lgth+,1/ Lgth+,1/ Lgth+,1/ Lgth+,,2 Lgth+,1: Lgth+,,1 Lgth+,1/ Lgth+,,2 Lgth+,1/ Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,/ Lgth+,,2 Lgth+,,4 Lgth+,,/ Lgth+,,/ Lgth+,,1 Lgth+,,; Lgth+,,6 Lgth+,,6 Lgth+,,4 Lgth+,14 Lgth+,1: Lgth+,,2 Lgth+,,2 Lgth+,,: Lgth+,,: Lgth+,,1 Lgth+,1: Lgth+,,1 Lgth+,/, Lgth+,1, Lght+,1: Lgth+,,/ Lgth+,,2 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,2 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,/ Lgth+,,4 Lgth+,,4 Lgth+,/: Lgth+,,2 Lgth+,,1 Lgth+,/, Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,14 Lgth+,,1 Lgth+,,1

LAE)" $RE3T <1E<E MEA$M -R5<A A5KC ER"E% ER"E3 ER!1L ER!1E "E%T1 !1LT1 !A$ME KCK@" 9 <-@ !<ART @7EL" 0T@AK MA"R! $E"R7 EM-7R R$)RM M<5RC M<5<$ M<5L!-0TA E9T%" M0TAE M0TA! M0T5E M0T5! KC7M% K10 < )R@<" M@R-) M@R)R $MAT) M-R1@ -R1@L 3<3!3 3L110 KC"!< 9" <1M-L KCE@@ R5M<5 3-RKC -RC70 MT-10GMARA "E%T1G)E% !1LT1G)E% %RK0TG)E%

E1MAKTM - Master material short texts (MAKT) M0"@) @unction 0-RA0 Language Ke* MAKT9 Material description 0-RA0G301 Language according to 301 62; E1MAR M - Master material segment (MAR ) M0"@) @unction %ERK0 -lant -0TAT Maintenance status L!1RM 5eletion #lag $%TT. !aluation categor*

16.01.14

-3-

LSMW - Examples
MAA$ T*pe+ <AR KCKR3 EK"RA70ME 530-R 530MM 530-1 -L3@C %E$AC -ERKC A7000 530L0 $E0KC 01$0L M3)$E E30$E $0TM3 $0TMA $0T@E $0TR@ MA$0T L10@9 0$5KC LA"-R ALT0L KCA70 A705T )@MAT KC$E5 M30KC @<1R3 -@RE3 @@RE3 R"EKC @E!1R $EARC R7ECT TRA)C $A0M" 5CE3T MA9LC LCE3< KC-R1 "-MKC 7EET1 7EETK 7)ET1 %CE3T AT-KC !C70L <ER$L 3)0MK 00E00 KC5KC 7MLM LA5"R 9 <-@ 70EE7 L"RA5 A7@TL -L!AR 1T.-E 1$H35 MT!@-ER3! KCK@K !R!EC A$ indicator Lgth+,,1 3ndicator+ ritical part -urchasing group 7nit o# issue Material+ MR- pro#ile MR- t*pe MR- controller -lanned deli&er* time in da*s "oods receipt processing time in da*s -eriod indicator Assembl* scrap in percent Lot si=e (materials planning) -rocurement T*pe 0pecial procurement t*pe Reorder point 0a#et* stoc> Minimum lot si=e Maximum lot si=e @ixed lot si=e Rounding &alue #or purchase order Fuantit* Maximum stoc> le&el 1rdering costs 5ependent reFmts ind? #or indi&idual and coll? reFmts 0torage costs indicator Method #or 0electing Alternati&e $ills o# Material 5iscontinuation indicator E##ecti&e-out date @olloA-up material 3ndicator #or ReFuirements "rouping Mixed MR- indicator 0cheduling Margin Ke* #or @loats 3ndicator+ automatic #ixing o# planned orders Release indicator #or production orders 3ndicator+ $ac>#lush -roduction scheduler -rocessing time 0etup and teardoAn time 3nteroperation time $ase Fuantit* 3n-house production time Maximum storage period 7nit #or maximum storage period 3ndicator+ AithdraAal o# stoc> #rom production bin 3ndicator+ material included in rough-cut planning 1&erdeli&er* tolerance limit 3ndicator+ 7nlimited o&erdeli&er* alloAed 7nderdeli&er* tolerance limit Total replenishment lead time (in Aor>da*s) Replacement part 0urcharge #actor #or cost in percent 0tate o# manu#acture -ost to inspection stoc> EA control >e* 5ocumentation reFuired indicator 0toc> in trans#er (plant to plant) Loading group $atch management reFuirement indicator Euota arrangement usage 0er&ice le&el 0plitting 3ndicator -lan &ersion 1bBect t*pe 1bBect 35 hec>ing group #or a&ailabilit* chec> @iscal *ear &ariant 3ndicator+ ta>e correction #actors into account 0hipping setup time

T*pe+ <AR T*pe+ <AR T*pe+7)3T T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+5E T*pe+ <AR T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+ 7RR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5AT0 T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+5E T*pe+5E T*pe+E7A) T*pe+5E T*pe+5E T*pe+7)3T T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+ <AR T*pe+5E T*pe+5E T*pe+ <AR T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+)7M T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E

Lgth+,,1 Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,1 Lgth+,,4 Lgth+,,2 Lgth+,,1 Lgth+,,2 Lgth+,1/ Lgth+,1/ Lgth+,1/ Lgth+,1/ Lgth+,1/ Lgth+,1/ Lgth+,1/ Lgth+,12 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,: Lgth+,1: Lgth+,,1 Lgth+,,1 Lgth+,,2 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,2 Lgth+,,6 Lgth+,,6 Lgth+,,6 Lgth+,1/ Lgth+,,2 Lgth+,,4 Lgth+,,2 Lgth+,,1 Lgth+,,1 Lgth+,,/ Lgth+,,1 Lgth+,,/ Lgth+,,2 Lgth+,,1 Lgth+,,4 Lgth+,,2 Lgth+,,1 Lgth+,,: Lgth+,,1 Lgth+,1/ Lgth+,,/ Lgth+,,1 Lgth+,,1 Lgth+,,/ Lgth+,,1 Lgth+,,2 Lgth+,,2 Lgth+,,: Lgth+,,2 Lgth+,,2 Lgth+,,1 Lgth+,,6

16.01.14

-4-

LSMW - Examples
!$AM" T*pe+E7A) !$EAC L3C.K $%0 L KA7T$ K1R5$ 0TA%) <ERKL <ERKR E9-ME MT!ER -R TR TRAME MR--0A7@T @9<1R !RM15 !3)T1 !3)T2 0TLAL 0TLA) -L))R A-LAL L10"R 01$0K @RTME L"-R1 530"R KA70@ EC"TTAKCT R%-R1 1-AM A$ 3) A%0L0 0ER)0T5-5 0@E-R 9M )" E00.0 L@R<. R5-R@ !R$MT !R$%K !R$5T !R$@K A7TR7 -RE@E -RE) -RE)1 -RE)5 -RE)E -RE)" 3TARK -R@RE KCK70TR"R L"@0$ 0 <"T @39 E-R31 EMATA -L)T. MM0TA 0@ -@ 0<@L" 0<CET M5A < $ase Fuantit* #or capacit* planning in shipping Lgth+,1/ 0hipping processing time 5eli&er* c*cle 0ource o# 0uppl* 3ndicator+ Iautomatic purchase order alloAedI 3ndicator+ 0ource list reFuirement ommodit* code D 3mport code number #or #oreign trade ountr* o# origin o# the material Region o# origin o# material (non-pre#erential origin) 7nit o# measure #or commodit* code (#oreign trade) ExportDimport material group -ro#it center 0toc> in transit -- planning calendar 3nd?+ Repetiti&e m#g alloAed -lanning time #ence onsumption mode onsumption period+ bac>Aard onsumption period+ #orAard Alternati&e $1M $1M usage Ke* #or tas> list group "roup counter osting lot si=e 0pecial -rocurement T*pe #or osting -roduction unit 3ssue storage location MR- "roup omponent scrap in percent erti#icate T*pe Ta>t time Range o# co&erage pro#ile Local #ield name #or 1D-A lin> to 01-h*sical in&entor* indicator #or c*cle counting !ariance >e* 0erial )umber -ro#ile on#igurable material Repetiti&e manu#acturing pro#ile )egati&e stoc>s alloAed in plant ReFuired EM 0*stem #or !endor -lanning c*cle Rounding pro#ile Re#erence material #or consumption Re#erence plant #or consumption To date o# the material to be copied #or consumption Multiplier #or re#erence material #or consumption Reset #orecast model automaticall* -re#erence indicator in exportDimport Exemption certi#icate+ 3ndicator #or legal control )umber o# exemption certi#icate in exportDimport 3ssue date o# exemption certi#icate 3ndicator+ !endor declaration exists !alidit* date o# &endor declaration 3ndicator+ Militar* goods haracter #ield Aith #ield length 8 3ndicator+ Material can be co-product -lanning strateg* group 5e#ault storage location #or external procurement 3ndicator+ bul> material indicator is #ixed %ithdraAal seFuence group #or stoc>s Material Authori=ation "roup #or Acti&ities in EM Tas> list t*pe -lant-0peci#ic Material 0tatus -roduction scheduling pro#ile 0a#et* time indicator (Aith or Aithout sa#et* time) 0a#et* time (in Aor>da*s) Action control+ planned order processing

T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+7)3T T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+ <AR T*pe+ <AR T*pe+)7M T*pe+ <AR T*pe+)7M T*pe+)7M T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+ <AR T*pe+7)3T T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+ <AR T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5AT0 T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+)7M T*pe+5AT0 T*pe+ <AR T*pe+5AT0 T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+)7M T*pe+ <AR

Lgth+,,6 Lgth+,,/ Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,18 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,1, Lgth+,14 Lgth+,,2 Lgth+,,1 Lgth+,,2 Lgth+,,1 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,1 Lgth+,,: Lgth+,,2 Lgth+,1/ Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,,/ Lgth+,,4 Lgth+,,/ Lgth+,,2 Lgth+,,2 Lgth+,1, Lgth+,,1 Lgth+,,6 Lgth+,,/ Lgth+,1: Lgth+,,/ Lgth+,,1 Lgth+,,/ Lgth+,,2 Lgth+,,/ Lgth+,1: Lgth+,,/ Lgth+,,: Lgth+,,4 Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,: Lgth+,,: Lgth+,,1 Lgth+,,: Lgth+,,1 Lgth+,,8 Lgth+,,1 Lgth+,,2 Lgth+,,/ Lgth+,,1 Lgth+,,1 Lgth+,,/ Lgth+,,6 Lgth+,,1 Lgth+,,2 Lgth+,,6 Lgth+,,1 Lgth+,,2 Lgth+,,2

16.01.14

-5-

LSMW - Examples
KCE < T*pe+ <AR MM0T5 M@R"R @!35K 3)570 M1%)R M1"R7 A0)R "-)7M 0TE7 @A$KC MAT"R L1""R !0-!$ 5-L@0 5-L-7 5-L<1 M3)L0 MA9L0 @39L0 LT3) 1M-L 1)!T @-R@M 0<-R1 @9-R7 KC-01 M-@ A-1KC A<530 E30L1 ) 10T ME"R7 5etermination o# batch entr* in the production Lgth+,,1 5ate #rom Ahich plant-speci#ic material status &alid Material #reight group -roduction &ersion to be costed Material @1- categor* A-+ )umber o# A- products list ommon Agricultural -olic*+ A0 number #or pharmaceutical products #oreign trade -roduction stat?+ -R15 1M number #or #oreign trade ontrol code #or consumption taxes in #oreign trade 3ndicator+ 3tem rele&ant to H3T deli&er* schedules "roup o# materials #or transition matrix Logistics handling group #or Aor>load calculation -roposed 0uppl* Area in Material Master Record @air share rule 3ndicator+ push distribution 5eplo*ment hori=on in da*s Minimum lot si=e #or 0uppl* 5emand Match Maximum lot si=e #or 0uppl* 5emand Match @ixed lot si=e #or 0uppl* 5emand Match Lot si=e increment #or 0uppl* 5emand Match Material completion le&el on&ersion t*pes #or production #igures 5istribution pro#ile o# material in plant -eriod pro#ile #or sa#et* time @ixed-price co-product 3ndicator #or cross-proBect material -ro#ile #or 1 M -- D -0 3ndicator+ 3s material rele&ant #or A-1 MR- rele&anc* #or dependent reFuirements Minimum sa#et* stoc> )o osting 7nit o# measure group

T*pe+5AT0 T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+)7M T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5AT0 T*pe+E7A) T*pe+E7A) T*pe+ <AR T*pe+5E T*pe+ <AR T*pe+7)3T T*pe+5E T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+E7A) T*pe+E7A) T*pe+E7A) T*pe+7)3T T*pe+E7A) T*pe+7)3T T*pe+E7A) T*pe+7)3T T*pe+7)3T T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ 7RR T*pe+ 7RR T*pe+5E

Lgth+,,: Lgth+,,: Lgth+,,/ Lgth+,,2 Lgth+,12 Lgth+,,6 Lgth+,14 Lgth+,,; Lgth+,16 Lgth+,,1 Lgth+,2, Lgth+,,/ Lgth+,1, Lgth+,,2 Lgth+,,1 Lgth+,,/ Lgth+,14 Lgth+,14 Lgth+,14 Lgth+,14 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,1 Lgth+,,1 Lgth+,,6 Lgth+,,1 Lgth+,,1 Lgth+,14 Lgth+,,1 Lgth+,,/ Lgth+,,2 Lgth+,,: Lgth+,14 Lgth+,14 Lgth+,,1 Lgth+,,6 Lgth+,,2 Lgth+,,2 Lgth+,,4 Lgth+,,4 Lgth+,1: Lgth+,,2 Lgth+,1/ Lgth+,1/ Lgth+,1/ Lgth+,,2 Lgth+,1/ Lgth+,,2 Lgth+,1/ Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,1, Lgth+,,1 Lgth+,,1 Lgth+,12 Lgth+,12 Lgth+,,4

E1M!E"M - Master material total consumption M0"@) @unction ERTA" @irst da* o# the period to Ahich the &alues re#er !$%RT onsumption &alue K1!$% orrected consumption &alue KCE93 hec>box A)TE3 Ratio o# the corrected &alue to the original &alue E1MARMM - Master material units o# measure (MARM) M0"@) @unction ME3)< Alternati&e unit o# measure #or stoc>>eeping unit 7MREC )umerator #or on&ersion to $ase 7nits o# Measure 7MRE) 5enominator #or con&ersion to base units o# measure EA)11 3nternational Article )umber (EA)D7- ) )7MT)umber categor* o# 3nternational Article )umber (EA)) LAE)" Length $RE3T %idth <1E<E <eight MEA$M 7nit o# dimension #or lengthDAidthDheight !1L7M !olume !1LE< !olume unit $R"E% "ross Aeight "E%E3 %eight 7nit ME07$ LoAer-Le&el 7nit o# Measure in a -ac>ing <ierarch* E1M$E%M - Master material material &aluation (M$E%) M0"@) @unction $%KE. !aluation area $%TAR !aluation t*pe L!1RM 5eletion #lag !-R0! -rice control indicator !ER-R Mo&ing a&erage priceDperiodic unit price 0T-R0 0tandard price -E3)< -rice unit

16.01.14

-6-

LSMW - Examples
$KLA0 T*pe+ <AR !M!-R !M!ER !M0T!M-E3 !M$KL !H!-R !H!ER !H0TL@"HA L@M1) $%TT. CK-R0 CK5AT $%-R0 $%-R< !H$%0 !H$%< !!HL$ !!ML$ !!0AL C-L-R C-L-1 C-L-2 C-L-2 C-L51 C-L52 C-L52 KALKC KALKL 9L3@1 M.-1L $%-<1 $%-01 A$%KC -0TAT KAL)1 KAL)R $%!A1 $%!A2 $%!A2 !ER01 !ER02 !ER02 <RK@T K10"R --R5C --R5L --R5! -5ATC -5ATL -5AT! EKALR !-L-R MLMAA MLA0T !H$KL !H-E3 <KMAT EKLA0 EKLA0 MT70E MT1R" 1%)-R $%-E3 !aluation class Lgth+,,/ -rice control indicator #or pre&ious period Mo&ing a&erageDperiodic unit price in pre&ious period 0tandard price in the pre&ious period -rice unit o# pre&ious period !aluation class o# pre&ious period -rice control indicator #or pre&ious *ear Mo&ing a&erage periodic unit price in pre&ious *ear 0tandard price in pre&ious *ear @iscal *ear o# current period urrent period (posting period) !aluation categor* @uture price 5ate as o# Ahich the price is &alid !aluation price based on tax laA+ le&el 1 !aluation price based on commercial laA+ le&el 1 !aluation price based on tax laA+ le&el 2 !aluation price based on commercial laA+ le&el 2 Total &aluated stoc> in *ear be#ore last Total &aluated stoc> in period be#ore last !alue o# total &aluated stoc> in period be#ore last @uture planned price @uture -lanned -rice 1 @uture -lanned -rice 2 @uture -lanned -rice 2 5ate #rom %hich @uture -lanned -rice 1 3s !alid 5ate #rom %hich @uture -lanned -rice 2 3s !alid 5ate #rom %hich @uture -lanned -rice 2 3s !alid 3ndicator+ 0tandard cost estimate #or the period 3ndicator+ standard cost estimate #or current period L3@1D@3@1-rele&ant -ool number #or L3@1 &aluation !aluation price based on commercial laA+ le&el 2 !aluation price based on tax laA+ le&el 2 LoAest &alue+ de&aluation indicator Maintenance status ost estimate number - product costing ost est number #or cost est ADo Ft* structure !aluation &ariant #or #uture standard cost estimate !aluation &ariant #or current standard cost estimate !aluation &ariant #or past standard cost estimate osting &ersion o# the #uture standard cost estimate osting &ersion o# the current standard cost estimate osting &ersion o# the pre&ious standard cost estimate 1rigin "roup as 0ubdi&ision o# ost Element osting o&erhead group -eriod o# #uture cost estimate -eriod o# the current cost estimate -eriod o# the pre&ious cost estimate @uture #iscal *ear @iscal *ear #or current cost estimate @iscal *ear o# pre&ious cost estimate Material is costed Aith Fuantit* structure -re&ious planned price Material ledger acti&ated at material le&el Material -rice 5etermination+ ontrol !aluation class #rom pre&ious *ear -rice unit o# pre&ious *ear Material-related origin !aluation lass #or 0ales 1rder 0toc> !aluation lass #or -roBect 0toc> 7sage o# the material 1rigin o# the material -roduced in-house -rice unit &al? prices based on taxDcommercial laA

T*pe+ <AR T*pe+ 7RR T*pe+ 7RR T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ 7RR T*pe+ 7RR T*pe+)7M T*pe+)7M T*pe+ <AR T*pe+ 7RR T*pe+5AT0 T*pe+ 7RR T*pe+ 7RR T*pe+ 7RR T*pe+ 7RR T*pe+E7A) T*pe+E7A) T*pe+ 7RR T*pe+ 7RR T*pe+ 7RR T*pe+ 7RR T*pe+ 7RR T*pe+5AT0 T*pe+5AT0 T*pe+5AT0 T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ 7RR T*pe+ 7RR T*pe+)7M T*pe+ <AR T*pe+)7M T*pe+)7M T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+)7M T*pe+)7M T*pe+)7M T*pe+ <AR T*pe+ <AR T*pe+)7M T*pe+)7M T*pe+)7M T*pe+)7M T*pe+)7M T*pe+)7M T*pe+ <AR T*pe+ 7RR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+ <AR T*pe+5E

Lgth+,,1 Lgth+,12 Lgth+,12 Lgth+,,4 Lgth+,,/ Lgth+,,1 Lgth+,12 Lgth+,12 Lgth+,,/ Lgth+,,2 Lgth+,,1 Lgth+,12 Lgth+,,: Lgth+,12 Lgth+,12 Lgth+,12 Lgth+,12 Lgth+,14 Lgth+,14 Lgth+,14 Lgth+,12 Lgth+,12 Lgth+,12 Lgth+,12 Lgth+,,: Lgth+,,: Lgth+,,: Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,/ Lgth+,12 Lgth+,12 Lgth+,,2 Lgth+,14 Lgth+,12 Lgth+,12 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,1, Lgth+,,2 Lgth+,,2 Lgth+,,2 Lgth+,,/ Lgth+,,/ Lgth+,,/ Lgth+,,1 Lgth+,12 Lgth+,,1 Lgth+,,1 Lgth+,,/ Lgth+,,8 Lgth+,,1 Lgth+,,/ Lgth+,,/ Lgth+,,1 Lgth+,,1 Lgth+,,1 Lgth+,,6

16.01.14

-7-

LSMW - Examples Fieldmapping

All #ields not listed o# the R'( structures )eep their initial &alues* +truct*, E1MARAM GG$E"3)G1@GRE 1R5GG gGediddGsegnam ( JE2MARAM,,1J? gGediddGsegnum ( J,,,1J? gGediddGpsgnum ( J,,,,,,J? gGediddGhle&el ( J,2J? clear E1MARAM? E1MARAM-M0"@) Rule t*pe+ onstant E1MARAM-M0"@) ( J,,/J? E1MARAM-MAT)R '((( MATL-MAT)R Rule t*pe+ -re#ix concatenate J"R,,J MATL-MAT)R into E1MARAM-MAT)R? E1MARAM-ER05A Rule t*pe+ A$A- oding K Ciel#eld+ E1MARAM-ER05A Erstellungsdatum E1MARAM-ER05A ( 0.-5AT7M? E1MARAM-ER)AM Rule t*pe+ A$A- oding K Ciel#eld+ E1MARAM-ER)AM )ame des 0achbearbeitersL der das 1bBe>t hin=u E1MARAM-ER)AM ( 0.-7)AME? E1MARAM--0TAT Rule t*pe+ onstant E1MARAM--0TAT ( J$J? E1MARAM-MTART '((( MATL-MATT.-E Rule t*pe+ A$A- oding E1MARAM-MTART ( MATL-MATT.-E? TRA)0LATE E1MARAM-MTART T1 7--ER E1MARAM-M$R0< '((( MATL-0E T1R Rule t*pe+ Translation (reusable) per#orm lsmAGtranslate using JM$R0<J MATL-0E T1R changing E1MARAM-M$R0<? E1MARAM-MATKL '((( MATL-MAT"R17Rule t*pe+ Translation (reusable) per#orm lsmAGtranslate using JMATKLJ MATL-MAT"R17changing E1MARAM-MATKL? E1MARAM-ME3)0 '((( MATL-7)3T Rule t*pe+ A$A- oding E1MARAM-ME3)0 ( MATL-7)3T? TRA)0LATE E1MARAM-ME3)0 T1 7--ER 16.01.14

A0E?

A0E? -8-

LSMW - Examples

E1MARAM-TRA"R '((( MATL-TRA)0"R Rule t*pe+ Trans#er (M1!E) E1MARAM-TRA"R ( MATL-TRA)0"R? GGE)5G1@GRE 1R5GG trans#erGrecord? +truct*, E1MAKTM GG$E"3)G1@GRE 1R5GG gGediddGsegnam ( JE2MAKTM,,1J? gGediddGsegnum ( J,,,2J? gGediddGpsgnum ( J,,,,,1J? gGediddGhle&el ( J,2J? clear E1MAKTM? E1MAKTM-M0"@) Rule t*pe+ onstant E1MAKTM-M0"@) ( J,,/J? E1MAKTM-0-RA0 Rule t*pe+ onstant E1MAKTM-0-RA0 ( J5J? E1MAKTM-MAKT9 '((( MATL-TE9T Rule t*pe+ Trans#er (M1!E) E1MAKTM-MAKT9 ( MATL-TE9T? GGE)5G1@GRE 1R5GG trans#erGrecord? +truct*, E1MAR M GG$E"3)G1@GRE 1R5GG gGediddGsegnam ( JE2MAR M,,1J? gGediddGsegnum ( J,,,2J? gGediddGpsgnum ( J,,,,,1J? gGediddGhle&el ( J,2J? clear E1MAR M? E1MAR M-M0"@) Rule t*pe+ onstant E1MAR M-M0"@) ( J,,/J? E1MAR M-%ERK0 '((( MATL--LA)T Rule t*pe+ Trans#er (M1!E) E1MAR M-%ERK0 ( MATL--LA)T? E1MAR M--0TAT Rule t*pe+ onstant E1MAR M--0TAT ( JA$ 5E@"KL-E0!9CJ? E1MAR M-$%TT. Rule t*pe+ onstant E1MAR M-$%TT. ( J$J? E1MAR M-EK"R- '((( MATL--7R <"R Rule t*pe+ Trans#er (M1!E) E1MAR M-EK"R- ( MATL--7R <"R? 16.01.14 -9-

LSMW - Examples

E1MAR M-530MM '((( MATL-MRRule t*pe+ A$A- oding E1MAR M-530MM ( MATL-MR-? TRA)0LATE E1MAR M-530MM T1 7--ER E1MAR M-530-1 '((( MATL-MR- 1)TR Rule t*pe+ Trans#er (M1!E) E1MAR M-530-1 ( MATL-MR- 1)TR? E1MAR M--ERKC '((( MATL--ER315 Rule t*pe+ Trans#er (M1!E) E1MAR M--ERKC ( MATL--ER315? E1MAR M-530L0 '((( MATL-L1T Rule t*pe+ A$A- oding E1MAR M-530L0 ( MATL-L1T? TRA)0LATE E1MAR M T1 7--ER

A0E?

A0E?

E1MAR M-LA"-R Rule t*pe+ Trans#er (M1!E) E1MAR M-LA"-R ( MATL-0T1R 10T? E1MAR M-@<1R3 Rule t*pe+ Trans#er (M1!E) E1MAR M-@<1R3 ( MATL-0 <E5? E1MAR M-LA5"R '((( MATL-L1A5"R Rule t*pe+ Trans#er (M1!E) E1MAR M-LA5"R ( MATL-L1A5"R? E1MAR M-MT!@- '((( MATL- <E K"R Rule t*pe+ Trans#er (M1!E) E1MAR M-MT!@- ( MATL- <E K"R? E1MAR M-L10"R Rule t*pe+ onstant E1MAR M-L10"R ( J1,,,J? E1MAR M-L"-R1 '((( MATL-L1 AT31) Rule t*pe+ Trans#er (M1!E) E1MAR M-L"-R1 ( MATL-L1 AT31)? GGE)5G1@GRE 1R5GG trans#erGrecord? +truct*, E1M!E"M GG$E"3)G1@GRE 1R5GG gGediddGsegnam ( JE2M!E"MJ? gGediddGsegnum ( J,,,;J? gGediddGpsgnum ( J,,,,,2J? gGediddGhle&el ( J,/J? clear E1M!E"M? E1M!E"M-M0"@) Rule t*pe+ onstant E1M!E"M-M0"@) ( J,,/J? E1M!E"M-ERTA" '((( MATL2- 1)5ATE Rule t*pe+ Trans#er (M1!E) 16.01.14 - 10 -

LSMW - Examples
E1M!E"M-ERTA" ( MATL2- 1)5ATE? E1M!E"M-!$%RT '((( MATL2- 1)!AL7E Rule t*pe+ Trans#er (M1!E) E1M!E"M-!$%RT ( MATL2- 1)!AL7E? GGE)5G1@GRE 1R5GG trans#erGrecord? +truct*, E1MARMM GG$E"3)G1@GRE 1R5GG gGediddGsegnam ( JE2MARMMJ? gGediddGsegnum ( J,,12J? gGediddGpsgnum ( J,,,,,1J? gGediddGhle&el ( J,2J? clear E1MARMM? E1MARMM-M0"@) Rule t*pe+ onstant E1MARMM-M0"@) ( J,,/J? E1MARMM-ME3)< Rule t*pe+ onstant E1MARMM-ME3)< ( J0TJ? GGE)5G1@GRE 1R5GG trans#erGrecord? +truct*, E1M$E%M GG$E"3)G1@GRE 1R5GG gGediddGsegnam ( JE2M$E%M,,1J? gGediddGsegnum ( J,,1/J? gGediddGpsgnum ( J,,,,,1J? gGediddGhle&el ( J,2J? clear E1M$E%M? E1M$E%M-M0"@) Rule t*pe+ onstant E1M$E%M-M0"@) ( J,,/J? E1M$E%M-$%KE. Rule t*pe+ onstant E1M$E%M-$%KE. ( J,,,1J? E1M$E%M-!-R0! Rule t*pe+ onstant E1M$E%M-!-R0! ( J0J? E1M$E%M--E3)< Rule t*pe+ onstant E1M$E%M--E3)< ( J1,J? E1M$E%M-$KLA0 Rule t*pe+ onstant E1M$E%M-$KLA0 ( J2,,,J? E1M$E%M-!M!-R Rule t*pe+ 16.01.14 onstant - 11 -

LSMW - Examples
E1M$E%M-!M!-R ( J0J? E1M$E%M-!M-E3 Rule t*pe+ onstant E1M$E%M-!M-E3 ( J1,J? E1M$E%M-!M$KL Rule t*pe+ onstant E1M$E%M-!M$KL ( J2,,,J? E1M$E%M-!H!-R Rule t*pe+ onstant E1M$E%M-!H!-R ( J0J? E1M$E%M-!H$KL Rule t*pe+ onstant E1M$E%M-!H$KL ( J2,,,J? E1M$E%M-!H-E3 Rule t*pe+ onstant E1M$E%M-!H-E3 ( J1,J? GGE)5G1@GRE 1R5GG trans#erGrecord? GGE)5G1@GTRA)0A T31)GG trans#erGtransaction?

16.01.14

- 12 -