Welcome! My friends!

LSMW Steps For Data Migration

上一篇 / 下一篇  2008-01-03 21:01:21 / 个人分类:SAP ABAP

How to develop a lsmw for data migration for va01 or xk01 transaction?

You can create lsmw for data migration as follows (using session method):

Example for xk01 (create vendor) ITPUB个人空间%TJ[DU
Initially there will be 20 steps but after processing 1 step it will reduced to 14 for session method.

1. TCode : LSMW. ITPUB个人空间1?$J ^`6Np D G&Z
2. Enter Project name, sub project name and object name.
%[h+Fcy)M0    Execute.
?S b#?S.KR6]S03. Maintain object attributes. ITPUB个人空间6_kI~O+mw B$P
    Execute
1d!ca3[mCg0    select Batch Input recording 
Q$j7qV L[G0    goto->Recording overview
9w5y,D'|3r&M[U%^0    create ITPUB个人空间 p1vC(_:V
    recording name.
-I k7o%~8`5N0    enter transaction code. ITPUB个人空间Q![^HC9] j3a(D5NP
    start recording ITPUB个人空间PMlt%B_ua U#V
    do recording as per ur choice.
1]8o h J8xi$X8H0    save + back. ITPUB个人空间5oO.k7st
    enter recording name in lsmw screen. ITPUB个人空间8V.e6_]Bb/t
    save + back

Now there will be 14 steps.
&W%S}wD/F02. MAINTAIN SOURCE STRUCTURES. ITPUB个人空间"KR.~MdF&BdQ5xS L
    Here you have  to enter the name of internal table.
]O]aV0    display change ITPUB个人空间-TS/t{&uaZ
    create  ITPUB个人空间!s1{-s\)g x-E4P
    save + back

3. MAINTAIN SOURCE FIELDS.
;Ba,B:o-Nqt0    display change
U3l3U1{#q h+ea*|}0    select structure
\ @V0ml$K0    source_fields->copy fields.
1aZRp%IZ+MR0    a dialogue window will come .
[ tu"N&h2ZAMC0    select -> from data file ITPUB个人空间Y.fu+L+Hs[Yh
    apply source fields
/`!^P'vR"c%^`E0    enter No. of fields 
/q/];hB!a](kd(a;]w]0    length of fields
9jE7VO0zA0    attach file
;c:_+x UJ;_|\%L]0    save + back

4. MAINTAIN STRUCTURE RELATIONS ITPUB个人空间!Lc LaLfu3dvB
    display change
Pg2~8qpi0    save + back

5. MAINTAN FIELD MAPPING & CONVERSION RULE
@[A]e-Oe"`w0    display change
1l3r6T\,A#d0    click on source field, select exact field from structue and enter
u7C3L4Vr)?'a0    repeat these steps for all fields. ITPUB个人空间O[TR7N/kse
    save+back

6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED
Q})YC5{k0    execute 
%uP@j2H(K&EL0    save + back

7. SPECIFY FILES. ITPUB个人空间\1z5Va)UN)o
    display change ITPUB个人空间qF C"n'b
    click on legacy data
}9b0SB-z+GEP:K#I0    attah flat file ITPUB个人空间x/p-V,@eI/Hs
    give description ITPUB个人空间0Y:a2P'd)jh
    select tabulatore  ITPUB个人空间cHqsE6JBF'C(U
    enter ITPUB个人空间6J W/U @'g&xb O-~N%P
    save + back

8. ASSIGN FILE 
df5Z/l+sf*KM8E0    execute  ITPUB个人空间 |afhZP
    display  change
| W$H0Qox%j0    save + back

9. IMPORT DATA.
8Z"M(r.Sx._Sm-T0    execute 
c`O zoY0    display  change ITPUB个人空间'~ E5{ UH!zq}
    save + back

10. DISPLAY IMPORTED DATA
l(n%N)_8|&e%bZ8m(e0      enter ok, it willl show records only. ITPUB个人空间(U%[VKt*^u i
      back

11. CONVERT DATA ITPUB个人空间4Nr&_)`*j0K#v
      execute  ITPUB个人空间&W4\Z}c] Ys
      display  change ITPUB个人空间 H;K%T:lj|+u Mr
      save + back

12. DISPLAY CONVERTED DATA
MP8R{tx0      execute 
F7RN$y/D:DX'r K0      display  change
3W*c ]1U:GN7E)F0      save + back

13. CREATE BATCH INPUT SESSION ITPUB个人空间WTc\+]0|R3h T
      tick keep batch input folder  ITPUB个人空间:Vw+{H"Y V!L+az/ZI
      F8 ITPUB个人空间Vo"_ k8q
      back

14. RUN BATCH INPUT SESSION.
HJ,Re+Chy0      sm35 will come
%K(Y/gt7Wc0      Object name will be shown here 
5h5e.t-l ]0      select object & process   ITPUB个人空间:~+r]N2|3@ ]&Yt0v"B


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-01-27  
  12345
6789101112
13141516171819
20212223242526
2728293031  

数据统计

  • 访问量: 6923
  • 日志数: 237
  • 图片数: 2
  • 影音数: 5
  • 文件数: 9
  • 建立时间: 2007-11-28
  • 更新时间: 2008-01-27

RSS订阅

Open Toolbar