AC220_EN_Col52_FV_Inst_A4 (第1页) | ERP软件技术分享

第 1 页 / 共 509 页

AC220

Special Purpose Ledger

mySAP ERP Financials

Date

Training Center

Instructors

Education Website

Instructor Handbook

Course Version: 2005 Q2

Course Duration: 5 Day(s)

Material Number: 50074176

Owner: Declan O’Connor (D001023)

An SAP Compass course - use it to learn, reference it for work

第 2 页 / 共 509 页

Nopartofthispublicationmaybereproducedortransmittedinanyformorforanypurpose

withouttheexpresspermissionofSAPAG.Theinformationcontainedhereinmaybechanged

withoutpriornotice.

SomesoftwareproductsmarketedbySAPAGanditsdistributorscontainproprietarysoftware

componentsofothersoftwarevendors.

Trademarks

• Microsoft®,WINDOWS®,NT®,EXCEL®,Word®,PowerPoint®andSQLServer®are

registeredtrademarksofMicrosoftCorporation.

• IBM®,DB2®,OS/2®,DB2/6000®,ParallelSysplex®,MVS/ESA®,RS/6000®,AIX®,

S/390®,AS/400®,OS/390®,andOS/400®areregisteredtrademarksofIBMCorporation.

• ORACLE®isaregisteredtrademarkofORACLECorporation.

• INFORMIX®-OnLineforSAPandINFORMIX®DynamicServerTMareregistered

trademarksofInformixSoftwareIncorporated.

• UNIX®,X/Open®,OSF/1®,andMotif®areregisteredtrademarksoftheOpenGroup.

• Citrix®,theCitrixlogo,ICA®,ProgramNeighborhood®,MetaFrame®,WinFrame®,

VideoFrame®,MultiWin®andotherCitrixproductnamesreferencedhereinaretrademarks

ofCitrixSystems,Inc.

• HTML,DHTML,XML,XHTMLaretrademarksorregisteredtrademarksofW3C®,World

WideWebConsortium,MassachusettsInstituteofTechnology.

• JAVA®isaregisteredtrademarkofSunMicrosystems,Inc.

• JAVASCRIPT®isaregisteredtrademarkofSunMicrosystems,Inc.,usedunderlicensefor

technologyinventedandimplementedbyNetscape.

• SAP,SAPLogo,R/2,RIVA,R/3,SAPArchiveLink,SAPBusinessWorkflow,WebFlow,SAP

EarlyWatch,BAPI,SAPPHIRE,ManagementCockpit,mySAP.comLogoandmySAP.com

aretrademarksorregisteredtrademarksofSAPAGinGermanyandinseveralothercountries

allovertheworld. Allotherproductsmentionedaretrademarksorregisteredtrademarksof

theirrespectivecompanies.

Disclaimer

THESEMATERIALSAREPROVIDEDBYSAPONAN"ASIS"BASIS,ANDSAPEXPRESSLY

DISCLAIMSANYANDALLWARRANTIES,EXPRESSORAPPLIED,INCLUDING

WITHOUTLIMITATIONWARRANTIESOFMERCHANTABILITYANDFITNESSFORA

PARTICULARPURPOSE,WITHRESPECTTOTHESEMATERIALSANDTHESERVICE,

INFORMATION,TEXT,GRAPHICS,LINKS,ORANYOTHERMATERIALSANDPRODUCTS

CONTAINEDHEREIN.INNOEVENTSHALLSAPBELIABLEFORANYDIRECT,

INDIRECT,SPECIAL,INCIDENTAL,CONSEQUENTIAL,ORPUNITIVEDAMAGESOFANY

KINDWHATSOEVER,INCLUDINGWITHOUTLIMITATIONLOSTREVENUESORLOST

PROFITS,WHICHMAYRESULTFROMTHEUSEOFTHESEMATERIALSORINCLUDED

SOFTWARECOMPONENTS.

第 3 页 / 共 509 页

About This Handbook

Thishandbookisintendedtocomplementtheinstructor-ledpresentationofthis

course,andserveasasourceofreference. Itisnotsuitableforself-study.

Typographic Conventions

American English is the standard used in this handbook. The following

typographic conventions are also used.

Type Style Description

Example text Wordsorcharactersthatappearonthescreen. These

includefieldnames,screentitles,pushbuttonsaswell

asmenunames, paths, andoptions.

Alsousedforcross-referencestootherdocumentation

bothinternal(inthisdocumentation)andexternal(in

other locations, such asSAPNet).

Example text Emphasizedwords or phrases in bodytext, titlesof

graphics, and tables

EXAMPLETEXT Names of elements in the system. These include

reportnames,programnames,transactioncodes,table

names, andindividualkey wordsof aprogramming

language,whensurroundedbybodytext,forexample

SELECT and INCLUDE.

Example text Screenoutput. Thisincludesfileanddirectorynames

and their paths, messages, names of variables and

parameters, and passages of the source text of a

program.

Example text Exactuserentry. Thesearewordsandcharactersthat

youenterinthesystemexactlyastheyappearinthe

documentation.

<Example text> Variableuserentry. Pointedbracketsindicatethatyou

replacethesewordsandcharacterswithappropriate

entries.

iii

Type Style	Description
Example text	Wordsorcharactersthatappearonthescreen. These includefieldnames,screentitles,pushbuttonsaswell asmenunames, paths, andoptions. Alsousedforcross-referencestootherdocumentation bothinternal(inthisdocumentation)andexternal(in other locations, such asSAPNet).
Example text	Emphasizedwords or phrases in bodytext, titlesof graphics, and tables
EXAMPLETEXT	Names of elements in the system. These include reportnames,programnames,transactioncodes,table names, andindividualkey wordsof aprogramming language,whensurroundedbybodytext,forexample SELECT and INCLUDE.
Example text	Screenoutput. Thisincludesfileanddirectorynames and their paths, messages, names of variables and parameters, and passages of the source text of a program.
Example text	Exactuserentry. Thesearewordsandcharactersthat youenterinthesystemexactlyastheyappearinthe documentation.
<Example text>	Variableuserentry. Pointedbracketsindicatethatyou replacethesewordsandcharacterswithappropriate entries.

第 4 页 / 共 509 页

AboutThisHandbook AC220

Icons in Body Text

The following iconsareused in thishandbook.

Icon Meaning

Formoreinformation,tips,orbackground

Noteorfurtherexplanationofpreviouspoint

Exception or caution

Procedures

Indicatesthattheitemisdisplayedintheinstructor’s

presentation.

Icon	Meaning
	Formoreinformation,tips,orbackground
	Noteorfurtherexplanationofpreviouspoint
	Exception or caution
	Procedures
	Indicatesthattheitemisdisplayedintheinstructor’s presentation.

第 5 页 / 共 509 页

Contents

Course Overview......................................................... vii

Course Goals...........................................................vii

Course Objectives ....................................................viii

Unit 1: FI-SL: Special Reporting........................................1

Overview of FI-SL.......................................................2

Unit 2: Table Definition Characteristics and Key Figures ...... 31

Characteristics and Key Figures of Table Definition..............33

Unit 3: Setting Up the FI-SL Environment.......................... 79

FI-SL Structure........................................................81

Configuring the Ledger...............................................95

Line Items and Customizing Tools.................................116

Unit 4: Direct Postings and Adjustments .........................149

Adjustment Postings in FI-SL ......................................151

Unit 5: Validations, Substitutions, and Rules ....................209

Functionality of FI-SL Validations and Substitutions ............211

Creation and Maintenance of Validations and Substitutions ...229

Unit 6: Sets and Basic Feature Of the Report Painter..........251

Sets....................................................................253

Report Painter Components........................................270

Unit 7: Planning .........................................................283

Settings in FI-SL Planning..........................................284

Unit 8: Allocations......................................................323

Using Allocations in FI-SL ..........................................324

Unit 9: Document Split.................................................345

Understanding and Customizing Document Split................346

Unit 10: Rollups .........................................................371

Rollups in FI-SL......................................................372

第 6 页 / 共 509 页

Contents AC220

Appendix 1: Course Information .................................437

Appendix 2: Appendix 2 ............................................453

Index .......................................................................489

第 7 页 / 共 509 页

Course Overview

Attheendofthecourse,theparticipantswillbefamiliarwiththeFI-SLfunction

andlearnhowtousetheFI-SLcomponents. Theywillalsogainknowledgeabout

theimportantcontrolanddataprocessingtechniques.

Target Audience

Thiscourseisintendedforthefollowing audiences:

• Project team members

Course Prerequisites

Required Knowledge

• A Level 1 and a Level 2 course

Course Duration Details

Unit 1:

FI-SL: Special Reporting

Overview of FI-SL 45 Minutes

Exercise 1: Standard Ledgers and Special Purpose

Ledgers 20 Minutes

Unit 2: Table Definition Characteristics and Key Figures

Characteristics and Key Figures of Table Definition 120 Minutes

Exercise 2: Characteristics and Basic Key Figures 90 Minutes

Unit 3: Setting Up the FI-SL Environment

FI-SL Structure 25 Minutes

Exercise 3: Transfer Postings 10 Minutes

Configuring the Ledger 25 Minutes

Exercise 4: Ledger Assignments 45 Minutes

Line Items and Customizing Tools 30 Minutes

Exercise 5: FI-SL Customizing Tools 1 20 Minutes

Exercise 6: FI-SL Diagnostic Tools for

Checking Postings, Ledger Comparison and

Troubleshooting 20 Minutes

Unit 4: Direct Postings and Adjustments

Adjustment Postings in FI-SL 45 Minutes

Exercise 7: FI Postings 10 Minutes

Exercise8: AdjustmentPostingsinFI-SLDocument

and Display of Totals Records 10 Minutes

vii

第 8 页 / 共 509 页

CourseOverview AC220

Unit 5: Validations, Substitutions, and Rules

Functionality of FI-SL Validations and Substitutions 20 Minutes

Exercise 9: Validations 40 Minutes

Creation and Maintenance of Validations and

Substitutions 20 Minutes

Exercise 10: Substitutions 40 Minutes

Unit 6: Sets and Basic Feature Of the Report Painter

Sets 60 Minutes

Exercise 11: Sets/Painter 30 Minutes

Report Painter Components 50 Minutes

Unit 7: Planning

Settings in FI-SL Planning 150 Minutes

Exercise 12: FI-SL Planning 75 Minutes

Unit 8: Allocations

Using Allocations in FI-SL 70 Minutes

Exercise 13: Allocation of Expenses to Regions 50 Minutes

Unit 9: Document Split

Understanding and Customizing Document Split 45 Minutes

Exercise 14: Splitting of Documents 45 Minutes

Unit 10: Rollups

Rollups in FI-SL 90 Minutes

Exercise 15: Definition and Execution of a Rollup 10 Minutes

Exercise 16: Additional Optional Exercises 30 Minutes

Course Goals

This course will prepare you to:

• UnderstandtheconceptsbehindFI-SL,beabletoprocessdatainFI-SL,and

generate reports on this data

• AcquireexpertisegoodknowledgeabouttheFI-SLfunctionsandbeableto

use FI-SL components

Course Objectives

After completingthiscourse, youwill beable to:

• ExplaintheimportanceofFI-SLandinformationflowinFI-SL

• ListthekeycharacteristicsandkeyfiguresintheFI-SLenvironment and

determinetheprerequisitestocreateanewfieldinFI-SL

viii

第 9 页 / 共 509 页

AC220 Course Overview

SAP Software Component Information

TheinformationinthiscoursepertainstothefollowingSAPSoftwareComponents

and releases:

SAP Contact(s)

Walldorf

JörgSiebert(responsibleforthechangesmadeinthetrainingmaterialfor4.7and

newenhancements[ParallelAccounting: ExampleForeignCurrencyValuation

and Unit on Document Split]

Declan O’Connor

Development Manager: Dr Georg Dopf

Course Details

Duration

This course is designed to last 4 1/2 days.

CourseMaterialsandotherMaterials(TrainingManual)

Information Database Presentation (graphics)

Participant Handbook

Exercises and Solutions

AdditionalExercisescontainedwithintheInstructor’sGuide

Appendix

Country-Specific Units

Not Applicable

Course Instructor Profiles

Level of Knowledge Required

The course deals with the subject in an integrated manner. You should have

detailed knowledge in the area of FI-SL regarding the business processes and

technical data requirements.

Proficiency will be required in at least the following application areas:

Financial Accounting, Legal Consolidation, Management Accounting, and

Cost of Goods Sold. Basic knowledge will be necessary in Procurement &

InventoryManagement,SalesOrderManagement,ProfitCenterAccounting,and

ReconciliationLedger. FI-SL asarecipient systemrecuperatesthedatafrom a

variety of feeder systems. You should be cognizant of thebasicdata flowand

businessprocessesthatpassdatathroughtheaccountinginterfaceintotheFI-SL

system.

第 10 页 / 共 509 页

CourseOverview AC220

Courses Recommended as Preparation

AC010,AC040,andifpossible,FI-GLConfigandConsolidation.

Online Help Recommended asPreparation

Online help for FI-SL, Report Painter, and Report Writer can be found under

Financial Accounting/Special PurposeLedger.

Inaddition,informationforFI-SL,ReportPainter,andReportWriterintheDocu

PrintCDisalsolocatedunderFinancialAccounting/SpecialPurposeLedger.

Hints on Preparing This Course

• AttendtheAC220coursefirstandifpossible,theothercoursessuggested.

• Makenotesonyourcopyoftheparticipanthandbook.

• Carefullyreadtheinstructornotesforeachgraphic.

• Practicetheexercises. Themenupathsareincludedinthesolutions.

• Practice the demonstrations.

• Practice the entire presentation.

Hints on Teaching This Course

TherearethreethingsthatIliketodobeforeIstarttheclass. Thethreethingsset

the expectations of the class:

• ReiteratethatthisisaLevel3classandIexpectthattheparticipantshave

taken the Level 1 and Level 2 courses. If not, the pace of the class will

be challenging. I like to get this across because there are always a few

participantsineveryclasswhohaveneverattendedaSAPclassbeforeand

betteryet,arestillintheprocessofimplementingandhavenevergottheir

hands onto a system yet.

• Dealingwithquestions(1). Irequestthattheparticipantskeepthequestions

focusedonthetopic. Itwillbeyourjobtoholdthemtothataswell. Don’t

gettooinvolvedin“consultingquestions”. Keepthequestionsfocusedso

that you can stay on schedule.

• Dealingwithquestions(2). Irequestthattheparticipantsasktheir“personal”

questions after class where you can spend more time on their questions

ratherthanaquick5-10minuteshereandthereatbreaks. Classroomtime

is for learning.

• This course does not cover specialist topics such as archiving, currency

conversion, and ALE and export ledger. Thesecouldpossibly havebeen

included. But instead of ’packing’ in these ancillary topics, the course

concentrates on the more important topics. The allotted 4-1/2 days are

required to cover these important topics.

• TrainingSystem(MotherforERPisF35,Client800)

Data available in System

第 11 页 / 共 509 页

AC220 Course Overview

Data DatainTrainingSystem DatainIDESSystem

Company AC01-AC18, 1000 1000

Code

Controlling 1000 1000

Area

Business 0001,1500,8000,9000, 0001,1500,8000,9000

Areas

RETL,WSLE

Functional 0300,0400,0500 0300,0400,0500

Areas

Customers T-F00A00 1000 1000

T-F20A01-18

Materials

T-IC-F1001-T-IC-F1003 T-IC-F1001-T-IC-F1003

T-IC-R2007–T-IC-R2009 T-IC-R2007–T-IC-R2009

Accounts

399999,420000,421000, 399999,420000,421000,

430000, 430000,

431000,472000 431000,472000

476000,810200,810300,810400 476000,800200,800300,

800400

Ledgers 00,0F 00,0F

CostCenters T-A20A01-18 1000

T-A20B01-18 3110

T-A20C01-18 4130

T-A20D01-18 4120

T-A20E01-18 4500

Controlling 1000 1000

Area

Special

N-001–N-003,NORTH N-001–N-003,NORTH

Regions

S-001–S-003,SOUTH S-001–S-003,SOUTH

E-001–E-003,EAST E-001–E-003,EAST

W-001–W-003,WEST W-001–W-003,WEST

Z-001 Z-001

Data	DatainTrainingSystem	DatainIDESSystem
Company Code	AC01-AC18, 1000	1000
Controlling Area	1000	1000
Business Areas	0001,1500,8000,9000, RETL,WSLE	0001,1500,8000,9000
Functional Areas	0300,0400,0500	0300,0400,0500
Customers	T-F00A00 T-F20A01-18	1000 1000
Materials	T-IC-F1001-T-IC-F1003 T-IC-R2007–T-IC-R2009	T-IC-F1001-T-IC-F1003 T-IC-R2007–T-IC-R2009
Accounts	399999,420000,421000, 430000, 431000,472000 476000,810200,810300,810400	399999,420000,421000, 430000, 431000,472000 476000,800200,800300, 800400
Ledgers	00,0F	00,0F
CostCenters	T-A20A01-18	1000
	T-A20B01-18	3110
	T-A20C01-18	4130
	T-A20D01-18	4120
	T-A20E01-18	4500
Controlling Area	1000	1000
Special Regions	N-001–N-003,NORTH S-001–S-003,SOUTH E-001–E-003,EAST W-001–W-003,WEST Z-001	N-001–N-003,NORTH S-001–S-003,SOUTH E-001–E-003,EAST W-001–W-003,WEST Z-001

第 12 页 / 共 509 页

CourseOverview AC220

Reports

0F-GUV1 0F-GUV1

0F-PER 0F-PER

ReportGroup 0F01, 0F02 0F01,0F02

Library 0F1 0F1

Tables

GLT0 GLT0

GLFUNCT GLFUNCT

GLU1 GLU1

ZZSPECT ZZSPECT

ZSLTABT(tobedefinedand

installedduringthecourse)

Customer ZZSPREG ZZSPREG

CodingBlock

Field

Rule &SELREG1

Fast Entry DEMO1, DEMO2 DEMO1, DEMO2

screen

template

Account

GL-SL01

assignment

Models Data available in System

DR-SL01/2 (These two should

be in the system. If not, to be

defined by you shortly before,

or right at thebeginning of the

course.

UserExits

VariableFieldMovement Variable Field Movement

U55

U55RollupHeaderD02

RollupHeader D02

Activ- RFBU, RGL0 RFBU, RGL0

ity(Vorgänge)

UserIDandPasswordsforCourseParticipants

AC220-01 to AC220-20

Initial Password: INIT

IftheseUserIDsarenotavailableinthetrainingsystems,youmustcreatethem

usingthetransactionZUSR,basedonUser-ID:AC220-99

xii

Reports	0F-GUV1 0F-PER	0F-GUV1 0F-PER
ReportGroup	0F01, 0F02	0F01,0F02
Library	0F1	0F1
Tables	GLT0 GLFUNCT GLU1 ZZSPECT ZSLTABT(tobedefinedand installedduringthecourse)	GLT0 GLFUNCT GLU1 ZZSPECT
Customer CodingBlock Field	ZZSPREG	ZZSPREG
Rule	&SELREG1
Fast Entry screen template	DEMO1, DEMO2	DEMO1, DEMO2
Account assignment Models	GL-SL01 Data available in System DR-SL01/2 (These two should be in the system. If not, to be defined by you shortly before, or right at thebeginning of the course.
UserExits	VariableFieldMovement U55RollupHeaderD02	Variable Field Movement U55 RollupHeader D02
Activ- ity(Vorgänge)	RFBU, RGL0	RFBU, RGL0

第 13 页 / 共 509 页

AC220 Course Overview

PreparationintheSystemtobedonebytheyoupriortothecourse

1. DeletingTransactionDatainthe0FLedger(optional):

Thiswillmakeiteasier for you andtheparticipantstofollowtheflowof

dataintothe0Fledger. Thedata,whichwillbethenheld,willbeeasierto

understand.

Steps required:

Menu path from SAP R/3 Enterprise: Tools → Business Engineer →

Customizing→IMG→FinancialAccounting→SpecialPurposeLedger→

Tools → Delete Transaction Data

Choose‘Selectivedeletionofanindividualledger’with‘Testrun’off.

Ledger0F,RecordType0,Version001,CompanyCode1000,CurrentFiscal

Year, Current Period.

2. ChoosetheSummarytableandboththeLineItemtables.

3. Classicexampleforhierarchicalsummarization: ONLYOPTIONAL!

Postingrecords(actualdata)forCCode1000inledger0F.Checktoseeif

dataexistsforPeriod09/2000. Ifnot,dothesepostings:

RBUSA RACCT Amount

2000 400000 UNI 1000

3000 400000 UNI 2000

4000 400000 UNI 3000

5000 400000 UNI 4000

6000 400000 UNI 5000

7000 400000 UNI 6000

Businessareatocreate: 2000-7000(ifnotalreadycreated). 2300(as2000).

4500(as4000), 6700(as6000), 5913 (as5000)

BasicsetscreatedforGLFUNCT:ROLL-BUSA-23: 2000.3000(rep.value

=2300),ROLL-BUSA-45: 4000.5000(rep.value=4500),ROLL-BUSA-67

: 6000.7000 ( rep.value = 6700)

SinglesetcreatedforGLFUNCT:ROLL-BUSA-ALwith1,2,and3

BasicsettocreateforGLFUNCTROLL-ACCTforRACCT(400000)

MultisettocreateforGLFUNCT:ROLL-MUL-HIE (Setsfor Ledger0F,

CoCode1000,RecordType0,Vers1andincludingSetsROLL-BUSA-AL

and ROLL-ACCT)

Fieldmovementtocreateforrollup: HIER:GLFUNCT>GLFUNCTonly

RBUSA 1:1

xiii

第 14 页 / 共 509 页

CourseOverview AC220

CreaterollupROLL-HIEforGLFUNCTwithrollupsetROLL-MUL-HIE,

Hierach. Dimension=RBUSA,fieldmovement=HIER,androllupledger

= R0

4. Check and if not already present, create number ranges for Co. Codes

AC220-00toAC220-18fortheFI-SLDocumenttypes,A0,A2,PL,andR0.

5. For the participants’ G/L postings and DR-Invoice postings Account

AssignmentModelssetup(orpleasecheckifcreated):

a) IMGCustomizing→Fin.Acctg. →FI-GlobalSettings→Document

→RecurringEntries→AccountAssignment Models: Defineentry

screen templates:

VariantSL-01(forG/L):Companycode,PostingKey,G/LAccount,

TaxCode,Amount,Costcenter,Equivalencenumber

VariantSL-02(forDR):Companycode, PostingKey, G/LAccount,

TaxCode,Amount,Bus.Area,Material,SpecialRegion,Equivalence

number

b) ApplicationFI-GL:Doct.Entry→ReferenceDocuments→Account

Assignment model:

Model GL-SL01 created.

Used: Currency USD, Chart of Accounts INT, Calculate Tax x,

‘Equivalence to ‘ not set.

Used: Screen TemplateVariant SL-01:

PK G/LAccount Tx.Code Amount Costcntr(XX=Participant

number)

40 420000 1000 T-A20AXX

40 420000 2000 T-A20BXX

40 420000 3000 T-A20EXX

40 421000 7000 T-A20AXX

40 421000 8000 T-A20BXX

40 421000 9000 T-A20EXX

40 430000 1000 T-A20AXX

40 430000 2000 T-A20BXX

40 430000 3000 T-A20EXX

40 431000 7000 T-A20AXX

40 431000 8000 T-A20BXX

40 431000 9000 T-A20EXX

xiv

第 15 页 / 共 509 页

AC220 Course Overview

40 472000 V0 4000 T-A20AXX

40 472000 V0 5000 T-A20BXX

40 472000 V0 6000 T-A20EXX

40 476000 V0 7000 T-A20AXX

40 476000 V0 8000 T-A20BXX

40 476000 V0 9000 T-A20EXX

50 399999 V0 81000

(XXtobereplacedbyuserswiththeirgroupnumbers.)

c) Application AR: Doct.Entry → Reference Documents → Account

Assignment model:

Model DR-SL01 created.

Used: Currency USD, Chart of AccountsINT, Calculate Tax x,

‘Equivalence to ‘ not set.

Used: UseScreenTemplateVariantSL-02:

PK Accountno. Tx.Code Amount Mat.no. Spec.Reg.

50 810200 A0 10000 0001 T-IC-F1001

50 810200 A0 10000 1500 T-IC-F1002

50 810200 A0 10000 8000 T-IC-F1003

50 810200 A0 10000 9000 T-IC-R2007

50 810300 A0 20000 0001 T-IC-F1001

50 810300 A0 20000 1500 T-IC-F1002

50 810300 A0 20000 8000 T-IC-F1003

50 810300 A0 20000 9000 T-IC-R2008

50 810400 A0 30000 0001 T-IC-F1001

50 810400 A0 30000 1500 T-IC-F1002

50 810400 A0 30000 8000 T-IC-F1003

50 810400 A0 30000 9000 T-IC-R2009

d) Checktoensurethat intheAttributesof ABAPZZLVU800(Rollup

Exits)theflag‘Fixedpointarithmetic’isNOTset. Otherwise,remove

it and generate the ABAP.

CATTs(shouldalreadyhavebeenrunforyoursystem):

Object Name Reference

第 16 页 / 共 509 页

CourseOverview AC220

CATT

Co.Code AC## 1000

ZT_AC_01

Customer T-F20A## 1000(Salesorg.0001,Distr.Channel1)

ZT_AC220_04/05

Supplier T-F00A00 1000

ZT_AC205_01

Cost Center T-A20A## 1000

ZT_AC220_02

T-A20B## 3110

T-A20C## 4130

T-A20D## 4120

T-A20E## 4500 ## = 00 to 20

<<Check the development class, ZFI0, and if need be change

the following, if not already set up): Transaction SE80: enter

DevelopmentclassZFI0: Double- clickonmainnodeZFI0then

change: entertransportlayerZF##(##=currentSystemNumber;

e.g. forI80 insert ZF80. Save) ****>>

Goals and Objectives

Course Goals

This course will enable participants to:

• Acquireconceptualknowledgeandhands-onexperienceonmanagingdata

andreportinginFI-SL,becomefamiliarwiththeFI-SLfunctionality, and

learn how to use FI-SL components.

Course Objectives

xvi

第 17 页 / 共 509 页

AC220 Course Overview

Attheconclusionofthecourse,participantswillbeableto:

• Explain the main purpose of FI-SL and the flow of information into the

system.

• IdentifythebasiccharacteristicsandkeyfiguresoftheFI-SLenvironment

anddeterminetherequirementstoestablishanewfieldforFI-SL

• Defineanewcodingblockfieldinthetest mode

• DefineanewtablegroupintherepositoryandinstallatablegroupinFI-SL

• Identify the preliminary resource issues prior to populating the FI-SL

database

• CreatetheFI-SLmasterdata,definetheorganizationalstructureofFI-SL,

and list the options for summary and single item data to be stored in the

ledgers

• TransferdataintoFI-SLfromoutsidetheapplicationarea

• CreateadjustmentpostingsinFI-SL usingversions

• Analyze the master data settingsand postings to Special PurposeLedger

using the Display and Diagnostic tools

• ExplaintheneedforValidationandSubstitutioninFI-SL.Defineanduse

both.

• SpecifythedifferenttypesofSets,identifytheareasinFI-SLwheretheyare

used, and create sets for use in FI-SL

• GainarudimentaryideaofhowtodefinereportsusingReportPainterand

execute reports using a report group

• Definetheplanningconfiguration, planninglayout, plannerprofile, enter

plandataandcontroltheresultsofplanninginFI-SL

• CreateAllocationsegmentsandcyclesandperformallocationsinFI-SL

• Createaledgertoreceivesplitdocumentinformation

• Define and execute Rollups in FI-SL

Course Structure and Flow

Unit-Preface: Detailsthecurriculumpath,prerequisites,andtargetgroup.

Unit -Introduction: Providesthecontentsand anoverall concept of what the

participants will learn in this class.

Unit-FI-SL:SpecialReportingRequirementsdiscussestheplaceFI-SLtakes

in Accounting, distinguishes between standard and customer-defined ledger,

pinpointsFI-SLadvantagesforaflexiblereportingenvironment,anddemonstrates

a‘showcase’P&LCost of GoodsSoldreporttoillustratehowdataarrivesina

particular form to fit acertain customer need.

Unit-TableDefinition: CharacteristicsandKeyFigures,theneedforandmeans

tocreatenewcustomerfieldsaredemonstratedaswellasthekeyfiguresoffered

for the balances to be held for the characteristic combinations. This unit also

xvii

第 18 页 / 共 509 页

CourseOverview AC220

providesinformationaboutdefining newtablesintherepositorytocatertothe

newcharacteristiccombinations,outlinestherequirementsforanewtablegroup,

andshowshowtoinstallthenewtablegroupintheFI-SLsystem.

Unit - Setting up the FI-SL Environment: Details how to set up the FI-SL

master data to allow for postings. The different assignment specifications –

companycodes/globalcompaniestoledgers,choiceofactivities,appropriatefield

movements, and ledger selection – are explained in depth. In this connection,

resource planning, optimal design, and performance considerations will also

featureinthediscussion. Thisisaveryimportantunitandisthe‘heart’ofFI-SL

inasmuchasitfocusesonthedegreeofflexibilitythecustomerhasindefining

therequiredlevelofdetailandrefinementofthedatatobestored.

Unit-ThroughpostingsandAdjustments: Discusseshowdatacanbepassed

online or as transfer postings through to FI-SL. In addition, the need to set up

valid master datafor newfields will beshown, especially for thepostings that

takeplacewithinFI-SL.Thepossibilitiesofenteringdatadirectlyasadjustment

postingsinFI-SLwillalsobedemonstrated. Inaddition,theuseofanSL-Ledger

tobuildupdatarequiredinaparallelaccountingview(forexample,IASandlocal

GAAP) will also be analyzed.

Unit-Validations,Substitutions,andRules: Providesanoverviewandconcrete

examplesofhowvalidationandsubstitutionofcharacteristiccombinationsina

direct FI-SL postingcan bedefinedand activated.

Unit-SetsandFundamentalsofReportPainter: Coversthedifferenttypesof

setsandtheirusagewithintheFI-SLsystemanddescribesthebasiccomponents

ofaPainterreportandhowreportsaredefinedandexecuted.

Unit-Planning: Describescustomizingforplanning,whichincludestheplanning

layout(s)andplannerprofile,howtoenterplandata,andcontroltheresults.

Unit-Allocations: Describeshowdistributionandassessmentofbalancestake

place within FI-SL and shows the different ways to determine the sender and

receiver rules.

Unit- SplitLedger: Describestheprinciplesof asplitdocument andhowthe

informationistransferredtoareservedledger. Italsoprovidesanoverviewofthe

customizing needed for this.

Unit-Rollups: Illustratesthevariousintentionsandmeansoffurthercondensing

datafor certain specificreportingrequirements.

Unit - Conclusion: Summarizes the goals and objectives of the course.

Recommendedfollow-upactivities are detailed.

xviii

第 19 页 / 共 509 页

Unit 1

FI-SL: Special Reporting

Explain the objectives, integration, and special requirements that speak for

the implementation of an FI-SL system. Demonstratethe P&L breakdown by

functional area. Explainthepostingsinthesystem.

Unit Overview

This unit gives you a rough representation of the objectives, integration, and

specialrequirementsthatspeakfortheimplementationofanFI-SLsystem. The

unit also presentsaconcreteexamplefor FI-SLusage, theP&Lbreakdownby

functionalareaswithexamplepostingsinthesystem.

Unit Objectives

After completing thisunit, you will beableto:

• UnderstandtheconceptofSpecialPurposeLedgeranditsobjectives

• DistinguishFI-SL from other SAP applications

• Describethe special reporting requirements

• Explain FI-SL with an example

Unit Contents

Lesson: Overview of FI-SL .......................................................2

Demonstration: Demonstration of FI-SL Example ......................14

Exercise 1: Standard Ledgers and Special Purpose Ledgers.........21

第 20 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

Lesson: Overview of FI-SL

Lesson Duration: 45 Minutes

Lesson Overview

Thislessonprovidesanoverviewof theFI-SLinformationsystem. It describes

howtodistinguishFI-SLfromotherSAPapplications.Inaddition,itdescribesthe

specialreportingrequirementsandprovidesanexampleofFI-SL.

Lesson Objectives

After completingthislesson, you will beable to:

• UnderstandtheconceptofSpecialPurposeLedgeranditsobjectives

• Distinguish FI-SLfromother SAP applications

• Describethespecial reporting requirements

• Explain FI-SL with an example

Give the participants an overview of the FI-SL information system. Explain

howFI-SLdiffersfromotherSAPapplicationsandexplaintheroleofFI-SLin

theSAPaccountingsystem. DescribethevariousFI-SLfunctions. Inaddition,

explainwithaspecificexample,howtoupdatedataforaprofitandlossstatement

in cost-of-salesaccounting format andthebreakdown of functionalarea costs.

DescribehowtheFI-SLsystemcanmeetspecial-purposereportingrequirements.

Business Example

Mostoftheinformationforyourcompanyisobtainedfromotherapplicationareas

andmustbereorganized. Insomecases,youneedtoprocesstheinformationto

providespecificcombinationsofsummarizeddata. Theconceptsanddesignof

thecomponentFI-SLmustbereviewedtoestablishwhetherornotFI-SLmeets

thesespecialrequirements. Onespecificrequirementistoprovideabreakdownof

thesecostsinto“functionalareas”,suchasmanufacturing,generaladministration,

sales,andresearchanddevelopment. YouneedtodeterminewhetherornotFI-SL

cancompilethisinformationandproduceacorrespondingreport.

FI-SL Information System

FI-SLInformationProcessing: Involvesstoringcross-applicationinformation

incustomer-specifictables,processingtheinformationinFI-SL,andevaluating

the information using Painter/Writer.

第 21 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Figure 1: FI-SL:SpecialReportingRequirements: Overview

Figure 2: FI-SL: Information Processing

InformationiscollectedfromotherSAPapplications,suchasFI,CO,MM,SD,

externaldatatransfer,andFI-SLadjustmentpostings. Thisinformationisstored

in user-defined tables for reporting purposes.

Theupdateandaccumulationofdatatakesplaceduringdatatransfer.

Additional processing functionsinFI-SL includeplanning, allocations, rollup,

currency translation, and balancecarryforward.

FI-SL enablesflexible evaluation options in reporting (Report Painter, Report

Writer).

第 22 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

FI-SL as Distinguished from Other SAP Applications

Standard Ledgers and Special-Purpose Ledgers: Clear separation of

PREDEFINED ledgers with predefined activities (firmly embedded in the

corresponding applications) from flexible, SPECIAL-PURPOSE ledgers with

a high degree of flexibility corresponding to the level of detail and choice of

information (activities).

Figure 3: Standard Ledgers and Special-Purpose Ledgers

Ledgers are broken down into two groups:

• Standard ledgers

• Special-purpose ledgers

Standard Ledgers

• StandardledgersarepreconfiguredledgersdeliveredbySAP.Thedatamodel

andspecificpredefinedfunctionsforbusinessrequirementsareavailableto

theusersinstandardledgers,suchasgeneralledger,reconciliationledger,

profitcenterledger,andconsolidationledger. FI-SLfunctionsareintegrated

into the corresponding application.

第 23 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Special-Purpose Ledgers

• Special-purpose ledgers are user-defined ledgers that can be maintained

as general ledgers or subledgers in the FI-SL application using account

assignments.

UsingtheFI-SLinstallationprograms,userscancreatetheirowndatabases

to meet their requirements.

• Accounting values on user-definedaccount assignmentscanbe stored as

summaryandlineitemtablesforreportingpurposesinFI-SL.

Figure 4: SAPStructuresandCustomer-DefinedStructures

ThoughthestructuresofthetablesdeliveredwiththestandardSAPsystemtable

arefixed,youcanalsocreateyourowntablestructuresinFI-SLtocontainflexible

combinations of characteristics.

Integrated Consolidation Integrated aspect: Explain the supply of data from

SAPapplicationsandpossiblyfromnon-SAPdata(mainsampleprogram,suchas

RGUREC00)withactual/plandata(fromCO)withcompleteintegration. Discuss

theoptionaluseofthevalidation/substitutiontechniquesforcharacteristicsentered

andledger selection. Inadditiontothese, explainthat fieldmovementsfor the

sender/receiver characteristicsenableyoutodeterminetheamount andtypeof

informationrequired. Thevariousoptionsorrequirementstoenrich,suppress,or

refinedata(periodicprocessing)areexplainedwithinFI-SL.

第 24 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

Figure 5: Integrated Consolidation

UsingFI-SL,youcancollectdatafromotherSAPapplications,suchasFI,CO,

MM, and SD, external systems, and FI-SL adjustment postings for reporting

purposes.

TheFI-SLsystemiscompletelyintegratedwithotherSAPsystems. Asaresult,

youdonotneedtomodify other SAP applications.

Duringdatatransfer,datacanbechangedoraccumulated.

In FI-SL, you can process data using planning, allocations, rollups, currency

translation,andbalancecarryforward(periodicprocessing)functions.

YoucanusetheinformationsysteminFI-SL(ReportPainter/ReportWriter)to

create flexible reports and evaluate data.

第 25 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Special Reporting Requirements

Special Requirements (1-6)

HighlightsomeofthefeaturesthatenableFI-SLtobeusedasanenhancementto

the standard SAP applications:

• Additional account assignments

• Selective data collection

• Alternative chart of accounts

• User-defined period definition

• Cross-application pooling of data

• Changes to data within FI-SL

Figure 6: Special Reporting Requirements (1)

You can use special purpose ledgers to report additional fields, such as ( →

additionallevelsofdetail,totalsforspecificfieldcombinations).

第 26 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

Figure 7: Special Reporting Requirements (2)

You can use special purpose ledgers to collect selective data ( → activity

assignment, ledger selection)

Figure 8: Special Reporting Requirements (3)

Youcanusespecialpurposeledgerstoupdatealternativechartsofaccounts(→

operating, country, corporate) and to use anon-calendar fiscal year→foreign

subsidiary, corporate group).

第 27 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Figure 9: Special Reporting Requirements (4)

Youcanusespecial-purposeledgerstodetermineyour ownperioddefinitions,

such as day, week, and month.

Figure 10: Special Reporting Requirements (5)

You can use special purpose ledgers to evaluate several applications and

organizational units.

第 28 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

Figure 11: Special Reporting Requirements (6)

You can use special purpose ledgers to allocate documents according to

characteristics,suchasprofitcenter,businessarea,specialregion,andmaterial.

FI-SL Example

FI-SL Example: Subject area: Comparison Period Accounting and

Cost-of-goods-sold Accounting, functional area as a new characteristic and

account assignment element and representation in an FI-SL ledger (standard

example0F).Presentation: Explainthetitles,ReportPainterreport,andposting

examples. Comparethetwoprocedures. Thebreakdownofthecostsbyfunctional

areas is explained in “Assignment of Functional Areas in the P and L”. This

is followed by an explanation of the activities to supply the necessary data in

“Cost-of-Sales Accounting”:

1. Thesalesrevenuesfrom thebillingdocument

2. Thecostsofgoodssoldfromthegoodsissue(standardprice)

3. The possible production variances resulting from a) the settlement of

a production order b) the over/under absorption (debits/credits) on the

production objects(cost centersand orders.)

4. Overheads posted to the other cost objects with the same technique

of derivation per substitution for the functional areas, sales, general

administration, research and development.

第 29 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Figure 12: Example: Cost of Sales by Functional Area

This figure shows asimplified exampleof an FI-SL report on aP/L statement

showingthecostofsalesbrokendownintothefunctionalareas,production,sales

anddistribution,administration,andresearchanddevelopment.

Figure 13: PandL Period and Cost-of-SalesAccounting

Thisfolioillustratestwomethodstocalculatetheprofitandlossstatementfora

company,Periodaccounting,whichusestotalcosts,andcost-of-salesaccounting,

which uses the cost of goods sold.

第 30 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

In the total costs schema, the profit and loss statement is broken down into

individual income and expense types.

The total operating profit for this accounting period is compared to the costs

incurred in the period.

In cost-of-sales accounting, the sales revenues of the accounting period are

balanced against the manufacturing costs incurred for the services rendered.

Thesystemassignstheexpenses, accordingtopriority, tothefunctionalareas

in the company, such as production, sales, and administration. Expenses and

revenuesthatcannotbeallocatedtofunctionalareasmustbedisplayedinother

P/Lstatementitemsclassifiedbyexpenseandrevenuetypes.

Figure14: AssignmentofFunctionalAreasintheP/LAccount

Bybreaking downcostsintothefunctional areassuchasmanufacturing, sales

and distribution, administration, and research and development, cost-of-sales

accountingshowswhereandwhycostswereaccruedinacompany.

第 31 页 / 共 509 页

AC220 Lesson: Overview of FI-SL

Figure 15: Cost-of-Sales Accounting: Overview

Forallexpensepostings,thefunctionalareaFAREAcanbederivedfromexisting

accountassignments,suchascostcenter,costelement,orproductionorder,and

recorded in the document line.

In addition to the general ledger FI-GL, another ledger is stored in FI-SL. All

FI-relatedbusinesstransactionscanbeupdatedinthisledger.

Unlikethegeneralledger,thetransactionfiguresarebrokendownintofunctional

areas.

Thisfiguredemonstrateshowyou canuseFI-SL.

Thefollowingsamplepostingsaredisplayedinthispart:

• SalesrevenuefromSalesOrderManagement(1)

• Cost of sales from Goods Issue (2)

• Productionvariancesfromsettlementoftheproductionorder(3)

• Allcreditsanddebitsonallproductioncostcenters(over/underabsorption)

(3a)

• All postings to cost centers related to the functional areas, sales and

distribution,administration,andresearchanddevelopment(3b)

• CorrectionpostingsfromthereconciliationledgerbacktoFI-SLinthecase

of secondarycross-functional area postings(3c)

• Postings to result objects (4)

• Other expenses (5)

第 32 页 / 共 509 页

Unit1: FI-SL:SpecialReporting AC220

Figure 16: Assignment of Functional Areas in the P/L

Ifthecostofsalesaccountingisactivatedforacompanycode,afunctionalareais

determined for all P and L postings.

No functional area is derived for postings to balance sheet accounts or for

recording keyfiguresinManagementAccounting.

Noconnection(reconciliationledger) toFI isavailablefor allocationsinProfit

Center Accounting.

To ensure that the derivation is consistent, only fields that are available for

ManagementAccounting-internalclearing,suchasassignment,canbequeriedin

theconditionsforsubstitutioninFI.AlthoughthesystemusesFIsubstitutionfor

ManagementAccounting-internalclearing,theresultswouldthenbedifferent.

Demonstration: Demonstration of FI-SL Example

Purpose

To demonstrate an FI-SL example

System Data

System:

Client:

UserID:

Password:

Setupinstructions: