best practice - project system – controlling (d11)

8/13/2019 Best Practice - Project System – Controlling (D11)

http://slidepdf.com/reader/full/best-practice-project-system-controlling-d11 1/22

SAP BW 3.2

November 2003

English

BW: Project System –Controlling (D11)

SAP AGNeurottstr. 1669190 Wall or! German"

Buil ing Blo#$ %on!iguration Gui e



SAP Best Practices BW: Pro&e#t S"stem ' %ontrolling( %on!iguration Gui e

Copyright) %o*"right 2003 SAP AG. All rights reserve .

No *art o! this *ubli#ation ma" be re*ro u#e or transmitte in an" !orm or !or an" *ur*ose +ithout

the e,*ress *ermission o! SAP AG. -he in!ormation #ontaine herein ma" be #hange +ithout *rior noti#e.

Some so!t+are *ro u#ts mar$ete b" SAP AG an its istributors #ontain *ro*rietar" so!t+are #om*onentso! other so!t+are ven ors.

i#roso!t/ W N WS/ N-/ E4%E5/ Wor / Po+erPoint/ an S 5 Server/ are registeretra emar$s o! i#roso!t %or*oration.

B / B2/ B2 7niversal atabase S82/ Parallel S"s*le,/ S8ESA A 4/ S8390/ AS8:00/S8390/ S8:00/ iSeries *Series ,Series ;Series ;8 S A<P ntelligent iner WebS*here/

Net!init"/ -ivoli/ n!ormi, an n!ormi,/ "nami# Server- are tra emar$s o! B %or*oration in 7SAan 8or other #ountries.

=A%5E/ is a registere tra emar$ o! =A%5E %or*oration.

7N 4/ 48 *en/ S<81/ an oti!/ are registere tra emar$s o! the *en Grou*.

%itri,/ the %itri, logo %A/ Program Neighborhoo / eta<rame/ Win<rame/ i eo<rame/ultiWin/ an other %itri, *ro u#t names re!eren#e herein are tra emar$s o! %itri, S"stems n#.

>- 5 >- 5 4 5 4>- 5 are tra emar$s or registere tra emar$s o! W3%/ Worl Wi e Web%onsortium assa#husetts nstitute o! -e#hnolog".

?A A/ is a registere tra emar$ o! Sun i#ros"stems n#.

?A AS%= P-/ is a registere tra emar$ o! Sun i#ros"stems n#. use un er li#ense !or te#hnolog"invente an im*lemente b" Nets#a*e.

ar$etSet an Enter*rise Bu"er are &ointl" o+ne tra emar$s o! SAP AG an %ommer#e ne.

SAP SAP 5ogo =82 =83 m"SAP m"SAP.#om an other SAP *ro u#ts an servi#es mentione herein as

+ell as their res*e#tive logos are tra emar$s or registere tra emar$s o! SAP AG in German" an inseveral other #ountries all over the +orl . All other *ro u#t an servi#e names mentione are thetra emar$s o! their res*e#tive #om*anies.

) SAP AG o! 22




ContentPro&e#t S"stem ' %ontrolling............................................................................................................6

1 Pre*aration............................................................................................................................. 11

2 nstallation.............................................................................................................................. 12

) SAP AG Page : o! 22




Icons

Icon Meaning

%aution

E,am*le

Note

=e#ommen ation

S"nta,

Typographic Con entions

Type Style Description

Example text Wor s or #hara#ters that a**ear on the s#reen. -hese in#lu e !ielnames s#reen titles *ushbuttons as +ell as menu names *aths ano*tions.

%ross're!eren#es to other o#umentation.

Example text Em*hasi;e +or s or *hrases in bo " te,t titles o! gra*hi#s an tables.

E4A P5E -E4- Names o! elements in the s"stem. -hese in#lu e re*ort names*rogram names transa#tion #o es table names an in ivi ual $e"+or s o! a *rogramming language +hen surroun e b" bo " te,t !ore,am*le SE5E%- an N%57 E.

Example text S#reen out*ut. -his in#lu es !ile an ire#tor" names an their *athsmessages sour#e #o e names o! variables an *arameters as +ell asnames o! installation u*gra e an atabase tools.

EXAMPLE TEXT @e"s on the $e"boar !or e,am*le !un#tion $e"s su#h as F2 or theENTER $e".

Example text E,a#t user entr". -hese are +or s or #hara#ters that "ou enter in thes"stem e,a#tl" as the" a**ear in the o#umentation.

<Example text> ariable user entr". Pointe bra#$ets in i#ate that "ou re*la#e these+or s an #hara#ters +ith a**ro*riate entries.

) SAP AG Page C o! 22




Project System ! Controlling

"se-his Buil ing blo#$ #ontains all the ne#essar" #on!iguration ste*s to install the n!o%ube0PSD%0:( Pro&e#t S"stem ' %ontrolling -e#hni#al Name( 0PSD%0: in "our SAP BW'S"stem.

#o$ can generate reports %or ario$s p$rposes &ase' on this In%oC$&e These incl$'e:

• %al#ulation o! =esi ual r er Plan n!o%ube Pro&e#t S"stem =esi ual r er Planuer" >ierar#hi#al Pro&e#t vervie+ 8 =esi ual r er Plan

• Elimination o! nternal Business olume n!o b&e#t nternal Business olume uer">ierar#hi#al Pro&e#t vervie+ 8 Settlement

A!ter the ar#hiving session elete the master ata an reloa them into BW. ! "ou o not o thisin#onsistent ata ma" e,ist. <or e,am*le the s"stem no longer is*la"s an ar#hive an eleteor er ho+ever the s"stem is*la"s #re its an ebits !or this or er belonging to the WBS

elements.

es$lt-he n!o%ube *rovi es the !ollo+ing in!ormation !or Pro&e#t S"stem ' %ontrolling(

Characteristics

In%o*&ject +ame

imension( Pro&e#t ob&e#ts 0PSD%0:1

0WBSDE5E - WBS Element

0% = E= r er Number

0P= ?E%- Pro&e#t e!inition

0A%- -F Net+or$ A#tivit"

0NE-W =@ Net+or$

0A%-FDE5E - Net+or$ A#tivit" Element

0S-A-7SSFS0 S"stem Status

0 B?S n!o b&e#ts : %hara#ters

imension( rgani;ational 7nits 0PSD%0:2

) SAP AG o! 22




0% DA=EA %ontrolling Area

0% PD% E %om*an" %o e

0B7SDA=EA Business Area

imension( Pro!it %enter 0PSD%0:3

0P= < -D%-= Pro!it %enter

imension( %ost element 0PSD%0::

0% S-E5 N- %ost Element

0 BD%=D N Sen er 8 =e#eiver n i#ator

0S-@EF< G Statisti#al @e" <igure

imension( alue t"*e 0PSD%0:C

0%7=-FPE %urren#" -"*e

0 E-FPE @e" <igure -"*e

0 - E-A 5 etailing the alue -"*e

0 -S-A- Statisti#s n i#ator !or alue -"*e

0 -FPE =e*orting alue -"*e

0%AS> E-A 5 %ash etails

0%AS>-FPE %ash -"*e

imension( Settlement 0PSD%0:6

0P B?S Partner n!o b&e#t : %hara#ter

0P A57E Partner b&e#t

0 N-DB7S nternal Business olume

imension( Plan ersion 0PSD%0:

0 A57A- N aluation ie+

0 E=S N ersion

) SAP AG Page o! 22




Time Characteristics

In%o*&ject +ame

0< S%PE= <is#al Fear 8 Perio

0< S% A=N- <is#al Fear ariant

0< S%FEA= <is#al Fear

0< S%PE=3 Posting Perio

,ey -ig$res

In%o*&ject +ame

0A 7N- Amount

0 7AN- -F uantit"

0A 7N-PP Pro&e#t Plan

0A 7N- P =P Pro&e#t Plan

0 7AN-DA =G nventor" uantit"

estricte' ,ey -ig$res

In%o*&ject +ame -orm$la . estriction

0PSD%0:D=@01: elimite =evenues %urren#" t"*e 20 $e" !igure t"*eelimite result version results

anal"sis version value t"*e etail 12value t"*e !or re*orting a##rual#al#ulation $e" !igure amount

0PSD%0:D=@010 Wor$( a#tual @e" !igure t"*e #osts an #orres*on ingHuantities unit o! measure hours valuet"*e etail 1': value t"*e !or re*orting

a#tual $e" !igure Huantit"

0PSD%0:D=@011 Wor$( *lanne @e" !igure t"*e #osts an #orres*on ingHuantities version *lan version valuet"*e etail 1': value t"*e !or re*orting

*lanne $e" !igure Huantit"

0PSD%0:D=@013 *en or ers %urren#" t"*e 20 $e" !igure t"*ein#oming or ers version results

) SAP AG Page I o! 22




anal"sis version value t"*e !or re*ortinga##rual #al#ulation $e" !igure amount

0PSD%0:D=@012 *en or ers %urren#" t"*e 20 $e" !igure t"*e o*enor ers version results anal"sis

version value t"*e etail 1 value t"*e!or re*orting a##rual #al#ulation $e"!igure amount

0PSD%0:D=@00I =evenues( verall *lan %urren#" t"*e 20 *osting *erio 0$e" !igure t"*e revenues an#orres*on ing Huantities version *lanversion value t"*e !or re*orting *lan$e" !igure *ro&e#t *lan

0PSD%0:D=@00 =evenues( a#tual %urren#" t"*e 20 *osting *erio 1'16$e" !igure t"*e revenues an#orres*on ing Huantities value t"*e

etail 1': value t"*e !or re*ortinga#tual $e" !igure amount

0PSD%0:D=@006 =evenues( *lanne %urren#" t"*e 20 *osting *erio 1'16$e" !igure t"*e revenues an#orres*on ing Huantities version *lanversion value t"*e etail 1': valuet"*e !or re*orting a#tual $e" !igure

*ro&e#t *lan

0PSD%0:D=@01 =evenue in e,#ess o!billing

%urren#" t"*e 20 $e" !igure t"*e sto#$W P version results anal"sis version

value t"*e etail 10 value t"*e !orre*orting a##rual #al#ulation $e" !igure

amount

0PSD%0:D=@016 =evenue sur*lus %urren#" t"*e 20 $e" !igure t"*e*rovision version results anal"sis

version value t"*e etail 10 valuet"*e !or re*orting a##rual #al#ulation$e" !igure amount

0PSD%0:D=@019 %ost o! sales %urren#" t"*e 20 $e" !igure t"*eelimite result version results

anal"sis version value t"*e etail 3'C

value t"*e !or re*orting a##rual#al#ulation $e" !igure amount

0PSD%0:D=@009 %osts( bu get @e" !igure t"*e 20 $e" !igure t"*e#osts an #orres*on ing Huantities

value t"*e !or re*orting bu get $e"!igure amount

0PSD%0:D=@00: %osts( overall *lan %urren#" t"*e 20 *osting *erio 0

) SAP AG o! 22




$e" !igure t"*e revenues an#orres*on ing Huantities version *lanversion value t"*e !or re*orting *lan$e" !igure *ro&e#t *lan

0PSD%0:D=@002 %osts( a#tual %urren#" t"*e 20 *osting *erio 1'16$e" !igure t"*e #osts an #orres*on ingHuantities version *lan version valuet"*e etail 1': value t"*e !or re*orting

a#tual $e" !igure Huantit"

0PSD%0:D=@030 %osts( a#tual in#lu inginvoi#ing

%urren#" t"*e 20 *osting *erio 1'16$e" !igure t"*e #osts an #orres*on ingHuantities value t"*e !or re*orting

a#tual $e" !igure amount

0PSD%0:D=@003 %osts( #ommitment @e" !igure t"*e 20 *osting *erio $e"!igure t"*e #osts an #orres*on ing

Huantities value t"*e !or re*orting#ommitment $e" !igure amount

0PSD%0:D=@001 %osts( *lanne %urren#" t"*e 20 *osting *erio 1'16$e" !igure t"*e #osts an #orres*on ingHuantities version *lan version valuet"*e etail 1': value t"*e !or re*orting

a#tual $e" !igure *ro&e#t *lan

0PSD%0:D=@001 %osts( *lanne in#lu inginvoi#ing

%urren#" t"*e 20 *osting *erio 1'16$e" !igure t"*e #osts an #orres*on ingHuantities version *lan version valuet"*e !or re*orting *lan $e" !igure

*ro&e#t *lan

0PSD%0:D=@020 Provision %urren#" t"*e 20 $e" !igure t"*e*rovision version results anal"sis

version value t"*e etail 1'3 valuet"*e !or re*orting a##rual #al#ulation$e" !igure amount

0PSD%0:D=@01I Provisions !or imminentlosses

%urren#" t"*e 20 $e" !igure t"*eelimite result version results

anal"sis version value t"*e etail1 10 11 value t"*e !or re*orting

a##rual #al#ulation $e" !igure amount

0PSD%0:D=@01C Wor$ in *rogress %urren#" t"*e 20 $e" !igure t"*e sto#$W P version results anal"sis version

value t"*e etail 1'3 value t"*e !orre*orting a##rual #al#ulation $e" !igure

amount

) SAP AG o! 22




"nits

In%o*&ject +ame

0%7==EN%F %urren#"

07N - 7nit o! easure

1 Preparation

1 1 Prere/$isites %or the B$il'ing Bloc0

=elease =eHuirements(

SAP BW

So%t are Component elease 2e el 3ighest S$pport Pac0age

SAP_BASIS 620 0027 SAPKB62027

SAP_ABA 620 0027 SAPKA62027

SAP_BW 310 0008 SAPKW31008

PI_BASIS 2003_1_620 0003 SAPKIPYH53

BI_CONT 320 000 SAPKIBIBP

SAP R/3

So%t are Component elease

SAP_BASIS 620

SAP_ABA 620

SAP_APP! : 0

PI_BASIS 2003D1D620

PI 2003D1D: 0

-he use o! automate BES- P=A%- %ES installation +ith hel* !rom Business %on!iguration

SetsJ %A-- *ro#e ures transa#tions an re*orts +as onl" vali ate !or the releases mentioneabove. ther releases have not been teste an vali ate thus !un#tional an integrationrestri#tions must be #onsi ere .

Be%ore starting acti ities in this B$il'ing Bloc04 yo$ nee' to per%orm or chec0 the%ollo ing points:

1. %onne#tivit"(

5o#al Settings SAP =83 the !ollo+ing a#tivities have to be #om*lete (

e!ining a 5ogi#al S"stem !or SAP =83 SAP =83

) SAP AG o! 22




%reating an =<% 7ser SAP =83

Assigning 5ogi#al S"stem to %lient SAP =83

5o#al Settings SAP BW the !ollo+ing a#tivities have to be #om*lete (

e!ining a 5ogi#al S"stem !or SAP BW SAP BW

Assigning 5ogi#al S"stem to %lient SAP BW

%reating an =<%'7ser SAP BW

%ross %onne#tivit" SAP =83 +ith SAP BW the !ollo+ing a#tivities have to be #om*lete (

SAP =83 e!ining a 5ogi#al S"stem !or SAP BW SAP =83

SAP =83 %onne#ting SAP BW SAP =83

SAP BW e!ining a 5ogi#al S"stem !or SAP =83 SAP BW

SAP BW %onne#ting SAP =83 SAP BW

SAP BW %reating =83 Sour#e S"stem SAP BW

2. General Settings !or BW ntegration(General settings in =83 the !ollo+ing a#tivities have to be #om*lete (

-rans!erring A**li#ation %om*onent >ierar#h" =83

General BW Settings the !ollo+ing a#tivities have to be #om*lete (

Settings !or aterial Number %onversion

-rans!erring Global Settings !rom =83

aintaining Sour#e S"stem s

5 Installation

5 1 Trans%erring B$siness Content DataSo$rces into 6cti e7ersion

"se! "ou +ant to trans!er ata !rom a sour#e s"stem into a BW using Business %ontentataSour#es then "ou have to !irst trans!er these ataSour#es in the sour#e s"stem !rom the

version into the a#tive version A version . -his a#tivit" is also reHuire !or this n!o%ube

! "ou *er!orme it alrea " "ou o not have to o it again. n that #ase "ou #an s$i* this #ha*ter.

Prere/$isites

Fou have #arrie out all the *revious ste*s.

Proce'$re-his ste* has to be #arrie out in the BW s"stem.

S6P BW -rans!erring Business %ontent ataSour#es

Transaction Co'e =SA1

n the A"m#$#%t&at'& W'&()e$*+, -'"el#$. vie+ #hoose S'/&*e % %tem%

) SAP AG o! 22




=ight'#li#$ the =83 Sour#e S"stem in the right han +in o+ an #hoose C/%t'm# #$. '& t+eExt&a*t'&%-he BW's"stem starts an =<%'%all to the Sour#e s"stem #lient.

! the logon s#reen o! "our sour#e s"stem is is*la"e log on to "our =83 sour#e s"stem #lient.ther+ise the 4#%pla I- vie+ is is*la"e imme iatel". n the 4#%pla I- #e #hoose

B/%#$e%% I$ '&mat#'$ Wa&e+'/%e à Business %ontent ataSour#es à -rans!er Business%ontent ataSour#es. n the I$%tallat#'$ ' 4ataS'/&*e !rom Business %ontent ie+ e,*an theno e SAP'=83.

1.

E ,*an the no e CO an sele#t the no e CO IO.

<rom the a**li#ation toolbar #hoose E"#t à Sele*t S/)$'"e 9: ;<=

<rom the no e CO IO sele#t the !ollo+ing(

6ll Dataso$rces .


-he sele#te ataSour#es the sele#te no es an all ataSour#es belo+ the sele#te no esa**ear in i!!erent #olour on the vie+.

2.

E,*an the no e CO O- an sele#t the no e CO O- OPA .


<rom the no e CO O- OPA sele#t the !ollo+ing(0% D D PAD1( nternal r ers( %osts0% D D PAD3( nternal r ers( verall8Annual Plan alues0% D D PAD6( nternal r ers( A#tual %osts 7sing elta E,tra#tion



3.

E ,*an the no e CO an sele#t the no e CO O- .


E,*an the no e CO O- P>O an sele#t the !ollo+ing(

0% D DN-WD1( Net+or$( %osts0% D DN-WD2( Net+or$s( A#tual %osts 7sing elta E,tra#tion0% D DNWAD1( Net+or$ A#tivities( %osts0% D DNWAD2( Net+or$ A#tivities( A#tual %osts 7sing elta E,tra#tion0% D DNAED1( Net+or$ A#tivit" Element( %osts0% D DNAED2( Net+or$ A#tivit" Elements( A#tual %osts 7sing elta E,tra#tion0% D DWBSDC( WBS Elements( A##rual %al#ulations0% D DWBSD2( WBS Element( Bu get0% D DWBSD1( WBS Elements( %osts

) SAP AG o! 22




0% D DWBSD:( WBS Elements( Statisti#al @e" <igures0% D DWBSD3( WBS Elements( verall Plan



:.

E ,*an the no e PS an sele#t the no e PS IO .


E,*an the no e PS IO an sele#t the !ollo+ing(

6ll Dataso$rces


-he sele#te ataSour#es the sele#te no es an all ataSour#es belo+ the sele#te no esa**ear in i!!erent #olor on the vie+.

C.

E,*an the no e PS an sele#t the !ollo+ing(0PSD%S>DNWA( Pa"ments in Net+or$ A#tivities0PSD%S>DN-W( Net+or$ Pa"ments0PSD%S>DWBS( Pa"ments in WBS Elements


-he sele#te ataSour#es the sele#te no es an all ataSour#es belo+ the sele#te no esa**ear in i!!erent #olor on the vie+.

n#e "ou have sele#te all reHuire ataSour#es an no es #hoose T&a$% 4ataS'/&*e% !romthe a**li#ation toolbar.

! a ialog bo, a**ears reHuesting the user to enter a evelo*ment #lass enter the a**ro*riateevelo*ment #lass an #hoose Sa e

%hoose Ba*( t+i#e to return to "our BW's"stem.

es$ltFou have trans!erre the ataSour#es !or master ata an transa#tion ata that are reHuire !orthe n!o%ube into the a#tive version.

5 5 eplicating DataSo$rces %or .8 System

"se-his a#tivit" is ne#essar" !or ata u*loa .

Prere/$isites%onne#tivit" bet+een SAP BW an SAP =83 has been set u*. ataSour#es have been #reate ora#tivate in the =83 Sour#e S"stem.

) SAP AG Page 1: o! 22




Proce'$re-his a#tivit" has to be #arrie out in the BW s"stem.

S6P BW oleMen$

>epl#*at#$. 4ataS'/&*e% '& >:3 S %tem

Transaction co'e=SA13

1. n the A"m#$#%t&at'& W'&()e$*+, -'"el#$. vie+ right'#li#$ the =83 Sour#e S"stem in the righthan +in o+ an #hoose >epl#*ate 4ataS'/&*e%

-o #he#$ the re*li#ation o! the ataSour#es right'#li#$ "our Sour#e S"stem in theright han +in o+ an #hoose 4ataS'/&*e ' e& #e .

n the right !rame #hoose ?p"ate T&ee . -he ataSour#es !rom "our =83'S"stem areis*la"e in the right han +in o+.

-he ataSour#es that "ou have a#tivate be!ore shoul be seen.

5 8 6ssigning So$rce System %or 6cti ation"seWhen "ou a#tivate Business %ontent ataSour#es are assigne to n!oSour#es !or all e,istingsour#e s"stems. ! "ou have several sour#e s"stems this ma" ta$e a lot o! time be#ause alsotrans!er rules have to be a#tivate !or ea#h ataSour#e !rom ea#h sour#e s"stemB" assigning the sour#e s"stems "ou limit the assignment to onl" the ataSour#es !rom theassigne sour#e s"stems. -his re u#es the time !or a#tivation.

Assign onl" the sour#e s"stems "ou nee to loa ata !rom !or the Business %ontent b&e#ts that"ou are going to a#tivate.

Prere/$isitesFou have #arrie out all the *revious ste*s.

Proce'$reS6P BW ole Men$ A*t# at#$. B/%#$e%% C'$te$t → A%%#.$ S'/&*e S %tem '& A*t# at#'$

Transaction Co'e =S =B%-

-hen #arr" out the !ollo+ing ste*s(

1. n the A"m#$#%t&at'& W'&()e$*+, B/%#$e%% C'$te$t vie+ !rom the menu #hoose E"#t S'/&*e S %tem A%%#.$me$t

2. n the C+''%e %'/&*e % %tem ) "e a/lt@ ialog bo, sele#t the #he#$bo, in the #olumn 4e a/lt a%%#.$me$t in the ro+ #ontaining the sour#e s"stems "ou nee to loa ata !rom

3. %hoose C'$t#$/e .

5 9 6cti ating B$siness Content: In%o*&ject Catalogs

"se A#tivate all ne#essar" n!o b&e#t %atalogs

) SAP AG Page 1C o! 22






-o a#tivate Business %ontent( n!o b&e#t %atalogs #hoose(

S6P BW oleMen$

A*t# at#$. B/%#$e%% C'$te$t → A*t# at#$. B/%#$e%%C'$te$t, I$ 'O) e*t Catal'.%

Transaction co'e =S =B%-


1. n the A"m#$#%t&at'& W'&()e$*+, B/%#$e%% C'$te$t vie+(

a. At the to* o! the right !rame #hoose &'/p#$. an sele#t '$l $e*e%%a& ') e*t% .

b. At the to* o! the right !rame #hoose C'lle*t#'$ m'"e an sele#t *'lle*t a/t'mat#*all .

#. n the le!t !rame sele#t O) e*t t pe% .. n the mi le !rame e,*an I$ 'O) e*t Catal'. an ouble'#li#$ Sele*t O) e*t% .

2. n the I$p/t +elp '& -eta"ata ialog bo,.

Sele#t the !ollo+ing n!o b&e#t #atalogs(

0 PAD%>A01 verhea %ost r ers à PA( %hara#teristi#s

0 PAD@F<01 verhea %ost r ers à PA( @e" !igures

0WBSD%>A01 verhea Pro&e#ts à WBS( %hara#teristi#s

0WBSD@F<01 verhea Pro&e#ts à WBS( @e" !igures

0PSD%>A01 Pro&e#t S"stem à PS( %hara#teristi#s

0PSD@F<01 Pro&e#t S"stem à PS( @e" !igures

<or multi*le sele#tion use the Ct&l '@e".

a. %hoose T&a$% e& %ele*t#'$%.

b. ! a ialog bo, Ex*ee"e" &/$t#me +e$ *'lle*t#$. ') e*t% a**ears #hooseC'$t#$/e .

3. At the to* o! the right !rame #hoose I$%tall an sele#t I$%tall #$ Ba*(.&'/$" .

:. n the I$%tall )/%#$e%% *'$te$t #$ t+e Ba*(.&'/$" ialog bo, #hoose Fes.

C. n the I$ '&mat#'$ ialog bo, note the &ob number an #hoose C'$t#$/e .

es$ltFou have starte a ba#$groun &ob that a#tivates the n!o b&e#t %atalogs. When the &ob is!inishe su##es!ull" the n!o b&e#t %atalogs are a#tive. n transa#tion S 3 "ou #an #he#$ i! the

&ob is !inishe .

) SAP AG o! 22




5 6cti ating B$siness Content: In%oSo$rces

"se A#tivate all re*orting relevant n!oSour#es !or the n!o%ube.


Proce'$re-his a#tivit" has to be #arrie out in the BW s"stem(

S6P BW oleMen$

A*t# at#$. B/%#$e%% C'$te$t → A*t# at#$. B/%#$e%%C'$te$t, I$ 'S'/&*e%

Transaction co'e =S =B%-


1. n the A ministrator Wor$ben#h( Business %ontent s#reen(a. At the to* o! the right !rame #hoose &'/p#$. an sele#t n ata!lo+ be!ore.

b. At the to* o! the right !rame #hoose C'lle*t#'$ m'"e an sele#t *'lle*t a/t'mat#*all .

#. n the le!t !rame sele#t O) e*t t pe%.

. n the mi le !rame e,*an I$ '%'/&*e% an ouble'#li#$ Sele*t O) e*t% .

2. n the I$p/t +elp '& -eta"ata ialog bo,.3. Sele#t the !ollo+ing n!osour#es(

0% D D PAD1( nternal r ers( %osts0% D D PAD3( nternal r ers( verall8Annual Plan alues0% D D PAD6( nternal r ers( A#tual %osts 7sing elta E,tra#tion0% D DN-WD1( Net+or$( %osts0% D DN-WD2( Net+or$s( A#tual %osts 7sing elta E,tra#tion0% D DNWAD1( Net+or$ A#tivities( %osts0% D DNWAD2( Net+or$ A#tivities( A#tual %osts 7sing elta E,tra#tion0% D DNAED1( Net+or$ A#tivit" Element( %osts0% D DNAED2( Net+or$ A#tivit" Elements( A#tual %osts 7sing elta E,tra#tion0% D DWBSDC( WBS Elements( A##rual %al#ulations0% D DWBSD2( WBS Element( Bu get0% D DWBSD1( WBS Elements( %osts0% D DWBSD:( WBS Elements( Statisti#al @e" <igures0% D DWBSD3( WBS Elements( verall Plan0PSD%S>DNWA( Pa"ments in Net+or$ A#tivities0PSD%S>DN-W( Net+or$ Pa"ments

0PSD%S>DWBS( Pa"ments in WBS Elements

<or multi*le sele#tion use the Ct&l '@e".

a. %hoose T&a$% e& %ele*t#'$%.

b. ! a ialog bo, Ex*ee"e" &/$t#me +e$ *'lle*t#$. ') e*t% a**ears #hoose C'$t#$/e .

:. At the to* o! the right !rame #hoose nstall an sele#t nstall in Ba#$groun .

) SAP AG Page 1 o! 22




C. n the nstall Business %ontent in the Ba#$groun ialog bo, #hoose "es.

6. n the n!ormation ialog bo, #hoose %ontinue.

. %hoose Ba*( .

6cti ating B$siness Content: In%oC$&e

"sen this ste* "ou a#tivate the n!o%ube 0PSD%0: Pro&e#t S"stem ' %ontrolling .



-o a#tivate Business %ontent( n!o%ubes #hoose(

S6P BW oleMen$

A*t# at#$. B/%#$e%% C'$te$t → A*t# at#$. B/%#$e%%C'$te$t, I$ 'C/)e

Transaction co'e >SO>BCT


1. n the A"m#$#%t&at'& W'&()e$*+, B/%#$e%% C'$te$t s#reen(

a. At the to* o! the right !rame #hoose &'/p#$. an sele#t #$ "ata l' )e '&e a$"a te& +ar s.

b. At the to* o! the right !rame #hoose C'lle*t#'$ m'"e an sele#t *'lle*ta/t'mat#*all .

#. n the le!t !rame sele#t O) e*t t pe% .. n the mi le !rame e,*an I$ 'C/)e an ouble'#li#$ Sele*t O) e*t% .

2. n the n*ut hel* !or -eta"ata ialog bo,(

a. Sele#t the n!o%ube 0PSD%0: Pro&e#t S"stem ' %ontrolling .

b. %hoose T&a$% e& %ele*t#'$%.

#. ! a ialog bo, Ex*ee"e" &/$t#me +e$ *'lle*t#$. ') e*t% a**ears #hooseC'$t#$/e .

3. At the to* o! the right !rame #hoose I$%tall an sele#t I$%tall #$ Ba*(.&'/$" .

:. n the I$%tall )/%#$e%% *'$te$t #$ t+e Ba*(.&'/$" ialog bo, #hoose Fes.

C. n the I$ '&mat#'$ ialog bo, note the ?ob number an #hoose C'$t#$/e .

es$ltFou have starte a ba#$groun &ob that a#tivates the n!o%ube. When the &ob is !inishesu##es!ull" the n!o%ube is a#tive.

n transa#tion S 3 "ou #an #he#$ i! the &ob is !inishe .

) SAP AG Page 1I o! 22




5 ; 2oa'ing Master Data . Te<ts . 3ierarchies

"se-his se#tion es#ribes the *ro#e ure !or loa ing master ata attributes te,ts an hierar#hies intoSAP BW.


Proce'$re! there is no master ata in the Sour#e s"stems o this ste* later an go to the ne,t a#tivit".

-his a#tivit" has to be #arrie out in the BW s"stem(S6P BW oleMen$

!'a"#$. 4ata → !'a"#$. -a%te& 4ata : Text% :H#e&a&*+#e%

Transaction co'e =SA12


1. n the A"m#$#%t&at'& W'&()e$*+, -'"el#$. vie+ the I$ 'S'/&*e% tree is is*la"e .

2. -o !in out +hi#h n!oSour#es are use in the n!o#ube re!er to the *ro#e ure es#ribebelo+.Fou +ill !in "our #orres*on ing Sour#e S"stem belo+ ea#h n!oSour#e +here ataSour#esare assigne .<or ea#h relevant n!osour#e that "ou nee to loa ata to see table belo+ *ro#ee as!ollo+s(Sele#t the Sour#e S"stem belo+ the n!oSour#e an #hoose C&eate I$ ' Pa*(a.e rom the#onte,t menu.

a. n the C&eate I$ 'Pa*(a.e ialog bo, "ou #an see all assigne ataSour#es.

b. a$e the !ollo+ing entries(

-iel' =ntry

n!oPa#$age es#ri*tion An" name

#. Sele#t one ataSour#e.

. %hoose Sa e

3. n the S*+e"/le& ;-a#$ta#$ I$ 'Pa*(a.e vie+(

a. ! "ou +ant to loa master ata hierar#hies #hoose the H#e&a&*+ Sele*t#'$ tab.ther+ise *ro#ee +ith ste* b.n the H#e&a&*+ Sele*t#'$ tab ma$e the !ollo+ing #hanges(

• %li#$ A a#la)le H#e&a&*+#e% &'m O!TP • %hoose the hierar#hies "ou +ant to u*loa b" #li#$ing the ra io bo,

• -i#$ the #he#$bo, o! the sele#te hierar#hies

b. %hoose the P&'*e%%#$. tab an ma$e the !ollo+ing entries(

-iel' =ntry

) SAP AG o! 22




PSA an then in then!o b&e#t

4

#. %hoose the ?p"ate pa&amete&% tab an ma$e the !ollo+ing entries(

-iel' =ntry

<ull u* ate 4

. %hoose the S*+e"/le tab an ma$e the !ollo+ing entries(

-iel' =ntry

Start ata loaimme iatel"

4

e. %hoose Sta&t;Exe*/te

<or testing *ur*oses "ou #an start the &ob imme iatel".

n *ro u#tive BW s"stems "ou shoul start the &ob later in the ba#$groun .

%reate an n!oPa#$age !or all ataSour#es "ou nee .Fou onKt have to loa ata !rom all ataSour#es &ust !or the #hara#teristi#s an

imensions "ou +ant to be is*la"e in "our Hueries.

>et 2ist o% In%oSo$rces $se' in the In%oC$&en A"m#$#%t&at'& W'&()e$*+ , -'"el#$. vie+ go to I$ 'P&' #"e& right #li#$ on the n!o%ube an

#hoose I$ 'S'/&*e O e& #e . Fou get an entire list o! the n!oSour#es use in this n!o%ube.

5 ? 2oa'ing Transaction Data"se

! there is no ata in the Sour#e s"stem #om*lete this a#tivit" later.



-o loa -ransa#tion ata #hoose(S6P BW oleMen$

!'a"#$. 4ata → !'a"#$. T&a$%a*t#'$ 4ata

Transaction co'e =SA12


) SAP AG o! 22




1. n the A ministrator Wor$ben#h( -'"el#$. vie+(Per!orm the !ollo+ing a#tivities !or ea#h o! !ollo+ing n!oSour#es(

0% D D PAD1( nternal r ers( %osts0% D D PAD3( nternal r ers( verall8Annual Plan alues0% D D PAD6( nternal r ers( A#tual %osts 7sing elta E,tra#tion0% D DN-WD1( Net+or$( %osts0% D DN-WD2( Net+or$s( A#tual %osts 7sing elta E,tra#tion0% D DNWAD1( Net+or$ A#tivities( %osts0% D DNWAD2( Net+or$ A#tivities( A#tual %osts 7sing elta E,tra#tion0% D DNAED1( Net+or$ A#tivit" Element( %osts0% D DNAED2( Net+or$ A#tivit" Elements( A#tual %osts 7sing elta E,tra#tion0% D DWBSDC( WBS Elements( A##rual %al#ulations0% D DWBSD2( WBS Element( Bu get0% D DWBSD1( WBS Elements( %osts0% D DWBSD:( WBS Elements( Statisti#al @e" <igures0% D DWBSD3( WBS Elements( verall Plan0% D DWBSD6( WBS Elements( A#tual %osts -hrough elta E,tra#tion0PSD%S>DNWA( Pa"ments in Net+or$ A#tivities0PSD%S>DN-W( Net+or$ Pa"ments

0PSD%S>DWBS( Pa"ments in WBS Elements

2. Sele#t the Sour#e s"stem belo+ the n!oSour#e.

a. <rom the #onte,t menu #hoose C&eate I$ 'Pa*(a.e .

b. n the C&eate I$ 'Pa*(a.e ialog bo, there shoul be assigne one ataSour#e +iththe same name as the n!oSour#e. a$e the !ollo+ing entries(

-iel' =ntry

n!oPa#$age es#ri*tion Enter a es#ri*tion

#. Sele#t the ataSour#e.

. %hoose Sa e

3. n the S#he uler aintain n!oPa#$age s#reen #hoose the P&'*e%%#$. tab an ma$e the!ollo+ing entries(

-iel' =ntry

PSA an then into atatargets *a#$et b"*a#$et

4

a. %hoose the 4ata Ta&.et% tab an ma$e the !ollo+ing entries(

-iel' =ntry

7* ate in all atatargets !or +hi#h a#tiverules e,ist

4

b. %hoose the ?p"ate tab. >ere "ou have the !ollo+ing o*tions !or the u* ate mo e(

"p'ate Mo'e Description

</ll ?p"ate A !ull u* ate reHuests all ata that #orres*on s to thesele#tion #riteria "ou etermine in the S#he uler.

! "ou loa ata the !irst time an "ou +ant to loa alle,isting ata into BW #hoose u* ate mo e <ull u* ate

4elta ?p"ate A elta u* ate onl" reHuests ata +hi#h has a**eare

) SAP AG o! 22




sin#e the last loa ing o! ata !rom the ataSour#e. %hoose this u* ate mo e !or *erio i# u*loa o!transa#tion ata.

A elta u* ate is onl" *ossible !or loa ing !romSAP sour#e s"stems.

Be!ore "ou #an reHuest a elta u* ate "ou must !irstinitiali;e the elta *ro#ess see ne,t table ro+ .

nitiali;e elta *ro#ess

A#tuall" this is anin i#ator !or the sour#es"stem that !rom no+ ononl" ne+l" #reate or#hanges8 eletions o!transa#tion ata are tobe trans!erre to SAPBW.

-o reHuest eltas "ou nee to have initiali;e the elta*ro#ess.

-he elta *ro#ess is initiali;e +hen a ata loa ingreHuest +ith u* ate mo e I$#t#al# e "elta *ro#ess has been e,e#ute su##es!ull". -hen it has the status greenin the a ministrator +or$ben#h monitor.

! there is no ata !oun in the sour#e s"stem thereHuest remains +ith status amberL-o ma$e sure that the reHuest is e,e#ute su##es!ull"

even i! there is no ata "et in the sour#e s"stem sele#tthe #he#$bo, I$#t#al# e W#t+'/t 4ata T&a$% e& L

#. %hoose the a*ro*riate u* ate mo e. We re#ommen to sele#t also the Al a % /p"ate"ata e e$ # $' ma%te& "ata ex#%t% '& t+e "ata button.

-he u* ate mo e re!ers onl" to the ata that meet the sele#tion #riteria that "ouinsert on the 4ata Sele*t#'$ tab.

.%hoose the S*+e"/le tab an ma$e the !ollo+ing entries(

-iel' =ntryStart ata loaimme iatel"

4

e. %hoose Sta&t .

<or testing *ur*oses start the &ob imme iatel".n *ro u#tive BW s"stems "ou shoul start the &ob later in the ba#$groun .

es$lte*en ing on the u* ate mo e "ou #hose either ata is loa e into the ata target an 8or the

elta *ro#ess is initiali;e in the sour#e s"stem.

-he su##es o! the initiali;ation o! the elta *ro#ess #an be #he#$e in the sour#es"stem in transa#tion =SA elta ueue aintenan#e . ! the initiali;ation has beensu##ess!ull !or an n!oSour#e "ou +ill !in the #orres*on ing ata sour#e +ith thesame te#hni#al name in the vie+ +ith status green.

best practice - project system – controlling (d11)

Documents