FI –PCA – CS – EIS Integration Model

Demo Guide for FI – PCA – CS – EIS Integration model

Update: Nov 24, 1998

List of contents

Introduction to the FI – PCA – CS – EIS Integration model___________________2

Overview of model organizational structure________________________________3
10 minute „Walk-trough EC“____________________________________________4
Financial Accounting: Postings integrated to EC____________________________6
Financial Accounting: Reporting_________________________________________9
Financial Accounting: Fixed Asset Reporting______________________________11
Profit Center Accounting: Org Structures_________________________________12
Profit Center Accounting: Reporting_____________________________________15
EC-CS Consolidation: Org Structures____________________________________18
EC-CS Consolidation: Carrying out consolidation__________________________20
EC-CS Consolidation: Reporting________________________________________23
EC-EIS: Reporting____________________________________________________28
Appendix 1: Used G/L Accounts and FS Items_____________________________31
Appendix 2: MM / SD Integration to Accounting___________________________32

SAP AG, QM-EC 1 480950238.doc

FI –PCA – CS – EIS Integration Model

Introduction to the FI – PCA – CS – EIS Integration model

Purpose:
Demonstrate complex business workflow in an integrated SAP Release 4.x environment. This
model should allow the demonstration of data flow through the financial applications.

Specific areas of interest include:

 Intercompany and interbusines area transactions that originate from SAP FI-GL
 Business Area & “Subsequent Business Area / Profit Center Processing”
 Functional Area Substitution via Cost Center type
 FI/CO Reconciliation Ledger
 Profit Center Accounting
 EC-CS Consolidation with multiple hierarchies for legal / management reporting
 EC-EIS Reporting from different sources: EC-CS, EC-BP, CO-PA, HR (partially started)
 Intercompany and interbusiness area transactions that originate from SAP Logistics SD
and MM Applications

Phased Implementation of Integration Model:

Phase Applications Status

1 FI / Basic CO-OM / PCA / CS / EIS / SD / MM available
2 CO-OM Alloc / CO-RCL / EC-BP not started

Participants:

Model design Marcus Wefers

Model implementation Marcus Wefers

Jens Baumann
Michael Metzner
Heike Wagner
Markus Heß
Sven Kerbitz
Michael Fromme

SAP Systems where Model is available:

System Client Description User / PW

DI0 860 IDES Demo System MusterQMEC / TestQMEC
IDT 860 IDES Test System MusterQMEC / TestQMEC

Documentation
MLP folder “QM-EC-MODEL” – document “EC Integration Model – Main document”

File Titel Content

EC_Integr_Cust.doc Configuration Description of Configuration including IMG
paths
EC_Integr_DemoGuide.doc Demo Guide Description of Posting szenarios in various
SAP modules
EC_Integration.ppt Powerpoint presentation

SAP AG, QM-EC 2 480950238.doc

FI –PCA – CS – EIS Integration Model

Overview of model organizational structure

Fiscal Year: 1999

1998 for year comparison and Cash Flow calculations only

FI

Company Code Business Areas Comments

C100 Palo Alto 6000 Pharma Headquarter
Production of Analgetcs & Diabetics
C200 New York 6000 Pharma Production of Diabetics
C300 Chicago 4000 Chemicals Production of medical substances for the
production of Analgetcs & Diabetics
8000 Services Pharma market analysis

EC-PCA
Controlling area: C001 (USD)
All PrCtr-Groups are linked to Business areas (BA). Examples:

BA in FI BA in EC-PCA Division Product Line Product = PrCtr

= PrCtr-Group
6000 C-BA-6000 C-DIV-61 DIV Analgetics C-PL-611 C6111 AS
BU Pharma BU Pharma Mono C6112 PCM
C-PL-612 C6121 Codein
Combo C6122 Azur
C-DIV-62 DIV Diabetics ... C6211 Insulin
C6212 H-Insulin
C6221 B-Insulin

EC-CS

Global Parameters

Dimension 02 FI Integration
03 PCA Integration
Version 100 Actuals
Fiscal Year 1999
Period 1
Chart of Accounts 01 US
Ledger 1C

SAP AG, QM-EC 3 480950238.doc

FI –PCA – CS – EIS Integration Model

10 minute „Walk-trough EC“

Overview  PPT with US map and Companies and BA See next page
 PPT with PCA Hierarchy underneath BA

FI FI Balance Sheet Reporting via CoCd = C100

FI G/L menu -> Periodic processing -> Info System -> Report
Selection -> choose first entry 5 times Actual / actual comparison for
year

Show FI G/L Document 1800000010 CoCd = C100

& show additional PCA & CS documents Year = 1999
via ‘Environment’ – ‘Accounting documents’
Message: Seemless data flow through all SAP modules

EC-PCA Show PCA Standard Hierarchy with focus on CO Area =

“BU 6000 Pharma” – “Division 61 Analgetics” C001

PCA Reporting via “Information System”- EC Integr.Model Reports Year = 1999

 I/S & B/S DIV Analgetics
 I/S with PCA Hierarchy (SALES, COGS, EBITDA)
 ROA Return on Operating Assets “Analgetics”
 Cash Flow for 3 PrCtr Groups

EC-CS Check Global Parameters Dim 02 / V 100 / 1999 / Per 1 / CoA 01 / Ledger 1C

Show Consolidation Group Hierarchies and focus on parallel

HI for Legal (by company) and Management view (by segment)

Data Monitor – show tasks DIM 02

Consolidation Monitor DIM 02

Choose Group by Segments – and buttom Show Tasks
Run task IU A/R A/P in test mode for group 6000
Expand item HI: 102.350 USD is current periods portion for elim

CS Reporting via Information System – EC Integr.Model Reports

 DIM 02 B/S compare Business Areas w/ HI
 DIM 02 Cash Flow Statment BA 6000
 DIM 02 ROCE – Return on Capital Employed
 Compare FI vs. PCA dimension (B/S Pharma)
 DIM 03 I/S by Products DIV 61 Analgetics DIM 03
 DIM 03 Return on Operating Assets ROA DIM 03

EC-EIS EIS Reporting via EIS menue - Information System – Report - Exec Aspect 712
Report EVA-I and EVA-I-HI
EIS Key figures via EIS Config – Data basis – Key figures – Display – Asp712

SAP AG, QM-EC 4 480950238.doc

FI –PCA – CS – EIS Integration Model

E n te r p r is e S tr u c tu r e

B U 4 0 0 0 C h e m ic a ls
D IV 4 3 M e d ic a l S u b s ta n c e s
D IV 4 1 P a c k a g in g M a te r ia l
B U 8 0 0 0 S e r v ic e s
D IV 8 1 P h a r m a M a r k e t R e s e a r c h

M e d ic a l s u b s ta n c e s & m a te r ia ls M e d ic a l s u b s ta n c e s & m a te r ia ls

C o m p a n y
C 3 0 0 C h ic a g o
H e a d q u a rte r C o m p a n y
C 1 0 0 P a lo A lto C 2 0 0 N e w Y o rk

B U 6 0 0 0 P h a rm a D ia b e tic s p r o d u c ts B U 6 0 0 0 P h a rm a
fo r d is tr ib u tio n
D IV 6 1 A n a lg e tic s D IV 6 2 D ia b e tic s
D IV 6 2 D ia b e tic s

 S A P A G 1 9 9 8 E 6 S tr a te g ic E n te r p r is e M a n a g e m e n t C o n g r e s s , S tr a s b o u r g ( M . W e fe r s ) / 9

S tr a te g ic B u s in e s s U n it „ P h a r m a “

D iv is io n A n a lg e tic s D iv is io n D ia b e tic s

P r o d u c t L in e M O N O P r o d u c t L in e
H u m a n b a s e d In s u lin
 A S A s p a ra x
 P C M P a ra c e ta m o l  In s u lin
 H -In s u lin

P r o d u c t L in e C O M B O P r o d u c t L in e
A n im a l b a s e d In s u lin
 C o d e in C o d e in & P C M
 A z u r C o d e in & A S  B -In s u lin

 S A P A G 1 9 9 8 E 6 S tr a te g ic E n te r p r is e M a n a g e m e n t C o n g r e s s , S tr a s b o u r g ( M . W e fe r s ) / 8

SAP AG, QM-EC 5 480950238.doc

FI –PCA – CS – EIS Integration Model

Financial Accounting: Postings integrated to EC

FI Documents
Menue Path: Accounting – FI – G/L – Document – Display

Within the document:

Environment – Accounting Document  double-click to show PCA or CS document

SAP AG, QM-EC 6 480950238.doc

FI –PCA – CS – EIS Integration Model

EC-CS Document initiated by FI posting

D a ta S tre a m to E C E n te r p r is e C o n tr o llin g

E IS B P
C O -P A E x e c u tiv e B u s in e s s
In fo r m a tio n P la n n in g
H R
S y s te m

E C -C S C o n s o lid a tio n
D im e n s io n
F I D a ta P C A D a ta
C o n s o lid a tio n U n it = C o n s . U n it =
C o m p a n y & B u s . A re a C o m p a n y & P rC tr

E C -P C A
P r o fit C e n te r A c c o u n tin g
P r o fit C e n te r , C o m p a n y C o d e

F I-G L G e n e r a l L e d g e r • A s s e ts • W iP C O C o n tr o llin g
S D B /S a c c o u n ts • A /R • In v e n to r y C o s t C e n te r
• A /P • M is c . O rd e r
M M I/S a c c o u n t
in c lu d in g C O o b je c t P r o je c ts
 S A P A G 1 9 9 8 E 6 S tr a te g ic E n te r p r is e M a n a g e m e n t C o n g r e s s , S tr a s b o u r g ( M . W e fe r s ) / 1 3

SAP AG, QM-EC 7 480950238.doc

FI –PCA – CS – EIS Integration Model

List of all FI documents

ABAP ZMW_1_CHOOSE_FI_DOCUMENT (via SE38 or EC-CS Reporting tree)

List all FI documents for a given G/L Account –> F2 displays single FI document

CoCd C100 Palo Alto Business Area 6000 Pharma Year 1999

FI Doc Nr Account Customer Partne Partne PrCtr Text Partner Text

Vendor r r PrCtr
Asset Comp BA
1800000017 144.000 IC A/R C100CUST2 C20000
802.000 IC Sales 6000 C6211 Insulin C6211 Insulin

1900000035 792.000 Fin. goods C-DV- DIV C4111 Transp

Purchased 61-BS Pharma Foils
164.000 IC A/P C100VEND3 C30000

Documents posted to higher level PrCtr Groups

FI Doc Nr Account Customer Partner Partner PrCtr Text Partner Text

Vendor Comp BA PrCtr
Asset
2100000118 45.000 Investmen C20000 6000 C-BA- BU C-BA- BU
t 6-BS Pharma 6-BS Pharma
110.000 Cash

100000125 2.000 Buildings 20.000 C-BA- BU

9 digits 6-BS Pharma
110.000 Cash
Note:
 Use ZMW_1_CHOOSE_FI_DOCUMENT without option “Ignore Cash”

CoCd C300 Chicago Business Area 4000 Pharma Year 1999

Documents with PrCtr and different Partner-PrCtr

FI Doc Nr Account Customer Partner Partner PrCtr Text Partner Text

Vendor Comp BA PrCtr
1800000007 144.000 IC A/R C300CUST2
802.000 IC C10000 6000 C4311 Acetyl C6111 AS
Sales
Note:
 CS document shows partner C20000 instead of C20000-6000, since BA-Adjustment
program runs subsequnetly !
 Those adjustments can be displayed within FI Postings with the menue path:
Environment – B/S Readjustment

SAP AG, QM-EC 8 480950238.doc

FI –PCA – CS – EIS Integration Model

Financial Accounting: Reporting

Execution via FI reporting tree

FI main menue – Periodic processing – Info system – Reporting

Nach der ersten Ausführung können die Daten gespeichert werden.

First set settings for Company, CoCd, BA, FS version, Year and Periods.
(Wichtig für Datenselektion und Navigation im data cube)

Company Code C100

Business Area 6000
FS Version EC01
Type of currency 10 Company code currency
Period / Year 1 / 1999

SAP AG, QM-EC 9 480950238.doc

FI –PCA – CS – EIS Integration Model

Execution different to FI reporting tree via transaction FIS0

SAP AG, QM-EC 10 480950238.doc

FI –PCA – CS – EIS Integration Model

Financial Accounting: Fixed Asset Reporting

FI-AA main menue – Report Selection – B/S explanations – Asset history sheet – SAP
standard -> choose Variant Integration 01
(CoCd C100, BA 6000, Date 31.01.1999, Depr.Area 01, Sort Version 016 = CoCd & PrCtr,
List assets = group totals, Further settings = posted depreciation (Report RAGITT01)

Double-click on comination of CoCd & PrCtr shows all assets for this combination:
Example CoCd C100 and PrCtr C-BA-6-BS

SAP AG, QM-EC 11 480950238.doc

FI –PCA – CS – EIS Integration Model

Profit Center Accounting: Org Structures

Controlling Area: C001

C-TOP-1 EC North America

C-SEG-A Segment A Pharma & Chemicals
C-BS-SEG-A B/S Segment A
C-SEG-A-BS B/S Segment A

C-BA-6000 Business Unit Pharma

C-BS-BA-6 B/S Business Unit Pharma
C-BA-6-BS B/S Business Unit Pharma

C-DIV-61 Analgetics Division

C-BS-DV-61 B/S Division Analgetics
C-DV-61-BS B/S Division Analgetics
C-PL-611 Product Line Mono 1 substance per product
C6111 AS Acetylsalicyl-Säure (AS-
Acid)
C6112 PCM Paracetamol
(PCM-Acid)

C-PL-612 Product Line Combo multiple substances

C6121 Codein Codein & PCM
C6122 Azur Codein & Acetyl

C-DIV-62 Diabetics Division

C-BS-DV-62 B/S Division Diabetics
C-DV-62-BS B/S Division Diabetics
C-PL-621 Product Line Human based Insulin Herst. über genetisches
Verfahren, das die
tierischen Hormone
(Schwein) an menschliche
Hormone anpaßt.
C6211 Insulin
C6212 H-Insulin
C-PL-622 Product Line Animal based Insulin Herstellung aus Schweine-
Hormonen
C6221 B-Insulin

SAP AG, QM-EC 12 480950238.doc

FI –PCA – CS – EIS Integration Model

C-BA-4000 Business Unit Chemicals

C-BS-BA-4 B/S Business Unit Chemicals
C-BA-4-BS B/S Business Unit Chemicals

C-DIV-41 Plastics Division

C-BS-DV-41 B/S Division Plastics
C-DV-41-BS B/S Division Plastics
C-PL-411 Product Line Foils
C4111 Transparent Foils
C4112 Heavy Duty Foils

C-DIV-43 Medical Subst. Division

C-BS-DV-43 B/S Division Medical Substances
C-DV-43-BS B/S Division Medical Substances
C-PL-431 Product Line Analgetics
C4311 Acetyl
C4312 Paracetamol
C4313 Codein
C-PL-432 Product Line Diabetics
C4321 H-Insulin
C4322 B-Insulin

C-SEG-B Segment B Services

C-BA-8000 Business Unit Services
C-BS-BA-8 B/S Business Unit Services
C-BA-8-BS B/S Business Unit Services

C-DIV-81 Pharma Analysis

C8111 Analgetica Market Analysis
C8112 Diabetica Market Analysis
C-DV-81-BS B/S Division Pharma Analysis

C-SEG-C Segment C Corporate & Others

C-BA-9900 Business Unit Corp & Others
C-BS-BA-9 B/S Business Unit Corp & Others
C-BA-9-BS B/S Business Unit Corp & Others

C-CORP-1 Corp Cash & Funding

C9901 Corp Cash & Funding
C-CORP-2 Corporate Admin
C9902 Corporate Admin
C-CORP-3 Corporate Default
C9903 Default PrCtr

Operatives PrCtr
PrCtr für zusätzliche Bilanzpositionen

SAP AG, QM-EC 13 480950238.doc

FI –PCA – CS – EIS Integration Model

P C A H ie r a r c h y w ith a d d itio n a l B /S P r C tr
T o ta l

S E G P h a rm a & C h e m S E G S e r v ic e s

B U P h a rm a B U C h e m ic a ls

D IV D ia b e t ic s D IV A n a lg e tic s B /S B U P h a r m a

B /S
P rC tr P h a rm a
P r o d u c t L in e M o n o B /S D IV A n a lg e t ic s

B /S
P rC tr A S P rC tr P C M P r C tr A n a lg e tic s

 S A P A G , M .W e fe rs F P M & E C In te g r a tio n A p r il 9 8 / 1 9

SAP AG, QM-EC 14 480950238.doc

 R e a liz a tio n o f E n te r p r is e R e q u ir e m e n ts
FI –PCA – CS – EIS Integration Model
F P M a p p lie d a t h ie r a r c h y le v e ls T o ta l, S e g m e n t, B u s in e s s U n it

 T o ta l C a s h F lo w

 R e tu r n o n C a p ita l E m p lo y e d

R O C E = N O P A T / A v e r a g e C a p ita l E m p lo y e d

N O P A T = N e t O p e r a tin g P r o fit A fte r T a x

C a p ita l E m p lo y e d = E q u ity = T o ta l A s s e ts - T o ta l L ia b ilitie s

o r
= E q u ity + L o n g -te r m L ia b ilitie s
= T o ta l A s s e ts - C u r r e n t L ia b litie s

R e a liz a tio n o f E n te r p r is e R e q u ir e m e n ts
 S A P A G , M .W e fe rs F P M & E C In te g r a tio n A p r il 9 8 / 8

F P M a p p lie d a t h ie r a r c h y le v e ls D iv is io n d o w n to P r C tr
 O p e r a tin g E x p e n s e s
 O p e r a tin g In c o m e
 O p e r a tin g C a s h F lo w (n o in v e s tin g / fin a n c in g )
 R e tu r n o n O p e r a tin g A s s e ts

R O A = O p e r a tin g In c o m e / O p e r a tin g A s s e ts

O p e r a tin g A s s e ts = F ix e d A s s e ts + In v e n to r y + A /R + A /P

 S A P A G , M .W e fe rs F P M & E C In te g r a tio n A p r il 9 8 / 9

SAP AG, QM-EC 15 480950238.doc

FI –PCA – CS – EIS Integration Model

Profit Center Accounting: Reporting

Path: PCA Menue – Information System: -> choose “EC Integration Model Reports”

SAP AG, QM-EC 16 480950238.doc

FI –PCA – CS – EIS Integration Model

I/S & B&S DIV Analgetics C-DIV-61

I/S with PCA Hierarchy (Sales, COGS, EBITDA)

SAP AG, QM-EC 17 480950238.doc

FI –PCA – CS – EIS Integration Model

ROA Return on Operating Assets “Analgetics”

Cash Flow for 3 PrCtr Groups

SAP AG, QM-EC 18 480950238.doc

FI –PCA – CS – EIS Integration Model

EC-CS Consolidation: Org Structures

Global Parameters
Dimension 02 FI Integration
03 PCA Integration
Version 100 Actuals
Fiscal Year 1999
Period 1
Chart of Accounts 01 US
Ledger 1C

Organizational Structure Dimension 02 “FI Integration”

SAP AG, QM-EC 19 480950238.doc

FI –PCA – CS – EIS Integration Model

Organizational Structure Dimension 03 “PCA Integration”

SAP AG, QM-EC 20 480950238.doc

FI –PCA – CS – EIS Integration Model

EC-CS Consolidation: Carrying out consolidation

Data Monitor

Tasks
 Balance Carry Forward
 Data Entry DIM 02 Direct Postings from FI DIM 03 Rollup from PCA
 Standardizing Entries
 Calculation of Net Income
 Validation of local currency
 Currency Translation
 Validation of group currency

SAP AG, QM-EC 21 480950238.doc

FI –PCA – CS – EIS Integration Model

Consolidation Monitor

Tasks
 Interunit Elimination of A/R and A/P
 Interunit Elimination of Sales and COGS
 Interunit Elimination of Dividends payed & received
 ...
 Consolidation of Investments

Task Interunit Elimination within Dim 02 “FI Integration”

SAP AG, QM-EC 22 480950238.doc

FI –PCA – CS – EIS Integration Model

Note: Elimination between C10000-6000 (C100 Pharma) and C30000-4000 (C300 Chem).
Current periods portion for elimination is 94.100 USD (510.000 USD already eliminated.)

Task Interunit Elimination within Dim 03 “PCA Integration”

Elimination between C6211-C10000 (PrCtr C6211 Insulin in CoCd C100) and same PrCtr in
CoCd C200. Difference of 10 USD occured.

SAP AG, QM-EC 23 480950238.doc

FI –PCA – CS – EIS Integration Model

EC-CS Consolidation: Reporting

Dimension 02 - FI Integration

X D02-BS-BA DIM 02 B/S compare Business Areas w/ HI

Compares BA 6000 / 4000 / 8000 using item hierarchy for B/S

D02-BS-CU DIM 02 B/S compare CU w/ Hierarchy

All CU’s in columns with item hierarchy
D02-BS-IS-BA DIM 02 B/S I/S BA Compare - w/o HI
Totals items for all 3 BA’s – no hierarchies
D02-BS-YR DIM 02 B/S Year comparison - Hierarchies
Year comparison for one specified BA

X D02-CFS-BA DIM 02 Cash Flow Statement BA 6000

D02-IS-CU DIM 02 I/S compare CU w/ Hierarchy

All CU’s in columns with item hierarchy

X D02-ROCE-BA DIM 02 ROCE Return on Capital Employed

Reconciliation of data from FI versus PCA Dimension

X D02-D03-COMP Compare FI vs PCA dimension (B/S Pharma)

Great for verification before analysis of PCA data stream
Note: ABAP ZMW_Recon_FI_PCA_CS compares CS with
data sources in FI and PCA by single G/L account

Dimension 03 - PCA Integration

X D03-IS-DIV DIM 03 I/S by Division

Shows SALES, COGS, EBITDA, Op.Profit without hierarchy

X D03-IS-DIV61 DIM 03 I/S by Products DIV 61 Analgetics

Compares DIV Analgetics with it’s PrCtr and B/S-PrCtr

X D03-BS-DIV61 DIM 03 B/S by Products of DIV 61 Analgetics

D03-BS-CU DIM 03 B/S compare CU w/ Hierarchy

Compares PrCtr C6111 and its B/S PrCtr above
D03-BS-DIV62 DIM 03 B/S by Products DIV 62 Diabetics

D03-BS-YR DIM 03 B/S Year comparison - Hierarchies

D03-IS-DIV62 DIM 03 I/S by Products DIV 62 Diabetics

X D03-ROA DIM 03 Return on operating Assets ROA

Compares ROA for DIV & PL of Analgetics and Diabetics

X D03-ROA-DV61 DIM 03 Return on Operating Assets DIV 61

ROA for DIV 61 Analgetics and its products
D03-ROA-DV62 DIM 03 ROA for Products DIV 62 Diabetics
X D03-BS-YR DIM 03 B/S Year comparison - Hierarchies

SAP AG, QM-EC 24 480950238.doc

FI –PCA – CS – EIS Integration Model

D02-BS-BA B/S compare Business Areas with Hierarchy

C a s h F lo w S ta te m e n t
E C -C S R e p o r tin g
B u s in e s s U n it 6 0 0 0 P h a r m a

C F f r o m O p e r a t in g A c t iv itie s

C F f r o m I n v e s tin g A c tiv itie s

C F f r o m F in a n c in g A c t iv it ie s
N e t in c r e a s e in c a s h
 S A P A G , M a rc u s W e fe rs E C In te g r a tio n ( S c r e e n s ) Ju ne l 98 / 1 7

SAP AG, QM-EC 25 480950238.doc

FI –PCA – CS – EIS Integration Model

R O C E - R e tu r n o n C a p ita l E m p lo y e d
E C -C S R e p o r tin g

 S A P A G , M a rc u s W e fe rs E C In te g r a tio n ( S c r e e n s ) Ju ne l 98 / 1 8

R e c o n c ilia tio n o f F I In te g r a tio n v s . P C A In te g r a tio n

w ith in E C -C S

 S A P A G , M a rc u s W e fe rs E C In te g r a tio n ( S c r e e n s ) Ju ne 9 8/ 21

SAP AG, QM-EC 26 480950238.doc

FI –PCA – CS – EIS Integration Model

Continue with DIM 03

Income Statement for Division 61 Analgetics and its products including B/S PrCtr

R O A - R e tu r n o n O p e r a tin g A s s e ts
E C -C S R e p o r tin g
D iv is io n s a n d P r o d u c t L in e s o f B u s in e s s U n it P H A R M A

 S A P A G , M a rc u s W e fe rs E C In te g r a tio n ( S c r e e n s ) Ju ne l 98 / 2 2

SAP AG, QM-EC 27 480950238.doc

FI –PCA – CS – EIS Integration Model

EC-EIS: Reporting

Sorry – this report is currently not available – see EVA reports on next page

EIS Main menue

 Buttom “Ececutive Menu”
 Buttom “Report Portfolio”
 Popup Usergroup: “MR” (Management Reports)
 Financial Performance
 Performance SBU

Data sources for this report:

 EC-CS
 EC-BP (as of Rel 4.5A – Plan values)
 CO-PA (Contribution margin)
 HR (Number of employees)
 MS Excel

SAP AG, QM-EC 28 480950238.doc

FI –PCA – CS – EIS Integration Model

E V A - E c o n o m ic V a lu e A d d e d

C a p ita l c h a r g e fo r m u la

E V A = N O P A T - ( W A C C * C a p ita l )
W A C C = W e ig h te d A v e r a g e C o s t o f C a p ita l

V a lu e S p r e a d fo r m u la

E V A = S P R E A D * C a p ita l
S P R E A D = R e tu r n o n C a p ita l - C o s t o f C a p ita l

 S A P A G 1 9 9 8 E 6 S tr a te g ic E n te r p r is e M a n a g e m e n t C o n g r e s s , S tr a s b o u r g ( M . W e fe r s ) / 4 5

E V A - V a lu e D r iv e r T r e e
E V A
N O P A T - (W A C C x C a p ita l)

N O P A T W A C C C a p ita l
W e ig h te d A v e r a g e C o s t o f C a p ita l

+
C o s t o f E q u ity II C o s t o f D e b t II
x x
C o s t o f E q u ity I E q u ity / C a p ita l R a tio C o s t o f D e b t I D e b t / C a p ita l R a tio
+ x
C o m p a n y R is k P r e m iu m
In te r e s t r a te 1 - T a x ra te
x
M a r k e t R is k P r e m iu m B e ta fa c to r
–
In te r e s t r a te A v e ra g e
r is k fr e e in v e s tm e n t M a rk e t R e tu rn
 S A P A G 1 9 9 8 E 6 S tr a te g ic E n te r p r is e M a n a g e m e n t C o n g r e s s , S tr a s b o u r g ( M . W e fe r s ) / 4 7

SAP AG, QM-EC 29 480950238.doc

FI –PCA – CS – EIS Integration Model

EIS Report EVA-I (Aspect 712) for Business Unit PHARMA

See also Report EVA-I-HI apllying the EC-CS hierarchy

SAP AG, QM-EC 30 480950238.doc

FI –PCA – CS – EIS Integration Model

Appendix 1: Used G/L Accounts and FS Items

Total FS Item G/L Account Clearing Acc
01 CAUS F.5D
Current Assets 110000 110100 110000 Cash
120000 120100 140000 A/R Trade 140098
125000 125100 62120 A/R Other (long term, no customer)
130000 130100 144000 A/R IC (refer to 144098 for Clearing) 144098
135000 135100 300000 Inventory - Raw Materials
135000 135200 793000 Inventory - WiP
135000 135300 792000 Inventory - Finished Goods - Purchased
135000 135400 799999 Inventory - Finished Goods - Production

Financial Assets 170000 170100 45000 Investments Subsidiaries - Purchase

Fixed Assets 191000 191100 1000 Land

191000 191200 2000 Buildings
191000 191500 11000 Machinery and Equipment
195000 195200 2010 Acc.Depreciation - (Land &) Buildings
195000 195500 11010 Acc.Depreciation - Machinery & Equip.

Short-term Liabilities 201000 201100 160000 Trade Payables 160098

205000 205100 46000 Other loans - short term
205000 205500 154000 Tax Accrual (Eingangssteuer Verb) 154095
210000 210100 164000 IC Trade Payables 164098
215000 215200 176500 Income Taxes Payables
220000 220100 175000 GST payable (Ausgangssteuer Ford) 175099
239999 239999 194500 BA Clearing Account

Long-term Liabilities 235000 235100 46020 Other loans, long-term

205700 205700 89000 Misc.Payables (long-term)(Retirements)

Equity 250000 250100 41000 Common Stock

250000 250500 71000 Paid in Capital
251000 251100 900000 Retained Earnings - Prior Years
251000 251200 Retained Earnings - Current Year from I/S

Sales 300000 301100 800000 Sales (3rd parties)- domestic

300000 301200 802000 IC Sales
COGS 303000 303100 893010 Cost of Goods Sold

OPEX 310000 310100 400000 Raw Materials Consumed

310000 310200 890000 Inventory change - work in process
310000 310300 405000 Packaging Materials Expense
310000 310500 416100 Heating and Electricity Expense
310000 310600 417000 Subcontractor Expense
310000 310700 420000 Salaries and Labor Expense
310000 311100 451000 Building maintenance costs
310000 311300 464100 Car Pool: Maintenance
310000 311920 211400 Depr.Expense - Buildings
310000 311950 211500 Depr.Expense - Mach. & Equipment
310000 312400 470000 Office and building rent
310000 312600 473120 Telephone Expense
310000 312900 476900 Other General Expenses
310000 313000 476500 Other Administrative Expenses

Non-operational 320000 320700 220000 Interest Expense

335000 340100 240000 Income Tax Provision (50%)
Net Income 390000 390000 Retained Earnings - Income Statement

SAP AG, QM-EC 31 480950238.doc

FI –PCA – CS – EIS Integration Model

Appendix 2: MM / SD Integration to Accounting

Szenario 1: Intercompany Procurement of “Medical Substances”

L O In te g r a tio n w ith F I a n d P C A
C u sto m e r V e n d o r
C o C d C 1 0 0 - P r C tr C 6 1 1 1 C o C d C 3 0 0 - P r C tr C 4 3 1 1

P u r c h a se O r d e r D e liv e r y

P ic k in g

G o o d s R e c e ip t G o o d s Issu e

I n v o ic e B illin g

 S A P A G 1 9 9 8 E C In te g r a tio n ( M a r c u s W e fe rs ) / 2 2

SAP AG, QM-EC 32 480950238.doc

FI –PCA – CS – EIS Integration Model

L O In te g r a tio n w ith F I a n d P C A

P u r c h a se O r d e r
M E 2 3 D o c 4 .5 0 0 .0 0 0 .0 0 2

N o F I d o c u m e n t a s s o c ia te d !
B u s in e s s T a s k :
C o m p a n y C 1 0 0 P a lo A lto is p la c in g a n o rd e r fo r m a te ria l C -S A 1 A c e ty l
S u b s ta n c e (M a te ria l M a s te r M M 0 3 ) fo r th e p ro d u c tio n o f A S P A R A X .
In te rc o m p a n y s u p p lie r is C 1 0 0 V E N D 3 c o m p a n y C 3 0 0 C h ic a g o .

N o te : P O d ire c tly c re a te s S D w o rk lis t - n o S a le s O rd e r re q u ire d

S e n d e r T r a d in g P a r tn e r
C o C d C 1 0 0 P a lo A lto
B A 6 0 0 0 P h a r m a
P r C tr C 6 1 1 1 A S P A R A X P r o d u c tio n
 S A P A G 1 9 9 8 E C In te g r a tio n ( M a r c u s W e fe rs ) / 2 3

L O In te g r a tio n w ith F I a n d P C A

D e liv e r y & P ic k in g
N o F I d o c u m e n t a s s o c ia te d ! V L 0 3 D o c 8 0 .0 0 0 .0 0 0

B u s in e s s T a s k :
C o m p a n y C 3 0 0 C h ic a g o g o t a n o rd e r fo r m a te ria l C -S A 1 A c e ty l S u b s ta n c e
fro m in te rc o m p a n y c u s to m e r C 3 0 0 C U S T 2 (C o m p a n y C 1 0 0 P a lo A lto ).
C re a tio n o f D e liv e ry a n d P ic k in g b a s e d o n S D w o rk lis t (c re a te d b y P O )

S e n d e r T r a d in g P a r tn e r
C o C d C 3 0 0 C h ic a g o
B A 4 0 0 0 C h e m ic a ls
P r C tr C 4 3 1 1 A c e ty l S u b sta n c e
 S A P A G 1 9 9 8 E C In te g r a tio n ( M a r c u s W e fe rs ) / 2 4

SAP AG, QM-EC 33 480950238.doc

FI –PCA – CS – EIS Integration Model

L O In te g r a tio n w ith F I a n d P C A

G o o d s Issu e
M B 5 1 D o c 4 9 .0 0 2 .2 8 9
B u s in e s s T a s k :
C o m p a n y C 3 0 0 C h ic a g o d e liv e rs g o o d s to I/C c u s to m e r.
F I P o s tin g :
D /R C o s ts o f G o o d s S o ld
C /R In v e n to ry R a w M a te ria ls

N o te : P a rtn e r-P rC tr d e riv e d fro m P O in a n o n -d is trib u te d s y s te m e n v iro n m e n t

S e n d e r T r a d in g P a r tn e r
C o C d C 3 0 0 C h ic a g o C 1 0 0 0 0 P a lo A lto
B A 4 0 0 0 C h e m ic a ls 6 0 0 0 P h a r m a
P r C tr C 4 3 1 1 A c e ty l S u b sta n c e C 6 1 1 1 A S P A R A X
 S A P A G 1 9 9 8 E C In te g r a tio n ( M a r c u s W e fe rs ) / 2 5

L O In te g r a tio n w ith F I a n d P C A

G o o d s R e c e ip t
M B 0 3 D o c 5 0 .0 0 2 .9 4 0

B u s in e s s T a s k :
C o m p a n y C 1 0 0 P a lo A lto re c e iv e s o rd e re d g o o d s fro m in te rc o m p a n y s u p p lie r
F I P o s tin g
D /R In v e n to ry R a w M a te ria l
C /R G R /IR A c c o u n t ( G o o d s R e c e ip t & I n v o ic e R e c e ip t C le a r in g A c c .)
N o te : T ra d in g P a rtn e r-P rC tr d e riv e d fro m D e liv e ry

S e n d e r T r a d in g P a r tn e r
C o C d C 1 0 0 P a lo A lto C 3 0 0 0 0 C h ic a g o
B A 6 0 0 0 P h a r m a 4 0 0 0 C h e m ic a ls
P r C tr C 6 1 1 1 A S P A R A X P r o d u c tio n C 4 3 1 1 A c e ty l S u b sta n c e
 S A P A G 1 9 9 8 E C In te g r a tio n ( M a r c u s W e fe rs ) / 2 6

SAP AG, QM-EC 34 480950238.doc

FI –PCA – CS – EIS Integration Model

L O In te g r a tio n w ith F I a n d P C A

B illin g
V F 0 3 D o c 9 .0 0 0 .0 0 0 .0
B u s in e s s T a s k :
C o m p a n y C 3 0 0 C h ic a g o s e n d s in v o ic e to I/C c u s to m e r.
F I P o s tin g :
D /R C u s to m e r C 3 0 0 C U S T 2 (A /R )
C /R S a le s R e v e n u e s & T a x

N o te : P a rtn e r-P rC tr d e riv e d fro m P O in a n o n -d is trib u te d s y s te m e n v iro n m e n t

S e n d e r T r a d in g P a r tn e r
C o C d C 3 0 0 C h ic a g o C 1 0 0 0 0 P a lo A lto
B A 4 0 0 0 C h e m ic a ls 6 0 0 0 P h a r m a
P r C tr C 4 3 1 1 A c e ty l S u b sta n c e C 6 1 1 1 A S P A R A X
 S A P A G 1 9 9 8 E C In te g r a tio n ( M a r c u s W e fe rs ) / 2 7

L O In te g r a tio n w ith F I a n d P C A

I n v o ic e
M R 0 3 D o c 5 .1 0 0 .0 0 0 .0 0 0

B u s in e s s T a s k :
C o m p a n y C 1 0 0 P a lo A lto re c e iv e s in v o ic e fro m in te rc o m p a n y s u p p lie r
F I P o s tin g
D /R G R /IR A c c o u n t & P ric e D iffe re n c e s
C /R V e n d o r C 1 0 0 V E N D 3 (A /P )
N o te : T ra d in g P a rtn e r-P rC tr d e riv e d fro m D e liv e ry

S e n d e r T r a d in g P a r tn e r
C o C d C 1 0 0 P a lo A lto C 3 0 0 0 0 C h ic a g o
B A 6 0 0 0 P h a r m a 4 0 0 0 C h e m ic a ls
P r C tr C 6 1 1 1 A S P A R A X P r o d u c tio n C 4 3 1 1 A c e ty l S u b sta n c e
 S A P A G 1 9 9 8 E C In te g r a tio n ( M a r c u s W e fe rs ) / 2 8

SAP AG, QM-EC 35 480950238.doc