$&5HSRUWLQJLQ),
$&
5HSRUWLQJLQ), SAP AG 2001 SAP AG 2001
n
System R/3
n
Release 4.6C
n
December 2001
n
Collection 14
n
Material Number 5005 1177
&RS\ULJKW
&RS\ULJKW6$3$*$OOULJKWVUHVHUYHG
1RSDUWRIWKLVSXEOLFDWLRQPD\EHUHSURGXFHGRUWUDQVPLWWHGLQ DQ\IRUPRUIRUDQ\SXUSRVHZLWKRXWWKHH[SUHVVSHUPLVVLRQRI 6$3$*7KHLQIRUPDWLRQFRQWDLQHGKHUHLQPD\EHFKDQJHG ZLWKRXWSULRUQRWLFH $OOULJKWVUHVHUYHG
SAP AG 2001
7UDGHPDUNV n
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
n
Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® and SQL Server® are registered trademarks of Microsoft Corporation.
n
IBM®, DB2®, OS/2®, DB2/6000®, Parallel Sysplex®, MVS/ESA®, RS/6000®, AIX®, S/390®, AS/400®, OS/390®, and OS/400® are registered trademarks of IBM Corporation.
n
ORACLE® is a registered trademark of ORACLE Corporation.
n
INFORMIX®-OnLine for SAP and INFORMIX® Dynamic ServerTM are registered trademarks of Informix Software Incorporated.
n
UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of the Open Group.
n
HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.
n
JAVA® is a registered trademark of Sun Microsystems, Inc.
n
JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.
n
SAP, SAP Logo, R/2, RIVA, R/3, ABAP, SAP ArchiveLink, SAP Business Workflow, WebFlow, SAP EarlyWatch, BAPI, SAPPHIRE, Management Cockpit, mySAP.com Logo and mySAP.com are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other products mentioned are trademarks or registered trademarks of their respective companies.
P\6$3)LQDQFLDOV),*/),$3),$5),$$),%/ P DQVU 0 ? 0# =@= A
B B
-.+ ') *, /10 2 "+ 435 # #
; ')+*+, 7 0 ?7= 3A7m5B; = 163 f
D E G HI.J¡KXM
N%O O?O Q?R
S'T J¡K
¢£e b Y+¤?H
D b H c
¥
St Assignment
Doc. No.
T G ¤ZbAe!Y GJI 9=KA9C8L D;CB '&AGMEG9 - %D>-Q=ACB=L;GSBBM9=>:G9 -
General details Evaluation name
'XHGDWHVWUXFWXUHE\ FRPSDQ\FRGH
SAP AG 2001
n
You enter the GDWDEDVHILHOG to be used to JURXSWKHHYDOXDWLRQ here. For the evaluation 'XHGDWH VWUXFWXUHE\FRPSDQ\FRGH, you have to enter the database field .1%%8.56 (see example on slide).
n
In the field 1XPEHURIWRSFXVWRPHUV, specify how many accounts or documents are to be included in the ranked list for this evaluation.
n
Using the parameters for the VRUWLQJE\QXPEHURIGD\V, you can enter day intervals for sorting the selected items (for example, for the due/not due items). Using the entries 15, 30, 45, a sorted list would be generated: é 0 – 15
é 16 - 30
é 31 – 45 é > 45
© SAP AG
AC280
5-12
$GGLWLRQDO9DULDQW$WWULEXWHV 9DULDQWPDLQWHQDQFH 5HSRUW5)'55(YDULDQW Variant attribute Field for grouping No. of top customers List sorted by days
.1%%8.56
GC9 &DrF@l9=;SNH?CD mL Dr< K D"B LO;nQ9"K 9 ;?SG E : : : E E : : : : : : E : :: v tuCvvCu vvv tJu uCvv"t yvvv ttuCvv"t t vvv /)IG=> 9"GHQ9"K 9=;?SGMp vCvCvYYy vCvvxtJ vvCvC y vCvv (DAx< GSqL;GM8m
GMI9"> L 9"Q=K Gp;x9";" L D=:Gq:G">r8EDH8m
G GJNH 9"GB9=K GCBxp vvvCt vCvvC" vCvvC y vCvCv
7KHEDVLFOLVWVKRZVWKHIROORZLQJ YDOXHVSHUFRPSDQ\FRGH å %DODQFHRIRSHQLWHPVLQWKH FXVWRPHUDFFRXQWV
$YHUDJHVDOHVIRUWKHVHOHFWHG SHULRG
ê '62GD\VEDODQFHGLYLGHGE\ WKHDYHUDJHVDOHVSHUPRQWK PXOWLSOLHGE\
SAP AG 2001
© SAP AG
AC280
5-27
'62$QDO\VLV'D\V
'D\V6DOHV2XWVWDQGLQJ
7KHEDVLFOLVWVKRZVWKHIROORZLQJ YDOXHVSHUFRPSDQ\FRGH
&DOFXODWLRQW\SH $YHUDJHEDODQFHVDOHVIURPRQHGD\ $WG"K 9S8¢L D;CB=
LOlxD qr9SIG=>E9"GQ9"K 9=;?CGYD q0;Y?"K D BG
E9"GHQ9 K 9";?G /7IG >E9"GRQ9=K 9=;?SG 'W*-¤ : : : E : :: E : : : E : : : E : :: E : : : E :: ¥ v '-9SNB5B9=K GSB (/ I G"> 9"GxB9"K GSBpD q-; lG">LD=< B
ê '62GD\VEDODQFHGLYLGHGE\ WKHDYHUDJHVDOHVSHUPRQWK PXOWLSOLHGE\
lG">L Dr< B58 DH8
GB 9"K GCBMq>EDF£D;Gx< 9JNH9SI G">E9"GB9 K GSB D"qr?CD> >EGSB l D; >:G=;C8-Q9"K 9 ;?SG58 DYB9 K GSB5q¢>ED F¦D;GY 9"GMD"q0;@lG">L D < B !L IGSB A=>> G";C80Q 9"K 9";?CG A=> >EG";C8-Q9"K 9 ;?SG 'W*-¤ :: : E : : : : : : E : : E : : : E :: : E : : : : : H¥ v 'W9JNBxB9"K GB (/ I G">E9"G5B 9"K GSBpD q0; lG"> L D=< B
SAP AG 2001
n
'62('D\V6DOHV2XWVWDQGLQJ) shows a customer’s balance in relation to his sales. It specifies KRZPDQ\GD\VVDOHVDFXVWRPHURZHVDFRPSDQ\ There are two procedures for calculating the DSO days. You can define the procedure required on the selection screen using the parameter "DSO calculation type".
n
([DPSOHVIRUERWKFDOFXODWLRQW\SHV n=3 Balance Sales Key date 15.02.2002 18,000 8,000 Period 01/2002 10,000 8,000 Period 12/2001 5,000 2,000 Period 11/2001 3,000 5,000 Calculation type 1: ------------------------Average balance = (10,000 + 5,000 + 3,000) / 3 = 6,000 Average sales = (8,000 + 2,000 + 5,000) / 3 = 5,000 6,000 DSO = ---------- * 30 = 36 5,000 Conclusion: The customer owes the value of 36 days sales Calculation type 2: ------------------------Current balance = 18,000 Average sales = (8,000 + 2,000 + 5,000) / 3 = 5,000 18,000 DSO = ---------- * 30 = 108 5,000 Conclusion: The customer owes the value of 108 days sales
© SAP AG
AC280
5-28
7HUPV$JUHHG7HUPV7DNHQ 7KHEDVLFOLVWVKRZV
å 7HUPVDJUHHGLQDFFRUGDQFHZLWKWKHWHUPVRISD\PHQWJUDQWHG
7HUPVWDNHQDFFRUGLQJWRWKHFDVKGLVFRXQWKLVWRU\RIWKHFXVWRPHU
ê 7KHGLIIHUHQFHEHWZHHQWHUPVDJUHHGDQGWHUPVWDNHQ 9LHZ
3D\PHQWW\SHV
9LHZ
7RS1FXVWRPHUV
7RS1FXVWRPHUV WRWDORUIRUH[DPSOH IRURQHFRPSDQ\FRGH VKRZVGDWDDV DERYHFODVVLILHGE\FXVWRPHU
3D\PHQWW\SHV WRWDORUIRU H[DPSOHIRURQHFRPSDQ\FRGH VKRZVGDWDDVDERYHFODVVLILHGE\ SD\PHQWW\SHV 1HWFDVKGLVFRXQW FDVKGLVFRXQW
9LHZ
/LQHLWHPDQDO\VLV
/LQHLWHPDQDO\VLV IRURQHFXVWRPHU GLVSOD\VOLQHLWHPVDQGGULOOGRZQOLVWV VRUWHGE\GRFXPHQW SAP AG 2001
n
The difference between the terms taken and the terms agreed with the customer is calculated.
n
This evaluation is RQO\available IRUFXVWRPHUV.
© SAP AG
AC280
5-29
7HUPV$JUHHG 7KHEDVLFOLVWVKRZV
å 7HUPVDJUHHGLQDFFRUGDQFHZLWKWKHWHUPVRISD\PHQWJUDQWHG
7HUPVWDNHQDFFRUGLQJWRWKHFDVKGLVFRXQWKLVWRU\RIWKHFXVWRPHU
ê 7KHGLIIHUHQFHEHWZHHQWHUPVDJUHHGDQGWHUPVWDNHQ
GD\V GD\V
1XPEHURIGD\V RUFDOFXODWLRQ
GD\V
&DVKGLVFRXQW
&DVKGLVFRXQW 1HWGXHGDWH
7LPH
%DVHOLQHGDWHIRUWHUPVRISD\PHQW SAP AG 2001
n
To determine the DJUHHGWHUPVRISD\PHQW LQGD\V , the invoices issued in the SHULRGNH\GDWHQ GD\Vare used. You can define the number of days n and the key date when you create the evaluation.
n
The calculation uses the WRWDORIWKHLQWHUHVWFDOFXODWLRQQXPHUDWRUV and the WRWDORIWKHLQYRLFH DPRXQWV This has the advantage that when you summarize the average days in arrears, the information about the LQYRLFHYROXPHVis also included.
n
The agreed days are calculated for all existing subterms (cash discount days 1, cash discount days 2, and net days).
© SAP AG
AC280
5-30
7HUPV7DNHQ 7KHEDVLFOLVWVKRZV
å 7HUPVDJUHHGLQDFFRUGDQFHZLWKWKHWHUPVRISD\PHQWJUDQWHG
7HUPVWDNHQDFFRUGLQJWRWKHFDVKGLVFRXQWKLVWRU\RIWKHFXVWRPHU ê 7KHGLIIHUHQFHEHWZHHQWHUPVDJUHHGDQGWHUPVWDNHQ
§ -DQXDU\ ¨ © ª « ¬ ® ¯ §:° §E§ § ¨ §E© §ª §:¬ §E §:® § ¯ ¨E° ¨§ ¨E¨ ¨ © ¨ ª ¨ « ¨E¬ ¨E ¨P® ¨E¯ ¨ ¯ ©P° ©m§ Company
2,DFFRXQW
±
²³{´ µC¶ ·i¸ ± Company
§ 0DUFK ¨ © ª « ¬ ® ¯ §E° §E§ §:¨ §:© §ª § ¬ §: §E® § ¯ ¨ ° ¨m§ ¨E¨ ¨E© ¨Eª ¨P« ¨E¬ ¨ ¨ ® ¨E¯ ¨E¯ © ° ©§ Check presentation
SAP AG 2001
n
To determine the terms of payment taken (in days), the invoices paid in the period NH\GDWHQGD\V are used. You can define the number of days and the key date when you create the evaluation.
n
The calculation also uses the total of the interest calculation numerators and the total of the invoice amounts This has the advantage that when you summarize the terms taken, the information about the invoice volumesis also included.
n
Firstly, the report determines which VXEWHUPwas used to pay each invoice (cash discount 1, cash discount 2, net). The following applies: é No cash discount taken, invoice paid net
é Up to 90% of the cash discount permitted for cash discount 1, invoice paid with cash discount 2
é 90% or more of the cash discount permitted for cash discount 1, invoice paid with cash discount 1
© SAP AG
AC280
5-31
)XQFWLRQVIRU'ULOOGRZQ/LVWV &KDQJH6HWWLQJV 9DOXHGLVSOD\
2ULJLQDOFXUUHQF\
$QDO\VLVFXUUHQF\
/LQHLWHPGLVSOD\ 2SHQLWHPV
&KDQJH
&OHDUHGLWHPV 3DUNHGLWHPV
3HUFHQWXDO
:LWKVSHFLDO*/WUDQVDFWLRQV
:LWKYHQGRULWHPV
1XPEHUIRUPDW
$FFWRFXUUHQF\
:LWKVFDOLQJ
&KDQJH
&KDUDFWHULVWLFGLVSOD\ 1DPH
/LQHOD\RXW
6WDQGDUGORFDOFXUUHQF\ $GGLWLRQDOKHDGLQJV
1DPHRIHYDOXDWLRQYLHZ
.H\
1DPHRIHYDOXDWLRQW\SH
1DPHRIHYDOXDWLRQ
SAP AG 2001
n
Navigate to a drilldown list on the lowest level of the tree structure of the AP/AR information system. The functions listed above are available in all drilldown lists.
n
You can:
é Change the FXUUHQF\for the display é Display SHUFHQWDJHILJXUHV
é Configure the scaling (for example, reports in thousands)
é Select how the characteristics are displayed (with QDPHor NH\ é Structure the OLQHLWHPGLVSOD\ according to your requirements é Display the list KHDGLQJV
© SAP AG
AC280
5-32
3ULQWLQJDQG6RUWLQJ
l 3ULQWGULOOGRZQOLVW
l 6RUWGULOOGRZQOLVW E\FROXPQ
SAP AG 2001
n
You can:
é 3ULQWthe drilldown list
é 6RUWthe drilldown list by the columns displayed
© SAP AG
AC280
5-33
6$33UHVHQWDWLRQ*UDSKLF 'XH'DWH$QDO\VLV
7KRXVDQGV
'XH
¹{º¢»{¼ ½ ¾À¿¢ÁÀ½
1RWGXH
'XH
1RWGXH SAP AG 2001
n
You can display the values using an 6$3SUHVHQWDWLRQJUDSKLF
© SAP AG
AC280
5-34
5HSRUWLQJ7UHH 8VHU6SHFLILF$FFHVV3DWK 6WDQGDUGHYDOXDWLRQVIRUFXVWRPHUV 'XHGDWHDQDO\VLV
(YDOXDWLRQE\FRPSDQ\FRGH )RUJURXS
)RUFUHGLWFRQWURODUHD )RUEXVLQHVVDUHD
l - " .H\ILJXUH %DODQFHVKHHWYDOXH ! 9 U !
$ %S& # $ %T( # $ %T*
! #
)RUP
)6LWHP )6LWHP )6LWHP
&]aGS]#$% "G?6 b^$L6 #b U ` 8:9^b$%]9$SbU(:WQc"!8^B^ .6 b^#]"!B^ ]"GU^de .0pNS
SAP AG 2001
n
Additional cell types for cell definition: •
6HOHFWLRQZLWKNH\ILJXUH YDOXHILHOG Choose 6HOHFWLRQZLWKNH\ILJXUH YDOXHILHOG if you want a separate selection at cell level. You then define the cell by selecting a key figure, characteristics and their values, and by specifying a special cell text. This cell definition is visualized by a square. Note that this special cell does not have to contain the value that would result from the intersection of the row and column selection.
•
'HILQHIRUPXODSULRULW\ This option is offered if the column and the row contain formulas. Here you define which of the formulas is to be used to calculate the cell. 5HVXOWIURPWKHFROXPQ IRUPXOD means that the formula defined in the column is used. 5HVXOWIURPURZIRUPXOD means that the formula defined in the row is used. Cells for which you have to define the formula priority have a red question mark in the form. The selected formula is shown by an arrow symbol that points to the dimension that has priority (column formula has priority: Arrow SRLQWV XSZDUGV; row formula has priority: Arrow SRLQWVOHIW).
© SAP AG
AC280
7-3
7H[WV 5HSRUWQDPH !
)URPSHULRG ! )LVFDO\HDU !
3DJH !
7RSHULRG !
)LQDQFLDOVWDWHPHQWYHUVLRQ ! &RPSDQ\FRGH !
*HQHUDO
)RUH[DPSOH 5HSRUWQDPH 3DJHQXPEHU 6HOHFWLRQGDWH $XWKRURIUHSRUW
6HOHFWLRQSDUDPHWHUV
7,7/(3$*(
)RUH[DPSOH )URPSHULRG YDOXH 7RSHULRG YDOXH )LVFDO\HDU YDOXH
+($'(5
&KDUDFWHULVWLFV
)RUH[DPSOH )LQDQFLDOVWDWHPHQWYHUV &RPSDQ\FRGH
)227(5 SAP AG 2001
n
In the layout for the report definiton, you can define texts for a title page, header, and footer.
n
To do this, you can use general text variables, text variables for selection parameters, and characteristic-based text variables.
n
For more information about the settings, see the 6$3/LEUDU\!&$'ULOOGRZQ5HSRUWLQJ! 5HSRUW!6HWWLQJV.
© SAP AG
AC280
7-4
'ULOOGRZQ5HSRUWLQJ*/ &XVWRPL]LQJ
SAP AG 2001
© SAP AG
AC280
7-5
'ULOOGRZQ5HSRUWLQJ*/ 6WDQGDUG&KDUDFWHULVWLFV DQG.H\)LJXUHV l &KDUDFWHULVWLFV
l .H\ILJXUHV
&KDUWRIDFFRXQWV
q q q q q q
*/DFFRXQW
q
%XVLQHVVDUHD
q
3ODQDFWXDOLQGLFDWRU
q
&RPSDQ\FRGH )LQDQFLDOVWDWHPHQWYHUVLRQ q
1XPEHUTXDQWLW\ q
3ODQYHUVLRQ q
%DODQFHVKHHWYDOXH
q
%DODQFHFDUU\IRUZDUG 'HELWWRWDO
&UHGLWWRWDO
&XPXODWLYHEDODQFH
)6LWHP q
)LVFDO\HDU q q q
3HULRG
3HULRG\HDU
SAP AG 2001
© SAP AG
AC280
7-6
'ULOOGRZQ5HSRUWLQJ*/ 6WDQGDUG9DULDEOHV l &KDUDFWHULVWLFYDULDEOHV JOREDO l 7H[WYDULDEOHV JOREDO q q q q q q q q q q
))*!
SAP AG 2001
n
If you use a single set in the row of your report definition, the results output for the report displays subtotals for each set used in the hierarchy.
© SAP AG
AC280
7-32
([SDQGLQJ5HSRUW5RZV
'RQRWH[SDQG %XVLQHVVDUHD VHW JLIWV
&RQVXPHUJGV *LIWV *LIWV
lm] %
n
v%w xky úfzeþü{ |y û x_| { ~ uý y
F*B=A8B*B*B
E B A8BB*B
op*q`78 )q*qt!s)*
%$ &RQVXPHUJRRGVDQG &RQVXPHU JGV
op*q%78 )qqr!s)
([SDQG
39*B3 39*B*9 39*B*@ u=v`w*xWy úz}þü{ ww|y 3@*B3 3@*B*9 3@*B*@ u=}p~ y ý y u'uv%w xWy úz}þü*{ |y û x| { ~ yý y o*q%7 )q q!/)
6LQJOHYDOXHV
39*B3 39*B*9 39*B*@ 3@*B3 3@*B*9 3@*B*@
m, D A8B*BB D A8B*BB 3mB A8B*BB 9B A8B*BB 3mB A8B*BB 9B A8B*BB 99 A8B*BB D 9 A8B*BB H9 A8B*BB m, D A B B B D A B B B 3B A B B B 3B A B B B 9*B A B B B 9*9 A B B B
n % D A8BB*B D A8BB*B 3mB A8BB*B D A8BB*B 3 D A8BB*B 3mG A8BB*B @G A8BB*B E G A8BB*B
!,7 *) D B AIB*B*B !]7 % ) D A BB*B D A BB*B 3B A BB*B D A BB*B D A BB*B E A BB*B 3 E A BB*B 9 E A BB*B
!,7 ) D A B*B*B D A B*B*B D A B*B*B 3 D A B*B*B 3G=A B*B*B
D A B*B*B D A B*B*B D A B*B*B D A B*B*B E A B*B*B
SAP AG 2001
n
If you use sets or several single values when you define rows, you can determine whether only the total row is displayed or whether the entire hierarchy of the set is expanded with subtotals, or whether each single value is displayed in a row. The system is set up such that only those rows for which relevant data exists are displayed.
© SAP AG
AC280
7-33
6RUWLQJ+LHUDUFKLHV
on!s)*mI*m
"
E=D B*B*B B E D 9*B*B B = E D F*B*B B =
o`B B B3
2' 2' 2'
ED B B*B*B E D 9 B*B*B E D F B*B*B
o:BB*B*9
,
%=/
2' 2' 2'
/'
/' s
!#"
**so`6!/)*
'2 '2 '2 2'
'2 '2 '2 s
2 2 2 2'
'2 '2 '2 /' 2
oB B*B3 oB B*B*9
ED B*B*B*B oB B*B3 oB B*B*9
ED 9*B*B*B oB B*B3 oB B*B*9
ED F*B*B*B
#
#%/
2
m" '/ '/ '/ '/ '/ '/ '/ '/ '/ '/
2' 2' 2' 2' 2' 2' 2' 2' 2' 2'
> !," /' /' /' /' /' /' /' /' /' /'
%XVLQHVVDUHD
$FFRXQW
$FFRXQW
%XVLQHVVDUHD
SAP AG 2001
n
If a combination of several characteristics is used in a block of rows, and this block is expanded, you are free to select the hierarchical order of the characteristics used.
© SAP AG
AC280
7-34
)OH[LEOH5HSRUWV8VLQJ9DULDEOHV 5
