extracting mm purchasing data into sap bw

Upload: deweshchandra

Post on 07-Aug-2018

224 views

Category:

Documents


1 download

TRANSCRIPT

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    1/27

    Extracting MM (Purchasing) Transaction Datafrom BW 2.0B

    BUSINESSINFORMATIONWAREHOUSE2.0B

    Version 1

    Last hange! on" 2#.0$.2001

    o%&rightCopyright 2001 SAP Markt! E"rop #$%H. A&& right! r!r'(.

    2001 SAP Markets Europe GmbH 1

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    2/27

    ontents

    1 INTRODUCTION...........................................................................................................................................3

    2 NEW EXTRACTORS/DATASOURCES WITH BW RELEASE 2.0B/R/3 PLUGIN PI 2000.1......... ....5

    2.1 THEDESIGNOFTHENEWEXTA!TST"!T"ES................................................................................... #

    2.2 ADMINISTATI$ETA%&ESFODEFININGEXTA!TST"!T"ESANDFO&IN'INGEXTA!T

    ST"!T"ESTODATASO"!ES............................................................................................................................(

    3 PREPARATION STEPS FOR EXTRACTION.................................................................................. .........9

    ).1 TANSFEING%"SINESS!ONTENTDATASO"!ES................................................................................ *

    ).2 MAINTAININGEXTA!TST"!T"ES...................................................................................................... *

    ).) MAINTAININGPO!ESS'E+S.................................................................................................................10

    3.3.1 Process Keys................................................................................................................................ ...10

    3.3.2 Process Key Determination.............................................................................................................11

    )., DATASO"!EMAINTENAN!E..................................................................................................................1)3.4.1 Reversability of Fields....................................................................................................................13

    3.4.2 Defining Selection Fields for InfoPacages...................................................................................14

    3.4.3 !iding Fields in t"e #$.................................................................................................................14

    4 EXTRACTING TRANSACTION DATA....................................................................................... ......... ...16

    ,.1 INITIA&I-INGOFTANSA!TIONDATASET"POFEXISTINGDO!"MENTS/............................................ 1#

    4.1.1 Feat%res &"en 'arrying (%t Set%) in t"e (*+P............................................................................1,

    4.1.2 -traction &it" t"e /)date ode F%ll /)date.............................................................................1,

    ,.2 DE&TA"P&OADOFEXTA!TIONDATATOTHEO&TP............................................................................1(

    4.2.1 at"ering Data for t"e 3 /)date.................................................................................................1

    4.2.2 Starting t"e 3 /)date...................................................................................................................15

    ,.) FEAT"ESOFDE&TA"PDATEINP"!HASING........................................................................................20

    4.3.1 Delta %)date only for relevant c"anges..........................................................................................204.3.2 (DS 'a)ability of P%rc"asing DataSo%rces..................................................................................20

    5 EXTRACTION LOG....................................................................................................................................21

    6 ENHANCING/CHANGING EXTRACT STRUCTURES........................................................................22

    #.1 &ATEENHAN!EMENTOFEXTA!TST"!T"E...................................................................................2,

    #.2 IN$A&IDFIE&DSINTHE&IS !OMM"NI!ATIONST"!T"ES..................................................................2,

    7 CHANGING OER FRO! LIS DATASOURCES TO "NEW" PURCHASING DATASOURCES OF

    THE LOGISTICS EXTRACT STRUCTURE CUSTO!I#ING COC$PIT............................................ .....26

    2001 SAP Markets Europe GmbH 2

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    3/27

    Etrakto %e3e4u4s5ate MM

    1 'ntro!uction

    Thi! (o)"$*t )o*tai*! i*+or$atio* a%o"t ,tra)tor! a*( -ataSo"r)! +or ,tra)ti*g

    P"r)ha!i*g tra*!a)tio* (ata that ar (&i'r( +or th +ir!t ti$ ith r&a! BW 2.0Ba*( PI 2000.1 or PI/A 2000.1 'a&i( +ro$ R/R&a! 3.0B 4. It !r'! a! a!"pp&$*t to !ta*(ar( SAP (o)"$*tatio*.

    Th i*+or$atio* )o*tai*( i* thi! (o)"$*t i! 'a&i( at th ti$ o+ p"%&i!hi*g. It i! *ot,ha"!ti' a*( $ay *( "p(ati*g +or +"rthr r&a!!

    Th targt gro"p o+ th papr i! pri$ari&y )o*!"&ta*t!5 a! && a! )"!to$r$p&oy! ho ar a)ti' i* SAP BW ("ri*g th BW pro6)t5 or ()i!io* $akr! hoar a!!!!i*g th pro6)t7! +a!i%i&ity+"t"r po!!i%i&iti!.

    8*o&(g o+ th opratio*a& pro)!!! i* MM P"r)ha!i*g45 a! && a! k*o&(go+ th B"!i*!! I*+or$atio* Warho"! SAP BW4 ara5 i! a* i$porta*t5 %"t *ota%!o&"t&y *)!!ary5 prr9"i!it +or a +"&& "*(r!ta*(i*g o+ th +o&&oi*gpro)("r!.

    Th (o)"$*t )o*tai*! a* o'r'i o+ a&& th *)!!ary !tp! +or a)ti'ati*g a*()arryi*g o"t !"))!!+"& (ata ,tra)tio*.It a&!o ,a$i*!5 i* (tai&5 th )o*)ptio* a*( t)h*i)a& %a)kgro"*( o+ thi!,tra)tio*5 !o that yo" )a* gai* a* i*itia& o'r'i o+ th po!!i%i&iti!5 a*( a&!o th&i$itatio*!5 o+ ,tra)ti*g p"r)ha!i*g tra*!a)tio* (ata.

    Th app&i)atio* 02 P"r)ha!i*g4 ,i!t! +or th ,tra)tor! )o*)r*(.

    Th B"!i*!! Co*t*t i* BW i! !ti&& gro"p( togthr "*(r th app&i)atio*)o$po**t MM:PUR.

    Th +o&&oi*g (o)"$*t r&at! ,)&"!i'&y to th ,tra)tor! a*( -ataSo"r)! +orth! app&i)atio*!.;o" )a* +i*( g*ra& i*+or$atio*5 that i!5 a! oppo!( to (tai&( app&i)atio*/%a!(i*+or$atio*5 i* th (o)"$*t Extraction of Logistics Transaction Data SAPNt /i*g )o)kpit +or th &ogi!ti)! ,tra)t !tr")t"r.

    A )orr!po*(i*g +o&&o/"p )o$po!it *ot5 that a&!o )o*tai*! a&& *)!!ary)orr)tio*! +or th P&"gI*5 +or R a*( +or BW Co*t*t5 i! p&a**( +or 'ry +"t"rP&"gI*.

    2001 SAP Markets Europe GmbH )

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    4/27

    Etrakto %e3e4u4s5ate MM

    To "! th * ,tra)tio* $tho(5 yo" $"!t $ak )ha*g! i* th R !y!t$. Th!r (&i'r( ith th R S"pport Pa)kag!.

    For th ,tra)tor! (!)ri%( hr5 thi! took p&a) ith th )orr)tio*! (!)ri%( i*

    *ot [email protected]! i! a* a%!o&"t prr9"i!it +or rror/+r "! o+ th P&"gI*! +or th,tra)tio* o+ p"r)ha!i*g tra*!a)tio* (ata.

    Si*) th! )orr)tio*! )o*)r* )ha*g! to th R !ta*(ar( !y!t$5 a*( thr+or)a**ot % (&i'r( ith a P&"gI*5 h* yo" "! th P&"gI*5 yo" $"!t )h)k hthrth! *ot! ha' a&ra(y %* i*!ta&&( o* yo"r )o$p"tr ith th R S"pportPa)kag.I+ thi! i! *ot th )a!5 yo" $"!t i*!ta&& th! *ot! $a*"a&&y.

    2001 SAP Markets Europe GmbH ,

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    5/27

    Etrakto %e3e4u4s5ate MM

    2 e Extractors*Data+ources ith BW ,e-ease 2.0B*,*$ P-ug'n P'2000.1

    Th &ogi!ti)! ,tra)tor! ,tra)t tra*!a)tio* (ata a*( ar (!ig*( to rp&a) thtra*!+r I*+o !tr")t"r! S011 to S0124 "!( "*ti& *o5 i* th +ir!t 'r!io* o+ thapp&i)atio* (a&t ith hr. ;o" )rat5 )ha*g or (&t (o)"$*t! i* thapp&i)atio*!. Th r!"&ti*g (ata i! !tag( o*&i* i* =IS )o$$"*i)atio* !tr")t"r!5hi)h yo" )a* th* "p(at )&a!!i)a&&y i* i*+o/!tr")t"r! "!i*g th =IS. Th )o*)pto+ th * ,tra)t !tr")t"r! app&i! hr.I* a((itio* to5 or a! a* a&tr*ati'5 to th=IS "p(at5 (ata i! tra*!+rr( +ro$ th =IS )o$$"*i)atio* !tr")t"r5 "!i*g ,tra)t!tr")t"r!5 i*to a )*tra& (&ta $a*ag$*t ara. Thi! tra*!+r tak! p&a) i* th "p(at a*( i! thr+or t$pora&&y (ta)h( +ro$ th app&i)atio*. Th (&ta$a*ag$*t a)t! a! a %"++r +or (ata that )a* % r9"!t( +ro$ th BW 'ia a*

    I*+oPa)kag ith th "p(at $o( delta upload. Th +o&&oi*g (iagra$ !ho! thi*tra)tio* %t* th =IS )o$$"*i)atio* !tr")t"r a*( th * ,tra)tio*t)h*o&ogy.

    %%-ication"

    Documents

    (reate/

    hange/

    De-ete)

    Data+ource

    Data+ource

    -assic

    L'+"

    %!ating

    'nfo

    structures

    e.g" +012

    Extract

    structure

    Extract

    structure

    Data+ource

    Data+ource

    e extraction

    techno-og&

    V$3Posting

    entra-

    De-ta3

    mgmt.

    4u5rou%

    ME6

    7n-ine

    L'+3omm.s

    tructure

    e.g.

    M02M80'TM

    e.g. 2L'+8028'TM

    e.g.

    2L'+8028+012

    5ra%hic 1" 7n-ine %!ate of Extract +tructures.

    I* p&a) o+ th tra*!+r! "!( pr'io"!&y5 I*+oPa)kag! ith th "p(at $o( deltainitialization ar "!( to tra*!+r ,i!ti*g or ar)hi'( (o)"$*t!. I* O=TP thI*+oPa)kag! rtri' (ata +ro$ th !t "p ta%&!5 hi)h ar a!!ig*( to th ,tra)t

    !tr")t"r!.;o" +i&& th! ta%&! "!i*g !p)ia& !t "p tra*!a)tio*! i* O=TP.-tai&! a%o"t th! +"*)tio*! ar (!)ri%( &atr i* thi! (o)"$*t.

    2001 SAP Markets Europe GmbH 6

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    6/27

    Etrakto %e3e4u4s5ate MM

    +tatistica-

    setu%

    %rogramm

    for historica-

    !ocuments

    L'+3omm.s

    truc

    ture

    Data+ource

    Data+ource

    Extract

    structure

    Extract

    structure

    (e) extraction

    techno-og&

    4u5rou%

    ME6

    Batch

    +etu%

    ta9-e

    e.g.

    M02M80'TM

    e.g.

    M02M80'TM+ETP

    e.g. 2L'+8028'TM

    5ra%hic 2" +etu% of Extract +tructures.

    For a)h ,tra)t !tr")t"r5 o* !t "p ta%& ith th *a$ o+ th ,tra)t !tr")t"r a*(DSETUP7 a! a !"++i,5 ,i!t!. E,a$p& E,tra)t !tr")t"r MC02M:01TM5 !t"p ta%&MC02M:01TMSETUP.Si*) yo" ar "!i*g )&"!tr ta%&!5 it (o! *ot $ak !*! to (i!p&ay th *tri! ithtra*!a)tio* SE1@.;o" )a**ot (tr$i* th *"$%r o+ *tri! +ro$ th *"$%r o+

    (ata r)or(!.Ho'r5 yo" )a* (i!p&ay (ata "!i*g tra*!a)tio* RSA5 !i*) thi! tra*!a)tio* "!!(ata +ro$ th !t "p ta%&!.

    2.1 The Design of the New Extract Structures

    Th ,tra)t !tr")t"r! ar a +"*(a$*ta& part o+ th * ,tra)tio* )o*)pt. Th!ar R/--IC !tr")t"r! that )o*tai* a&& +i&(! ho! (ata )o*t*t! ar tra*!+rr(+ro$ th tra*!a)tio* (ata 'ia th -ataSo"r)! to th BW h* yo" a)ti'at thr&'a*t ,tra)tio*.

    Th ,tra)t !tr")t"r! +or app&i)atio* 02 ar !tr")t"r( i* !")h a ay that $o!t o+ th+i&(! ithi* th$ ar +i&&( (ir)t&y +ro$ th +i&( )o*t*t! o+ th =IS )o$$"*i)atio*!tr")t"r!.So$ a((itio*a& +i&(! ar (tr$i*( i* th ,tra)tio* $o("&!.E'ry =IS )o$$"*i)atio* !tr")t"r that i! "!( to +i&& a* ,tra)t !tr")t"r i! a!!ig*(to a* i*)&"( !tr")t"r i* th ,tra)t !tr")t"r. Wh* yo" ar a((i*g ,tra +i&(!5ho! +i&( *a$! ar i(*ti)a& i* !'ra& =IS )o$$"*i)atio* !tr")t"r! i*t*(( +or"! ith o* ,tra)tor5 it i! po!!i%& to "*i9"&y a!!ig* th =IS )o$$"*i)atio*!tr")t"r! +ro$ hi)h th (ata )o*t*t! ar tra*!+rr(.Ho'r5 thi! (o! *ot $a*that yo" )a* i*)&"( a +i&( ith th !a$ *a$ !'ra& ti$! i* th !a$ ,tra)t!tr")t"r.

    Thi! ,tra)t !tr")t"r )o*)pt a&&o! yo" to i*)&"( othr +i&(! itho"t $o(i+i)atio* a! && a! "!r/(+i*( +i&(!5 hi)h r i*)&"(( "!i*g app*( t)h*o&ogy i* th

    2001 SAP Markets Europe GmbH #

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    7/27

    Etrakto %e3e4u4s5ate MM

    )orr!po*(i*g i*)&"( o+ th =IS )o$$"*i)atio* !tr")t"r / i* th ,tra)t !tr")t"r!.Thy ar th* a"to$ati)a&&y +i&&( ith th 'a&" +ro$ th )orr!po*(i*g =IS)o$$"*i)atio* !tr")t"r $a*i*g th =IS )o$$"*i)atio* !tr")t"r to hi)h th +i&(yo" !&)t( r+r!4.

    Th ,tra)tor! ar th* a!!ig*( to (i++r*t (o)"$*t &'&! -o)"$*t ha(r GH-R5 (o)"$*t it$ G ITM5 !)h("& &i* G SC=4. ;o" )a* i*)&"( +i&(! i* th,tra)tor +ro$ ithr th !a$ (o)"$*t &'& or a highr (o)"$*t &'&. Th &attr5that i! th i*)&"!io* o+ +i&(! +ro$ a highr &'&5 i! o*&y po!!i%& +or +i&(! that i&&&atr !r' a! )hara)tri!ti)! i* th BW +or ,a$p& th p"r)ha! or(r it$,tra)tor )a* tak )hara)tri!ti)! +ro$ th or(r ha(r +or ,a$p& '*(or5p"r)ha!i*g orga*i>atio*4.Fi&(! +ro$ a &or &'& )a* *at"ra&&y *ot % o++r(. I+ yo"!&)t( +i&(! that yo" a*t to "! a! ky +ig"r! i* th BW +ro$ a highr &'&5 th'a&"! o"&( % tra*!+rr( $or tha* o*) a*( ky +ig"r! o"&( % ("p&i)at( i*th BW (ata targt!.Thr+or !")h +i&(! ar *ot i*)&"(( i* th ,tra)t !tr")t"ra*( ar *ot i*)&"(( i* th !&)tio* o+ +i&(! that yo" )a* "! to *ha*) th ,tra)t

    !tr")t"r.

    E*ha*)i*g !tr")t"r! i! (i!)"!!( i* (tai& i* !)tio* @ Enhancing/Changing ExtractStructures4.A$o*g!t othr thi*g!5 th !)tio* ,p&ai*! hy *ot a&& +i&(! o+ th =IS)o$$"*i)atio* !tr")t"r that yo" ar "!i*g ar i*)&"(( i* th !&)tio* o+ a'ai&a%&+i&(! h* yo" a*t to *ha*) a* ,tra)t !tr")t"r.

    Th +o&&oi*g ta%& gi'! a* o'r'i o+ th ,tra)tor! +or app&i)atio* 025 !ho!hi)h =IS )o$$"*i)atio* !tr")t"r! ar %a!( o* th$5 +or hi)h '*t! i* O=TPyo" )a* tra*!+r (ata i*to th BW a*( hat th -ataSo"r)! a!!ig*( to th,tra)tor! ar )a&&(.

    E'*t MA $a*! )rati*g5 )ha*gi*g or (&ti*g p"r)ha! or(r!.E'*t MB $a*! )rati*g5 )ha*gi*g or (&ti*g goo(! r)ipt!.E'*t MC $a*! )rati*g5 )ha*gi*g or (&ti*g i*'oi) r)ipt!.E'*t M- $a*! )rati*g5 )ha*gi*g or (&ti*g !)h("&i*g agr$*t!.E'*t ME $a*! )rati*g5 )ha*gi*g or (&ti*g )o*tra)t!.E'*t MF $a*! )rati*g5 )ha*gi*g or (&ti*g r9"!t!9"otatio*!.

    %%-. Extractstructure

    om.structure

    'nc-u!e E:ent Data+ource ame

    02 MC02M:0H-R MA5 M-5ME5 MF 2=IS:02:H-R P"r)ha! or(r(o)"$*t ha(r

    MCE88O MC02M:1H-R

    02 MC02M:0ITM MA5 MB5MC5 M-5ME5 MF

    2=IS:02:ITM P"r)ha! or(r(o)"$*t

    MCE88O MC02M:1ITM

    MCE8PO MC02M:2ITM

    02 MC02M:0SC= MA5 MB5MC5 M-5

    2=IS:02:SC= P"r)ha! or(r(o)"$*t !)h("&&i*

    MCE88O MC02M:1SC=MCE8PO MC02M:1SC=

    MCE8ET MC02M:1SC=

    2001 SAP Markets Europe GmbH 7

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    8/27

    Etrakto %e3e4u4s5ate MM

    I*+o Th ,tra)t !tr")t"r MC02M:0H-R $ai*&y )o*tai*! i*+or$atio* o* "p(ati*g(o)"$*t )o"*tr! i* th BW.

    Th ,tra)t !tr")t"r MC02M:0ITM $ai*&y )o*tai*! i*+or$atio* o* "p(ati*g

    it$ )o"*tr!5 )o*tra)t i*+or$atio* a*( '*(or 'a&"atio* poi*t! !)or! i* thBW.

    Th ,tra)t !tr")t"r MC02M:0SC= $ai*&y )o*tai*! i*+or$atio* o* "p(ati*g9"a*titi! a*( 'a&"! o+ p"r)ha! or(r! i* th BW.

    A! && a! th i*)&"(! gi'* a%o'5 a&& ,tra)t !tr")t"r! !ti&& )o*tai* +i&(! that ar*tr( (ir)t&y i* th --IC !tr")t"r +or ,a$p&5 MC11A0H-R4. -ata i* th!+i&(! i! *ot a!!ig*( %y $appi*g5 "!i*g =IS )o$$"*i)atio* !tr")t"r!. It i!(tr$i*( ,p&i)it&y i* th ,tra)tio* $o("&!.

    2.2 Administrative Tables for Defining Extract Structures and for LiningExtract Structures to DataSources

    Th i*tra)tio* o+ th =IS )o$$"*i)atio* !tr")t"r! ith th ,tra)t !tr")t"r! i!)o*tro&&(5 a$o*g!t othr thi*g!5 %y th ta%& TMCECFS5 i* hi)h i*+or$atio*a%o"t th +i&(! that yo" ha' !&)t(5 or th +i&(! that ar *ot a'ai&a%& +or!&)tio*5 i! )o*tai*( +or a&& =IS )o$$"*i)atio* !tr")t"r!.

    Ta%& TMCECF r)or(! a&& a((itio*a& +i&(! that th )"!to$r ha! )ho!*.

    Th ,tra)t !tr")t"r! ar a!!ig*( to thir -ataSo"r)! "!i*g ta%& TMCEACT. I*a((itio*5 ta%& TMCEACT r)or(! th a)ti'atio* !tat"! +or th ,tra)tio*.

    Th -ataSo"r) i! g*rat( o* th %a!i! o+ th! ta%&! +or ,a$p&5 a))or(i*g toth *ha*)$*t o+ a* ,tra)t !tr")t"r4.

    2001 SAP Markets Europe GmbH (

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    9/27

    Etrakto %e3e4u4s5ate MM

    $ Pre%aration +te%s for Extraction

    !.1 Transferring "usiness #ontent DataSources

    Th +ir!t !tp that yo" ha' to )arry o"t to a)ti'at th pro)!! o+ ,tra)ti*gtra*!a)tio* (ata i! to tra*!+r i*to th O=TP5 tho! -ataSo"r)! that ha' %*(&i'r( a! -/'r!io* -ataSo"r)!. Thi! g*rat! th A/'r!io*! o+ th-ataSo"r)!.

    To )arry o"t thi! !tp5 )hoo! th $*" path B"!i*!! Co*t*t -ataSo"r)! /atio*! Or/&i*k4.

    Moro'r5 th !&)tio* )o*(itio*! +or th I*+oPa)kag! ha' *o i*+&"*) o* th,tra)tio* $o("& or !t"p progra$ i* O=TP. S")h (ata i! !ti&& )rat( i*(p*(*t&yo+ th !&)tio* )o*(itio*! at th ti$ o+ ,tra)tio*5 yo" (o *ot *( to k*o hi)hI*+oPa)kag yo" ar "!i*g to &oa( (ata i*to th BW5 it $ay % that th (ata i!!&)t( +or (i++r*t BW! ith (i++r*t !&)tio* )ritria.Thr+or5 yo" )a* *ot i$pro' O=TP ,tra)tio* pr+or$a*) %y "!i*g !&)tio*)o*(itio*! i* I*+oPa)kag!.W $"!t a&!o poi*t o"t that a+tr th ,)"tio* o+ th )o&&)ti' r"*5 o*&y th BWtra*!+r (ata +or hi)h thr i! a&ra(y a (&ta i*itia&i>atio* i! rtai*(. A !"%!9"*t(&ta i*itia&i>atio* that ai$! +or a* ,pa*!io* o+ th !&)tio* ra*g o+ a &atr (&ta"p&oa( *o &o*gr ha! a* ++)t i* th (o)"$*t! a&ra(y ,)"t( +or th

    )o&&)ti' r"*.S")h (o)"$*t! )a* o*&y % tra*!+rr( to th BW "!i*g !t"p.

    I* parti)"&ar5 it i! a&!o *ot po!!i%& to "! th !&)tio* )o*(itio*! to rit ,tra)t((ata to (i++r*t )"%! ith I*+oPa)kag!. Thi! i! %)a"! th !&)tio* )o*(itio*! o+a&& (&ta "p&oa( I*+oPa)kag! ha' a&ra(y %* (+i*( % th !&)tio* )o*(itio*!o+ a&& (&ta i*itia&i>atio*!.

    .3. Hi(i*g Fi&(! i* th BW

    U!i*g th +&ag KHi( +i&(K5 yo" )a* (+i*5 +or i*(i'i("a& -ataSo"r) +i&(!5 hthr

    th +i&( i* th -ataSo"r) !ho"&( % hi((*. I+ a +i&( i! hi((*5 it i! a&!o *o &o*gr+o"*( i* th tra*!+r !tr")t"r a*( )a* *o &o*gr % !&)t( i* th tra*!+r r"&! +orth I*+oSo"r)!.

    2001 SAP Markets Europe GmbH 1,

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    15/27

    Etrakto %e3e4u4s5ate MM

    It i! po!!i%& to hi( o* o+ th !ta*(ar(/(&i'ry !&)t( -ataSo"r) +i&(!5 %"t thi!)a* &a( to th "p(at i* SAP (&i'r( )"%! %i*g i*)o*!i!t*t.

    I+ a )ha*g to a (o)"$*t tak! p&a) i*'o&'i*g a $o(i+i( +i&( that i! a hi((* +i&(i* a -ataSo"r)5 o&( a*( * r)or(! ar !ti&& tra*!+rr( to th BW.Thr+or it i!*ot po!!i%& to r(") th *"$%r o+ (ata r)or(! to % tra*!+rr( to th BW %yhi(i*g +i&(!.

    2001 SAP Markets Europe GmbH 16

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    16/27

    Etrakto %e3e4u4s5ate MM

    A Extracting Transaction Data

    (.1 )nitiali*ing of Transaction Data +Setu, of Existing Documents-

    To tra*!+r i*+or$atio* to th BW +ro$ (o)"$*t! that a&ra(y ,i!t i* th O=TP5 yo"$"!t )arry o"t th +o&&oi*g !tp!

    1. cti:ateth (!ir( ,tra)tio* i* th K=ogi!ti)! E,tra)t Str")t"r C"!to$i>i*gCo)kpitK =BWE4.Thi! tak! p&a) at th &'& o+ th r&'a*t ,tra)t !tr")t"r!.NotPro)!! ky! $"!t % a)ti'4

    2. Th (ata $"!t th* % $a( a'ai&a%& i* th !t"p ta%&! i* O=TP "!i*g thsetu% +"*)tio*!.-"ri*g thi! pro)!!5 yo" !ho"&( *ot $ak a*y (o)"$*t)ha*g! i* th !y!t$.I+ yo" ar (a&i*g ith &arg 9"a*titi! o+ (ata5 yo" !ho"&(

    +ir!t&y a!!!! th (ata 'o&"$ o+ th !t"p ta%& "!i*g a t!t r"*. Th*5 i+*)!!ary5 *ha*) th (ata%a! ta%& !pa).

    ). I+ th !t"p ta%&! ar +i&&(5 yo" )a* %gi* agai* to pro)!! (o)"$*t! i* thO=TP.A++)t( "!r! !ho"&( -og on to the s&stem again.Thi! *!"r! that,tra)tio* a)ti'atio* i! a))o"*t( +or at (o)"$*t po!ti*g.;o" $"!t $ak !"r that no V$ co--ecti:e run i! !tart( %+or th !"))!!+"&"p&oa( o+ a* I*+oPa)kag i* th BW ith th "p(at $o( Qinitia-i@ation of the!e-ta %rocessQ. Othri! a&& (&ta (ata "p&oa(( i* th $a*ti$ i! &o!t +or 'r+or th BW "p(at a*( )a* o*&y % r)rat( %y r+i&&i*g th !t"p ta%&! i* thO=TP.

    ,. Th (ata pro'i(( i* th !t"p ta%&! $"!t *o % r9"!t( +ro$ th BW ithth "p(at $o( initia-i@ation of !e-ta %rocess "!i*g a* I*+oPa)kag.O*&y a+tr th !"))!!+"& pro)!!i*g o+ thi! I*+oPa)kag ar a&& ,tra)tor"p(at *tri! !"pp&i( to th BW +or r9"!t!. Thi! i! (o* %y !tarti*g th )o&&)ti' pro)!!i*g i* )*tra& (&ta $a*ag$*t. -o)"$*t i*+or$atio*pro)!!( i* a pr'io"!&y !tart( prhap! %y $i!tak4 )o&&)ti' pro)!!i*gr"* )a* *ot % tra*!+rr( to th BW ith a (&ta "p&oa(. Thi! i! %)a"! th!y!t$ thi*k! yo" *o &o*gr *( th i*+or$atio* i* th BW %)a"! o+ th$i!!i*g i*itia&i>atio*4.

    6. I+ yo" a*t to rpat a (&ta i*itia&i>atio*5 a&tho"gh a (&ta i*itia&i>atio* ha!a&ra(y %* )arri( yo" $"!t +ir!t (&t th i*itia&i>atio* i*+or$atio* i* th BW+or th -ataSo"r).Thi! tak! p&a) i* th $ai*t*a*) (ia&og o+ a* I*+oPa)kago+ th )orr!po*(i*g I*+oSo"r) +or th a++)t( !o"r) !y!t$ "!i*g Scheduler-> nitialization for a Source S!ste".;o" )a* (&t th )orr!po*(i*g *tri!thr.Th* yo" !ho"&( (&t th r9"!t! that ha' %* r)i'( +ro$ th PSAa*( (ata targt! .A+tr thi! !tp. pro)( agai* a! ,p&ai*( i* !tp! 1 to 3.;o" $"!t $ak !"rthat a&& ,i!ti*g *tri! i* th !t"p ta%&! ar (&t( %+or r+i&&i*g th !t"pta%&!.E'* i*+or$atio* o* th !a$ (o)"$*t that ha! *ot )ha*g( i* th$a*ti$ i! a'ai&a%& i* ("p&i)at i* th !t"p ta%& i+ th !t"p !&)tio* )o'r!thi! (o)"$*t agai*.

    2001 SAP Markets Europe GmbH 1#

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    17/27

    Etrakto %e3e4u4s5ate MM

    3.1.1 Fat"r! h* Carryi*g O"t St"p i* th O=TP

    For th !t"p o+ (ata +or th )o**)tio* to th BW5 th !a$ !&)tio* progra$! ar"!( i* p"r)ha!i*g a! +or th !tati!ti) (ata !t"p +or th =IS. Thi! ($a*(! a +*ha*)$*t! to th! progra$! that )a* *ot % (&i'r( "!i*g a P&"gI*. Th

    *ha*)$*t! ar ithr (&i'r( ith a* R Hot Pa)kag or $"!t % $a($a*"a&&y.Thi! a++)t! *ot! 20223@ a*( 21L2L thy $"!t % i*)orporat(.

    Wh* !tarti*g th !t"p a! a %a)kgro"*( 6o%5 $ak !"r that th "!( rport'aria*t! ar )rat( ith tra*!a)tio* O=IBW a*( *ot ith O=I. Othri! th BWr&'a*) )a* *ot % r)og*i>(.

    I+ th !t"p i! to % p&a**( a! !'ra& para&&& 6o%!5 $ak !"r yo" )h)k +ir!ththr )orr)tio*! +ro$ *ot J a&ra(y ,i!t i* yo"r P&"gI*. Othri! (ata&o!! i! "*a'oi(a%&.

    I+ yo" ha' too $")h (ata to i*)&"( a&& th (o)"$*t! i* th !t"p r"*5 th !t"p)a* % !p&it i*to to part!Pha! 1 St"p o+ a&& (o)"$*t! that ha' (+i*it&y *ot %* )ha*g( %y th

    *( o+ th *tir i*itia&i>atio* pro)!!.+or ,a$p&5 a&& (o)"$*t! "p toa (o)"$*t *"$%r )rat( appro,i$at&y 12 $o*th! ago4.Thi! (ata i!tra*!+rr( to th BW a! a fu-- u%-oa!. -"ri*g thi! ti$5 +"rthr)ha*g! )a* % $a( to th othr4 (o)"$*t!.

    Pha! 2 -&ta i*itia&i>atio* ith th r!t o+ th (o)"$*t! i* thi! pha!5 a&&(o)"$*t pro)!!i*g $"!t % i*)&"((.Fir!t o+ a&&5 a&& "p(at *tri!a))"$"&at( i* pha! 1 $"!t % pro)!!( !tart 'ia )o*tro& i* th

    =ogi!ti)! E,tra)t Str")t"r C"!to$i>i*g Co)kpit4.A! *o I*+oPa)kagha! yt %* tra*!+rr( to th BW a! a (&ta i*itia&i>atio*5 thi! (ata i!ig*or( %y th )*tra& (&ta $a*ag$*t. It i! a&!o "**)!!ary5 a! th)orr!po*(i*g (o)"$*t! ar tra*!+rr( to th BW i* thir )"rr*t!tat"! ith th !"%!9"*t a*( &a!t part o+ th !t"p.B+or !tarti*g th!t"p i* th O=TP5 th pha! 1 (o)"$*t! $"!t % (&t( +ro$ th!t"p ta%&! "!i*g =BW#.A+tr ,)"ti*g th pha! 2 !t"p5 th (ata i!*o r9"!t( +ro$ th BW ith th "p(at $o( initia-i@ation of!e-ta %rocess "!i*g a* I*+oPa)kag.A! ,p&ai*( a%o' i* !tp 5th (o)"$*t pro)!!i*g )a* % )o*ti*"( !traight a+tr th !t"pta%&! ha' %* +i&&( i+ yo" )a* *!"r that th )o&&)ti' r"* i! *ot

    !tart( too ar&y.

    Ca"tio* It i! o*&y po!!i%& to !p&it th !t"p i*to to pha!! i+ yo" ar *ot "!i*ga*y O-S o%6)t! a! (ata targt!.At pr!*t5 o*&y +"&& "p&oa(I*+oPa)kag! or o*&y (&ta i*itia&i>atatio* I*+oPa)kag! )a* % "!( +orI*+oSo"r)! ith "p(at r"&! i* a* O-S o%6)t.

    Th t)h*i)a& ra&i>atio* o+ th tra*!a)tio* +or (&ti*g a* app&i)atio*K! !t"p ta%&!)o*!i!t! o+ a ta%& %i*g (&t( +ro$ th (ata%a! a*( %i*g r)rat(. Mak !"rthat thi! '*t i! )ro!!/)&i*t !o that *tri! i* a&& )&i*t! ar (&t(.

    3.1.2 E,tra)tio* ith th Up(at Mo( KF"&& Up(atK.

    2001 SAP Markets Europe GmbH 17

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    18/27

    Etrakto %e3e4u4s5ate MM

    Wh* th * ,tra)tio* tak! p&a)5 th (ata i! *ot kpt i* a ta%& i* th O=TP. Thi!i! i* )o*tra!t to ,tra)tio* o* th %a!i! o+ th =IS i*+o/!tr")t"r!.

    Thr+or5 th ,tra)tio* ith rg"&ar r9"!t o+ a* I*+oPa)kag ith th "p(at$o( K+"&& "p(atK i! o*&y po!!i%& ith a((itio*a& ++ort.

    So a* ,tra)tio* pro)!! )a* o*&y5 i+ at a&&5 % %*+i)ia& i* th )a! o+ tra*!a)tio*(ata +or hi)h thr ar *o )ha*g +"*)tio*! i* th O=TP +or ,a$p& $atria&(o)"$*t!4. Th*5 pr +"&& "p&oa( yo" o*&y *( to ,tra)t (ata r)or(! )rat(!i*) th &a!t +"&& "p&oa(.

    With th tra*!a)tio* (ata (!)ri%( hr5 hi)h %&o*g to th P"r)ha!i*g)o$po**t5 thi! i!5 ho'r5 *ot th )a!. Thr+or5 ith thi! $tho( itK! a 'ry(o"%t+"& pro)!! to *!"r that a&& (o)"$*t! ar ,tra)t( )orr)t&y5 yo" $"!t,tra)t a&& (o)"$*t! rg"&ar&y a*( +ir!t (&t a&& )orr!po*(i*g r9"!t! i* th BW.

    Thi! pro)!! o"&( &a( to a pr$a**t&y i*)ra!i*g r"*ti$ +or th ,tra)tio*.Moro'r5 ith thi! $tho( it o"&( *ot % po!!i%& to rit th (i++r*)! ari!i*g+ro$ (o)"$*t )ha*g! (&ta!4 to th ti$ %a! K)ha*g (atK i* th )"%.A! th (ata ,tra)t( i* th * ,tra)tio* *o &o*gr *(! to % kpt i* =IS i*+o/!tr")t"r! i* th O=TP5 a )o$p&t !t"p $"!t % ,)"t( i* th O=TP +or thi!$tho( %+or 'ry "p&oa(.

    4or these reasons. e strong-& a!:ise &ou against using this o%tion for theextractors !escri9e! here.

    -!pit thi!5 th optio* o+ &oa(i*g +"&& "p&oa( I*+oPa)kag! i*to th BW )a*5 a!,p&ai*( a%o'5 a&!o % o+ grat i$porta*) ith thi! ,tra)tio*.

    (.2 Delta ,load of Extraction Data to the /LT%

    3.2.1 #athri*g -ata +or th Up(at

    I+ at &a!t o* ,tra)t !tr")t"r ith a* a!!ig*$*t to '*t MA i! a)ti'5 th ,tra)t$o("&! i&& r"* h* p"r)ha! or(r (ata i! )rat(5 )ha*g( or (&t(. I+5 a! ar!"&t o+ th )ha*g( p"r)ha! or(r (ata5 thr i! a )ha*g i* at &a!t o* +i&( o+a* a)ti' ,tra)t !tr")t"r5 a "p(at $o("& i! )a&&(. Thi! i! ,)"t( at th &atr)a&& o+ a )o&&)ti' r"*.Th !a$ i! tr" +or goo(! r)ipt '*t ME4 a*( i*'oi) r)ipt '*t MC4 a*( !oo*.

    Th ,tra)tio* (ata i! a'ai&a%& +or +"rthr pro)!!i*g i* th "p&oa( (ata "*ti& th )o&&)ti' r"* i! )a&&(.

    Thi! (ata )a* % o%!r'( "!i*g tra*!a)tio* SM1 !&)tio* ith !tat"! K2,)"t(K4 a*( %ra*)hi*g to th "p&oa( $o("&!.Hr yo" )a* (i!p&ay th (ata ith

    th "p&oa( $o("&! +or ,a$p& MCE:UP-ATE:024 o+ th $o("& typ K)o&&)ti'r"*K. ;o" )a* !5 a$o*g!t othr thi*g!5 th i*tr+a) ta%&! i* th +or$ o+ ,tra)t!tr")t"r!.

    2001 SAP Markets Europe GmbH 1(

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    19/27

    Etrakto %e3e4u4s5ate MM

    A))or(i*g&y5 ith a)ti' ,tra)t !tr")t"r!5 %+or th !tart o+ a )o&&)ti' r"* a*op* "p&oa( *try ari!! +or a)h (o)"$*t )ha*g )arri( o"t. Thi! i! *ot a* rror.Th (ata "p&oa( i! p"rpo!+"&&y h&( %a)k "*ti& it i! triggr( ,p&i)it&y.Th ,)ptio*to thi! i! th ERS pro)!! i* th %a)kgro"*( a"to$ati) )a&)"atio* o+ goo(! r)ipt

    i* P"r)ha!i*g4.A+tr th ERS ha! r"*5 a&& (ata i! ritt* (ir)t&y to th (&ta 9""a*( (o! *ot gt !*t to th "p(at.

    A&& othr "p&oa( !tp! R (o)"$*t po!ti*g5 =IS/2 "p&oa( a*( !o o*4 ar )arri(o"t %+orha*( i*(p*(*t&y o+ th BW ,tra)tio* "p(at. Th !"))!!+"&pro)!!i*g o+ th! "p&oa( !tp! i! i*(p*(*t o+ hthr or *ot thr ar op* "p(at !tp!.

    P-ease note the fo--oing carefu--&"

    B+or %ri*gi*g i* a* R !ta*(ar( S"pport Pa)kag or a P&"gI* pat)h5 or %+or th

    ,)"tio* o+ a* R "pgra( or P&"gI* "pgra(5 a&& op* "p&oa( *tri! $"!t %pro)!!(.Thi! i! parti)"&ar&y i$porta*t +or "p&oa( *tri! o+ typ )o&&)ti' r"*4.Ho to (o thi! i! (!)ri%( %&o.Othri! th "p&oa( *tri! $ight *o &o*gr % !"))!!+"&&y "p&oa((5 a*( thr)o"&( % a* rror i+ o* o+ th !tr")t"r! "!( i* th "p&oa( *try ha! )ha*g( ithth pat)h or "pgra(.A )ha*g to th (ata &$*t or (o$ai* o+ a* i*'o&'( +i&( i!!"++i)i*t +or thi!.

    3.2.2 Starti*g th Up(at

    By !tarti*g a r&'a*t 6o% ith th )o*tro& %"tto* o+ a* app&i)atio* i* th =ogi!ti)!E,tra)t Str")t"r C"!to$i>i*g Co)kpit5 yo" )a* pro)!! a&& "p&oa( *tri! +or hi)hth "p&oa( o+ th ,tra)tio* $o("& o+ th r&'a*t app&i)atio* i! !ti&& i*itia& progra$RMBW024.

    For 02 app&i)atio*!5 thi! $o("& i! MCE:UP-ATE:02.

    Thi! $a*! that i+ yo" !tart a 6o% +or 02 app&i)atio*!5 a&& "p&oa( *tri! ith th i*itia&$o("& MCE:UP-ATE:02 ar pro)!!(.

    A+tr th !"))!!+"& pro)!!i*g o+ th! "p&oa( *tri!5 th ,tra)tio* (ata i!a'ai&a%& i* th (&ta 9"" o+ th Sr'i) API )*tra& $a*ag$*t4 to % )o&&)t("!i*g (&ta I*+oPa)kag! a*( th BW.

    W r)o$$*( that i* pro(")ti' opratio* yo" ,)"t th )o&&)ti' r"* )a&&!+or i*(i'i("a& app&i)atio*! ith appropriat&y !taggr( ti$i*g. Thi! i! %)a"! "p&oa(*tri! )a* !o$ti$! )o*tai* !'ra& (i++r*t $o("&!.

    Th BW (&ta 9"" (ata $"!t % r9"!t( +ro$ th BW at th right ti$ a+tr th )o&&)ti' r"*.At th 'ry &a!t yo" !ho"&( *!"r that th *"$%r o+ =UW! (i!p&ay( +ro$ th

    o'r'i !)r* o* tra*!a)tio* RSAL pr -ataSo"r)targt !y!t$ i* th +i&( Ktota&Ki! *ot &argr tha* . Othri!5 it $ay tak a (i!proportio*at&y &o*g r"*ti$ topro)!! th (ata.

    2001 SAP Markets Europe GmbH 1*

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    20/27

    Etrakto %e3e4u4s5ate MM

    i+ +or ,a$p& (" to ig*ori*g th a%o'4 it i! *)!!ary5 (" to a too &arg 9"a*tityo+ (ata i* th BW (&ta 9"" a*( a!!o)iat( pro%&$! ith th )o**)tio*5 to(&t th *tri! o+ a -ataSo"r) or targt !y!t$ +ro$ th BW (&ta 9""5 it i!g*ra&&y *ot !"++i)i*t to (&t th )orr!po*(i*g *tri! i* tra*!a)tio* RSAL or tor!t th (&ta i*itia&i>atio* +ro$ th BW !i(. Th pro)("r +or (&ti*g th (ata

    +ro$ th BW (&ta 9"" i! (!)ri%( i* *ot 23@22. ;o" !ho"&( a&!o r+r to thi!*ot i+ yo" a*t to r!t a (&ta i*itia&i>atio*.Th *"$%r o+ th (i!p&ay( =UW! i* th BW (&ta 9"" (o! *ot )orr!po*( toth *"$%r o+ a))o$pa*yi*g (o)"$*t!.;o" )a* )o$pr!! a &arg *"$%r o+ (o)"$*t! to o* =UW.For thi!5 yo" $"!t r+rto *ot J??1.

    I+ o* o+ th +"*)tio* $o("& i*tr+a) !tr")t"r! MCE88O5 MCEMPO a*( !o o*4)ha*g! %t* th ti$ o+ )ratio* (o)"$*t !a'4 a*( th ,)"tio* o+ th"p&oa( !tart o+ th )o&&)ti' pro)!!i*g45 th "p&oa( )a* *ot % rror +r a*( i!tr$i*at(. Thi! i! !p)ia&&y &ik&y to happ* i+ ,tra)t !tr")t"r! ar *ha*)(.

    To a'oi( thi! pro%&$ ! !)tio* @ E*ha*)i*gCha*gi*g E,tra)t Str")t"r!4.

    (.! 0eatures of Delta ,date in %urchasing

    3..1 -&ta "p(at o*&y +or r&'a*t )ha*g!

    P"r)h!i*g ,tra)tio* $o("&! ar ra&i>( !o that5 i* )o*tra!t to ,tra)tio* ith =ISi*+o/!tr")t"r!5 th tra*!+r o+ o&( a*( * (ata r)or(! o*&y tak! p&a) i+ at &a!to* +i&( i* th ,tra)t !tr")t"r ha! %* )ha*g(. Th ROCANCE= +i&( i! *ota++)t( hr5 !i*) it a&ay! (i!ti*g"i!h! %t* * a*( o&( r)or(!.

    Thr+or5 )ha*g! i* th O=TP that a++)t *o ,tra)t !tr")t"r +i&(! a&!o (o *ot &a(to a BW ,tra)tio*.Ho'r5 yo" )a* *ot pr'*t a* o&( a*( * r)or( %i*g tra*!+rr( to th BW %y!tti*g th +&ag KHi( +i&(K +or a -ataSo"r) +i&( 5 '* i+ th (o)"$*t )ha*gr+rr( ,)&"!i'&y to thi! +i&(.Th ()i!io* o* hthr to tra*!+r (ata tak! p&a)o*&y o* th %a!i! o+ th ,tra)t !tr")t"r.

    3..2 O-S Capa%i&ity o+ P"r)ha!i*g -ataSo"r)!

    I+ yo" a*t to "p(at +ro$ P"r)ha!i*g -ataSo"r)! to O-S o%6)t!5 yo" $"!t r+r

    to *ot! 222@L a*( 300.

    Wh* "p(ati*g to a* O-S o%6)t th I*+oO%6)t 0RECOR-MO-E i! o+ )*tra&i$porta*).I+ yo" a*t to (&t (ata r)or(! +ro$ a* O-S5 th appropriat (ata r)or( i!tra*!+r( ith 0RECOR-MO-E G KRK r$o'4. Thi! i! pr)i!&y th )a! i+ th)orr!po*(i*g (o)"$*t or it$ i! (&t( i* th O=TP.

    2001 SAP Markets Europe GmbH 20

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    21/27

    Etrakto %e3e4u4s5ate MM

    C Extraction Log

    Thr i! a )o$$o* &og tra*!a)tio* +or =O ,tra)tor!. Th &og i! app&i)atio* a*( "!r/

    !p)i+i).

    I+5 i* th O=TP5 a "!r !t! th SET:#ET para$tr "!r para$tr4 MC= to KK5 i+at &a!t o* ,tra)t !tr")t"r o+ th r&'a*t app&i)atio* i! a)ti' a* *try i! ritt* toth ,tra)tio* &og +or a)h (o)"$*t po!ti*g %y &oggi*g th (ata ,tra)t( +or thBW.With (o)"$*t )ha*g!5 th o&( r)or( i! !ho* a! && a! th * r)or(.

    With a)h * (o)"$*t po!ti*g5 th pr'io"!&y a'ai&a%& *try i! o'rritt*.

    O* th othr ha*(5 it i! *ot po!!i%& to +i&& th !t"p ta%&! a*( th &og at th !a$ti$ ith a !t"p r"* %y !tti*g th "!r para$tr. Thi! $"!t tak p&a) a! to!parat a)tio*!.

    Th &og !r'! to )o*tro& th ,tra)tor! i* th ('&op$*t a*( t!t !y!t$!. ThMC= para$tr !ho"&( *ot % !t i* pro(")ti' !y!t$! +or pr+or$a*) ra!o*!.

    2001 SAP Markets Europe GmbH 21

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    22/27

    Etrakto %e3e4u4s5ate MM

    Enhancing*hanging Extract +tructures

    With th =ogi!ti)! E,tra)t Str")t"r C"!to$i>i*g Co)kpit a too& i! $a( a'ai&a%& +or

    &ogi!ti) tra*!a)tio* (ata ,tra)tio* that *a%&! yo" to *ha*) th ,tra)t !tr")t"ritho"t *ha*)$*t ith th +i&(! o+ %a!i) =IS )o$$"*i)atio* !tr")t"r!.Th =IS )"!to$r ,it *ha*)$*t =EINS0014 that a! i$p&$*t( +orP"r)ha!i*g )o$$"*i)atio* !tr")t"r *ha*)$*t! )a* % "!( +or th !a$p"rpo! a! th =IS to +i&& )"!to$r/!p)i+i) +i&(! that r i*)&"(( ith th app*(t)h*o&ogy i* th appropriat i*)&"(! o+ th =IS )o$$"*i)atio* !tr")t"r!. Thi!)"to$r ,it ha! a&ra(y %* r"* i* a BW (ata ,tra)tio*5 !o a&& r&'a*t i*+or$atio*i! a'ai&a%& +or it.For +"rthr pro)("ra& i*+or$atio* ! (o)"$*tatio* o* th *a$(*ha*)$*t!. Thi! )a* % +o"*( "!i*g tra*!a)tio* SMO- !"%o%6)t K(o)"$*tatio*K4.Thr+or it i! po!!i%&5 a+tr th *ha*)$*t o+ th =IS )o$$"*i)atio* !tr")t"r!5to i*)&"( th r&'a*t +i&(! i* th =ogi!ti)! E,tra)t Str")t"r C"!to$i>i*g Co)kpit i*o* or $or ,tra)t !tr")t"r!5 a! &o*g a! th )o$$"*i)atio* !tr")t"r i! +o"*( i*th !&)tio* optio*! o+ th r&'a*t ,tra)t !tr")t"r. Thi! tra*!+r! th (ata +i&&( i*th )"!to$r ,it to th BW.A! *ot a&& a'ai&a%& +i&(! i* th =I=S )o$$"*i)atio* !tr")t"r! ar i*)&"(( i* thSAP (&i'ry i* th ,tra)t !tr")t"r5 it i! a&!o po!!i%& to i*)&"( +"rthr !ta*(ar(+i&(! +ro$ th =IS )o$$"*i)atio* !tr")t"r! i* th ,tra)t !tr")t"r.A&& +i&(! th"! !&)t( ar i*)&"(( i* th a"to$ati)a&&y g*rat( app*( !tr")t"ro+ th )orr!po*(i*g i*)&"( !tr")t"r o+ th ,tra)t !tr")t"r +or ,a$p& app*(MC02M:0ITM o+ i*)&"( MC02M:0ITM +or a((itio*a& +i&(! i* th or(r it$

    !tr")t"r o+ th =IS )o$$"*i)atio* !tr")t"r MCE8PO4.I+ th !a$ +i&(! ar i*)&"(( i* a &atr P&"gI* i* th !ta*(ar( ,tra)t !tr")t"r5 th)"!to$r *ha*)$*t i* th ,tra)t !tr")t"r i&& % r(")( %y thi! +i&( "!i*g a*a"to$ati)a&&y ,)"t( PRA progra$ h* th "pgra( tak! p&a).Ho'r5 +or $a*y ra!o*!5 *ot a&& +i&(! a'ai&a%& i* th =IS )o$$"*i)atio*!tr")t"r! )a* % o++r( +or !&)tio* +or th ,tra)t !tr")t"r ! !)tio* @.2KI*'a&i( Fi&(! i* =IS Co$$"*i)atio* Str")t"r!K4.

    A+tr *ha)i*g a* ,tra)t !tr")t"r yo" $"!t rg*rat th -ataSo"r) a*(rp&i)at it i* th BW.Th &attr tak! p&a) "!i*g th appropriat +"*)tio* i* th BWI*+oSo"r) tr ith r+r*) to th r&'a*t !o"r) !y!t$.

    ;o" $"!t *ot that it i! *)!!ary to rg*rat th a++)t( tra*!+r !tr")t"r! i* thBW. Othri!5 th +ir!t I*+oPa)kag! a+tr th *ha*)$*t ar )a*)&&( a*( thrror $!!ag KTra*!+r !tr")t"r $"!t % rg*rat(K appar!. I* g*ra&5 yo"*ha*) th tra*!+r !tr")t"r ith th +i&(! to % i*!rt( a*( a(6"!t th tra*!+rr"&!.Th g*ratio* o+ th tra*!+r !tr")t"r i! +or th ti$ %i*g a&!o *)!!ary i+yo" (o *ot a*t to )ha*g th tra*!+r !tr")t"r a*( th tra*!+r r"&! +or hat'rra!o*.

    B+or )ha*gi*g a* ,tra)t !tr")t"r5 yo" $"!t *ot th +o&&oi*g poi*t!

    1. Thr !ho"&( *ot % a*y "*pro)!!( "p(at *tri! +or th a++)t(app&i)atio*.I+ thr ar !o$5 h* th "p&oa( !tart! that i!5 th )o&&)ti' r"*4thr i&& % a* rror. Thi! i! %)a"! th i*tr+a) o+ th a++)t( $o("& ha!

    2001 SAP Markets Europe GmbH 22

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    23/27

    Etrakto %e3e4u4s5ate MM

    )ha*g(.To pr'*t thi! yo" $"!t i*itiat th pro)!!i*g o+ th *tri! )o&&)ti' r"*4 i*th =ogi!ti)! E,tra)t Str")t"r C"!to$i>i*g Co)kpit "!i*g )o*tro&.I+ yo" (i(*ot (o thi! %+or )ha*gi*g th ,tra)t !tr")t"r5 yo" $"!t ithr (&t th"p&oa( *tri! "!i*g tra*!a)tio* SM1 or t$porari&y )ha*g th ,tra)t !tr")t"r

    %a)k i*to it! o&( !tat.

    2. Thr !ho"&( % *o $or (ata i* th )*tra& (&ta $a*ag$*t +or th a++)t(,tra)t !tr")t"r.I+ thr i! (ata5 th (ata $"!t % r9"!t( +ro$ th BW "!i*ga* I*+oPa)kag %+or yo" )ha*g th ,tra)t !tr")t"r.

    ). Thr !ho"&( % *o $or (ata i* th !t"p ta%& +or th a++)t( ,tra)t !tr")t"r.I+ thr i! (ata5 it )a* *o &o*gr % tra*!$itt( to th BW.;o" $"!t (&t th(ata a*( i+ yo" *( th (ata agai* r)o$pi& it a+tr )ha*gi*g th ,tra)t!tr")t"r a*( ra)ti'ati*g th "p(at.

    3. I+ th "p(at &og i! a)ti'5 th (ata o+ th a++)t( app&i)atio* )a* +ir!t % ra( %yth "!r i+5 a+tr )ha*gi*g th ,tra)t !tr")t"r a*( ra)ti'ati*g th "p(at5th"!r )rat!5 )ha*g! or (&t! a (o)"$*t +ro$ th a++)t( app&i)atio* or)arri! o"t a !i$"&atio* o+ th !t"p +"*)tio*.

    B+or tra*!porti*g th )ha*g! $a( to a* ,tra)t !tr")t"r i*to a targt !y!t$5yo" $"!t )h)k that th! poi*t ha' a&!o %* *!"r( i* th targt !y!t$.

    With P&"gI* 2000.2 a*( PI/A 2000.25 th =ogi!ti)! E,tra)t Str")t"r C"!to$i>i*gCo)kpit +or th ,tra)t !tr")t"r! (!)ri%( hr ha! %* *ha*)( !o that it i! *otpo!!i%& th )ha*g ,tra)t !tr")t"r! i+ o* o+ poi*t! 1/ ha! %* 'io&at(. I+ a

    )ha*g )a* % ,)"t(5 a&& &og *tri! ar a"to$ati)a&&y (&t( i$$(iat&y.

    Moro'r5 yo" )a* "! th rport RMCSBWCC to $ak th )h)k! $*tio*(a%o' %+or a tra*!port.;o" !tart th rport i* th targt !y!t$ a*( $"!t $ak!"r %+or !tarti*g th tra*!port that thr ar *o $!!ag! (i!p&ay( prtai*i*g toth poi*t! a%o'. I* parti)"&ar5 it !ho"&( % )arri( o"t %+or a tra*!port i*to thpro(")ti' !y!t$5 %)a"! i* thi! !y!t$5 th )o*!9"*)! o+ a* i*!"++i)i*t&yprpar( ,tra)t !tr")t"r )ha*g )a* % parti)"&ar&y "*p&a!a*t.

    -"ri*g th a)t"a& tra*!port5 *o "!r! !ho"&( % &ogg( o* th a++)t( app&i)atio*! i*th !y!t$. Thi! i! %)a"! --IC )ha*g! ar %i*g $a(.

    I* thory it i! a&!o po!!i%& to *ha*) a -ataSo"r) i* th B"!i*!! I*+or$atio*Warho"! O=TP C"!to$i>i*g "!i*g th $*" path KPo!tpro)!!i*g /< E(it-ataSo"r)K. Ho'r5th +i&(! i*!rt( thr )a* *ot % +i&&( i* th *or$a&,tra)tio* $o("&! "!i*g th =IS )o$$"*i)atio* !tr")t"r!.For thi! p"rpo! thr i! a )"!to$r ,it ith th SAP *ha*)$*t RSAP0001.Hr5 yo" !ho"&( r$$%r that at thi! poi*t yo" )a* *o &o*gr (ir)t&y a))!! thr&'a*t tra*!a)tio* (ata a*( that thi! ,it i! *ot r"* "*ti& th "p(at tak! p&a)that i!5 ("ri*g th )o&&)ti' r"*4. -ata +ro$ th app&i)atio* (o)"$*t that i! *ota'ai&a%& i* th ,tra)t !tr")t"r o"&( ha' to % ra( +ro$ th (ata%a!5 %"t thi! i!i*a('i!a%&. I* a((itio*5 ("ri*g thi! pha! +"rthr (o)"$*t )ha*g! )o"&( a&!o %$a(.Thi! )a* &a( to i*)o*!i!t*)i! i* (ata i+ yo" try to ra( th tra*!a)tio* (ata+ro$ thi! ,it.

    2001 SAP Markets Europe GmbH 2)

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    24/27

    Etrakto %e3e4u4s5ate MM

    Ba!i)a&&y5 th &a!t *a$( +or$ o+ K(ir)tK ,tra)t !tr")t"r *ha*)$*t ith th,tra)t !tr")t"r! o+ th =ogi!ti)! E,tra)t Str")t"r C"!to$i>i*g Co)kpit i! *ota('i!a%&.A! a r"&5 th %!t thi*g to (o i! to *ha*) a*( +i&& th )o$$"*i)atio*!tr")t"r! MCE88O a*( MCE8PO. It i! a&!o po!!i%& to *ha*) th %"++r ta%&E88O5 E8PO a*( !o a*(5 a*( to +i&& th$ "!i*g th r&'a*t "!r ,it o+ th

    P"r)ha!i*g app&i)atio*. Th +i&(! i*!rt( %y app*( ar a&!o a'ai&a%& i* th=ogi!ti)! E,tra)t Str")t"r C"!to$i>i*g Co)kpit +or th *ha*)$*t o+ ,tra)t!tr")t"r!. For th &a!t pro)("r5 r$$%r that th (ata i*!rt( to th %"++rta%&! i! !tor( ith (o)"$*t i*+or$atio* i* th (ata%a!.

    I+ yo" ha' *ha*)( ,tra)t !tr")t"r! ith app*( +i&(! o+ )o$$"*i)atio*!tr")t"r! or %"++r ta%&!5 %"t (o *ot *( o* o+ th +i&(!5 r$o' it +ro$ th,tra)t !tr")t"r i* th =ogi!ti)! E,tra)t Str")t"r C"!to$i>i*g Co)kpit.Th* (&t iti* th )o$$"*i)atio* !tr")t"r or %"++r ta%& app*(.

    .1 Later Enhancement of Extract Structure

    I+ yo" a*t to *ha*) a* ,tra)t !tr")t"r ith +i&(! a*( th "p(at i* th BW ha!a&ra(y %* pro(")ti' +or a hi&5 a*( yo" (o* *ot a*t5 or )a* *ot )arry o"t a *(ata i*itia&i>atio*5 yo" $"!t +o&&o th +o&&oi*g !tp! to pr'*t &o!i*g i*(i'i("a&(&ta "p&oa(! thro"gh thi! a(6"!t$*t.

    1. E*( a&& (o)"$*t po!ti*g! o+ th a++)t( app&i)atio*! i* "rg*t )a!!5 %y&o)ki*g th r&'a*t tra*!a)tio*! yo" (o *ot *( to (a)ti'at th "p(at thi!o"&( % poi*t&!!4.

    2. Start th pro)!!i*g o+ a&& op* "p(at *tri! "!i*g K Co*tro&K i* th=ogi!ti)! E,tra)t Str")t"r C"!to$i>i*g Co)kpit )h)k "!i*g SM1 or rportRMCSBWCC +ro$ PI 2000.24.

    . -&t th !t"p ta%&! o+ th a++)t( app&i)atio*! th! !ho"&( i* a*y )a! %(&t( a+tr a !"))!!+"& i*itia&i>atio*4.

    3. Ft)h th (&ta 9"" (ata +or a&& a++)t( -ataSo"r)! %y r9"!ti*g th)orr!po*(i*g I*+oPa)kag! +ro$ a&& r&'a*t BW !y!t$! )h)k i+ th (ata ha!a&ra(y %* +t)h( "!i*g th rport RMCSBWCC +ro$ PI 2000.24.

    J. E*ha*) th ,tra)t !tr")t"r! or tra*!port th ,tra)t !tr")t"r )ha*g! +ro$ a('&op$*t or )o*!o&i(atio* !y!t$.

    @. A)ti'at th -ataSo"r)!

    L. Rp&i)at th -ataSo"r)! i* th BW?. A)ti'at th a++)t( tra*!+r !tr")t"r! i* th BW.. R!"$ptio* o+ (o)"$*t pro)!!i*g %y th "!r5 a*( !tart o+ th "p(at th

    r!"$ptio* o+ (o)"$*t pro)!!i*g )a* a&ra(y tak p&a) a+tr !tp @ i+ yo" )a**!"r that th "p(at +or th a++)t( ,tra)t !tr")t"r! (o! *ot !tart tooar&y4.

    .2 )nvalid 0ields in the L)S #ommunication Structures

    Not a&& +i&(! that ,i!t i* a* =IS )o$$"*i)atio* !tr")t"r ar o++r( +or !&)tio* +or

    th *ha*)$*t o+ ,tra)t !tr")t"r! i* th =ogi!ti)! E,tra)t Str")t"r C"!to$i>i*gCo)kpit. S")h +i&(! ar ,p&i)it&y +or%i((* i* th *tri! o+ th )o*tro& ta%&TMCECFS.

    2001 SAP Markets Europe GmbH 2,

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    25/27

    Etrakto %e3e4u4s5ate MM

    W !tro*g&y a('i! yo" agai*!t )ha*gi*g th !tti*g! i* th ta%& TMCECFS. I*parti)"&ar5 SAP i&& *ot tak o* $ai*t*a*) r!po*!i%i&ity +or th )o*!9"*)! o+!")h )ha*g!.

    2001 SAP Markets Europe GmbH 26

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    26/27

    Etrakto %e3e4u4s5ate MM

    hanging 7:er from L'+ Data+ources to %it

    Th I*+oSo"r)! *&y (&i'r( ith BW 2.0B ar !tr")t"r( !o that it i! po!!i%&5ith pr'io"!&y a)ti' "p(at! +ro$ th =IS I*+o/!tr")t"r! S011 a*( S012 to )ha*go'r to th * -ataSo"r)! itho"t (ata &o!! or !t"p.

    I+ th BW "p(at o* th %a!i! o+ I*+o/!tr")t"r! S011 a*( S012 i! a)ti'5 )arry o"tth +o&&oi*g !tp! to )ha*g +ro$ th o&( -ataSo"r)! to th * i+ yo" (o*Kt a*t5or ar "*a%& to ha' a )o$p&t !t"p o+ (ata.

    1. Mak !"r that a&& "p(at! o+ th * ,tra)t !tr")t"r! ar (a)ti'at( =BWE4.

    I+ yo" ha' a)i(*ta&&y a)ti'at( "p(at! i* rror5 a+tr (a)ti'atio* !tart th )o&&)ti' r"* +or a&& thr app&i)atio*! "!i*g th )o*tro&.

    2. Tra*!+r th * BW -ataSo"r)! to th O=TPThi! g*rat! th a)ti' 'r!io*! o+ th -ataSo"r)!.Th* rp&i)at th -ataSo"r)! %y i*itia&i>i*g rp&i)atio* i* th BW !y!t$ +or thappropriat !o"r) !y!t$.

    ). Tra*!+r th * BW o%6)t! to th BWI* parti)"&ar5 yo" !ho"&( )hoo! th * I*+oSo"r)!5 th tra*!+r r"&!5 a*( th* "p(at r"&!.

    ,. ;o" $"!t )rat )orr!po*(i*g "p(at r"&! r&ati*g to th * I*+oSo"r)! +ora&& "p(at r"&! )rat( %y yo" i* i*(i'i("a& )"%! o* th %a!i! o+ =IS !tr")t"r!S011 a*( S012.For )"%! (&i'r( %y SAP a! )o*t*t5 th! ar a&!o a&ra(ya'ai&a%& o* th %a!i! o+ th K*K I*+o/!tr")t"r! a*( *( o*&y % a(6"!t( i+ yo"ha' a&ra(y )ha*g( th (&i'r( "p(at r"&! o* th %a!i! o+ S011 a*( S012.Th !tr")t"r S01 '*(or 'a&"atio*4 ha! *ot %* a(6"!t( o* th %a!i! o+ thK*K I*+o/!tr")t"r!.

    6. No $ak !"r that a&& "!r! ith )ha*g a"thori>atio* +or P"r)ha!i*g(o)"$*t! &og o++ +ro$ th !y!t$.

    #. -a)ti'at th "p(at o+ th =IS tra*!+r I*+o/!tr")t"r! S011 a*( S012 ithtra*!a)tio* =BW1.

    7. A)ti'at th "p(at o+ th * ,tra)t !tr")t"r! i* th =ogi!ti)! E,tra)t Str")t"rC"!to$i>i*g Co)kpit.

    (. Th* thr ar *o )o*!trai*t! o* )o*ti*"i*g ith th (o)"$*t pro)!!i*g.

    . No tra*!+r th &a!t o%tai*( (&ta r)or( o+ th o&( -ataSo"r) to th BW.10. No (&t th I*+oPa)kag! o+ th o&( I*+oSo"r)!.

    11. -&t a*y ,i!ti*g (ata r)or(! +ro$ th !t"p ta%&! o+ th * ,tra)t!tr")t"r!.

    2001 SAP Markets Europe GmbH 2#

  • 8/21/2019 Extracting MM Purchasing Data Into SAP BW

    27/27

    Etrakto %e3e4u4s5ate MM

    12. No !tart th I*+oPa)kag! ith th "p(at $o( K(&ta i*itia&i>atio*K +or a)h o+th * I*+oSo"r)!.;o" )a* a&!o !t th !it)h KI*itia&i>atio* itho"t -ata Tra*!+rK +or thi!.R+r to th a((itio*a& i*+or$atio* o* thi! !it)h i* F1 H&p.

    1). Th )o&&)ti' r"*! )a* o*&y % !tart( a+tr thi! poi*t.